string(861) "SELECT COUNT(p.ID) FROM wpatm_posts as p LEFT JOIN wpatm_postmeta as pm ON pm.post_id = p.ID LEFT JOIN wpatm_postmeta as pmr ON pmr.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' AND ( pmr.meta_key = 'Produits_fabriqu_s' AND ( pmr.meta_value LIKE '{d5e8ab3083dee06ceb6412a801a3cf86b3557e1899bef9fd2fcf080f55ac08b5}Amendements organiques{d5e8ab3083dee06ceb6412a801a3cf86b3557e1899bef9fd2fcf080f55ac08b5}' OR pmr.meta_value LIKE '{d5e8ab3083dee06ceb6412a801a3cf86b3557e1899bef9fd2fcf080f55ac08b5}Engrais organiques{d5e8ab3083dee06ceb6412a801a3cf86b3557e1899bef9fd2fcf080f55ac08b5}' OR pmr.meta_value LIKE '{d5e8ab3083dee06ceb6412a801a3cf86b3557e1899bef9fd2fcf080f55ac08b5}Engrais organo-minéraux{d5e8ab3083dee06ceb6412a801a3cf86b3557e1899bef9fd2fcf080f55ac08b5}' ) );"
object(stdClass)#2270 (12) { ["name"]=> string(20) "SOUFFLET AGRICULTURE" ["website"]=> string(16) "www.soufflet.com" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> string(0) "" ["zoho_id"]=> string(18) "246999000000253275" ["address"]=> object(stdClass)#2171 (4) { ["street"]=> string(19) "Quai Sarrail - BP12" ["postalcode"]=> string(5) "10402" ["city"]=> string(16) "NOGENT SUR SEINE" ["country"]=> string(6) "France" } ["adherents"]=> array(2) { [0]=> string(9) "Adhérent" [1]=> string(15) "Membre Associé" } ["produits_fabriques"]=> array(5) { [0]=> string(22) "Amendements organiques" [1]=> string(18) "Engrais organiques" [2]=> string(24) "Engrais organo-minéraux" [3]=> string(13) "Biostimulants" [4]=> string(24) "Membre associé d'Afaïa" } ["contributeurs_statistiques"]=> string(0) "" ["tag"]=> array(0) { } ["logo"]=> object(stdClass)#2116 (3) { ["full"]=> object(stdClass)#2241 (3) { ["src"]=> string(83) "https://extranet.afaia.fr/wp-content/uploads/2020/02/logo-soufflet-agriculture.jpeg" ["width"]=> int(267) ["height"]=> int(189) } ["medium"]=> object(stdClass)#2114 (3) { ["src"]=> string(83) "https://extranet.afaia.fr/wp-content/uploads/2020/02/logo-soufflet-agriculture.jpeg" ["width"]=> int(267) ["height"]=> int(189) } ["thumbnail"]=> object(stdClass)#2113 (3) { ["src"]=> string(91) "https://extranet.afaia.fr/wp-content/uploads/2020/02/logo-soufflet-agriculture-150x150.jpeg" ["width"]=> int(150) ["height"]=> int(150) } } }SOUFFLET AGRICULTURE Amendements organiques, Engrais organiques, Engrais organo-minéraux, Biostimulants, Membre associé d'Afaïa http://www.soufflet.com
object(stdClass)#2112 (12) { ["name"]=> string(14) "SUEZ ORGANIQUE" ["website"]=> string(19) "https://www.suez.fr" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> string(0) "" ["zoho_id"]=> string(18) "246999000000253277" ["address"]=> object(stdClass)#2111 (4) { ["street"]=> NULL ["postalcode"]=> NULL ["city"]=> NULL ["country"]=> NULL } ["adherents"]=> array(1) { [0]=> string(9) "Adhérent" } ["produits_fabriques"]=> array(1) { [0]=> string(22) "Amendements organiques" } ["contributeurs_statistiques"]=> string(0) "" ["tag"]=> array(0) { } ["logo"]=> object(stdClass)#2213 (3) { ["full"]=> object(stdClass)#2110 (3) { ["src"]=> string(66) "https://extranet.afaia.fr/wp-content/uploads/2020/02/logo-suez.png" ["width"]=> int(334) ["height"]=> int(85) } ["medium"]=> object(stdClass)#2256 (3) { ["src"]=> string(73) "https://extranet.afaia.fr/wp-content/uploads/2020/02/logo-suez-300x76.png" ["width"]=> int(300) ["height"]=> int(76) } ["thumbnail"]=> object(stdClass)#2138 (3) { ["src"]=> string(73) "https://extranet.afaia.fr/wp-content/uploads/2020/02/logo-suez-150x85.png" ["width"]=> int(150) ["height"]=> int(85) } } }SUEZ ORGANIQUE Amendements organiques https://www.suez.fr
object(stdClass)#2283 (12) { ["name"]=> string(20) "TERRIAL Groupe AVRIL" ["website"]=> string(22) "https://www.terrial.fr" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> string(0) "" ["zoho_id"]=> string(18) "246999000000253286" ["address"]=> object(stdClass)#2284 (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(24) "Engrais organo-minéraux" } ["contributeurs_statistiques"]=> string(0) "" ["tag"]=> array(0) { } ["logo"]=> object(stdClass)#2286 (3) { ["full"]=> object(stdClass)#2285 (3) { ["src"]=> string(68) "https://extranet.afaia.fr/wp-content/uploads/2020/02/terrial-273.jpg" ["width"]=> int(273) ["height"]=> int(184) } ["medium"]=> object(stdClass)#2287 (3) { ["src"]=> string(68) "https://extranet.afaia.fr/wp-content/uploads/2020/02/terrial-273.jpg" ["width"]=> int(273) ["height"]=> int(184) } ["thumbnail"]=> object(stdClass)#2288 (3) { ["src"]=> string(76) "https://extranet.afaia.fr/wp-content/uploads/2020/02/terrial-273-150x150.jpg" ["width"]=> int(150) ["height"]=> int(150) } } }TERRIAL Groupe AVRIL Amendements organiques, Engrais organiques, Engrais organo-minéraux https://www.terrial.fr
object(stdClass)#2289 (12) { ["name"]=> string(17) "TIMAC AGRO France" ["website"]=> string(25) "https://fr.timacagro.com/" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> object(stdClass)#2290 (2) { ["internationalFormat"]=> string(12) "+33299206520" ["frenchFormat"]=> string(14) "02 99 20 65 20" } ["zoho_id"]=> string(18) "246999000006165003" ["address"]=> object(stdClass)#2291 (4) { ["street"]=> string(25) "27 Av. Franklin Roosevelt" ["postalcode"]=> string(5) "35400" ["city"]=> string(10) "Saint-Malo" ["country"]=> string(6) "FRANCE" } ["adherents"]=> array(1) { [0]=> string(9) "Adhérent" } ["produits_fabriques"]=> array(4) { [0]=> string(22) "Amendements organiques" [1]=> string(18) "Engrais organiques" [2]=> string(24) "Engrais organo-minéraux" [3]=> string(13) "Biostimulants" } ["contributeurs_statistiques"]=> string(0) "" ["tag"]=> array(0) { } ["logo"]=> object(stdClass)#2293 (3) { ["full"]=> object(stdClass)#2292 (3) { ["src"]=> string(67) "https://extranet.afaia.fr/wp-content/uploads/2021/12/timac-agro.jpg" ["width"]=> int(322) ["height"]=> int(95) } ["medium"]=> object(stdClass)#2294 (3) { ["src"]=> string(74) "https://extranet.afaia.fr/wp-content/uploads/2021/12/timac-agro-300x89.jpg" ["width"]=> int(300) ["height"]=> int(89) } ["thumbnail"]=> object(stdClass)#2295 (3) { ["src"]=> string(74) "https://extranet.afaia.fr/wp-content/uploads/2021/12/timac-agro-150x95.jpg" ["width"]=> int(150) ["height"]=> int(95) } } }TIMAC AGRO France Amendements organiques, Engrais organiques, Engrais organo-minéraux, Biostimulants https://fr.timacagro.com/
object(stdClass)#2296 (12) { ["name"]=> string(5) "TONYX" ["website"]=> string(12) "www.tonyx.fr" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> string(0) "" ["zoho_id"]=> string(18) "246999000005167147" ["address"]=> object(stdClass)#2297 (4) { ["street"]=> string(19) "58 rue de Fressines" ["postalcode"]=> string(5) "79370" ["city"]=> string(11) "Aigondigné" ["country"]=> string(6) "France" } ["adherents"]=> array(1) { [0]=> string(9) "Adhérent" } ["produits_fabriques"]=> array(4) { [0]=> string(22) "Amendements organiques" [1]=> string(18) "Engrais organiques" [2]=> string(24) "Engrais organo-minéraux" [3]=> string(13) "Biostimulants" } ["contributeurs_statistiques"]=> string(0) "" ["tag"]=> array(0) { } ["logo"]=> object(stdClass)#2299 (3) { ["full"]=> object(stdClass)#2298 (3) { ["src"]=> string(62) "https://extranet.afaia.fr/wp-content/uploads/2021/09/tonyx.jpg" ["width"]=> int(1280) ["height"]=> int(878) } ["medium"]=> object(stdClass)#2300 (3) { ["src"]=> string(70) "https://extranet.afaia.fr/wp-content/uploads/2021/09/tonyx-300x206.jpg" ["width"]=> int(300) ["height"]=> int(206) } ["thumbnail"]=> object(stdClass)#2301 (3) { ["src"]=> string(70) "https://extranet.afaia.fr/wp-content/uploads/2021/09/tonyx-150x150.jpg" ["width"]=> int(150) ["height"]=> int(150) } } }TONYX Amendements organiques, Engrais organiques, Engrais organo-minéraux, Biostimulants http://www.tonyx.fr
object(stdClass)#2302 (12) { ["name"]=> string(14) "TOOPI ORGANICS" ["website"]=> string(27) "https://toopi-organics.com/" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> object(stdClass)#2303 (2) { ["internationalFormat"]=> string(12) "+33630498837" ["frenchFormat"]=> string(14) "06 30 49 88 37" } ["zoho_id"]=> string(18) "246999000004560041" ["address"]=> object(stdClass)#2304 (4) { ["street"]=> string(30) "ZA Ecopole lieu dit aux Halies" ["postalcode"]=> string(5) "33190" ["city"]=> string(19) "Loupiac de la Reole" ["country"]=> NULL } ["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)#2306 (3) { ["full"]=> object(stdClass)#2305 (3) { ["src"]=> string(76) "https://extranet.afaia.fr/wp-content/uploads/2021/07/logo-toopi-organics.png" ["width"]=> int(600) ["height"]=> int(239) } ["medium"]=> object(stdClass)#2307 (3) { ["src"]=> string(84) "https://extranet.afaia.fr/wp-content/uploads/2021/07/logo-toopi-organics-300x120.png" ["width"]=> int(300) ["height"]=> int(120) } ["thumbnail"]=> object(stdClass)#2308 (3) { ["src"]=> string(84) "https://extranet.afaia.fr/wp-content/uploads/2021/07/logo-toopi-organics-150x150.png" ["width"]=> int(150) ["height"]=> int(150) } } }TOOPI ORGANICS Amendements organiques, Biostimulants https://toopi-organics.com/
object(stdClass)#2309 (12) { ["name"]=> string(18) "TRUFFAUT SELECTION" ["website"]=> string(24) "https://www.truffaut.com" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> object(stdClass)#2310 (2) { ["internationalFormat"]=> string(12) "+33169915370" ["frenchFormat"]=> string(14) "01 69 91 53 70" } ["zoho_id"]=> string(18) "246999000000253295" ["address"]=> object(stdClass)#2311 (4) { ["street"]=> NULL ["postalcode"]=> NULL ["city"]=> NULL ["country"]=> NULL } ["adherents"]=> array(1) { [0]=> string(9) "Adhérent" } ["produits_fabriques"]=> array(6) { [0]=> string(19) "Supports de culture" [1]=> string(9) "Paillages" [2]=> string(22) "Amendements organiques" [3]=> string(18) "Engrais organiques" [4]=> string(24) "Engrais organo-minéraux" [5]=> string(13) "Biostimulants" } ["contributeurs_statistiques"]=> string(0) "" ["tag"]=> array(0) { } ["logo"]=> object(stdClass)#2313 (3) { ["full"]=> object(stdClass)#2312 (3) { ["src"]=> string(70) "https://extranet.afaia.fr/wp-content/uploads/2020/02/logo-truffaut.png" ["width"]=> int(134) ["height"]=> int(57) } ["medium"]=> object(stdClass)#2314 (3) { ["src"]=> string(70) "https://extranet.afaia.fr/wp-content/uploads/2020/02/logo-truffaut.png" ["width"]=> int(134) ["height"]=> int(57) } ["thumbnail"]=> object(stdClass)#2315 (3) { ["src"]=> string(70) "https://extranet.afaia.fr/wp-content/uploads/2020/02/logo-truffaut.png" ["width"]=> int(134) ["height"]=> int(57) } } }TRUFFAUT SELECTION Supports de culture, Paillages, Amendements organiques, Engrais organiques, Engrais organo-minéraux, Biostimulants https://www.truffaut.com
object(stdClass)#2316 (12) { ["name"]=> string(4) "UNDV" ["website"]=> string(18) "http://www.undv.fr" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> string(0) "" ["zoho_id"]=> string(18) "246999000000253297" ["address"]=> object(stdClass)#2317 (4) { ["street"]=> NULL ["postalcode"]=> NULL ["city"]=> NULL ["country"]=> NULL } ["adherents"]=> array(1) { [0]=> string(9) "Adhérent" } ["produits_fabriques"]=> array(2) { [0]=> string(22) "Amendements organiques" [1]=> string(18) "Engrais organiques" } ["contributeurs_statistiques"]=> string(0) "" ["tag"]=> array(0) { } ["logo"]=> object(stdClass)#2319 (3) { ["full"]=> object(stdClass)#2318 (3) { ["src"]=> string(82) "https://extranet.afaia.fr/wp-content/uploads/2020/02/undv-logo-2013-vecto-cmjn.jpg" ["width"]=> int(872) ["height"]=> int(969) } ["medium"]=> object(stdClass)#2320 (3) { ["src"]=> string(90) "https://extranet.afaia.fr/wp-content/uploads/2020/02/undv-logo-2013-vecto-cmjn-270x300.jpg" ["width"]=> int(270) ["height"]=> int(300) } ["thumbnail"]=> object(stdClass)#2321 (3) { ["src"]=> string(90) "https://extranet.afaia.fr/wp-content/uploads/2020/02/undv-logo-2013-vecto-cmjn-150x150.jpg" ["width"]=> int(150) ["height"]=> int(150) } } }UNDV Amendements organiques, Engrais organiques http://www.undv.fr
object(stdClass)#2322 (12) { ["name"]=> string(7) "VALAVIE" ["website"]=> string(22) "http://www.aviferme.re" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> string(0) "" ["zoho_id"]=> string(18) "246999000000253298" ["address"]=> object(stdClass)#2323 (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(24) "Engrais organo-minéraux" } ["contributeurs_statistiques"]=> string(0) "" ["tag"]=> array(0) { } ["logo"]=> object(stdClass)#2325 (3) { ["full"]=> object(stdClass)#2324 (3) { ["src"]=> string(67) "https://extranet.afaia.fr/wp-content/uploads/2020/02/valavie150.png" ["width"]=> int(150) ["height"]=> int(71) } ["medium"]=> object(stdClass)#2326 (3) { ["src"]=> string(67) "https://extranet.afaia.fr/wp-content/uploads/2020/02/valavie150.png" ["width"]=> int(150) ["height"]=> int(71) } ["thumbnail"]=> object(stdClass)#2327 (3) { ["src"]=> string(67) "https://extranet.afaia.fr/wp-content/uploads/2020/02/valavie150.png" ["width"]=> int(150) ["height"]=> int(71) } } }VALAVIE Amendements organiques, Engrais organiques, Engrais organo-minéraux http://www.aviferme.re
object(stdClass)#2328 (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)#2329 (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)#2331 (3) { ["full"]=> object(stdClass)#2330 (3) { ["src"]=> string(69) "https://extranet.afaia.fr/wp-content/uploads/2020/02/vanisrae150l.png" ["width"]=> int(150) ["height"]=> int(150) } ["medium"]=> object(stdClass)#2332 (3) { ["src"]=> string(69) "https://extranet.afaia.fr/wp-content/uploads/2020/02/vanisrae150l.png" ["width"]=> int(150) ["height"]=> int(150) } ["thumbnail"]=> object(stdClass)#2333 (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)#2334 (12) { ["name"]=> string(8) "VERAGROW" ["website"]=> string(20) "https://veragrow.fr/" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> object(stdClass)#2335 (2) { ["internationalFormat"]=> string(12) "+33646797477" ["frenchFormat"]=> string(14) "06 46 79 74 77" } ["zoho_id"]=> string(18) "246999000007791087" ["address"]=> object(stdClass)#2336 (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)#2338 (3) { ["full"]=> object(stdClass)#2337 (3) { ["src"]=> string(65) "https://extranet.afaia.fr/wp-content/uploads/2022/03/veragrow.png" ["width"]=> int(108) ["height"]=> int(96) } ["medium"]=> object(stdClass)#2339 (3) { ["src"]=> string(65) "https://extranet.afaia.fr/wp-content/uploads/2022/03/veragrow.png" ["width"]=> int(108) ["height"]=> int(96) } ["thumbnail"]=> object(stdClass)#2340 (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)#2341 (12) { ["name"]=> string(7) "VIVAGRO" ["website"]=> string(14) "www.vivagro.eu" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> object(stdClass)#2342 (2) { ["internationalFormat"]=> string(12) "+33557783268" ["frenchFormat"]=> string(14) "05 57 78 32 68" } ["zoho_id"]=> string(18) "246999000003338040" ["address"]=> object(stdClass)#2343 (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)#2345 (3) { ["full"]=> object(stdClass)#2344 (3) { ["src"]=> string(64) "https://extranet.afaia.fr/wp-content/uploads/2021/03/vivagro.jpg" ["width"]=> int(257) ["height"]=> int(141) } ["medium"]=> object(stdClass)#2346 (3) { ["src"]=> string(64) "https://extranet.afaia.fr/wp-content/uploads/2021/03/vivagro.jpg" ["width"]=> int(257) ["height"]=> int(141) } ["thumbnail"]=> object(stdClass)#2347 (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