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(19) "BIOLANDES PIN DECOR" ["website"]=> string(25) "https://www.biolandes.com" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> object(stdClass)#2030 (2) { ["internationalFormat"]=> string(12) "+33558510000" ["frenchFormat"]=> string(14) "05 58 51 00 00" } ["zoho_id"]=> string(18) "246999000000253147" ["address"]=> object(stdClass)#2100 (4) { ["street"]=> string(20) "2760 Route de Bélis" ["postalcode"]=> string(5) "40420" ["city"]=> string(6) "LE SEN" ["country"]=> string(6) "FRANCE" } ["adherents"]=> array(1) { [0]=> string(9) "Adhérent" } ["produits_fabriques"]=> array(3) { [0]=> string(19) "Supports de culture" [1]=> string(9) "Paillages" [2]=> string(22) "Amendements organiques" } ["contributeurs_statistiques"]=> string(0) "" ["tag"]=> array(0) { } ["logo"]=> object(stdClass)#1971 (3) { ["full"]=> object(stdClass)#1973 (3) { ["src"]=> string(66) "https://extranet.afaia.fr/wp-content/uploads/2020/02/biolande1.jpg" ["width"]=> int(500) ["height"]=> int(83) } ["medium"]=> object(stdClass)#1970 (3) { ["src"]=> string(73) "https://extranet.afaia.fr/wp-content/uploads/2020/02/biolande1-300x50.jpg" ["width"]=> int(300) ["height"]=> int(50) } ["thumbnail"]=> object(stdClass)#1969 (3) { ["src"]=> string(73) "https://extranet.afaia.fr/wp-content/uploads/2020/02/biolande1-150x83.jpg" ["width"]=> int(150) ["height"]=> int(83) } } }BIOLANDES PIN DECOR Supports de culture, Paillages, Amendements organiques https://www.biolandes.com
object(stdClass)#1968 (12) { ["name"]=> string(17) "BORREGAARD France" ["website"]=> string(27) "https://www.borregaard.com/" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> string(0) "" ["zoho_id"]=> string(18) "246999000000253155" ["address"]=> object(stdClass)#1967 (4) { ["street"]=> string(33) "122 Avenue du général de Gaulle" ["postalcode"]=> NULL ["city"]=> string(5) "92200" ["country"]=> string(16) "Neully sur Seine" } ["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)#2115 (3) { ["full"]=> object(stdClass)#2072 (3) { ["src"]=> string(81) "https://extranet.afaia.fr/wp-content/uploads/2020/02/borregaard-blue-rgb-logo.jpg" ["width"]=> int(1315) ["height"]=> int(326) } ["medium"]=> object(stdClass)#1997 (3) { ["src"]=> string(88) "https://extranet.afaia.fr/wp-content/uploads/2020/02/borregaard-blue-rgb-logo-300x74.jpg" ["width"]=> int(300) ["height"]=> int(74) } ["thumbnail"]=> object(stdClass)#2142 (3) { ["src"]=> string(89) "https://extranet.afaia.fr/wp-content/uploads/2020/02/borregaard-blue-rgb-logo-150x150.jpg" ["width"]=> int(150) ["height"]=> int(150) } } }BORREGAARD France Biostimulants https://www.borregaard.com/
object(stdClass)#2143 (12) { ["name"]=> string(12) "BRILL FRANCE" ["website"]=> string(32) "https://www.brill-substrate.com/" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> object(stdClass)#2144 (2) { ["internationalFormat"]=> string(12) "+33472775277" ["frenchFormat"]=> string(14) "04 72 77 52 77" } ["zoho_id"]=> string(18) "246999000000253156" ["address"]=> object(stdClass)#2145 (4) { ["street"]=> string(21) "21 Rue de l'Industrie" ["postalcode"]=> string(5) "69530" ["city"]=> string(8) "Brignais" ["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)#2147 (3) { ["full"]=> object(stdClass)#2146 (3) { ["src"]=> string(62) "https://extranet.afaia.fr/wp-content/uploads/2020/02/brill.jpg" ["width"]=> int(392) ["height"]=> int(374) } ["medium"]=> object(stdClass)#2148 (3) { ["src"]=> string(70) "https://extranet.afaia.fr/wp-content/uploads/2020/02/brill-300x286.jpg" ["width"]=> int(300) ["height"]=> int(286) } ["thumbnail"]=> object(stdClass)#2149 (3) { ["src"]=> string(70) "https://extranet.afaia.fr/wp-content/uploads/2020/02/brill-150x150.jpg" ["width"]=> int(150) ["height"]=> int(150) } } }BRILL FRANCE Supports de culture https://www.brill-substrate.com/
object(stdClass)#2150 (12) { ["name"]=> string(10) "CARBONLOOP" ["website"]=> string(26) "https://carbonloop.energy/" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> string(0) "" ["zoho_id"]=> string(18) "246999000011445007" ["address"]=> object(stdClass)#2151 (4) { ["street"]=> string(20) "41 rue François 1er" ["postalcode"]=> string(5) "75008" ["city"]=> string(5) "PARIS" ["country"]=> string(6) "FRANCE" } ["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)#2153 (3) { ["full"]=> object(stdClass)#2152 (3) { ["src"]=> string(67) "https://extranet.afaia.fr/wp-content/uploads/2022/12/carbonloop.jpg" ["width"]=> int(872) ["height"]=> int(372) } ["medium"]=> object(stdClass)#2154 (3) { ["src"]=> string(75) "https://extranet.afaia.fr/wp-content/uploads/2022/12/carbonloop-300x128.jpg" ["width"]=> int(300) ["height"]=> int(128) } ["thumbnail"]=> object(stdClass)#2155 (3) { ["src"]=> string(75) "https://extranet.afaia.fr/wp-content/uploads/2022/12/carbonloop-150x150.jpg" ["width"]=> int(150) ["height"]=> int(150) } } }CARBONLOOP Amendements organiques, Biostimulants https://carbonloop.energy/
object(stdClass)#2156 (12) { ["name"]=> string(14) "CLER VERTS SAS" ["website"]=> string(24) "http://www.cler-verts.fr" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> string(0) "" ["zoho_id"]=> string(18) "246999000000253165" ["address"]=> object(stdClass)#2157 (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)#2159 (3) { ["full"]=> object(stdClass)#2158 (3) { ["src"]=> string(67) "https://extranet.afaia.fr/wp-content/uploads/2020/02/cler-verts.jpg" ["width"]=> int(225) ["height"]=> int(225) } ["medium"]=> object(stdClass)#2160 (3) { ["src"]=> string(67) "https://extranet.afaia.fr/wp-content/uploads/2020/02/cler-verts.jpg" ["width"]=> int(225) ["height"]=> int(225) } ["thumbnail"]=> object(stdClass)#2161 (3) { ["src"]=> string(75) "https://extranet.afaia.fr/wp-content/uploads/2020/02/cler-verts-150x150.jpg" ["width"]=> int(150) ["height"]=> int(150) } } }CLER VERTS SAS Amendements organiques http://www.cler-verts.fr
object(stdClass)#2162 (12) { ["name"]=> string(24) "COBIOTEX Laboratoire SAS" ["website"]=> string(25) "https://www.dietaxion.com" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> object(stdClass)#2163 (2) { ["internationalFormat"]=> string(16) "+332.40.40.13.14" ["frenchFormat"]=> string(14) "02.40.40.13.14" } ["zoho_id"]=> string(18) "246999000000253166" ["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(86) "https://extranet.afaia.fr/wp-content/uploads/2020/02/laboratoirecobiotex-hd575x166.png" ["width"]=> int(575) ["height"]=> int(166) } ["medium"]=> object(stdClass)#2167 (3) { ["src"]=> string(93) "https://extranet.afaia.fr/wp-content/uploads/2020/02/laboratoirecobiotex-hd575x166-300x87.png" ["width"]=> int(300) ["height"]=> int(87) } ["thumbnail"]=> object(stdClass)#2168 (3) { ["src"]=> string(94) "https://extranet.afaia.fr/wp-content/uploads/2020/02/laboratoirecobiotex-hd575x166-150x150.png" ["width"]=> int(150) ["height"]=> int(150) } } }COBIOTEX Laboratoire SAS Biostimulants https://www.dietaxion.com
object(stdClass)#2169 (12) { ["name"]=> string(3) "DAE" ["website"]=> string(0) "" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> string(0) "" ["zoho_id"]=> string(18) "246999000009254001" ["address"]=> object(stdClass)#2170 (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)#2172 (3) { ["full"]=> object(stdClass)#2171 (3) { ["src"]=> string(65) "https://extranet.afaia.fr/wp-content/uploads/2022/07/Logo dae.png" ["width"]=> int(937) ["height"]=> int(718) } ["medium"]=> object(stdClass)#2173 (3) { ["src"]=> string(73) "https://extranet.afaia.fr/wp-content/uploads/2022/07/Logo dae-300x230.png" ["width"]=> int(300) ["height"]=> int(230) } ["thumbnail"]=> object(stdClass)#2174 (3) { ["src"]=> string(73) "https://extranet.afaia.fr/wp-content/uploads/2022/07/Logo dae-150x150.png" ["width"]=> int(150) ["height"]=> int(150) } } }DAE Biostimulants
object(stdClass)#2175 (12) { ["name"]=> string(12) "DCM SOPRIMEX" ["website"]=> string(23) "http://www.soprimex.com" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> object(stdClass)#2176 (2) { ["internationalFormat"]=> string(12) "+33490240424" ["frenchFormat"]=> string(14) "04 90 24 04 24" } ["zoho_id"]=> string(18) "246999000000253175" ["address"]=> object(stdClass)#2177 (4) { ["street"]=> string(17) "23 rue du Creuzat" ["postalcode"]=> string(5) "38080" ["city"]=> string(18) "L’ISLE D’ABEAU" ["country"]=> string(6) "FRANCE" } ["adherents"]=> array(1) { [0]=> string(9) "Adhérent" } ["produits_fabriques"]=> array(5) { [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" } ["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/2020/02/dcm-soprimex.jpg" ["width"]=> int(346) ["height"]=> int(67) } ["medium"]=> object(stdClass)#2180 (3) { ["src"]=> string(76) "https://extranet.afaia.fr/wp-content/uploads/2020/02/dcm-soprimex-300x58.jpg" ["width"]=> int(300) ["height"]=> int(58) } ["thumbnail"]=> object(stdClass)#2181 (3) { ["src"]=> string(76) "https://extranet.afaia.fr/wp-content/uploads/2020/02/dcm-soprimex-150x67.jpg" ["width"]=> int(150) ["height"]=> int(67) } } }DCM SOPRIMEX Supports de culture, Paillages, Amendements organiques, Engrais organiques, Engrais organo-minéraux http://www.soprimex.com
object(stdClass)#2182 (12) { ["name"]=> string(21) "DELEPLANQUE & CIE" ["website"]=> string(27) "https://www.deleplanque.fr/" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> object(stdClass)#2183 (2) { ["internationalFormat"]=> string(12) "+33134932727" ["frenchFormat"]=> string(14) "01 34 93 27 27" } ["zoho_id"]=> string(18) "246999000002925005" ["address"]=> object(stdClass)#2184 (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)#2186 (3) { ["full"]=> object(stdClass)#2185 (3) { ["src"]=> string(68) "https://extranet.afaia.fr/wp-content/uploads/2021/01/deleplanque.jpg" ["width"]=> int(474) ["height"]=> int(158) } ["medium"]=> object(stdClass)#2187 (3) { ["src"]=> string(76) "https://extranet.afaia.fr/wp-content/uploads/2021/01/deleplanque-300x100.jpg" ["width"]=> int(300) ["height"]=> int(100) } ["thumbnail"]=> object(stdClass)#2188 (3) { ["src"]=> string(76) "https://extranet.afaia.fr/wp-content/uploads/2021/01/deleplanque-150x150.jpg" ["width"]=> int(150) ["height"]=> int(150) } } }DELEPLANQUE & CIE Amendements organiques, Engrais organiques, Engrais organo-minéraux https://www.deleplanque.fr/
object(stdClass)#2189 (12) { ["name"]=> string(6) "DUMONA" ["website"]=> string(23) "https://www.dumona.com/" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> object(stdClass)#2190 (2) { ["internationalFormat"]=> string(12) "+33474808155" ["frenchFormat"]=> string(14) "04 74 80 81 55" } ["zoho_id"]=> string(18) "246999000000253176" ["address"]=> object(stdClass)#2191 (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)#2193 (3) { ["full"]=> object(stdClass)#2192 (3) { ["src"]=> string(69) "https://extranet.afaia.fr/wp-content/uploads/2020/02/dumona-vecto.jpg" ["width"]=> int(300) ["height"]=> int(133) } ["medium"]=> object(stdClass)#2194 (3) { ["src"]=> string(69) "https://extranet.afaia.fr/wp-content/uploads/2020/02/dumona-vecto.jpg" ["width"]=> int(300) ["height"]=> int(133) } ["thumbnail"]=> object(stdClass)#2195 (3) { ["src"]=> string(77) "https://extranet.afaia.fr/wp-content/uploads/2020/02/dumona-vecto-150x133.jpg" ["width"]=> int(150) ["height"]=> int(133) } } }DUMONA Supports de culture https://www.dumona.com/
object(stdClass)#2196 (12) { ["name"]=> string(16) "ENERGIPOLE VERDE" ["website"]=> string(25) "https://www.suez.fr/fr-fr" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> object(stdClass)#2197 (2) { ["internationalFormat"]=> string(12) "+33590571061" ["frenchFormat"]=> string(14) "05 90 57 10 61" } ["zoho_id"]=> string(18) "246999000000253266" ["address"]=> object(stdClass)#2198 (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)#2200 (3) { ["full"]=> object(stdClass)#2199 (3) { ["src"]=> string(67) "https://extranet.afaia.fr/wp-content/uploads/2020/02/energipole.jpg" ["width"]=> int(245) ["height"]=> int(191) } ["medium"]=> object(stdClass)#2201 (3) { ["src"]=> string(67) "https://extranet.afaia.fr/wp-content/uploads/2020/02/energipole.jpg" ["width"]=> int(245) ["height"]=> int(191) } ["thumbnail"]=> object(stdClass)#2202 (3) { ["src"]=> string(75) "https://extranet.afaia.fr/wp-content/uploads/2020/02/energipole-150x150.jpg" ["width"]=> int(150) ["height"]=> int(150) } } }ENERGIPOLE VERDE Amendements organiques https://www.suez.fr/fr-fr
object(stdClass)#2203 (12) { ["name"]=> string(7) "EQUITOX" ["website"]=> string(23) "https://www.equitox.eu/" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> object(stdClass)#2204 (2) { ["internationalFormat"]=> string(12) "+33482539018" ["frenchFormat"]=> string(14) "04 82 53 90 18" } ["zoho_id"]=> string(18) "246999000007830423" ["address"]=> object(stdClass)#2205 (4) { ["street"]=> NULL ["postalcode"]=> NULL ["city"]=> NULL ["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)#2207 (3) { ["full"]=> object(stdClass)#2206 (3) { ["src"]=> string(64) "https://extranet.afaia.fr/wp-content/uploads/2022/04/equitox.png" ["width"]=> int(154) ["height"]=> int(49) } ["medium"]=> object(stdClass)#2208 (3) { ["src"]=> string(64) "https://extranet.afaia.fr/wp-content/uploads/2022/04/equitox.png" ["width"]=> int(154) ["height"]=> int(49) } ["thumbnail"]=> object(stdClass)#2209 (3) { ["src"]=> string(71) "https://extranet.afaia.fr/wp-content/uploads/2022/04/equitox-150x49.png" ["width"]=> int(150) ["height"]=> int(49) } } }EQUITOX Membre associé d'Afaïa https://www.equitox.eu/