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 '{c24ee669042b04a6a77eff0b5144298fb6729eb334faf1334c502cdebb253535}Amendements organiques{c24ee669042b04a6a77eff0b5144298fb6729eb334faf1334c502cdebb253535}' OR pmr.meta_value LIKE '{c24ee669042b04a6a77eff0b5144298fb6729eb334faf1334c502cdebb253535}Engrais organiques{c24ee669042b04a6a77eff0b5144298fb6729eb334faf1334c502cdebb253535}' OR pmr.meta_value LIKE '{c24ee669042b04a6a77eff0b5144298fb6729eb334faf1334c502cdebb253535}Engrais organo-minéraux{c24ee669042b04a6a77eff0b5144298fb6729eb334faf1334c502cdebb253535}' ) );"
object(stdClass)#2131 (12) { ["name"]=> string(12) "HELLO NATURE" ["website"]=> string(29) "https://www.hello-nature.com/" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> object(stdClass)#2032 (2) { ["internationalFormat"]=> string(12) "+33492967640" ["frenchFormat"]=> string(14) "04 92 96 76 40" } ["zoho_id"]=> string(18) "246999000000253225" ["address"]=> object(stdClass)#2102 (4) { ["street"]=> string(63) "Espace Beethoven - Bat 3 - 1er étage - 1208 Route des Lucioles" ["postalcode"]=> string(5) "06560" ["city"]=> string(8) "VALBONNE" ["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)#1973 (3) { ["full"]=> object(stdClass)#1975 (3) { ["src"]=> string(84) "https://extranet.afaia.fr/wp-content/uploads/2020/02/logo-hello-nature-2l-scaled.jpg" ["width"]=> int(2560) ["height"]=> int(1490) } ["medium"]=> object(stdClass)#1972 (3) { ["src"]=> string(85) "https://extranet.afaia.fr/wp-content/uploads/2020/02/logo-hello-nature-2l-300x175.jpg" ["width"]=> int(300) ["height"]=> int(175) } ["thumbnail"]=> object(stdClass)#1971 (3) { ["src"]=> string(85) "https://extranet.afaia.fr/wp-content/uploads/2020/02/logo-hello-nature-2l-150x150.jpg" ["width"]=> int(150) ["height"]=> int(150) } } }HELLO NATURE Amendements organiques, Engrais organiques, Engrais organo-minéraux, Biostimulants https://www.hello-nature.com/
object(stdClass)#1970 (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)#1969 (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)#2117 (3) { ["full"]=> object(stdClass)#2074 (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)#1997 (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)#2144 (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)#2145 (12) { ["name"]=> string(4) "IF2O" ["website"]=> string(0) "" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> string(0) "" ["zoho_id"]=> string(18) "246999000000253216" ["address"]=> object(stdClass)#2146 (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)#2148 (3) { ["full"]=> object(stdClass)#2147 (3) { ["src"]=> string(68) "https://extranet.afaia.fr/wp-content/uploads/2020/02/if20-scaled.jpg" ["width"]=> int(1810) ["height"]=> int(2560) } ["medium"]=> object(stdClass)#2149 (3) { ["src"]=> string(69) "https://extranet.afaia.fr/wp-content/uploads/2020/02/if20-212x300.jpg" ["width"]=> int(212) ["height"]=> int(300) } ["thumbnail"]=> object(stdClass)#2150 (3) { ["src"]=> string(69) "https://extranet.afaia.fr/wp-content/uploads/2020/02/if20-150x150.jpg" ["width"]=> int(150) ["height"]=> int(150) } } }IF2O Amendements organiques, Engrais organiques, Engrais organo-minéraux
object(stdClass)#2151 (12) { ["name"]=> string(6) "NAREMA" ["website"]=> string(0) "" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> object(stdClass)#2152 (2) { ["internationalFormat"]=> string(12) "+33678713201" ["frenchFormat"]=> string(14) "06 78 71 32 01" } ["zoho_id"]=> string(18) "246999000014872370" ["address"]=> object(stdClass)#2153 (4) { ["street"]=> string(25) "276 Route du Vois du Four" ["postalcode"]=> string(5) "38430" ["city"]=> string(7) "MOIRANS" ["country"]=> string(6) "FRANCE" } ["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)#2155 (3) { ["full"]=> object(stdClass)#2154 (3) { ["src"]=> string(68) "https://extranet.afaia.fr/wp-content/uploads/2024/01/NAREMA Logo.png" ["width"]=> int(2546) ["height"]=> int(608) } ["medium"]=> object(stdClass)#2156 (3) { ["src"]=> string(75) "https://extranet.afaia.fr/wp-content/uploads/2024/01/NAREMA Logo-300x72.png" ["width"]=> int(300) ["height"]=> int(72) } ["thumbnail"]=> object(stdClass)#2157 (3) { ["src"]=> string(76) "https://extranet.afaia.fr/wp-content/uploads/2024/01/NAREMA Logo-150x150.png" ["width"]=> int(150) ["height"]=> int(150) } } }NAREMA Engrais organiques, Engrais organo-minéraux
object(stdClass)#2158 (12) { ["name"]=> string(7) "PLANTIN" ["website"]=> string(23) "https://www.plantin.fr/" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> object(stdClass)#2159 (2) { ["internationalFormat"]=> string(12) "+33490702003" ["frenchFormat"]=> string(14) "04 90 70 20 03" } ["zoho_id"]=> string(18) "246999000002519027" ["address"]=> object(stdClass)#2160 (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)#2162 (3) { ["full"]=> object(stdClass)#2161 (3) { ["src"]=> string(69) "https://extranet.afaia.fr/wp-content/uploads/2020/12/logo-plantin.png" ["width"]=> int(737) ["height"]=> int(424) } ["medium"]=> object(stdClass)#2163 (3) { ["src"]=> string(77) "https://extranet.afaia.fr/wp-content/uploads/2020/12/logo-plantin-300x173.png" ["width"]=> int(300) ["height"]=> int(173) } ["thumbnail"]=> object(stdClass)#2164 (3) { ["src"]=> string(77) "https://extranet.afaia.fr/wp-content/uploads/2020/12/logo-plantin-150x150.png" ["width"]=> int(150) ["height"]=> int(150) } } }PLANTIN Amendements organiques, Engrais organiques, Engrais organo-minéraux, Biostimulants https://www.plantin.fr/
object(stdClass)#2165 (12) { ["name"]=> string(14) "PRESTA HORIZON" ["website"]=> string(31) "https://www.presta-horizon.com/" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> object(stdClass)#2166 (2) { ["internationalFormat"]=> string(12) "+33326522599" ["frenchFormat"]=> string(14) "03 26 52 25 99" } ["zoho_id"]=> string(18) "246999000013464010" ["address"]=> object(stdClass)#2167 (4) { ["street"]=> string(15) "4 rue des Ormes" ["postalcode"]=> string(5) "51130" ["city"]=> string(14) "PIERRE-MORAINS" ["country"]=> string(6) "FRANCE" } ["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"]=> NULL }PRESTA HORIZON Amendements organiques, Engrais organiques https://www.presta-horizon.com/
object(stdClass)#2168 (12) { ["name"]=> string(19) "PRODUCTOS LABIN.SL." ["website"]=> string(18) "https://labin.net/" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> object(stdClass)#2169 (2) { ["internationalFormat"]=> string(15) "+33+34938031966" ["frenchFormat"]=> string(13) "0+34938031966" } ["zoho_id"]=> string(18) "246999000002573041" ["address"]=> object(stdClass)#2170 (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)#2172 (3) { ["full"]=> object(stdClass)#2171 (3) { ["src"]=> string(69) "https://extranet.afaia.fr/wp-content/uploads/2020/12/macasa-labin.png" ["width"]=> int(256) ["height"]=> int(80) } ["medium"]=> object(stdClass)#2173 (3) { ["src"]=> string(69) "https://extranet.afaia.fr/wp-content/uploads/2020/12/macasa-labin.png" ["width"]=> int(256) ["height"]=> int(80) } ["thumbnail"]=> object(stdClass)#2174 (3) { ["src"]=> string(76) "https://extranet.afaia.fr/wp-content/uploads/2020/12/macasa-labin-150x80.png" ["width"]=> int(150) ["height"]=> int(80) } } }PRODUCTOS LABIN.SL. Engrais organiques, Engrais organo-minéraux, Biostimulants https://labin.net/
object(stdClass)#2175 (12) { ["name"]=> string(7) "PUR VER" ["website"]=> string(25) "https://www.purver.com/fr" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> object(stdClass)#2176 (2) { ["internationalFormat"]=> string(15) "+33+32470330399" ["frenchFormat"]=> string(13) "0+32470330399" } ["zoho_id"]=> string(18) "246999000011445054" ["address"]=> object(stdClass)#2177 (4) { ["street"]=> string(19) "Rue de Maubray 109A" ["postalcode"]=> string(4) "7740" ["city"]=> string(4) "PECQ" ["country"]=> string(8) "BELGIQUE" } ["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)#2179 (3) { ["full"]=> object(stdClass)#2178 (3) { ["src"]=> string(69) "https://extranet.afaia.fr/wp-content/uploads/2022/12/logo-pur-ver.jpg" ["width"]=> int(203) ["height"]=> int(201) } ["medium"]=> object(stdClass)#2180 (3) { ["src"]=> string(69) "https://extranet.afaia.fr/wp-content/uploads/2022/12/logo-pur-ver.jpg" ["width"]=> int(203) ["height"]=> int(201) } ["thumbnail"]=> object(stdClass)#2181 (3) { ["src"]=> string(77) "https://extranet.afaia.fr/wp-content/uploads/2022/12/logo-pur-ver-150x150.jpg" ["width"]=> int(150) ["height"]=> int(150) } } }PUR VER Amendements organiques, Biostimulants https://www.purver.com/fr
object(stdClass)#2182 (12) { ["name"]=> string(9) "SARIA SAS" ["website"]=> string(24) "https://www.saria.fr/fr/" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> object(stdClass)#2183 (2) { ["internationalFormat"]=> string(12) "+33141403000" ["frenchFormat"]=> string(14) "01 41 40 30 00" } ["zoho_id"]=> string(18) "246999000007830506" ["address"]=> object(stdClass)#2184 (4) { ["street"]=> string(13) "24 Rue Martre" ["postalcode"]=> string(5) "92586" ["city"]=> string(6) "CLICHY" ["country"]=> NULL } ["adherents"]=> array(1) { [0]=> string(9) "Adhérent" } ["produits_fabriques"]=> array(2) { [0]=> string(18) "Engrais organiques" [1]=> string(13) "Biostimulants" } ["contributeurs_statistiques"]=> string(0) "" ["tag"]=> array(0) { } ["logo"]=> object(stdClass)#2186 (3) { ["full"]=> object(stdClass)#2185 (3) { ["src"]=> string(62) "https://extranet.afaia.fr/wp-content/uploads/2022/04/saria.png" ["width"]=> int(177) ["height"]=> int(35) } ["medium"]=> object(stdClass)#2187 (3) { ["src"]=> string(62) "https://extranet.afaia.fr/wp-content/uploads/2022/04/saria.png" ["width"]=> int(177) ["height"]=> int(35) } ["thumbnail"]=> object(stdClass)#2188 (3) { ["src"]=> string(69) "https://extranet.afaia.fr/wp-content/uploads/2022/04/saria-150x35.png" ["width"]=> int(150) ["height"]=> int(35) } } }SARIA SAS Engrais organiques, Biostimulants https://www.saria.fr/fr/
object(stdClass)#2189 (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)#2190 (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)#2192 (3) { ["full"]=> object(stdClass)#2191 (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)#2193 (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)#2194 (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)#2195 (12) { ["name"]=> string(18) "SEDE ENVIRONNEMENT" ["website"]=> string(27) "https://www.sede.veolia.com" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> string(0) "" ["zoho_id"]=> string(18) "246999000000253265" ["address"]=> object(stdClass)#2196 (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)#2198 (3) { ["full"]=> object(stdClass)#2197 (3) { ["src"]=> string(73) "https://extranet.afaia.fr/wp-content/uploads/2020/02/logo-sede-veolia.jpg" ["width"]=> int(400) ["height"]=> int(250) } ["medium"]=> object(stdClass)#2199 (3) { ["src"]=> string(81) "https://extranet.afaia.fr/wp-content/uploads/2020/02/logo-sede-veolia-300x188.jpg" ["width"]=> int(300) ["height"]=> int(188) } ["thumbnail"]=> object(stdClass)#2200 (3) { ["src"]=> string(81) "https://extranet.afaia.fr/wp-content/uploads/2020/02/logo-sede-veolia-150x150.jpg" ["width"]=> int(150) ["height"]=> int(150) } } }SEDE ENVIRONNEMENT Amendements organiques https://www.sede.veolia.com
object(stdClass)#2201 (12) { ["name"]=> string(8) "SOILTECH" ["website"]=> string(23) "https://soiltech.nl/fr/" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> string(0) "" ["zoho_id"]=> string(18) "246999000005167103" ["address"]=> object(stdClass)#2202 (4) { ["street"]=> string(23) "Biezenmortelsestraat 57" ["postalcode"]=> string(4) "5074" ["city"]=> string(15) "RJ Biezenmortel" ["country"]=> string(11) "Netherlands" } ["adherents"]=> array(1) { [0]=> string(9) "Adhérent" } ["produits_fabriques"]=> array(2) { [0]=> string(24) "Engrais organo-minéraux" [1]=> string(13) "Biostimulants" } ["contributeurs_statistiques"]=> string(0) "" ["tag"]=> array(0) { } ["logo"]=> object(stdClass)#2204 (3) { ["full"]=> object(stdClass)#2203 (3) { ["src"]=> string(75) "https://extranet.afaia.fr/wp-content/uploads/2021/09/soiltech-solutions.png" ["width"]=> int(311) ["height"]=> int(126) } ["medium"]=> object(stdClass)#2205 (3) { ["src"]=> string(83) "https://extranet.afaia.fr/wp-content/uploads/2021/09/soiltech-solutions-300x122.png" ["width"]=> int(300) ["height"]=> int(122) } ["thumbnail"]=> object(stdClass)#2206 (3) { ["src"]=> string(83) "https://extranet.afaia.fr/wp-content/uploads/2021/09/soiltech-solutions-150x126.png" ["width"]=> int(150) ["height"]=> int(126) } } }SOILTECH Engrais organo-minéraux, Biostimulants https://soiltech.nl/fr/