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)#9886 (12) { ["name"]=> string(10) "VAN ISRAEL" ["website"]=> string(23) "http://www.vanisrael.be" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> string(0) "" ["zoho_id"]=> string(18) "246999000000253305" ["address"]=> object(stdClass)#9802 (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)#9858 (3) { ["full"]=> object(stdClass)#9830 (3) { ["src"]=> string(69) "https://extranet.afaia.fr/wp-content/uploads/2020/02/vanisrae150l.png" ["width"]=> int(150) ["height"]=> int(150) } ["medium"]=> object(stdClass)#9774 (3) { ["src"]=> string(69) "https://extranet.afaia.fr/wp-content/uploads/2020/02/vanisrae150l.png" ["width"]=> int(150) ["height"]=> int(150) } ["thumbnail"]=> object(stdClass)#9773 (3) { ["src"]=> string(77) "https://extranet.afaia.fr/wp-content/uploads/2020/02/vanisrae150l-150x150.png" ["width"]=> int(150) ["height"]=> int(150) } } }VAN ISRAEL Supports de culture, Paillages, Amendements organiques http://www.vanisrael.be
object(stdClass)#9772 (12) { ["name"]=> string(11) "VEGENOV BBV" ["website"]=> string(15) "www.vegenov.com" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> string(0) "" ["zoho_id"]=> string(18) "246999000000253306" ["address"]=> object(stdClass)#9771 (4) { ["street"]=> NULL ["postalcode"]=> NULL ["city"]=> NULL ["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)#9769 (3) { ["full"]=> object(stdClass)#9770 (3) { ["src"]=> string(64) "https://extranet.afaia.fr/wp-content/uploads/2020/02/vegenov.jpg" ["width"]=> int(226) ["height"]=> int(198) } ["medium"]=> object(stdClass)#9872 (3) { ["src"]=> string(64) "https://extranet.afaia.fr/wp-content/uploads/2020/02/vegenov.jpg" ["width"]=> int(226) ["height"]=> int(198) } ["thumbnail"]=> object(stdClass)#9915 (3) { ["src"]=> string(72) "https://extranet.afaia.fr/wp-content/uploads/2020/02/vegenov-150x150.jpg" ["width"]=> int(150) ["height"]=> int(150) } } }VEGENOV BBV Membre associé d'Afaïa http://www.vegenov.com
object(stdClass)#362 (12) { ["name"]=> string(16) "VEGEPOLYS VALLEY" ["website"]=> string(23) "www.vegepolys-valley.eu" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> string(0) "" ["zoho_id"]=> string(18) "246999000000253308" ["address"]=> object(stdClass)#9942 (4) { ["street"]=> NULL ["postalcode"]=> NULL ["city"]=> NULL ["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)#9944 (3) { ["full"]=> object(stdClass)#9943 (3) { ["src"]=> string(92) "https://extranet.afaia.fr/wp-content/uploads/2020/02/vegepolys-valley-logo-verticale-rvb.png" ["width"]=> int(1312) ["height"]=> int(1827) } ["medium"]=> object(stdClass)#9945 (3) { ["src"]=> string(100) "https://extranet.afaia.fr/wp-content/uploads/2020/02/vegepolys-valley-logo-verticale-rvb-215x300.png" ["width"]=> int(215) ["height"]=> int(300) } ["thumbnail"]=> object(stdClass)#9946 (3) { ["src"]=> string(100) "https://extranet.afaia.fr/wp-content/uploads/2020/02/vegepolys-valley-logo-verticale-rvb-150x150.png" ["width"]=> int(150) ["height"]=> int(150) } } }VEGEPOLYS VALLEY Membre associé d'Afaïa http://www.vegepolys-valley.eu
object(stdClass)#9947 (12) { ["name"]=> string(8) "VERAGROW" ["website"]=> string(20) "https://veragrow.fr/" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> object(stdClass)#9948 (2) { ["internationalFormat"]=> string(12) "+33646797477" ["frenchFormat"]=> string(14) "06 46 79 74 77" } ["zoho_id"]=> string(18) "246999000007791087" ["address"]=> object(stdClass)#9949 (4) { ["street"]=> string(50) "1 Voie des Vendaises - Parc d'activité du Vauvray" ["postalcode"]=> string(5) "27100" ["city"]=> string(12) "Val De Reuil" ["country"]=> string(6) "France" } ["adherents"]=> array(1) { [0]=> string(9) "Adhérent" } ["produits_fabriques"]=> array(2) { [0]=> string(22) "Amendements organiques" [1]=> string(13) "Biostimulants" } ["contributeurs_statistiques"]=> string(0) "" ["tag"]=> array(0) { } ["logo"]=> object(stdClass)#9951 (3) { ["full"]=> object(stdClass)#9950 (3) { ["src"]=> string(65) "https://extranet.afaia.fr/wp-content/uploads/2022/03/veragrow.png" ["width"]=> int(108) ["height"]=> int(96) } ["medium"]=> object(stdClass)#9952 (3) { ["src"]=> string(65) "https://extranet.afaia.fr/wp-content/uploads/2022/03/veragrow.png" ["width"]=> int(108) ["height"]=> int(96) } ["thumbnail"]=> object(stdClass)#9953 (3) { ["src"]=> string(65) "https://extranet.afaia.fr/wp-content/uploads/2022/03/veragrow.png" ["width"]=> int(108) ["height"]=> int(96) } } }VERAGROW Amendements organiques, Biostimulants https://veragrow.fr/
object(stdClass)#9954 (12) { ["name"]=> string(7) "VIVAGRO" ["website"]=> string(14) "www.vivagro.eu" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> object(stdClass)#9955 (2) { ["internationalFormat"]=> string(12) "+33557783268" ["frenchFormat"]=> string(14) "05 57 78 32 68" } ["zoho_id"]=> string(18) "246999000003338040" ["address"]=> object(stdClass)#9956 (4) { ["street"]=> string(50) "Technopole Montesquieu - 5 allée Jacques Latrille" ["postalcode"]=> string(5) "33650" ["city"]=> string(9) "MARTILLAC" ["country"]=> string(6) "FRANCE" } ["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)#9958 (3) { ["full"]=> object(stdClass)#9957 (3) { ["src"]=> string(64) "https://extranet.afaia.fr/wp-content/uploads/2021/03/vivagro.jpg" ["width"]=> int(257) ["height"]=> int(141) } ["medium"]=> object(stdClass)#9959 (3) { ["src"]=> string(64) "https://extranet.afaia.fr/wp-content/uploads/2021/03/vivagro.jpg" ["width"]=> int(257) ["height"]=> int(141) } ["thumbnail"]=> object(stdClass)#9960 (3) { ["src"]=> string(72) "https://extranet.afaia.fr/wp-content/uploads/2021/03/vivagro-150x141.jpg" ["width"]=> int(150) ["height"]=> int(141) } } }VIVAGRO Engrais organiques, Engrais organo-minéraux, Biostimulants http://www.vivagro.eu
object(stdClass)#9961 (12) { ["name"]=> string(8) "VIVESCIA" ["website"]=> string(16) "www.vivescia.com" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> string(0) "" ["zoho_id"]=> string(18) "246999000010330017" ["address"]=> object(stdClass)#9962 (4) { ["street"]=> string(27) "2 rue Clément-Ader BP 1017" ["postalcode"]=> string(5) "51685" ["city"]=> string(13) "REIMS Cedex 2" ["country"]=> NULL } ["adherents"]=> array(1) { [0]=> 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)#9964 (3) { ["full"]=> object(stdClass)#9963 (3) { ["src"]=> string(70) "https://extranet.afaia.fr/wp-content/uploads/2022/09/logo-vivescia.jpg" ["width"]=> int(1902) ["height"]=> int(561) } ["medium"]=> object(stdClass)#9965 (3) { ["src"]=> string(77) "https://extranet.afaia.fr/wp-content/uploads/2022/09/logo-vivescia-300x88.jpg" ["width"]=> int(300) ["height"]=> int(88) } ["thumbnail"]=> object(stdClass)#9966 (3) { ["src"]=> string(78) "https://extranet.afaia.fr/wp-content/uploads/2022/09/logo-vivescia-150x150.jpg" ["width"]=> int(150) ["height"]=> int(150) } } }VIVESCIA Membre associé d'Afaïa http://www.vivescia.com
object(stdClass)#9967 (12) { ["name"]=> string(7) "VOXGAIA" ["website"]=> string(23) "https://www.voxgaia.fr/" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> string(0) "" ["zoho_id"]=> string(18) "246999000001634120" ["address"]=> object(stdClass)#9968 (4) { ["street"]=> NULL ["postalcode"]=> NULL ["city"]=> NULL ["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)#9970 (3) { ["full"]=> object(stdClass)#9969 (3) { ["src"]=> string(65) "https://extranet.afaia.fr/wp-content/uploads/2020/09/voxgaia2.png" ["width"]=> int(220) ["height"]=> int(101) } ["medium"]=> object(stdClass)#9971 (3) { ["src"]=> string(65) "https://extranet.afaia.fr/wp-content/uploads/2020/09/voxgaia2.png" ["width"]=> int(220) ["height"]=> int(101) } ["thumbnail"]=> object(stdClass)#9972 (3) { ["src"]=> string(73) "https://extranet.afaia.fr/wp-content/uploads/2020/09/voxgaia2-150x101.png" ["width"]=> int(150) ["height"]=> int(101) } } }VOXGAIA Membre associé d'Afaïa https://www.voxgaia.fr/
object(stdClass)#9973 (12) { ["name"]=> string(6) "YNSECT" ["website"]=> string(14) "www.ynsect.com" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> string(0) "" ["zoho_id"]=> string(18) "246999000000253316" ["address"]=> object(stdClass)#9974 (4) { ["street"]=> NULL ["postalcode"]=> NULL ["city"]=> NULL ["country"]=> NULL } ["adherents"]=> array(1) { [0]=> string(9) "Adhérent" } ["produits_fabriques"]=> array(3) { [0]=> string(22) "Amendements organiques" [1]=> string(18) "Engrais organiques" [2]=> string(13) "Biostimulants" } ["contributeurs_statistiques"]=> string(0) "" ["tag"]=> array(0) { } ["logo"]=> object(stdClass)#9976 (3) { ["full"]=> object(stdClass)#9975 (3) { ["src"]=> string(69) "https://extranet.afaia.fr/wp-content/uploads/2020/02/logo-ynsect3.png" ["width"]=> int(200) ["height"]=> int(250) } ["medium"]=> object(stdClass)#9977 (3) { ["src"]=> string(69) "https://extranet.afaia.fr/wp-content/uploads/2020/02/logo-ynsect3.png" ["width"]=> int(200) ["height"]=> int(250) } ["thumbnail"]=> object(stdClass)#9978 (3) { ["src"]=> string(77) "https://extranet.afaia.fr/wp-content/uploads/2020/02/logo-ynsect3-150x150.png" ["width"]=> int(150) ["height"]=> int(150) } } }YNSECT Amendements organiques, Engrais organiques, Biostimulants http://www.ynsect.com