string(214) "SELECT COUNT(p.ID) FROM wpatm_posts as p LEFT JOIN wpatm_postmeta as pm ON pm.post_id = p.ID WHERE p.post_type = 'company' AND p.post_status = 'publish' AND pm.meta_key = 'public_display' AND pm.meta_value = '1' ;"
object(stdClass)#9815 (12) { ["name"]=> string(14) "4 VAULX JARDIN" ["website"]=> string(28) "http://www.4vaulx-jardin.com" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> string(0) "" ["zoho_id"]=> string(18) "246999000000253095" ["address"]=> object(stdClass)#9759 (4) { ["street"]=> string(21) "CAT Coëtfinet - BP 4" ["postalcode"]=> string(5) "22130" ["city"]=> string(7) "CORSEUL" ["country"]=> NULL } ["adherents"]=> array(1) { [0]=> string(9) "Adhérent" } ["produits_fabriques"]=> array(4) { [0]=> string(19) "Supports de culture" [1]=> string(22) "Amendements organiques" [2]=> string(18) "Engrais organiques" [3]=> string(24) "Engrais organo-minéraux" } ["contributeurs_statistiques"]=> string(0) "" ["tag"]=> array(0) { } ["logo"]=> object(stdClass)#9787 (3) { ["full"]=> object(stdClass)#9856 (3) { ["src"]=> string(79) "https://extranet.afaia.fr/wp-content/uploads/2020/02/logo-esat-quatre-vaulx.png" ["width"]=> int(300) ["height"]=> int(210) } ["medium"]=> object(stdClass)#9718 (3) { ["src"]=> string(79) "https://extranet.afaia.fr/wp-content/uploads/2020/02/logo-esat-quatre-vaulx.png" ["width"]=> int(300) ["height"]=> int(210) } ["thumbnail"]=> object(stdClass)#9717 (3) { ["src"]=> string(87) "https://extranet.afaia.fr/wp-content/uploads/2020/02/logo-esat-quatre-vaulx-150x150.png" ["width"]=> int(150) ["height"]=> int(150) } } }
object(stdClass)#9716 (12) { ["name"]=> string(6) "ADIVET" ["website"]=> string(21) "http://www.adivet.net" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> string(0) "" ["zoho_id"]=> string(18) "246999000000253097" ["address"]=> object(stdClass)#9715 (4) { ["street"]=> string(18) "84 rue de Grenelle" ["postalcode"]=> string(5) "75007" ["city"]=> string(5) "PARIS" ["country"]=> NULL } ["adherents"]=> array(2) { [0]=> string(9) "Adhérent" [1]=> string(15) "Membre Associé" } ["produits_fabriques"]=> array(1) { [0]=> string(24) "Membre associé d'Afaïa" } ["contributeurs_statistiques"]=> string(0) "" ["tag"]=> array(0) { } ["logo"]=> object(stdClass)#9713 (3) { ["full"]=> object(stdClass)#9714 (3) { ["src"]=> string(69) "https://extranet.afaia.fr/wp-content/uploads/2020/02/logo-adivet1.gif" ["width"]=> int(1200) ["height"]=> int(855) } ["medium"]=> object(stdClass)#9801 (3) { ["src"]=> string(77) "https://extranet.afaia.fr/wp-content/uploads/2020/02/logo-adivet1-300x214.gif" ["width"]=> int(300) ["height"]=> int(214) } ["thumbnail"]=> object(stdClass)#9857 (3) { ["src"]=> string(77) "https://extranet.afaia.fr/wp-content/uploads/2020/02/logo-adivet1-150x150.gif" ["width"]=> int(150) ["height"]=> int(150) } } }
object(stdClass)#9703 (12) { ["name"]=> string(11) "AESEA Group" ["website"]=> string(19) "https://aquiland.fr" ["twitter"]=> string(0) "" ["image"]=> string(160) "3a982a1a3974c5cb7746a8c22a059a727b86a550081bc857fa6c6e6d2c9d5ce3416e277ea7cd4789bbd437df6e670fc8fb1dbae165c596a95b292bd5fa2b686952dfb3b43839e1d70384adfeea8e975a" ["phone"]=> string(0) "" ["zoho_id"]=> string(18) "246999000000253098" ["address"]=> object(stdClass)#9884 (4) { ["street"]=> string(4) "BP 2" ["postalcode"]=> string(5) "33270" ["city"]=> string(8) "LANDIRAS" ["country"]=> NULL } ["adherents"]=> array(1) { [0]=> string(9) "Adhérent" } ["produits_fabriques"]=> array(1) { [0]=> string(19) "Supports de culture" } ["contributeurs_statistiques"]=> string(0) "" ["tag"]=> array(0) { } ["logo"]=> object(stdClass)#9886 (3) { ["full"]=> object(stdClass)#9885 (3) { ["src"]=> string(70) "https://extranet.afaia.fr/wp-content/uploads/2020/02/logo-aquiland.jpg" ["width"]=> int(333) ["height"]=> int(123) } ["medium"]=> object(stdClass)#9887 (3) { ["src"]=> string(78) "https://extranet.afaia.fr/wp-content/uploads/2020/02/logo-aquiland-300x111.jpg" ["width"]=> int(300) ["height"]=> int(111) } ["thumbnail"]=> object(stdClass)#9888 (3) { ["src"]=> string(78) "https://extranet.afaia.fr/wp-content/uploads/2020/02/logo-aquiland-150x123.jpg" ["width"]=> int(150) ["height"]=> int(123) } } }
object(stdClass)#9889 (12) { ["name"]=> string(6) "AGARIS" ["website"]=> string(14) "www.agaris.com" ["twitter"]=> string(0) "" ["image"]=> string(160) "3a982a1a3974c5cb7746a8c22a059a727b86a550081bc857fa6c6e6d2c9d5ce3f258b1beff92bedebcbe5e7dffde69581acd0b7bccff1369456cfa4b3e7337520d099be347910744e75eb825eccc0981" ["phone"]=> object(stdClass)#9890 (2) { ["internationalFormat"]=> string(14) "+33+3292180330" ["frenchFormat"]=> string(12) "0+3292180330" } ["zoho_id"]=> string(18) "246999000000253106" ["address"]=> object(stdClass)#9891 (4) { ["street"]=> string(16) "Skaldenstraat 7a" ["postalcode"]=> string(4) "9042" ["city"]=> string(10) "Desteldonk" ["country"]=> string(8) "BELGIQUE" } ["adherents"]=> array(1) { [0]=> string(9) "Adhérent" } ["produits_fabriques"]=> array(4) { [0]=> string(19) "Supports de culture" [1]=> string(9) "Paillages" [2]=> string(22) "Amendements organiques" [3]=> string(18) "Engrais organiques" } ["contributeurs_statistiques"]=> string(0) "" ["tag"]=> array(0) { } ["logo"]=> object(stdClass)#9893 (3) { ["full"]=> object(stdClass)#9892 (3) { ["src"]=> string(74) "https://extranet.afaia.fr/wp-content/uploads/2020/02/agaris-h-cmyk-002.jpg" ["width"]=> int(1733) ["height"]=> int(450) } ["medium"]=> object(stdClass)#9894 (3) { ["src"]=> string(81) "https://extranet.afaia.fr/wp-content/uploads/2020/02/agaris-h-cmyk-002-300x78.jpg" ["width"]=> int(300) ["height"]=> int(78) } ["thumbnail"]=> object(stdClass)#9895 (3) { ["src"]=> string(82) "https://extranet.afaia.fr/wp-content/uploads/2020/02/agaris-h-cmyk-002-150x150.jpg" ["width"]=> int(150) ["height"]=> int(150) } } }
object(stdClass)#9896 (12) { ["name"]=> string(9) "AGRAUXINE" ["website"]=> string(21) "https://agrauxine.com" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> string(0) "" ["zoho_id"]=> string(18) "246999000000253107" ["address"]=> object(stdClass)#9897 (4) { ["street"]=> NULL ["postalcode"]=> NULL ["city"]=> NULL ["country"]=> NULL } ["adherents"]=> array(1) { [0]=> string(9) "Adhérent" } ["produits_fabriques"]=> array(1) { [0]=> string(13) "Biostimulants" } ["contributeurs_statistiques"]=> string(0) "" ["tag"]=> array(0) { } ["logo"]=> object(stdClass)#9899 (3) { ["full"]=> object(stdClass)#9898 (3) { ["src"]=> string(73) "https://extranet.afaia.fr/wp-content/uploads/2020/02/agrauxine-header.jpg" ["width"]=> int(700) ["height"]=> int(325) } ["medium"]=> object(stdClass)#9900 (3) { ["src"]=> string(81) "https://extranet.afaia.fr/wp-content/uploads/2020/02/agrauxine-header-300x139.jpg" ["width"]=> int(300) ["height"]=> int(139) } ["thumbnail"]=> object(stdClass)#9901 (3) { ["src"]=> string(81) "https://extranet.afaia.fr/wp-content/uploads/2020/02/agrauxine-header-150x150.jpg" ["width"]=> int(150) ["height"]=> int(150) } } }
object(stdClass)#9902 (12) { ["name"]=> string(13) "AGRI SYMBIOSE" ["website"]=> string(17) "www.planetagro.fr" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> object(stdClass)#9903 (2) { ["internationalFormat"]=> string(11) "+3355621179" ["frenchFormat"]=> string(9) "055621179" } ["zoho_id"]=> string(18) "246999000007791001" ["address"]=> object(stdClass)#9904 (4) { ["street"]=> string(45) "5 rue Auguste et Louis Lumière - ZA Riboulet" ["postalcode"]=> string(5) "33670" ["city"]=> string(5) "CREON" ["country"]=> NULL } ["adherents"]=> array(1) { [0]=> string(9) "Adhérent" } ["produits_fabriques"]=> array(3) { [0]=> string(18) "Engrais organiques" [1]=> string(24) "Engrais organo-minéraux" [2]=> string(13) "Biostimulants" } ["contributeurs_statistiques"]=> string(0) "" ["tag"]=> array(0) { } ["logo"]=> object(stdClass)#9906 (3) { ["full"]=> object(stdClass)#9905 (3) { ["src"]=> string(104) "https://extranet.afaia.fr/wp-content/uploads/2023/01/logo agriymbiose - groupe pa - fonf transparent.png" ["width"]=> int(3383) ["height"]=> int(667) } ["medium"]=> object(stdClass)#9907 (3) { ["src"]=> string(111) "https://extranet.afaia.fr/wp-content/uploads/2023/01/logo agriymbiose - groupe pa - fonf transparent-300x59.png" ["width"]=> int(300) ["height"]=> int(59) } ["thumbnail"]=> object(stdClass)#9908 (3) { ["src"]=> string(112) "https://extranet.afaia.fr/wp-content/uploads/2023/01/logo agriymbiose - groupe pa - fonf transparent-150x150.png" ["width"]=> int(150) ["height"]=> int(150) } } }
object(stdClass)#9909 (12) { ["name"]=> string(7) "AGRIMER" ["website"]=> string(22) "http://www.agrimer.com" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> string(0) "" ["zoho_id"]=> string(18) "246999000000253108" ["address"]=> object(stdClass)#9910 (4) { ["street"]=> string(24) "645 Prad Menan - CS 2003" ["postalcode"]=> string(5) "29880" ["city"]=> string(12) "PLOUGUERNEAU" ["country"]=> string(6) "FRANCE" } ["adherents"]=> array(1) { [0]=> string(9) "Adhérent" } ["produits_fabriques"]=> array(1) { [0]=> string(13) "Biostimulants" } ["contributeurs_statistiques"]=> string(0) "" ["tag"]=> array(0) { } ["logo"]=> object(stdClass)#9912 (3) { ["full"]=> object(stdClass)#9911 (3) { ["src"]=> string(64) "https://extranet.afaia.fr/wp-content/uploads/2020/02/agrimer.jpg" ["width"]=> int(165) ["height"]=> int(86) } ["medium"]=> object(stdClass)#9913 (3) { ["src"]=> string(64) "https://extranet.afaia.fr/wp-content/uploads/2020/02/agrimer.jpg" ["width"]=> int(165) ["height"]=> int(86) } ["thumbnail"]=> object(stdClass)#9914 (3) { ["src"]=> string(71) "https://extranet.afaia.fr/wp-content/uploads/2020/02/agrimer-150x86.jpg" ["width"]=> int(150) ["height"]=> int(86) } } }
object(stdClass)#9915 (12) { ["name"]=> string(17) "AGRIVER - TONUSOL" ["website"]=> string(23) "https://www.tonusol.com" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> string(0) "" ["zoho_id"]=> string(18) "246999000000253115" ["address"]=> object(stdClass)#9916 (4) { ["street"]=> NULL ["postalcode"]=> NULL ["city"]=> NULL ["country"]=> NULL } ["adherents"]=> array(1) { [0]=> string(9) "Adhérent" } ["produits_fabriques"]=> array(3) { [0]=> string(19) "Supports de culture" [1]=> string(9) "Paillages" [2]=> string(22) "Amendements organiques" } ["contributeurs_statistiques"]=> string(0) "" ["tag"]=> array(0) { } ["logo"]=> object(stdClass)#9918 (3) { ["full"]=> object(stdClass)#9917 (3) { ["src"]=> string(64) "https://extranet.afaia.fr/wp-content/uploads/2020/02/tonusol.jpg" ["width"]=> int(300) ["height"]=> int(207) } ["medium"]=> object(stdClass)#9919 (3) { ["src"]=> string(64) "https://extranet.afaia.fr/wp-content/uploads/2020/02/tonusol.jpg" ["width"]=> int(300) ["height"]=> int(207) } ["thumbnail"]=> object(stdClass)#9920 (3) { ["src"]=> string(72) "https://extranet.afaia.fr/wp-content/uploads/2020/02/tonusol-150x150.jpg" ["width"]=> int(150) ["height"]=> int(150) } } }
object(stdClass)#9921 (12) { ["name"]=> string(10) "AGRONUTRIS" ["website"]=> string(26) "https://www.agronutris.com" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> object(stdClass)#9922 (2) { ["internationalFormat"]=> string(12) "+33531543288" ["frenchFormat"]=> string(14) "05 31 54 32 88" } ["zoho_id"]=> string(18) "246999000000390060" ["address"]=> object(stdClass)#9923 (4) { ["street"]=> NULL ["postalcode"]=> NULL ["city"]=> NULL ["country"]=> NULL } ["adherents"]=> array(1) { [0]=> string(9) "Adhérent" } ["produits_fabriques"]=> array(1) { [0]=> string(18) "Engrais organiques" } ["contributeurs_statistiques"]=> string(0) "" ["tag"]=> array(0) { } ["logo"]=> object(stdClass)#9925 (3) { ["full"]=> object(stdClass)#9924 (3) { ["src"]=> string(67) "https://extranet.afaia.fr/wp-content/uploads/2020/03/agronutris.jpg" ["width"]=> int(324) ["height"]=> int(84) } ["medium"]=> object(stdClass)#9926 (3) { ["src"]=> string(74) "https://extranet.afaia.fr/wp-content/uploads/2020/03/agronutris-300x78.jpg" ["width"]=> int(300) ["height"]=> int(78) } ["thumbnail"]=> object(stdClass)#9927 (3) { ["src"]=> string(74) "https://extranet.afaia.fr/wp-content/uploads/2020/03/agronutris-150x84.jpg" ["width"]=> int(150) ["height"]=> int(84) } } }
object(stdClass)#9928 (12) { ["name"]=> string(16) "AGRONUTRITION SA" ["website"]=> string(28) "http://www.agronutrition.com" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> string(0) "" ["zoho_id"]=> string(18) "246999000000253117" ["address"]=> object(stdClass)#9929 (4) { ["street"]=> NULL ["postalcode"]=> NULL ["city"]=> NULL ["country"]=> NULL } ["adherents"]=> array(1) { [0]=> string(9) "Adhérent" } ["produits_fabriques"]=> array(3) { [0]=> string(18) "Engrais organiques" [1]=> string(24) "Engrais organo-minéraux" [2]=> string(13) "Biostimulants" } ["contributeurs_statistiques"]=> string(0) "" ["tag"]=> array(0) { } ["logo"]=> object(stdClass)#9931 (3) { ["full"]=> object(stdClass)#9930 (3) { ["src"]=> string(70) "https://extranet.afaia.fr/wp-content/uploads/2020/02/agronutrition.jpg" ["width"]=> int(269) ["height"]=> int(84) } ["medium"]=> object(stdClass)#9932 (3) { ["src"]=> string(70) "https://extranet.afaia.fr/wp-content/uploads/2020/02/agronutrition.jpg" ["width"]=> int(269) ["height"]=> int(84) } ["thumbnail"]=> object(stdClass)#9933 (3) { ["src"]=> string(77) "https://extranet.afaia.fr/wp-content/uploads/2020/02/agronutrition-150x84.jpg" ["width"]=> int(150) ["height"]=> int(84) } } }
object(stdClass)#9934 (12) { ["name"]=> string(13) "AKIOLIS Group" ["website"]=> string(26) "https://www.akiolis.com/fr" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> object(stdClass)#9935 (2) { ["internationalFormat"]=> string(12) "+33244815010" ["frenchFormat"]=> string(14) "02 44 81 50 10" } ["zoho_id"]=> string(18) "246999000002925037" ["address"]=> object(stdClass)#9936 (4) { ["street"]=> string(26) "72 avenue Olivier Messiaen" ["postalcode"]=> string(5) "72000" ["city"]=> string(7) "Le Mans" ["country"]=> NULL } ["adherents"]=> array(1) { [0]=> string(9) "Adhérent" } ["produits_fabriques"]=> array(2) { [0]=> string(18) "Engrais organiques" [1]=> string(24) "Engrais organo-minéraux" } ["contributeurs_statistiques"]=> string(0) "" ["tag"]=> array(0) { } ["logo"]=> object(stdClass)#9938 (3) { ["full"]=> object(stdClass)#9937 (3) { ["src"]=> string(85) "https://extranet.afaia.fr/wp-content/uploads/2021/01/akiolis-revelateur-de-valeur.png" ["width"]=> int(180) ["height"]=> int(110) } ["medium"]=> object(stdClass)#9939 (3) { ["src"]=> string(85) "https://extranet.afaia.fr/wp-content/uploads/2021/01/akiolis-revelateur-de-valeur.png" ["width"]=> int(180) ["height"]=> int(110) } ["thumbnail"]=> object(stdClass)#9940 (3) { ["src"]=> string(93) "https://extranet.afaia.fr/wp-content/uploads/2021/01/akiolis-revelateur-de-valeur-150x110.png" ["width"]=> int(150) ["height"]=> int(110) } } }
object(stdClass)#9941 (12) { ["name"]=> string(7) "ALGAÏA" ["website"]=> string(22) "https://www.algaia.com" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> string(0) "" ["zoho_id"]=> string(18) "246999000000253118" ["address"]=> object(stdClass)#9942 (4) { ["street"]=> string(21) "91 Rue Edouard Branly" ["postalcode"]=> string(6) "50 000" ["city"]=> string(8) "SAINT LO" ["country"]=> string(6) "FRANCE" } ["adherents"]=> array(1) { [0]=> string(9) "Adhérent" } ["produits_fabriques"]=> array(1) { [0]=> string(13) "Biostimulants" } ["contributeurs_statistiques"]=> string(0) "" ["tag"]=> array(0) { } ["logo"]=> object(stdClass)#9944 (3) { ["full"]=> object(stdClass)#9943 (3) { ["src"]=> string(68) "https://extranet.afaia.fr/wp-content/uploads/2020/02/logo-algaia.jpg" ["width"]=> int(2445) ["height"]=> int(808) } ["medium"]=> object(stdClass)#9945 (3) { ["src"]=> string(75) "https://extranet.afaia.fr/wp-content/uploads/2020/02/logo-algaia-300x99.jpg" ["width"]=> int(300) ["height"]=> int(99) } ["thumbnail"]=> object(stdClass)#9946 (3) { ["src"]=> string(76) "https://extranet.afaia.fr/wp-content/uploads/2020/02/logo-algaia-150x150.jpg" ["width"]=> int(150) ["height"]=> int(150) } } }