string(492) "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 '{c4e8501c04857bb829746fc2ffae974daca5573d9842cdfe24b63101c5ed2f8e}Biostimulants{c4e8501c04857bb829746fc2ffae974daca5573d9842cdfe24b63101c5ed2f8e}' ) );"
object(stdClass)#2131 (12) { ["name"]=> string(18) "TRUFFAUT SELECTION" ["website"]=> string(24) "https://www.truffaut.com" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> object(stdClass)#2032 (2) { ["internationalFormat"]=> string(12) "+33169915370" ["frenchFormat"]=> string(14) "01 69 91 53 70" } ["zoho_id"]=> string(18) "246999000000253295" ["address"]=> object(stdClass)#2102 (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)#1973 (3) { ["full"]=> object(stdClass)#1975 (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)#1972 (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)#1971 (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)#1970 (12) { ["name"]=> string(10) "UPL FRANCE" ["website"]=> string(26) "https://www.upl-ltd.com/fr" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> object(stdClass)#1969 (2) { ["internationalFormat"]=> string(12) "+33145359200" ["frenchFormat"]=> string(14) "01 45 35 92 00" } ["zoho_id"]=> string(18) "246999000007789141" ["address"]=> object(stdClass)#2074 (4) { ["street"]=> string(36) "Tour Voltaire - 1, place des Degrés" ["postalcode"]=> string(5) "92800" ["city"]=> string(7) "PUTEAUX" ["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)#1997 (3) { ["full"]=> object(stdClass)#2117 (3) { ["src"]=> string(104) "https://extranet.afaia.fr/wp-content/uploads/2022/03/upl-primary-brand-mark-colourblack-logotype-rgb.png" ["width"]=> int(1448) ["height"]=> int(941) } ["medium"]=> object(stdClass)#2144 (3) { ["src"]=> string(112) "https://extranet.afaia.fr/wp-content/uploads/2022/03/upl-primary-brand-mark-colourblack-logotype-rgb-300x195.png" ["width"]=> int(300) ["height"]=> int(195) } ["thumbnail"]=> object(stdClass)#2145 (3) { ["src"]=> string(112) "https://extranet.afaia.fr/wp-content/uploads/2022/03/upl-primary-brand-mark-colourblack-logotype-rgb-150x150.png" ["width"]=> int(150) ["height"]=> int(150) } } }UPL FRANCE Biostimulants https://www.upl-ltd.com/fr
object(stdClass)#2146 (12) { ["name"]=> string(8) "VERAGROW" ["website"]=> string(20) "https://veragrow.fr/" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> object(stdClass)#2147 (2) { ["internationalFormat"]=> string(12) "+33646797477" ["frenchFormat"]=> string(14) "06 46 79 74 77" } ["zoho_id"]=> string(18) "246999000007791087" ["address"]=> object(stdClass)#2148 (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)#2150 (3) { ["full"]=> object(stdClass)#2149 (3) { ["src"]=> string(65) "https://extranet.afaia.fr/wp-content/uploads/2022/03/veragrow.png" ["width"]=> int(108) ["height"]=> int(96) } ["medium"]=> object(stdClass)#2151 (3) { ["src"]=> string(65) "https://extranet.afaia.fr/wp-content/uploads/2022/03/veragrow.png" ["width"]=> int(108) ["height"]=> int(96) } ["thumbnail"]=> object(stdClass)#2152 (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)#2153 (12) { ["name"]=> string(7) "VIVAGRO" ["website"]=> string(14) "www.vivagro.eu" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> object(stdClass)#2154 (2) { ["internationalFormat"]=> string(12) "+33557783268" ["frenchFormat"]=> string(14) "05 57 78 32 68" } ["zoho_id"]=> string(18) "246999000003338040" ["address"]=> object(stdClass)#2155 (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)#2157 (3) { ["full"]=> object(stdClass)#2156 (3) { ["src"]=> string(64) "https://extranet.afaia.fr/wp-content/uploads/2021/03/vivagro.jpg" ["width"]=> int(257) ["height"]=> int(141) } ["medium"]=> object(stdClass)#2158 (3) { ["src"]=> string(64) "https://extranet.afaia.fr/wp-content/uploads/2021/03/vivagro.jpg" ["width"]=> int(257) ["height"]=> int(141) } ["thumbnail"]=> object(stdClass)#2159 (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)#2160 (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)#2161 (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)#2163 (3) { ["full"]=> object(stdClass)#2162 (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)#2164 (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)#2165 (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