string(214) "SELECT COUNT(p.ID) FROM wpatm_posts as p LEFT JOIN wpatm_postmeta as pm ON pm.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' ;"
object(stdClass)#2130 (12) { ["name"]=> string(13) "GREEN IMPULSE" ["website"]=> string(28) "https://www.greenimpulse.fr/" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> string(0) "" ["zoho_id"]=> string(18) "246999000001019015" ["address"]=> object(stdClass)#2031 (4) { ["street"]=> string(23) "1 rue Alexandre Fleming" ["postalcode"]=> string(5) "49000" ["city"]=> string(6) "ANGERS" ["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)#1974 (3) { ["full"]=> object(stdClass)#2101 (3) { ["src"]=> string(69) "https://extranet.afaia.fr/wp-content/uploads/2020/06/greenimpulse.png" ["width"]=> int(270) ["height"]=> int(65) } ["medium"]=> object(stdClass)#1972 (3) { ["src"]=> string(69) "https://extranet.afaia.fr/wp-content/uploads/2020/06/greenimpulse.png" ["width"]=> int(270) ["height"]=> int(65) } ["thumbnail"]=> object(stdClass)#1971 (3) { ["src"]=> string(76) "https://extranet.afaia.fr/wp-content/uploads/2020/06/greenimpulse-150x65.png" ["width"]=> int(150) ["height"]=> int(65) } } }
object(stdClass)#1970 (12) { ["name"]=> string(20) "GREENCELL (Biovitis)" ["website"]=> string(33) "https://laboratoires-biovitis.fr/" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> object(stdClass)#1969 (2) { ["internationalFormat"]=> string(12) "+33471783700" ["frenchFormat"]=> string(14) "04 71 78 37 00" } ["zoho_id"]=> string(18) "246999000000253148" ["address"]=> object(stdClass)#1968 (4) { ["street"]=> NULL ["postalcode"]=> NULL ["city"]=> NULL ["country"]=> NULL } ["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)#2116 (3) { ["full"]=> object(stdClass)#2073 (3) { ["src"]=> string(83) "https://extranet.afaia.fr/wp-content/uploads/2020/02/4-greencell-logo2021-blue.webp" ["width"]=> int(258) ["height"]=> int(128) } ["medium"]=> object(stdClass)#1998 (3) { ["src"]=> string(83) "https://extranet.afaia.fr/wp-content/uploads/2020/02/4-greencell-logo2021-blue.webp" ["width"]=> int(258) ["height"]=> int(128) } ["thumbnail"]=> object(stdClass)#2143 (3) { ["src"]=> string(91) "https://extranet.afaia.fr/wp-content/uploads/2020/02/4-greencell-logo2021-blue-150x128.webp" ["width"]=> int(150) ["height"]=> int(128) } } }
object(stdClass)#2144 (12) { ["name"]=> string(12) "HELIOPOTASSE" ["website"]=> string(0) "" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> string(0) "" ["zoho_id"]=> string(18) "246999000005167034" ["address"]=> object(stdClass)#2145 (4) { ["street"]=> string(23) "25 place de la Réunion" ["postalcode"]=> string(5) "68100" ["city"]=> string(8) "Mulhouse" ["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)#2147 (3) { ["full"]=> object(stdClass)#2146 (3) { ["src"]=> string(69) "https://extranet.afaia.fr/wp-content/uploads/2021/09/heliopotasse.png" ["width"]=> int(274) ["height"]=> int(112) } ["medium"]=> object(stdClass)#2148 (3) { ["src"]=> string(69) "https://extranet.afaia.fr/wp-content/uploads/2021/09/heliopotasse.png" ["width"]=> int(274) ["height"]=> int(112) } ["thumbnail"]=> object(stdClass)#2149 (3) { ["src"]=> string(77) "https://extranet.afaia.fr/wp-content/uploads/2021/09/heliopotasse-150x112.png" ["width"]=> int(150) ["height"]=> int(112) } } }
object(stdClass)#2150 (12) { ["name"]=> string(12) "HELLO NATURE" ["website"]=> string(29) "https://www.hello-nature.com/" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> object(stdClass)#2151 (2) { ["internationalFormat"]=> string(12) "+33492967640" ["frenchFormat"]=> string(14) "04 92 96 76 40" } ["zoho_id"]=> string(18) "246999000000253225" ["address"]=> object(stdClass)#2152 (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)#2154 (3) { ["full"]=> object(stdClass)#2153 (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)#2155 (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)#2156 (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) } } }
object(stdClass)#2157 (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)#2158 (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)#2160 (3) { ["full"]=> object(stdClass)#2159 (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)#2161 (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)#2162 (3) { ["src"]=> string(76) "https://extranet.afaia.fr/wp-content/uploads/2022/09/logo-holdex-150x100.jpg" ["width"]=> int(150) ["height"]=> int(100) } } }
object(stdClass)#2163 (12) { ["name"]=> string(7) "IF TECH" ["website"]=> string(20) "http://www.iftech.fr" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> string(0) "" ["zoho_id"]=> string(18) "246999000000253215" ["address"]=> object(stdClass)#2164 (4) { ["street"]=> NULL ["postalcode"]=> NULL ["city"]=> NULL ["country"]=> NULL } ["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)#2166 (3) { ["full"]=> object(stdClass)#2165 (3) { ["src"]=> string(68) "https://extranet.afaia.fr/wp-content/uploads/2020/02/logo-iftech.png" ["width"]=> int(272) ["height"]=> int(124) } ["medium"]=> object(stdClass)#2167 (3) { ["src"]=> string(68) "https://extranet.afaia.fr/wp-content/uploads/2020/02/logo-iftech.png" ["width"]=> int(272) ["height"]=> int(124) } ["thumbnail"]=> object(stdClass)#2168 (3) { ["src"]=> string(76) "https://extranet.afaia.fr/wp-content/uploads/2020/02/logo-iftech-150x124.png" ["width"]=> int(150) ["height"]=> int(124) } } }
object(stdClass)#2169 (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)#2170 (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)#2172 (3) { ["full"]=> object(stdClass)#2171 (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)#2173 (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)#2174 (3) { ["src"]=> string(69) "https://extranet.afaia.fr/wp-content/uploads/2020/02/if20-150x150.jpg" ["width"]=> int(150) ["height"]=> int(150) } } }
object(stdClass)#2175 (12) { ["name"]=> string(17) "INOCULUM PLUS SAS" ["website"]=> string(22) "http://inoculumplus.eu" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> object(stdClass)#2176 (2) { ["internationalFormat"]=> string(12) "+33345831193" ["frenchFormat"]=> string(14) "03 45 83 11 93" } ["zoho_id"]=> string(18) "246999000000253217" ["address"]=> object(stdClass)#2177 (4) { ["street"]=> NULL ["postalcode"]=> NULL ["city"]=> NULL ["country"]=> NULL } ["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)#2179 (3) { ["full"]=> object(stdClass)#2178 (3) { ["src"]=> string(70) "https://extranet.afaia.fr/wp-content/uploads/2020/02/inoculum-plus.jpg" ["width"]=> int(196) ["height"]=> int(169) } ["medium"]=> object(stdClass)#2180 (3) { ["src"]=> string(70) "https://extranet.afaia.fr/wp-content/uploads/2020/02/inoculum-plus.jpg" ["width"]=> int(196) ["height"]=> int(169) } ["thumbnail"]=> object(stdClass)#2181 (3) { ["src"]=> string(78) "https://extranet.afaia.fr/wp-content/uploads/2020/02/inoculum-plus-150x150.jpg" ["width"]=> int(150) ["height"]=> int(150) } } }
object(stdClass)#2182 (12) { ["name"]=> string(13) "JS Consulting" ["website"]=> string(22) "https://js-consult.fr/" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> object(stdClass)#2183 (2) { ["internationalFormat"]=> string(12) "+33782560714" ["frenchFormat"]=> string(14) "07 82 56 07 14" } ["zoho_id"]=> string(18) "246999000012780050" ["address"]=> object(stdClass)#2184 (4) { ["street"]=> string(24) "17 c Avenue Jean Jaurès" ["postalcode"]=> string(5) "31290" ["city"]=> string(25) "VILLEFRANCHE DE LAURAGAIS" ["country"]=> string(6) "FRANCE" } ["adherents"]=> array(2) { [0]=> string(9) "Adhérent" [1]=> string(15) "Membre Associé" } ["produits_fabriques"]=> array(0) { } ["contributeurs_statistiques"]=> string(0) "" ["tag"]=> array(0) { } ["logo"]=> object(stdClass)#2186 (3) { ["full"]=> object(stdClass)#2185 (3) { ["src"]=> string(91) "https://extranet.afaia.fr/wp-content/uploads/2023/04/logo-js-consulting-rd-bioscience-1.png" ["width"]=> int(6969) ["height"]=> int(1953) } ["medium"]=> object(stdClass)#2187 (3) { ["src"]=> string(98) "https://extranet.afaia.fr/wp-content/uploads/2023/04/logo-js-consulting-rd-bioscience-1-300x84.png" ["width"]=> int(300) ["height"]=> int(84) } ["thumbnail"]=> object(stdClass)#2188 (3) { ["src"]=> string(99) "https://extranet.afaia.fr/wp-content/uploads/2023/04/logo-js-consulting-rd-bioscience-1-150x150.png" ["width"]=> int(150) ["height"]=> int(150) } } }
object(stdClass)#2189 (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)#2190 (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)#2192 (3) { ["full"]=> object(stdClass)#2191 (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)#2193 (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)#2194 (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) } } }
object(stdClass)#2195 (12) { ["name"]=> string(14) "KOPPERT FRANCE" ["website"]=> string(22) "https://www.koppert.fr" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> string(0) "" ["zoho_id"]=> string(18) "246999000000253227" ["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(13) "Biostimulants" } ["contributeurs_statistiques"]=> string(0) "" ["tag"]=> array(0) { } ["logo"]=> object(stdClass)#2198 (3) { ["full"]=> object(stdClass)#2197 (3) { ["src"]=> string(64) "https://extranet.afaia.fr/wp-content/uploads/2020/02/koppert.png" ["width"]=> int(400) ["height"]=> int(130) } ["medium"]=> object(stdClass)#2199 (3) { ["src"]=> string(71) "https://extranet.afaia.fr/wp-content/uploads/2020/02/koppert-300x98.png" ["width"]=> int(300) ["height"]=> int(98) } ["thumbnail"]=> object(stdClass)#2200 (3) { ["src"]=> string(72) "https://extranet.afaia.fr/wp-content/uploads/2020/02/koppert-150x130.png" ["width"]=> int(150) ["height"]=> int(130) } } }
object(stdClass)#2201 (12) { ["name"]=> string(4) "MEAC" ["website"]=> string(0) "" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> object(stdClass)#2202 (2) { ["internationalFormat"]=> string(12) "+33228504012" ["frenchFormat"]=> string(14) "02 28 50 40 12" } ["zoho_id"]=> string(18) "246999000014478139" ["address"]=> object(stdClass)#2203 (4) { ["street"]=> string(14) "10, Le Cormier" ["postalcode"]=> string(5) "44110" ["city"]=> string(6) "ERBRAY" ["country"]=> string(6) "FRANCE" } ["adherents"]=> array(1) { [0]=> string(9) "Adhérent" } ["produits_fabriques"]=> array(1) { [0]=> string(30) "Amendements minéraux basiques" } ["contributeurs_statistiques"]=> string(0) "" ["tag"]=> array(0) { } ["logo"]=> NULL }