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(5) "MYCEA" ["website"]=> string(17) "https://mycea.fr/" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> object(stdClass)#2031 (2) { ["internationalFormat"]=> string(12) "+33467794784" ["frenchFormat"]=> string(14) "04 67 79 47 84" } ["zoho_id"]=> string(18) "246999000003887001" ["address"]=> object(stdClass)#2101 (4) { ["street"]=> string(30) "162 rue du Caducée - CS 75095" ["postalcode"]=> string(5) "34197" ["city"]=> string(19) "MONTPELLIER Cedex 5" ["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)#1972 (3) { ["full"]=> object(stdClass)#1974 (3) { ["src"]=> string(77) "https://extranet.afaia.fr/wp-content/uploads/2021/03/logo-mycea-300x188-1.jpg" ["width"]=> int(300) ["height"]=> int(188) } ["medium"]=> object(stdClass)#1971 (3) { ["src"]=> string(77) "https://extranet.afaia.fr/wp-content/uploads/2021/03/logo-mycea-300x188-1.jpg" ["width"]=> int(300) ["height"]=> int(188) } ["thumbnail"]=> object(stdClass)#1970 (3) { ["src"]=> string(85) "https://extranet.afaia.fr/wp-content/uploads/2021/03/logo-mycea-300x188-1-150x150.jpg" ["width"]=> int(150) ["height"]=> int(150) } } }
object(stdClass)#1969 (12) { ["name"]=> string(10) "MYCELIANCE" ["website"]=> string(22) "https://myceliance.com" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> object(stdClass)#1968 (2) { ["internationalFormat"]=> string(12) "+33658573436" ["frenchFormat"]=> string(14) "06 58 57 34 36" } ["zoho_id"]=> string(18) "246999000011445232" ["address"]=> object(stdClass)#2073 (4) { ["street"]=> string(18) "2 rue Paul Gauguin" ["postalcode"]=> string(5) "49130" ["city"]=> string(15) "LES PONTS-DE-CE" ["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)#1998 (3) { ["full"]=> object(stdClass)#2116 (3) { ["src"]=> string(72) "https://extranet.afaia.fr/wp-content/uploads/2022/12/logo-myceliance.png" ["width"]=> int(4641) ["height"]=> int(2671) } ["medium"]=> object(stdClass)#2143 (3) { ["src"]=> string(80) "https://extranet.afaia.fr/wp-content/uploads/2022/12/logo-myceliance-300x173.png" ["width"]=> int(300) ["height"]=> int(173) } ["thumbnail"]=> object(stdClass)#2144 (3) { ["src"]=> string(80) "https://extranet.afaia.fr/wp-content/uploads/2022/12/logo-myceliance-150x150.png" ["width"]=> int(150) ["height"]=> int(150) } } }
object(stdClass)#2145 (12) { ["name"]=> string(9) "MYCOPHYTO" ["website"]=> string(20) "http://mycophyto.fr/" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> object(stdClass)#2146 (2) { ["internationalFormat"]=> string(12) "+33628262872" ["frenchFormat"]=> string(14) "06 28 26 28 72" } ["zoho_id"]=> string(18) "246999000011445111" ["address"]=> object(stdClass)#2147 (4) { ["street"]=> string(27) "45, Boulevard Marcel Pagnol" ["postalcode"]=> string(5) "06130" ["city"]=> string(6) "GRASSE" ["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)#2149 (3) { ["full"]=> object(stdClass)#2148 (3) { ["src"]=> string(71) "https://extranet.afaia.fr/wp-content/uploads/2022/12/mycophyto-logo.png" ["width"]=> int(300) ["height"]=> int(263) } ["medium"]=> object(stdClass)#2150 (3) { ["src"]=> string(71) "https://extranet.afaia.fr/wp-content/uploads/2022/12/mycophyto-logo.png" ["width"]=> int(300) ["height"]=> int(263) } ["thumbnail"]=> object(stdClass)#2151 (3) { ["src"]=> string(79) "https://extranet.afaia.fr/wp-content/uploads/2022/12/mycophyto-logo-150x150.png" ["width"]=> int(150) ["height"]=> int(150) } } }
object(stdClass)#2152 (12) { ["name"]=> string(6) "NAREMA" ["website"]=> string(0) "" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> object(stdClass)#2153 (2) { ["internationalFormat"]=> string(12) "+33678713201" ["frenchFormat"]=> string(14) "06 78 71 32 01" } ["zoho_id"]=> string(18) "246999000014872370" ["address"]=> object(stdClass)#2154 (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)#2156 (3) { ["full"]=> object(stdClass)#2155 (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)#2157 (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)#2158 (3) { ["src"]=> string(76) "https://extranet.afaia.fr/wp-content/uploads/2024/01/NAREMA Logo-150x150.png" ["width"]=> int(150) ["height"]=> int(150) } } }
object(stdClass)#2159 (12) { ["name"]=> string(9) "NOURRITEC" ["website"]=> string(0) "" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> string(0) "" ["zoho_id"]=> string(18) "246999000009254029" ["address"]=> object(stdClass)#2160 (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"]=> NULL }
object(stdClass)#2161 (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)#2162 (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)#2164 (3) { ["full"]=> object(stdClass)#2163 (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)#2165 (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)#2166 (3) { ["src"]=> string(81) "https://extranet.afaia.fr/wp-content/uploads/2020/02/logo-penez-herman-150x77.png" ["width"]=> int(150) ["height"]=> int(77) } } }
object(stdClass)#2167 (12) { ["name"]=> string(10) "PLANCTONID" ["website"]=> string(23) "https://planctonid.com/" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> object(stdClass)#2168 (2) { ["internationalFormat"]=> string(12) "+33448201516" ["frenchFormat"]=> string(14) "04 48 20 15 16" } ["zoho_id"]=> string(18) "246999000007830448" ["address"]=> object(stdClass)#2169 (4) { ["street"]=> string(14) "29 Rue Bassano" ["postalcode"]=> string(5) "75008" ["city"]=> string(5) "PARIS" ["country"]=> NULL } ["adherents"]=> array(1) { [0]=> string(9) "Adhérent" } ["produits_fabriques"]=> array(0) { } ["contributeurs_statistiques"]=> string(0) "" ["tag"]=> array(0) { } ["logo"]=> object(stdClass)#2171 (3) { ["full"]=> object(stdClass)#2170 (3) { ["src"]=> string(71) "https://extranet.afaia.fr/wp-content/uploads/2022/04/planctonid-230.png" ["width"]=> int(230) ["height"]=> int(61) } ["medium"]=> object(stdClass)#2172 (3) { ["src"]=> string(71) "https://extranet.afaia.fr/wp-content/uploads/2022/04/planctonid-230.png" ["width"]=> int(230) ["height"]=> int(61) } ["thumbnail"]=> object(stdClass)#2173 (3) { ["src"]=> string(78) "https://extranet.afaia.fr/wp-content/uploads/2022/04/planctonid-230-150x61.png" ["width"]=> int(150) ["height"]=> int(61) } } }
object(stdClass)#2174 (12) { ["name"]=> string(7) "PLANTIN" ["website"]=> string(23) "https://www.plantin.fr/" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> object(stdClass)#2175 (2) { ["internationalFormat"]=> string(12) "+33490702003" ["frenchFormat"]=> string(14) "04 90 70 20 03" } ["zoho_id"]=> string(18) "246999000002519027" ["address"]=> object(stdClass)#2176 (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)#2178 (3) { ["full"]=> object(stdClass)#2177 (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)#2179 (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)#2180 (3) { ["src"]=> string(77) "https://extranet.afaia.fr/wp-content/uploads/2020/12/logo-plantin-150x150.png" ["width"]=> int(150) ["height"]=> int(150) } } }
object(stdClass)#2181 (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)#2182 (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)#2184 (3) { ["full"]=> object(stdClass)#2183 (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)#2185 (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)#2186 (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) } } }
object(stdClass)#2187 (12) { ["name"]=> string(14) "PRESTA HORIZON" ["website"]=> string(31) "https://www.presta-horizon.com/" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> object(stdClass)#2188 (2) { ["internationalFormat"]=> string(12) "+33326522599" ["frenchFormat"]=> string(14) "03 26 52 25 99" } ["zoho_id"]=> string(18) "246999000013464010" ["address"]=> object(stdClass)#2189 (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 }
object(stdClass)#2190 (12) { ["name"]=> string(19) "PRODUCTOS LABIN.SL." ["website"]=> string(18) "https://labin.net/" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> object(stdClass)#2191 (2) { ["internationalFormat"]=> string(15) "+33+34938031966" ["frenchFormat"]=> string(13) "0+34938031966" } ["zoho_id"]=> string(18) "246999000002573041" ["address"]=> object(stdClass)#2192 (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)#2194 (3) { ["full"]=> object(stdClass)#2193 (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)#2195 (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)#2196 (3) { ["src"]=> string(76) "https://extranet.afaia.fr/wp-content/uploads/2020/12/macasa-labin-150x80.png" ["width"]=> int(150) ["height"]=> int(80) } } }
object(stdClass)#2197 (12) { ["name"]=> string(7) "PUR VER" ["website"]=> string(25) "https://www.purver.com/fr" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> object(stdClass)#2198 (2) { ["internationalFormat"]=> string(15) "+33+32470330399" ["frenchFormat"]=> string(13) "0+32470330399" } ["zoho_id"]=> string(18) "246999000011445054" ["address"]=> object(stdClass)#2199 (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)#2201 (3) { ["full"]=> object(stdClass)#2200 (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)#2202 (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)#2203 (3) { ["src"]=> string(77) "https://extranet.afaia.fr/wp-content/uploads/2022/12/logo-pur-ver-150x150.jpg" ["width"]=> int(150) ["height"]=> int(150) } } }