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 '{711906f03b60be3ae3919468bcb1e5fe52bc75e3b4281f5bea378b65240043b2}Amendements organiques{711906f03b60be3ae3919468bcb1e5fe52bc75e3b4281f5bea378b65240043b2}' OR pmr.meta_value LIKE '{711906f03b60be3ae3919468bcb1e5fe52bc75e3b4281f5bea378b65240043b2}Engrais organiques{711906f03b60be3ae3919468bcb1e5fe52bc75e3b4281f5bea378b65240043b2}' OR pmr.meta_value LIKE '{711906f03b60be3ae3919468bcb1e5fe52bc75e3b4281f5bea378b65240043b2}Engrais organo-minéraux{711906f03b60be3ae3919468bcb1e5fe52bc75e3b4281f5bea378b65240043b2}' ) );"
object(stdClass)#9765 (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)#9779 (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)#9649 (3) { ["full"]=> object(stdClass)#9766 (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)#9650 (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)#9648 (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)#9647 (12) { ["name"]=> string(6) "AGARIS" ["website"]=> string(14) "www.agaris.com" ["twitter"]=> string(0) "" ["image"]=> string(160) "c9fda16b6c26913d5fa6fc695806e18e08ad6b4341bf80f18601bc5c1f9b84833f3971fb9b70b3c4fc8c1269e7a1aab93bf78fe72f2775c47cd8c7be8f59d29a5808c81d932a48cf1f094abe9376b68a" ["phone"]=> object(stdClass)#9646 (2) { ["internationalFormat"]=> string(14) "+33+3292180330" ["frenchFormat"]=> string(12) "0+3292180330" } ["zoho_id"]=> string(18) "246999000000253106" ["address"]=> object(stdClass)#9645 (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)#9751 (3) { ["full"]=> object(stdClass)#9644 (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)#9794 (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)#9680 (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)#9821 (12) { ["name"]=> string(13) "AGRI SYMBIOSE" ["website"]=> string(25) "https://agrisymbiose.com/" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> object(stdClass)#9822 (2) { ["internationalFormat"]=> string(11) "+3355621179" ["frenchFormat"]=> string(9) "055621179" } ["zoho_id"]=> string(18) "246999000007791001" ["address"]=> object(stdClass)#9823 (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)#9825 (3) { ["full"]=> object(stdClass)#9824 (3) { ["src"]=> string(70) "https://extranet.afaia.fr/wp-content/uploads/2022/03/agri-symbiose.png" ["width"]=> int(262) ["height"]=> int(145) } ["medium"]=> object(stdClass)#9826 (3) { ["src"]=> string(70) "https://extranet.afaia.fr/wp-content/uploads/2022/03/agri-symbiose.png" ["width"]=> int(262) ["height"]=> int(145) } ["thumbnail"]=> object(stdClass)#9827 (3) { ["src"]=> string(78) "https://extranet.afaia.fr/wp-content/uploads/2022/03/agri-symbiose-150x145.png" ["width"]=> int(150) ["height"]=> int(145) } } }AGRI SYMBIOSE Engrais organiques, Engrais organo-minéraux, Biostimulants https://agrisymbiose.com/
object(stdClass)#9828 (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)#9829 (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)#9831 (3) { ["full"]=> object(stdClass)#9830 (3) { ["src"]=> string(64) "https://extranet.afaia.fr/wp-content/uploads/2020/02/tonusol.jpg" ["width"]=> int(300) ["height"]=> int(207) } ["medium"]=> object(stdClass)#9832 (3) { ["src"]=> string(64) "https://extranet.afaia.fr/wp-content/uploads/2020/02/tonusol.jpg" ["width"]=> int(300) ["height"]=> int(207) } ["thumbnail"]=> object(stdClass)#9833 (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)#9834 (12) { ["name"]=> string(10) "AGRONUTRIS" ["website"]=> string(26) "https://www.agronutris.com" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> object(stdClass)#9835 (2) { ["internationalFormat"]=> string(12) "+33531543288" ["frenchFormat"]=> string(14) "05 31 54 32 88" } ["zoho_id"]=> string(18) "246999000000390060" ["address"]=> object(stdClass)#9836 (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)#9838 (3) { ["full"]=> object(stdClass)#9837 (3) { ["src"]=> string(67) "https://extranet.afaia.fr/wp-content/uploads/2020/03/agronutris.jpg" ["width"]=> int(324) ["height"]=> int(84) } ["medium"]=> object(stdClass)#9839 (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)#9840 (3) { ["src"]=> string(74) "https://extranet.afaia.fr/wp-content/uploads/2020/03/agronutris-150x84.jpg" ["width"]=> int(150) ["height"]=> int(84) } } }AGRONUTRIS Engrais organiques https://www.agronutris.com
object(stdClass)#9841 (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)#9842 (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)#9844 (3) { ["full"]=> object(stdClass)#9843 (3) { ["src"]=> string(70) "https://extranet.afaia.fr/wp-content/uploads/2020/02/agronutrition.jpg" ["width"]=> int(269) ["height"]=> int(84) } ["medium"]=> object(stdClass)#9845 (3) { ["src"]=> string(70) "https://extranet.afaia.fr/wp-content/uploads/2020/02/agronutrition.jpg" ["width"]=> int(269) ["height"]=> int(84) } ["thumbnail"]=> object(stdClass)#9846 (3) { ["src"]=> string(77) "https://extranet.afaia.fr/wp-content/uploads/2020/02/agronutrition-150x84.jpg" ["width"]=> int(150) ["height"]=> int(84) } } }AGRONUTRITION SA Engrais organiques, Engrais organo-minéraux, Biostimulants http://www.agronutrition.com
object(stdClass)#9847 (12) { ["name"]=> string(13) "AKIOLIS Group" ["website"]=> string(26) "https://www.akiolis.com/fr" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> object(stdClass)#9848 (2) { ["internationalFormat"]=> string(12) "+33244815010" ["frenchFormat"]=> string(14) "02 44 81 50 10" } ["zoho_id"]=> string(18) "246999000002925037" ["address"]=> object(stdClass)#9849 (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)#9851 (3) { ["full"]=> object(stdClass)#9850 (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)#9852 (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)#9853 (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) } } }AKIOLIS Group Engrais organiques, Engrais organo-minéraux https://www.akiolis.com/fr
object(stdClass)#9854 (12) { ["name"]=> string(8) "ANGIBAUD" ["website"]=> string(15) "www.angibaud.fr" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> string(0) "" ["zoho_id"]=> string(18) "246999000000253127" ["address"]=> object(stdClass)#9855 (4) { ["street"]=> NULL ["postalcode"]=> NULL ["city"]=> NULL ["country"]=> NULL } ["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)#9857 (3) { ["full"]=> object(stdClass)#9856 (3) { ["src"]=> string(73) "https://extranet.afaia.fr/wp-content/uploads/2020/02/angibau-baseline.png" ["width"]=> int(228) ["height"]=> int(140) } ["medium"]=> object(stdClass)#9858 (3) { ["src"]=> string(73) "https://extranet.afaia.fr/wp-content/uploads/2020/02/angibau-baseline.png" ["width"]=> int(228) ["height"]=> int(140) } ["thumbnail"]=> object(stdClass)#9859 (3) { ["src"]=> string(81) "https://extranet.afaia.fr/wp-content/uploads/2020/02/angibau-baseline-150x140.png" ["width"]=> int(150) ["height"]=> int(140) } } }ANGIBAUD Amendements organiques, Engrais organiques, Engrais organo-minéraux, Biostimulants http://www.angibaud.fr
object(stdClass)#9860 (12) { ["name"]=> string(5) "BIO3G" ["website"]=> string(12) "www.bio3g.fr" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> string(0) "" ["zoho_id"]=> string(18) "246999000000253138" ["address"]=> object(stdClass)#9861 (4) { ["street"]=> NULL ["postalcode"]=> NULL ["city"]=> NULL ["country"]=> NULL } ["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)#9863 (3) { ["full"]=> object(stdClass)#9862 (3) { ["src"]=> string(62) "https://extranet.afaia.fr/wp-content/uploads/2020/02/bio3g.jpg" ["width"]=> int(187) ["height"]=> int(187) } ["medium"]=> object(stdClass)#9864 (3) { ["src"]=> string(62) "https://extranet.afaia.fr/wp-content/uploads/2020/02/bio3g.jpg" ["width"]=> int(187) ["height"]=> int(187) } ["thumbnail"]=> object(stdClass)#9865 (3) { ["src"]=> string(70) "https://extranet.afaia.fr/wp-content/uploads/2020/02/bio3g-150x150.jpg" ["width"]=> int(150) ["height"]=> int(150) } } }BIO3G Amendements organiques, Engrais organiques, Engrais organo-minéraux, Biostimulants http://www.bio3g.fr
object(stdClass)#9866 (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)#9867 (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)#9869 (3) { ["full"]=> object(stdClass)#9868 (3) { ["src"]=> string(66) "https://extranet.afaia.fr/wp-content/uploads/2020/02/biofertil.jpg" ["width"]=> int(600) ["height"]=> int(198) } ["medium"]=> object(stdClass)#9870 (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)#9871 (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)#9872 (12) { ["name"]=> string(19) "BIOLANDES PIN DECOR" ["website"]=> string(25) "https://www.biolandes.com" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> object(stdClass)#9873 (2) { ["internationalFormat"]=> string(12) "+33558510000" ["frenchFormat"]=> string(14) "05 58 51 00 00" } ["zoho_id"]=> string(18) "246999000000253147" ["address"]=> object(stdClass)#9874 (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)#9876 (3) { ["full"]=> object(stdClass)#9875 (3) { ["src"]=> string(66) "https://extranet.afaia.fr/wp-content/uploads/2020/02/biolande1.jpg" ["width"]=> int(500) ["height"]=> int(83) } ["medium"]=> object(stdClass)#9877 (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)#9878 (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)#9879 (12) { ["name"]=> string(14) "CLER VERTS SAS" ["website"]=> string(24) "http://www.cler-verts.fr" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> string(0) "" ["zoho_id"]=> string(18) "246999000000253165" ["address"]=> object(stdClass)#9880 (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)#9882 (3) { ["full"]=> object(stdClass)#9881 (3) { ["src"]=> string(67) "https://extranet.afaia.fr/wp-content/uploads/2020/02/cler-verts.jpg" ["width"]=> int(225) ["height"]=> int(225) } ["medium"]=> object(stdClass)#9883 (3) { ["src"]=> string(67) "https://extranet.afaia.fr/wp-content/uploads/2020/02/cler-verts.jpg" ["width"]=> int(225) ["height"]=> int(225) } ["thumbnail"]=> object(stdClass)#9884 (3) { ["src"]=> string(75) "https://extranet.afaia.fr/wp-content/uploads/2020/02/cler-verts-150x150.jpg" ["width"]=> int(150) ["height"]=> int(150) } } }CLER VERTS SAS Amendements organiques http://www.cler-verts.fr