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 '{4a6a6e1a9908b73a9d9deb3735bdb417b54a6bc79c3c83ffc74664b29a29ae41}Supports de culture{4a6a6e1a9908b73a9d9deb3735bdb417b54a6bc79c3c83ffc74664b29a29ae41}' OR pmr.meta_value LIKE '{4a6a6e1a9908b73a9d9deb3735bdb417b54a6bc79c3c83ffc74664b29a29ae41}Paillages{4a6a6e1a9908b73a9d9deb3735bdb417b54a6bc79c3c83ffc74664b29a29ae41}' ) );"
object(stdClass)#2131 (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)#2032 (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)#1975 (3) { ["full"]=> object(stdClass)#2102 (3) { ["src"]=> string(67) "https://extranet.afaia.fr/wp-content/uploads/2022/10/LogoFertil.png" ["width"]=> int(134) ["height"]=> int(134) } ["medium"]=> object(stdClass)#1973 (3) { ["src"]=> string(67) "https://extranet.afaia.fr/wp-content/uploads/2022/10/LogoFertil.png" ["width"]=> int(134) ["height"]=> int(134) } ["thumbnail"]=> object(stdClass)#1972 (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
object(stdClass)#1971 (12) { ["name"]=> string(11) "FIBRE VERTE" ["website"]=> string(26) "https://www.fibreverte.com" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> string(0) "" ["zoho_id"]=> string(18) "246999000000253205" ["address"]=> object(stdClass)#1970 (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(9) "Paillages" } ["contributeurs_statistiques"]=> string(0) "" ["tag"]=> array(0) { } ["logo"]=> object(stdClass)#2074 (3) { ["full"]=> object(stdClass)#1969 (3) { ["src"]=> string(70) "https://extranet.afaia.fr/wp-content/uploads/2020/02/fibreverte150.png" ["width"]=> int(150) ["height"]=> int(150) } ["medium"]=> object(stdClass)#2117 (3) { ["src"]=> string(70) "https://extranet.afaia.fr/wp-content/uploads/2020/02/fibreverte150.png" ["width"]=> int(150) ["height"]=> int(150) } ["thumbnail"]=> object(stdClass)#1997 (3) { ["src"]=> string(78) "https://extranet.afaia.fr/wp-content/uploads/2020/02/fibreverte150-150x150.png" ["width"]=> int(150) ["height"]=> int(150) } } }FIBRE VERTE Supports de culture, Paillages https://www.fibreverte.com
object(stdClass)#2144 (12) { ["name"]=> string(11) "FLORENTAISE" ["website"]=> string(26) "http://www.florentaise.com" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> string(0) "" ["zoho_id"]=> string(18) "246999000000253206" ["address"]=> object(stdClass)#2145 (4) { ["street"]=> NULL ["postalcode"]=> NULL ["city"]=> NULL ["country"]=> NULL } ["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(13) "Biostimulants" } ["contributeurs_statistiques"]=> string(0) "" ["tag"]=> array(0) { } ["logo"]=> object(stdClass)#2147 (3) { ["full"]=> object(stdClass)#2146 (3) { ["src"]=> string(68) "https://extranet.afaia.fr/wp-content/uploads/2020/02/florentaise.jpg" ["width"]=> int(400) ["height"]=> int(76) } ["medium"]=> object(stdClass)#2148 (3) { ["src"]=> string(75) "https://extranet.afaia.fr/wp-content/uploads/2020/02/florentaise-300x57.jpg" ["width"]=> int(300) ["height"]=> int(57) } ["thumbnail"]=> object(stdClass)#2149 (3) { ["src"]=> string(75) "https://extranet.afaia.fr/wp-content/uploads/2020/02/florentaise-150x76.jpg" ["width"]=> int(150) ["height"]=> int(76) } } }FLORENTAISE Supports de culture, Paillages, Amendements organiques, Biostimulants http://www.florentaise.com
object(stdClass)#2150 (12) { ["name"]=> string(10) "FRAYSSINET" ["website"]=> string(36) "https://www.groupe-frayssinet.fr/fr/" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> string(0) "" ["zoho_id"]=> string(18) "246999000002519016" ["address"]=> object(stdClass)#2151 (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)#2153 (3) { ["full"]=> object(stdClass)#2152 (3) { ["src"]=> string(72) "https://extranet.afaia.fr/wp-content/uploads/2020/12/logo-frayssinet.png" ["width"]=> int(552) ["height"]=> int(370) } ["medium"]=> object(stdClass)#2154 (3) { ["src"]=> string(80) "https://extranet.afaia.fr/wp-content/uploads/2020/12/logo-frayssinet-300x201.png" ["width"]=> int(300) ["height"]=> int(201) } ["thumbnail"]=> object(stdClass)#2155 (3) { ["src"]=> string(80) "https://extranet.afaia.fr/wp-content/uploads/2020/12/logo-frayssinet-150x150.png" ["width"]=> int(150) ["height"]=> int(150) } } }FRAYSSINET Supports de culture, Paillages, Amendements organiques, Engrais organiques, Engrais organo-minéraux, Biostimulants https://www.groupe-frayssinet.fr/fr/
object(stdClass)#2156 (12) { ["name"]=> string(20) "HOLDEX ENVIRONNEMENT" ["website"]=> string(0) "" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> string(0) "" ["zoho_id"]=> string(18) "246999000010330049" ["address"]=> object(stdClass)#2157 (4) { ["street"]=> NULL ["postalcode"]=> NULL ["city"]=> NULL ["country"]=> NULL } ["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)#2159 (3) { ["full"]=> object(stdClass)#2158 (3) { ["src"]=> string(68) "https://extranet.afaia.fr/wp-content/uploads/2022/09/logo-holdex.jpg" ["width"]=> int(200) ["height"]=> int(100) } ["medium"]=> object(stdClass)#2160 (3) { ["src"]=> string(68) "https://extranet.afaia.fr/wp-content/uploads/2022/09/logo-holdex.jpg" ["width"]=> int(200) ["height"]=> int(100) } ["thumbnail"]=> object(stdClass)#2161 (3) { ["src"]=> string(76) "https://extranet.afaia.fr/wp-content/uploads/2022/09/logo-holdex-150x100.jpg" ["width"]=> int(150) ["height"]=> int(100) } } }HOLDEX ENVIRONNEMENT Supports de culture, Paillages, Amendements organiques, Engrais organiques
object(stdClass)#2162 (12) { ["name"]=> string(29) "KLASMANN-DEILMANN FRANCE SARL" ["website"]=> string(28) "http://klasmann-deilmann.com" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> string(0) "" ["zoho_id"]=> string(18) "246999000000253226" ["address"]=> object(stdClass)#2163 (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)#2165 (3) { ["full"]=> object(stdClass)#2164 (3) { ["src"]=> string(94) "https://extranet.afaia.fr/wp-content/uploads/2020/02/klasmann-deilmann-logo-corporate-cmyk.jpg" ["width"]=> int(1181) ["height"]=> int(744) } ["medium"]=> object(stdClass)#2166 (3) { ["src"]=> string(102) "https://extranet.afaia.fr/wp-content/uploads/2020/02/klasmann-deilmann-logo-corporate-cmyk-300x189.jpg" ["width"]=> int(300) ["height"]=> int(189) } ["thumbnail"]=> object(stdClass)#2167 (3) { ["src"]=> string(102) "https://extranet.afaia.fr/wp-content/uploads/2020/02/klasmann-deilmann-logo-corporate-cmyk-150x150.jpg" ["width"]=> int(150) ["height"]=> int(150) } } }KLASMANN-DEILMANN FRANCE SARL Supports de culture http://klasmann-deilmann.com
object(stdClass)#2168 (12) { ["name"]=> string(21) "PENEZ HERMAN CHAMORIN" ["website"]=> string(26) "http://www.penezherman.com" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> string(0) "" ["zoho_id"]=> string(18) "246999000000253247" ["address"]=> object(stdClass)#2169 (4) { ["street"]=> NULL ["postalcode"]=> NULL ["city"]=> NULL ["country"]=> NULL } ["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)#2171 (3) { ["full"]=> object(stdClass)#2170 (3) { ["src"]=> string(74) "https://extranet.afaia.fr/wp-content/uploads/2020/02/logo-penez-herman.png" ["width"]=> int(296) ["height"]=> int(77) } ["medium"]=> object(stdClass)#2172 (3) { ["src"]=> string(74) "https://extranet.afaia.fr/wp-content/uploads/2020/02/logo-penez-herman.png" ["width"]=> int(296) ["height"]=> int(77) } ["thumbnail"]=> object(stdClass)#2173 (3) { ["src"]=> string(81) "https://extranet.afaia.fr/wp-content/uploads/2020/02/logo-penez-herman-150x77.png" ["width"]=> int(150) ["height"]=> int(77) } } }PENEZ HERMAN CHAMORIN Paillages http://www.penezherman.com
object(stdClass)#2174 (12) { ["name"]=> string(25) "PREMIER TECH HORTICULTURE" ["website"]=> string(36) "http://www.pthorticulture-france.com" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> string(0) "" ["zoho_id"]=> string(18) "246999000000253248" ["address"]=> object(stdClass)#2175 (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(13) "Biostimulants" } ["contributeurs_statistiques"]=> string(0) "" ["tag"]=> array(0) { } ["logo"]=> object(stdClass)#2177 (3) { ["full"]=> object(stdClass)#2176 (3) { ["src"]=> string(81) "https://extranet.afaia.fr/wp-content/uploads/2020/02/5brand-logo-premier-tech.jpg" ["width"]=> int(769) ["height"]=> int(433) } ["medium"]=> object(stdClass)#2178 (3) { ["src"]=> string(89) "https://extranet.afaia.fr/wp-content/uploads/2020/02/5brand-logo-premier-tech-300x169.jpg" ["width"]=> int(300) ["height"]=> int(169) } ["thumbnail"]=> object(stdClass)#2179 (3) { ["src"]=> string(89) "https://extranet.afaia.fr/wp-content/uploads/2020/02/5brand-logo-premier-tech-150x150.jpg" ["width"]=> int(150) ["height"]=> int(150) } } }PREMIER TECH HORTICULTURE Supports de culture, Paillages, Biostimulants http://www.pthorticulture-france.com
object(stdClass)#2180 (12) { ["name"]=> string(12) "ROCHER COUPE" ["website"]=> string(27) "https://www.rocher-coupe.fr" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> string(0) "" ["zoho_id"]=> string(18) "246999000000253255" ["address"]=> object(stdClass)#2181 (4) { ["street"]=> NULL ["postalcode"]=> NULL ["city"]=> NULL ["country"]=> NULL } ["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)#2183 (3) { ["full"]=> object(stdClass)#2182 (3) { ["src"]=> string(69) "https://extranet.afaia.fr/wp-content/uploads/2020/02/rocher-coupe.png" ["width"]=> int(870) ["height"]=> int(509) } ["medium"]=> object(stdClass)#2184 (3) { ["src"]=> string(77) "https://extranet.afaia.fr/wp-content/uploads/2020/02/rocher-coupe-300x176.png" ["width"]=> int(300) ["height"]=> int(176) } ["thumbnail"]=> object(stdClass)#2185 (3) { ["src"]=> string(77) "https://extranet.afaia.fr/wp-content/uploads/2020/02/rocher-coupe-150x150.png" ["width"]=> int(150) ["height"]=> int(150) } } }ROCHER COUPE Paillages https://www.rocher-coupe.fr
object(stdClass)#2186 (12) { ["name"]=> string(21) "ROCKWOOL B.V / GRODAN" ["website"]=> string(13) "www.grodan.fr" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> string(0) "" ["zoho_id"]=> string(18) "246999000000253256" ["address"]=> object(stdClass)#2187 (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)#2189 (3) { ["full"]=> object(stdClass)#2188 (3) { ["src"]=> string(68) "https://extranet.afaia.fr/wp-content/uploads/2020/02/grodan-logo.jpg" ["width"]=> int(266) ["height"]=> int(149) } ["medium"]=> object(stdClass)#2190 (3) { ["src"]=> string(68) "https://extranet.afaia.fr/wp-content/uploads/2020/02/grodan-logo.jpg" ["width"]=> int(266) ["height"]=> int(149) } ["thumbnail"]=> object(stdClass)#2191 (3) { ["src"]=> string(76) "https://extranet.afaia.fr/wp-content/uploads/2020/02/grodan-logo-150x149.jpg" ["width"]=> int(150) ["height"]=> int(149) } } }ROCKWOOL B.V / GRODAN Supports de culture http://www.grodan.fr
object(stdClass)#2192 (12) { ["name"]=> string(16) "SBM LIFE SCIENCE" ["website"]=> string(22) "http://sbm-company.com" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> string(0) "" ["zoho_id"]=> string(18) "246999000000253258" ["address"]=> object(stdClass)#2193 (4) { ["street"]=> string(22) "60 chemin des Mouilles" ["postalcode"]=> string(5) "69130" ["city"]=> string(6) "ECULLY" ["country"]=> string(6) "FRANCE" } ["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)#2195 (3) { ["full"]=> object(stdClass)#2194 (3) { ["src"]=> string(65) "https://extranet.afaia.fr/wp-content/uploads/2022/08/logo sbm.jpg" ["width"]=> int(204) ["height"]=> int(62) } ["medium"]=> object(stdClass)#2196 (3) { ["src"]=> string(65) "https://extranet.afaia.fr/wp-content/uploads/2022/08/logo sbm.jpg" ["width"]=> int(204) ["height"]=> int(62) } ["thumbnail"]=> object(stdClass)#2197 (3) { ["src"]=> string(72) "https://extranet.afaia.fr/wp-content/uploads/2022/08/logo sbm-150x62.jpg" ["width"]=> int(150) ["height"]=> int(62) } } }SBM LIFE SCIENCE Supports de culture, Paillages, Amendements organiques, Engrais organiques, Engrais organo-minéraux, Biostimulants http://sbm-company.com
object(stdClass)#2198 (12) { ["name"]=> string(18) "TRUFFAUT SELECTION" ["website"]=> string(24) "https://www.truffaut.com" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> object(stdClass)#2199 (2) { ["internationalFormat"]=> string(12) "+33169915370" ["frenchFormat"]=> string(14) "01 69 91 53 70" } ["zoho_id"]=> string(18) "246999000000253295" ["address"]=> object(stdClass)#2200 (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)#2202 (3) { ["full"]=> object(stdClass)#2201 (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)#2203 (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)#2204 (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