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)#2129 (12) { ["name"]=> string(7) "ALGAÏA" ["website"]=> string(22) "https://www.algaia.com" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> string(0) "" ["zoho_id"]=> string(18) "246999000000253118" ["address"]=> object(stdClass)#2030 (4) { ["street"]=> string(21) "91 Rue Edouard Branly" ["postalcode"]=> string(6) "50 000" ["city"]=> string(8) "SAINT LO" ["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)#1973 (3) { ["full"]=> object(stdClass)#2100 (3) { ["src"]=> string(68) "https://extranet.afaia.fr/wp-content/uploads/2020/02/logo-algaia.jpg" ["width"]=> int(2445) ["height"]=> int(808) } ["medium"]=> object(stdClass)#1971 (3) { ["src"]=> string(75) "https://extranet.afaia.fr/wp-content/uploads/2020/02/logo-algaia-300x99.jpg" ["width"]=> int(300) ["height"]=> int(99) } ["thumbnail"]=> object(stdClass)#1970 (3) { ["src"]=> string(76) "https://extranet.afaia.fr/wp-content/uploads/2020/02/logo-algaia-150x150.jpg" ["width"]=> int(150) ["height"]=> int(150) } } }
object(stdClass)#1969 (12) { ["name"]=> string(16) "ANDERMATT France" ["website"]=> string(24) "https://www.andermatt.fr" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> string(0) "" ["zoho_id"]=> string(18) "246999000000253126" ["address"]=> object(stdClass)#1968 (4) { ["street"]=> string(55) "80 Chemin de l’Aviation - Domaine du Makila – Bat B" ["postalcode"]=> string(5) "64200" ["city"]=> string(11) "BASSUSSARRY" ["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)#2072 (3) { ["full"]=> object(stdClass)#1967 (3) { ["src"]=> string(86) "https://extranet.afaia.fr/wp-content/uploads/2020/02/andermatt-logo-1472639694-jpg.png" ["width"]=> int(1081) ["height"]=> int(552) } ["medium"]=> object(stdClass)#2115 (3) { ["src"]=> string(94) "https://extranet.afaia.fr/wp-content/uploads/2020/02/andermatt-logo-1472639694-jpg-300x153.png" ["width"]=> int(300) ["height"]=> int(153) } ["thumbnail"]=> object(stdClass)#1997 (3) { ["src"]=> string(94) "https://extranet.afaia.fr/wp-content/uploads/2020/02/andermatt-logo-1472639694-jpg-150x150.png" ["width"]=> int(150) ["height"]=> int(150) } } }
object(stdClass)#2142 (12) { ["name"]=> string(8) "ANGIBAUD" ["website"]=> string(15) "www.angibaud.fr" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> string(0) "" ["zoho_id"]=> string(18) "246999000000253127" ["address"]=> object(stdClass)#2143 (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)#2145 (3) { ["full"]=> object(stdClass)#2144 (3) { ["src"]=> string(73) "https://extranet.afaia.fr/wp-content/uploads/2020/02/angibau-baseline.png" ["width"]=> int(228) ["height"]=> int(140) } ["medium"]=> object(stdClass)#2146 (3) { ["src"]=> string(73) "https://extranet.afaia.fr/wp-content/uploads/2020/02/angibau-baseline.png" ["width"]=> int(228) ["height"]=> int(140) } ["thumbnail"]=> object(stdClass)#2147 (3) { ["src"]=> string(81) "https://extranet.afaia.fr/wp-content/uploads/2020/02/angibau-baseline-150x140.png" ["width"]=> int(150) ["height"]=> int(140) } } }
object(stdClass)#2148 (12) { ["name"]=> string(13) "Anjou Ardoise" ["website"]=> string(29) "https://www.anjou-ardoise.fr/" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> object(stdClass)#2149 (2) { ["internationalFormat"]=> string(12) "+33626158450" ["frenchFormat"]=> string(14) "06 26 15 84 50" } ["zoho_id"]=> string(18) "246999000013464039" ["address"]=> object(stdClass)#2150 (4) { ["street"]=> string(27) "15 place Alexandre Veillard" ["postalcode"]=> string(5) "35140" ["city"]=> string(22) "SAINT-AUBIN-DU-CORMIER" ["country"]=> string(6) "FRANCE" } ["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)#2152 (3) { ["full"]=> object(stdClass)#2151 (3) { ["src"]=> string(75) "https://extranet.afaia.fr/wp-content/uploads/2023/07/logo-anjou-ardoise.png" ["width"]=> int(544) ["height"]=> int(346) } ["medium"]=> object(stdClass)#2153 (3) { ["src"]=> string(83) "https://extranet.afaia.fr/wp-content/uploads/2023/07/logo-anjou-ardoise-300x191.png" ["width"]=> int(300) ["height"]=> int(191) } ["thumbnail"]=> object(stdClass)#2154 (3) { ["src"]=> string(83) "https://extranet.afaia.fr/wp-content/uploads/2023/07/logo-anjou-ardoise-150x150.png" ["width"]=> int(150) ["height"]=> int(150) } } }
object(stdClass)#2155 (12) { ["name"]=> string(7) "ANTEDIS" ["website"]=> string(24) "https://www.antedis.com/" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> string(0) "" ["zoho_id"]=> string(18) "246999000002519005" ["address"]=> object(stdClass)#2156 (4) { ["street"]=> string(22) "48 rue de la Madeleine" ["postalcode"]=> string(5) "60000" ["city"]=> string(8) "BEAUVAIS" ["country"]=> NULL } ["adherents"]=> array(2) { [0]=> string(9) "Adhérent" [1]=> string(15) "Membre Associé" } ["produits_fabriques"]=> array(1) { [0]=> string(24) "Membre associé d'Afaïa" } ["contributeurs_statistiques"]=> string(0) "" ["tag"]=> array(0) { } ["logo"]=> object(stdClass)#2158 (3) { ["full"]=> object(stdClass)#2157 (3) { ["src"]=> string(64) "https://extranet.afaia.fr/wp-content/uploads/2020/12/antedis.jpg" ["width"]=> int(220) ["height"]=> int(81) } ["medium"]=> object(stdClass)#2159 (3) { ["src"]=> string(64) "https://extranet.afaia.fr/wp-content/uploads/2020/12/antedis.jpg" ["width"]=> int(220) ["height"]=> int(81) } ["thumbnail"]=> object(stdClass)#2160 (3) { ["src"]=> string(71) "https://extranet.afaia.fr/wp-content/uploads/2020/12/antedis-150x81.jpg" ["width"]=> int(150) ["height"]=> int(81) } } }
object(stdClass)#2161 (12) { ["name"]=> string(18) "ATLANTICA AGRICOLA" ["website"]=> string(32) "http://www.atlanticaagricola.com" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> object(stdClass)#2162 (2) { ["internationalFormat"]=> string(15) "+33+34965800358" ["frenchFormat"]=> string(13) "0+34965800358" } ["zoho_id"]=> string(18) "246999000000253128" ["address"]=> object(stdClass)#2163 (4) { ["street"]=> string(49) "Polígono Industrial El Rubial, calle 8 número 2" ["postalcode"]=> string(5) "03400" ["city"]=> string(18) "Villena (Alicante)" ["country"]=> string(7) "ESPAGNE" } ["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)#2165 (3) { ["full"]=> object(stdClass)#2164 (3) { ["src"]=> string(75) "https://extranet.afaia.fr/wp-content/uploads/2020/02/atlantica-agricola.jpg" ["width"]=> int(400) ["height"]=> int(309) } ["medium"]=> object(stdClass)#2166 (3) { ["src"]=> string(83) "https://extranet.afaia.fr/wp-content/uploads/2020/02/atlantica-agricola-300x232.jpg" ["width"]=> int(300) ["height"]=> int(232) } ["thumbnail"]=> object(stdClass)#2167 (3) { ["src"]=> string(83) "https://extranet.afaia.fr/wp-content/uploads/2020/02/atlantica-agricola-150x150.jpg" ["width"]=> int(150) ["height"]=> int(150) } } }
object(stdClass)#2168 (12) { ["name"]=> string(18) "AXIOMA BIOLOGICALS" ["website"]=> string(34) "https://www.axioma-biologicals.com" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> string(0) "" ["zoho_id"]=> string(18) "246999000000253137" ["address"]=> object(stdClass)#2169 (4) { ["street"]=> string(20) "8 Boulevard Voltaire" ["postalcode"]=> string(5) "19100" ["city"]=> string(18) "BRIVE LA GAILLARDE" ["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)#2171 (3) { ["full"]=> object(stdClass)#2170 (3) { ["src"]=> string(75) "https://extranet.afaia.fr/wp-content/uploads/2020/02/axioma-biologicals.png" ["width"]=> int(3342) ["height"]=> int(1934) } ["medium"]=> object(stdClass)#2172 (3) { ["src"]=> string(83) "https://extranet.afaia.fr/wp-content/uploads/2020/02/axioma-biologicals-300x174.png" ["width"]=> int(300) ["height"]=> int(174) } ["thumbnail"]=> object(stdClass)#2173 (3) { ["src"]=> string(83) "https://extranet.afaia.fr/wp-content/uploads/2020/02/axioma-biologicals-150x150.png" ["width"]=> int(150) ["height"]=> int(150) } } }
object(stdClass)#2174 (12) { ["name"]=> string(17) "BCF LIFE SCIENCES" ["website"]=> string(33) "https://www.bcf-lifesciences.com/" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> string(0) "" ["zoho_id"]=> string(18) "246999000005308003" ["address"]=> object(stdClass)#2175 (4) { ["street"]=> string(6) "BOISEL" ["postalcode"]=> string(5) "56140" ["city"]=> string(9) "PLEUCADEC" ["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)#2177 (3) { ["full"]=> object(stdClass)#2176 (3) { ["src"]=> string(70) "https://extranet.afaia.fr/wp-content/uploads/2021/09/bcf350x222dpi.png" ["width"]=> int(350) ["height"]=> int(222) } ["medium"]=> object(stdClass)#2178 (3) { ["src"]=> string(78) "https://extranet.afaia.fr/wp-content/uploads/2021/09/bcf350x222dpi-300x190.png" ["width"]=> int(300) ["height"]=> int(190) } ["thumbnail"]=> object(stdClass)#2179 (3) { ["src"]=> string(78) "https://extranet.afaia.fr/wp-content/uploads/2021/09/bcf350x222dpi-150x150.png" ["width"]=> int(150) ["height"]=> int(150) } } }
object(stdClass)#2180 (12) { ["name"]=> string(5) "BIO3G" ["website"]=> string(12) "www.bio3g.fr" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> string(0) "" ["zoho_id"]=> string(18) "246999000000253138" ["address"]=> object(stdClass)#2181 (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)#2183 (3) { ["full"]=> object(stdClass)#2182 (3) { ["src"]=> string(62) "https://extranet.afaia.fr/wp-content/uploads/2020/02/bio3g.jpg" ["width"]=> int(187) ["height"]=> int(187) } ["medium"]=> object(stdClass)#2184 (3) { ["src"]=> string(62) "https://extranet.afaia.fr/wp-content/uploads/2020/02/bio3g.jpg" ["width"]=> int(187) ["height"]=> int(187) } ["thumbnail"]=> object(stdClass)#2185 (3) { ["src"]=> string(70) "https://extranet.afaia.fr/wp-content/uploads/2020/02/bio3g-150x150.jpg" ["width"]=> int(150) ["height"]=> int(150) } } }
object(stdClass)#2186 (12) { ["name"]=> string(21) "BIODEVAS LABORATOIRES" ["website"]=> string(15) "www.biodevas.fr" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> string(0) "" ["zoho_id"]=> string(18) "246999000000253145" ["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(13) "Biostimulants" } ["contributeurs_statistiques"]=> string(0) "" ["tag"]=> array(0) { } ["logo"]=> object(stdClass)#2189 (3) { ["full"]=> object(stdClass)#2188 (3) { ["src"]=> string(65) "https://extranet.afaia.fr/wp-content/uploads/2020/02/biodevas.jpg" ["width"]=> int(400) ["height"]=> int(142) } ["medium"]=> object(stdClass)#2190 (3) { ["src"]=> string(73) "https://extranet.afaia.fr/wp-content/uploads/2020/02/biodevas-300x107.jpg" ["width"]=> int(300) ["height"]=> int(107) } ["thumbnail"]=> object(stdClass)#2191 (3) { ["src"]=> string(73) "https://extranet.afaia.fr/wp-content/uploads/2020/02/biodevas-150x142.jpg" ["width"]=> int(150) ["height"]=> int(142) } } }
object(stdClass)#2192 (12) { ["name"]=> string(9) "BIOFERTIL" ["website"]=> string(21) "https://biofertil.fr/" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> string(0) "" ["zoho_id"]=> string(18) "246999000000253146" ["address"]=> object(stdClass)#2193 (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(22) "Amendements organiques" } ["contributeurs_statistiques"]=> string(0) "" ["tag"]=> array(0) { } ["logo"]=> object(stdClass)#2195 (3) { ["full"]=> object(stdClass)#2194 (3) { ["src"]=> string(66) "https://extranet.afaia.fr/wp-content/uploads/2020/02/biofertil.jpg" ["width"]=> int(600) ["height"]=> int(198) } ["medium"]=> object(stdClass)#2196 (3) { ["src"]=> string(73) "https://extranet.afaia.fr/wp-content/uploads/2020/02/biofertil-300x99.jpg" ["width"]=> int(300) ["height"]=> int(99) } ["thumbnail"]=> object(stdClass)#2197 (3) { ["src"]=> string(74) "https://extranet.afaia.fr/wp-content/uploads/2020/02/biofertil-150x150.jpg" ["width"]=> int(150) ["height"]=> int(150) } } }
object(stdClass)#2198 (12) { ["name"]=> string(10) "BIOINTRANT" ["website"]=> string(27) "https://www.biointrant.com/" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> string(0) "" ["zoho_id"]=> string(18) "246999000007912163" ["address"]=> object(stdClass)#2199 (4) { ["street"]=> string(26) "139 Rue Philippe de Girard" ["postalcode"]=> string(5) "84120" ["city"]=> string(7) "PERTUIS" ["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"]=> NULL }