string(666) "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 '{43051dd72730a3d6aedefcfb01a1c884c7ac1c461261b18c2c040a9210ce2534}Supports de culture{43051dd72730a3d6aedefcfb01a1c884c7ac1c461261b18c2c040a9210ce2534}' OR pmr.meta_value LIKE '{43051dd72730a3d6aedefcfb01a1c884c7ac1c461261b18c2c040a9210ce2534}Paillages{43051dd72730a3d6aedefcfb01a1c884c7ac1c461261b18c2c040a9210ce2534}' ) );"
object(stdClass)#10505 (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)#10406 (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)#10352 (3) { ["full"]=> object(stdClass)#10476 (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)#10350 (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)#10349 (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) } } }4 VAULX JARDIN Supports de culture, Amendements organiques, Engrais organiques, Engrais organo-minéraux http://www.4vaulx-jardin.com
object(stdClass)#10348 (12) { ["name"]=> string(11) "AESEA Group" ["website"]=> string(19) "https://aquiland.fr" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> string(0) "" ["zoho_id"]=> string(18) "246999000000253098" ["address"]=> object(stdClass)#10347 (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)#10448 (3) { ["full"]=> object(stdClass)#10346 (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)#10491 (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)#10376 (3) { ["src"]=> string(78) "https://extranet.afaia.fr/wp-content/uploads/2020/02/logo-aquiland-150x123.jpg" ["width"]=> int(150) ["height"]=> int(123) } } }AESEA Group Supports de culture https://aquiland.fr
object(stdClass)#10518 (12) { ["name"]=> string(6) "AGARIS" ["website"]=> string(14) "www.agaris.com" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> object(stdClass)#10519 (2) { ["internationalFormat"]=> string(14) "+33+3292180330" ["frenchFormat"]=> string(12) "0+3292180330" } ["zoho_id"]=> string(18) "246999000000253106" ["address"]=> object(stdClass)#10520 (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)#10522 (3) { ["full"]=> object(stdClass)#10521 (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)#10523 (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)#10524 (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) } } }AGARIS Supports de culture, Paillages, Amendements organiques, Engrais organiques http://www.agaris.com
object(stdClass)#10525 (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)#10526 (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)#10528 (3) { ["full"]=> object(stdClass)#10527 (3) { ["src"]=> string(64) "https://extranet.afaia.fr/wp-content/uploads/2020/02/tonusol.jpg" ["width"]=> int(300) ["height"]=> int(207) } ["medium"]=> object(stdClass)#10529 (3) { ["src"]=> string(64) "https://extranet.afaia.fr/wp-content/uploads/2020/02/tonusol.jpg" ["width"]=> int(300) ["height"]=> int(207) } ["thumbnail"]=> object(stdClass)#10530 (3) { ["src"]=> string(72) "https://extranet.afaia.fr/wp-content/uploads/2020/02/tonusol-150x150.jpg" ["width"]=> int(150) ["height"]=> int(150) } } }AGRIVER - TONUSOL Supports de culture, Paillages, Amendements organiques https://www.tonusol.com
object(stdClass)#10531 (12) { ["name"]=> string(13) "Anjou Ardoise" ["website"]=> string(29) "https://www.anjou-ardoise.fr/" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> object(stdClass)#10532 (2) { ["internationalFormat"]=> string(12) "+33626158450" ["frenchFormat"]=> string(14) "06 26 15 84 50" } ["zoho_id"]=> string(18) "246999000013464039" ["address"]=> object(stdClass)#10533 (4) { ["street"]=> string(27) "15 place Alexandre Veillard" ["postalcode"]=> string(5) "35140" ["city"]=> string(22) "SAINT-AUBIN-DU-CORMIER" ["country"]=> string(6) "FRANCE" } ["adherents"]=> array(1) { [0]=> string(9) "Adhérent" } ["produits_fabriques"]=> array(1) { [0]=> string(9) "Paillages" } ["contributeurs_statistiques"]=> string(0) "" ["tag"]=> array(0) { } ["logo"]=> object(stdClass)#10535 (3) { ["full"]=> object(stdClass)#10534 (3) { ["src"]=> string(75) "https://extranet.afaia.fr/wp-content/uploads/2023/07/logo-anjou-ardoise.png" ["width"]=> int(544) ["height"]=> int(346) } ["medium"]=> object(stdClass)#10536 (3) { ["src"]=> string(83) "https://extranet.afaia.fr/wp-content/uploads/2023/07/logo-anjou-ardoise-300x191.png" ["width"]=> int(300) ["height"]=> int(191) } ["thumbnail"]=> object(stdClass)#10537 (3) { ["src"]=> string(83) "https://extranet.afaia.fr/wp-content/uploads/2023/07/logo-anjou-ardoise-150x150.png" ["width"]=> int(150) ["height"]=> int(150) } } }Anjou Ardoise Paillages https://www.anjou-ardoise.fr/
object(stdClass)#10538 (12) { ["name"]=> string(9) "BIOFERTIL" ["website"]=> string(21) "https://biofertil.fr/" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> string(0) "" ["zoho_id"]=> string(18) "246999000000253146" ["address"]=> object(stdClass)#10539 (4) { ["street"]=> NULL ["postalcode"]=> NULL ["city"]=> NULL ["country"]=> NULL } ["adherents"]=> array(1) { [0]=> string(9) "Adhérent" } ["produits_fabriques"]=> array(2) { [0]=> string(19) "Supports de culture" [1]=> string(22) "Amendements organiques" } ["contributeurs_statistiques"]=> string(0) "" ["tag"]=> array(0) { } ["logo"]=> object(stdClass)#10541 (3) { ["full"]=> object(stdClass)#10540 (3) { ["src"]=> string(66) "https://extranet.afaia.fr/wp-content/uploads/2020/02/biofertil.jpg" ["width"]=> int(600) ["height"]=> int(198) } ["medium"]=> object(stdClass)#10542 (3) { ["src"]=> string(73) "https://extranet.afaia.fr/wp-content/uploads/2020/02/biofertil-300x99.jpg" ["width"]=> int(300) ["height"]=> int(99) } ["thumbnail"]=> object(stdClass)#10543 (3) { ["src"]=> string(74) "https://extranet.afaia.fr/wp-content/uploads/2020/02/biofertil-150x150.jpg" ["width"]=> int(150) ["height"]=> int(150) } } }BIOFERTIL Supports de culture, Amendements organiques https://biofertil.fr/
object(stdClass)#10544 (12) { ["name"]=> string(19) "BIOLANDES PIN DECOR" ["website"]=> string(25) "https://www.biolandes.com" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> object(stdClass)#10545 (2) { ["internationalFormat"]=> string(12) "+33558510000" ["frenchFormat"]=> string(14) "05 58 51 00 00" } ["zoho_id"]=> string(18) "246999000000253147" ["address"]=> object(stdClass)#10546 (4) { ["street"]=> string(20) "2760 Route de Bélis" ["postalcode"]=> string(5) "40420" ["city"]=> string(6) "LE SEN" ["country"]=> string(6) "FRANCE" } ["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)#10548 (3) { ["full"]=> object(stdClass)#10547 (3) { ["src"]=> string(66) "https://extranet.afaia.fr/wp-content/uploads/2020/02/biolande1.jpg" ["width"]=> int(500) ["height"]=> int(83) } ["medium"]=> object(stdClass)#10549 (3) { ["src"]=> string(73) "https://extranet.afaia.fr/wp-content/uploads/2020/02/biolande1-300x50.jpg" ["width"]=> int(300) ["height"]=> int(50) } ["thumbnail"]=> object(stdClass)#10550 (3) { ["src"]=> string(73) "https://extranet.afaia.fr/wp-content/uploads/2020/02/biolande1-150x83.jpg" ["width"]=> int(150) ["height"]=> int(83) } } }BIOLANDES PIN DECOR Supports de culture, Paillages, Amendements organiques https://www.biolandes.com
object(stdClass)#10551 (12) { ["name"]=> string(12) "BRILL FRANCE" ["website"]=> string(32) "https://www.brill-substrate.com/" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> object(stdClass)#10552 (2) { ["internationalFormat"]=> string(12) "+33472775277" ["frenchFormat"]=> string(14) "04 72 77 52 77" } ["zoho_id"]=> string(18) "246999000000253156" ["address"]=> object(stdClass)#10553 (4) { ["street"]=> string(21) "21 Rue de l'Industrie" ["postalcode"]=> string(5) "69530" ["city"]=> string(8) "Brignais" ["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)#10555 (3) { ["full"]=> object(stdClass)#10554 (3) { ["src"]=> string(62) "https://extranet.afaia.fr/wp-content/uploads/2020/02/brill.jpg" ["width"]=> int(392) ["height"]=> int(374) } ["medium"]=> object(stdClass)#10556 (3) { ["src"]=> string(70) "https://extranet.afaia.fr/wp-content/uploads/2020/02/brill-300x286.jpg" ["width"]=> int(300) ["height"]=> int(286) } ["thumbnail"]=> object(stdClass)#10557 (3) { ["src"]=> string(70) "https://extranet.afaia.fr/wp-content/uploads/2020/02/brill-150x150.jpg" ["width"]=> int(150) ["height"]=> int(150) } } }BRILL FRANCE Supports de culture https://www.brill-substrate.com/
object(stdClass)#10558 (12) { ["name"]=> string(12) "DCM SOPRIMEX" ["website"]=> string(23) "http://www.soprimex.com" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> object(stdClass)#10559 (2) { ["internationalFormat"]=> string(12) "+33490240424" ["frenchFormat"]=> string(14) "04 90 24 04 24" } ["zoho_id"]=> string(18) "246999000000253175" ["address"]=> object(stdClass)#10560 (4) { ["street"]=> string(17) "23 rue du Creuzat" ["postalcode"]=> string(5) "38080" ["city"]=> string(18) "L’ISLE D’ABEAU" ["country"]=> string(6) "FRANCE" } ["adherents"]=> array(1) { [0]=> string(9) "Adhérent" } ["produits_fabriques"]=> array(5) { [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" } ["contributeurs_statistiques"]=> string(0) "" ["tag"]=> array(0) { } ["logo"]=> object(stdClass)#10562 (3) { ["full"]=> object(stdClass)#10561 (3) { ["src"]=> string(69) "https://extranet.afaia.fr/wp-content/uploads/2020/02/dcm-soprimex.jpg" ["width"]=> int(346) ["height"]=> int(67) } ["medium"]=> object(stdClass)#10563 (3) { ["src"]=> string(76) "https://extranet.afaia.fr/wp-content/uploads/2020/02/dcm-soprimex-300x58.jpg" ["width"]=> int(300) ["height"]=> int(58) } ["thumbnail"]=> object(stdClass)#10564 (3) { ["src"]=> string(76) "https://extranet.afaia.fr/wp-content/uploads/2020/02/dcm-soprimex-150x67.jpg" ["width"]=> int(150) ["height"]=> int(67) } } }DCM SOPRIMEX Supports de culture, Paillages, Amendements organiques, Engrais organiques, Engrais organo-minéraux http://www.soprimex.com
object(stdClass)#10565 (12) { ["name"]=> string(6) "DUMONA" ["website"]=> string(23) "https://www.dumona.com/" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> object(stdClass)#10566 (2) { ["internationalFormat"]=> string(12) "+33474808155" ["frenchFormat"]=> string(14) "04 74 80 81 55" } ["zoho_id"]=> string(18) "246999000000253176" ["address"]=> object(stdClass)#10567 (4) { ["street"]=> NULL ["postalcode"]=> NULL ["city"]=> NULL ["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)#10569 (3) { ["full"]=> object(stdClass)#10568 (3) { ["src"]=> string(69) "https://extranet.afaia.fr/wp-content/uploads/2020/02/dumona-vecto.jpg" ["width"]=> int(300) ["height"]=> int(133) } ["medium"]=> object(stdClass)#10570 (3) { ["src"]=> string(69) "https://extranet.afaia.fr/wp-content/uploads/2020/02/dumona-vecto.jpg" ["width"]=> int(300) ["height"]=> int(133) } ["thumbnail"]=> object(stdClass)#10571 (3) { ["src"]=> string(77) "https://extranet.afaia.fr/wp-content/uploads/2020/02/dumona-vecto-150x133.jpg" ["width"]=> int(150) ["height"]=> int(133) } } }DUMONA Supports de culture https://www.dumona.com/
object(stdClass)#10572 (12) { ["name"]=> string(13) "EVADEA GROUPE" ["website"]=> string(26) "http://www.tourbieres.com/" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> string(0) "" ["zoho_id"]=> string(18) "246999000000253187" ["address"]=> object(stdClass)#10573 (4) { ["street"]=> NULL ["postalcode"]=> NULL ["city"]=> NULL ["country"]=> NULL } ["adherents"]=> array(1) { [0]=> string(9) "Adhérent" } ["produits_fabriques"]=> array(5) { [0]=> string(19) "Supports de culture" [1]=> string(9) "Paillages" [2]=> string(22) "Amendements organiques" [3]=> string(18) "Engrais organiques" [4]=> string(13) "Biostimulants" } ["contributeurs_statistiques"]=> string(0) "" ["tag"]=> array(0) { } ["logo"]=> object(stdClass)#10575 (3) { ["full"]=> object(stdClass)#10574 (3) { ["src"]=> string(78) "https://extranet.afaia.fr/wp-content/uploads/2022/01/EVADEA PICTO BASELINE.png" ["width"]=> int(934) ["height"]=> int(431) } ["medium"]=> object(stdClass)#10576 (3) { ["src"]=> string(86) "https://extranet.afaia.fr/wp-content/uploads/2022/01/EVADEA PICTO BASELINE-300x138.png" ["width"]=> int(300) ["height"]=> int(138) } ["thumbnail"]=> object(stdClass)#10577 (3) { ["src"]=> string(86) "https://extranet.afaia.fr/wp-content/uploads/2022/01/EVADEA PICTO BASELINE-150x150.png" ["width"]=> int(150) ["height"]=> int(150) } } }EVADEA GROUPE Supports de culture, Paillages, Amendements organiques, Engrais organiques, Biostimulants http://www.tourbieres.com/
object(stdClass)#10578 (12) { ["name"]=> string(6) "FERTIL" ["website"]=> string(16) "http://fertil.fr" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> string(0) "" ["zoho_id"]=> string(18) "246999000000253196" ["address"]=> object(stdClass)#10579 (4) { ["street"]=> NULL ["postalcode"]=> NULL ["city"]=> NULL ["country"]=> NULL } ["adherents"]=> array(1) { [0]=> string(9) "Adhérent" } ["produits_fabriques"]=> array(2) { [0]=> string(9) "Paillages" [1]=> string(18) "Engrais organiques" } ["contributeurs_statistiques"]=> string(0) "" ["tag"]=> array(0) { } ["logo"]=> object(stdClass)#10581 (3) { ["full"]=> object(stdClass)#10580 (3) { ["src"]=> string(67) "https://extranet.afaia.fr/wp-content/uploads/2022/10/LogoFertil.png" ["width"]=> int(134) ["height"]=> int(134) } ["medium"]=> object(stdClass)#10582 (3) { ["src"]=> string(67) "https://extranet.afaia.fr/wp-content/uploads/2022/10/LogoFertil.png" ["width"]=> int(134) ["height"]=> int(134) } ["thumbnail"]=> object(stdClass)#10583 (3) { ["src"]=> string(67) "https://extranet.afaia.fr/wp-content/uploads/2022/10/LogoFertil.png" ["width"]=> int(134) ["height"]=> int(134) } } }FERTIL Paillages, Engrais organiques http://fertil.fr