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 '{4a3dcd2ca58d62969e4c8cb9b8b5b00930ded38386e49752d91acfed5e3dcd8a}Amendements organiques{4a3dcd2ca58d62969e4c8cb9b8b5b00930ded38386e49752d91acfed5e3dcd8a}' OR pmr.meta_value LIKE '{4a3dcd2ca58d62969e4c8cb9b8b5b00930ded38386e49752d91acfed5e3dcd8a}Engrais organiques{4a3dcd2ca58d62969e4c8cb9b8b5b00930ded38386e49752d91acfed5e3dcd8a}' OR pmr.meta_value LIKE '{4a3dcd2ca58d62969e4c8cb9b8b5b00930ded38386e49752d91acfed5e3dcd8a}Engrais organo-minéraux{4a3dcd2ca58d62969e4c8cb9b8b5b00930ded38386e49752d91acfed5e3dcd8a}' ) );"
object(stdClass)#2132 (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)#2033 (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)#1976 (3) { ["full"]=> object(stdClass)#2103 (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)#1974 (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)#1973 (3) { ["src"]=> string(75) "https://extranet.afaia.fr/wp-content/uploads/2020/02/cler-verts-150x150.jpg" ["width"]=> int(150) ["height"]=> int(150) } } }
object(stdClass)#1972 (12) { ["name"]=> string(12) "DCM SOPRIMEX" ["website"]=> string(23) "http://www.soprimex.com" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> object(stdClass)#1971 (2) { ["internationalFormat"]=> string(12) "+33490240424" ["frenchFormat"]=> string(14) "04 90 24 04 24" } ["zoho_id"]=> string(18) "246999000000253175" ["address"]=> object(stdClass)#1970 (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)#2118 (3) { ["full"]=> object(stdClass)#2075 (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)#1998 (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)#2145 (3) { ["src"]=> string(76) "https://extranet.afaia.fr/wp-content/uploads/2020/02/dcm-soprimex-150x67.jpg" ["width"]=> int(150) ["height"]=> int(67) } } }
object(stdClass)#2146 (12) { ["name"]=> string(21) "DELEPLANQUE & CIE" ["website"]=> string(27) "https://www.deleplanque.fr/" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> object(stdClass)#2147 (2) { ["internationalFormat"]=> string(12) "+33134932727" ["frenchFormat"]=> string(14) "01 34 93 27 27" } ["zoho_id"]=> string(18) "246999000002925005" ["address"]=> object(stdClass)#2148 (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)#2150 (3) { ["full"]=> object(stdClass)#2149 (3) { ["src"]=> string(68) "https://extranet.afaia.fr/wp-content/uploads/2021/01/deleplanque.jpg" ["width"]=> int(474) ["height"]=> int(158) } ["medium"]=> object(stdClass)#2151 (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)#2152 (3) { ["src"]=> string(76) "https://extranet.afaia.fr/wp-content/uploads/2021/01/deleplanque-150x150.jpg" ["width"]=> int(150) ["height"]=> int(150) } } }
object(stdClass)#2153 (12) { ["name"]=> string(16) "ENERGIPOLE VERDE" ["website"]=> string(25) "https://www.suez.fr/fr-fr" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> object(stdClass)#2154 (2) { ["internationalFormat"]=> string(12) "+33590571061" ["frenchFormat"]=> string(14) "05 90 57 10 61" } ["zoho_id"]=> string(18) "246999000000253266" ["address"]=> object(stdClass)#2155 (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)#2157 (3) { ["full"]=> object(stdClass)#2156 (3) { ["src"]=> string(67) "https://extranet.afaia.fr/wp-content/uploads/2020/02/energipole.jpg" ["width"]=> int(245) ["height"]=> int(191) } ["medium"]=> object(stdClass)#2158 (3) { ["src"]=> string(67) "https://extranet.afaia.fr/wp-content/uploads/2020/02/energipole.jpg" ["width"]=> int(245) ["height"]=> int(191) } ["thumbnail"]=> object(stdClass)#2159 (3) { ["src"]=> string(75) "https://extranet.afaia.fr/wp-content/uploads/2020/02/energipole-150x150.jpg" ["width"]=> int(150) ["height"]=> int(150) } } }
object(stdClass)#2160 (12) { ["name"]=> string(11) "ETS HUON SA" ["website"]=> string(23) "http://www.ets-huon.com" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> string(0) "" ["zoho_id"]=> string(18) "246999000000253186" ["address"]=> object(stdClass)#2161 (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)#2163 (3) { ["full"]=> object(stdClass)#2162 (3) { ["src"]=> string(66) "https://extranet.afaia.fr/wp-content/uploads/2020/02/logo-huon.png" ["width"]=> int(162) ["height"]=> int(179) } ["medium"]=> object(stdClass)#2164 (3) { ["src"]=> string(66) "https://extranet.afaia.fr/wp-content/uploads/2020/02/logo-huon.png" ["width"]=> int(162) ["height"]=> int(179) } ["thumbnail"]=> object(stdClass)#2165 (3) { ["src"]=> string(74) "https://extranet.afaia.fr/wp-content/uploads/2020/02/logo-huon-150x150.png" ["width"]=> int(150) ["height"]=> int(150) } } }
object(stdClass)#2166 (12) { ["name"]=> string(13) "EVADEA GROUPE" ["website"]=> string(26) "http://www.tourbieres.com/" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> string(0) "" ["zoho_id"]=> string(18) "246999000000253187" ["address"]=> object(stdClass)#2167 (4) { ["street"]=> NULL ["postalcode"]=> NULL ["city"]=> NULL ["country"]=> NULL } ["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(13) "Biostimulants" } ["contributeurs_statistiques"]=> string(0) "" ["tag"]=> array(0) { } ["logo"]=> object(stdClass)#2169 (3) { ["full"]=> object(stdClass)#2168 (3) { ["src"]=> string(78) "https://extranet.afaia.fr/wp-content/uploads/2022/01/EVADEA PICTO BASELINE.png" ["width"]=> int(934) ["height"]=> int(431) } ["medium"]=> object(stdClass)#2170 (3) { ["src"]=> string(86) "https://extranet.afaia.fr/wp-content/uploads/2022/01/EVADEA PICTO BASELINE-300x138.png" ["width"]=> int(300) ["height"]=> int(138) } ["thumbnail"]=> object(stdClass)#2171 (3) { ["src"]=> string(86) "https://extranet.afaia.fr/wp-content/uploads/2022/01/EVADEA PICTO BASELINE-150x150.png" ["width"]=> int(150) ["height"]=> int(150) } } }
object(stdClass)#2172 (12) { ["name"]=> string(6) "FERTIL" ["website"]=> string(16) "http://fertil.fr" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> string(0) "" ["zoho_id"]=> string(18) "246999000000253196" ["address"]=> object(stdClass)#2173 (4) { ["street"]=> NULL ["postalcode"]=> NULL ["city"]=> NULL ["country"]=> NULL } ["adherents"]=> array(1) { [0]=> string(9) "Adhérent" } ["produits_fabriques"]=> array(2) { [0]=> string(9) "Paillages" [1]=> string(18) "Engrais organiques" } ["contributeurs_statistiques"]=> string(0) "" ["tag"]=> array(0) { } ["logo"]=> object(stdClass)#2175 (3) { ["full"]=> object(stdClass)#2174 (3) { ["src"]=> string(67) "https://extranet.afaia.fr/wp-content/uploads/2022/10/LogoFertil.png" ["width"]=> int(134) ["height"]=> int(134) } ["medium"]=> object(stdClass)#2176 (3) { ["src"]=> string(67) "https://extranet.afaia.fr/wp-content/uploads/2022/10/LogoFertil.png" ["width"]=> int(134) ["height"]=> int(134) } ["thumbnail"]=> object(stdClass)#2177 (3) { ["src"]=> string(67) "https://extranet.afaia.fr/wp-content/uploads/2022/10/LogoFertil.png" ["width"]=> int(134) ["height"]=> int(134) } } }
object(stdClass)#2178 (12) { ["name"]=> string(8) "FERTILEO" ["website"]=> string(23) "https://www.fertileo.fr" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> string(0) "" ["zoho_id"]=> string(18) "246999000000253198" ["address"]=> object(stdClass)#2179 (4) { ["street"]=> NULL ["postalcode"]=> NULL ["city"]=> NULL ["country"]=> NULL } ["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"]=> object(stdClass)#2181 (3) { ["full"]=> object(stdClass)#2180 (3) { ["src"]=> string(76) "https://extranet.afaia.fr/wp-content/uploads/2020/02/fertileo-rvb-300dpi.jpg" ["width"]=> int(1772) ["height"]=> int(1181) } ["medium"]=> object(stdClass)#2182 (3) { ["src"]=> string(84) "https://extranet.afaia.fr/wp-content/uploads/2020/02/fertileo-rvb-300dpi-300x200.jpg" ["width"]=> int(300) ["height"]=> int(200) } ["thumbnail"]=> object(stdClass)#2183 (3) { ["src"]=> string(84) "https://extranet.afaia.fr/wp-content/uploads/2020/02/fertileo-rvb-300dpi-150x150.jpg" ["width"]=> int(150) ["height"]=> int(150) } } }
object(stdClass)#2184 (12) { ["name"]=> string(8) "FERTIVAL" ["website"]=> string(24) "https://www.fertival.fr/" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> string(0) "" ["zoho_id"]=> string(18) "246999000000439014" ["address"]=> object(stdClass)#2185 (4) { ["street"]=> string(10) "La Vallée" ["postalcode"]=> string(5) "22400" ["city"]=> string(9) "QUINTENIC" ["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)#2187 (3) { ["full"]=> object(stdClass)#2186 (3) { ["src"]=> string(74) "https://extranet.afaia.fr/wp-content/uploads/2020/04/new-logo-fertival.jpg" ["width"]=> int(1500) ["height"]=> int(424) } ["medium"]=> object(stdClass)#2188 (3) { ["src"]=> string(81) "https://extranet.afaia.fr/wp-content/uploads/2020/04/new-logo-fertival-300x85.jpg" ["width"]=> int(300) ["height"]=> int(85) } ["thumbnail"]=> object(stdClass)#2189 (3) { ["src"]=> string(82) "https://extranet.afaia.fr/wp-content/uploads/2020/04/new-logo-fertival-150x150.jpg" ["width"]=> int(150) ["height"]=> int(150) } } }
object(stdClass)#2190 (12) { ["name"]=> string(11) "FLORENTAISE" ["website"]=> string(26) "http://www.florentaise.com" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> string(0) "" ["zoho_id"]=> string(18) "246999000000253206" ["address"]=> object(stdClass)#2191 (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(13) "Biostimulants" } ["contributeurs_statistiques"]=> string(0) "" ["tag"]=> array(0) { } ["logo"]=> object(stdClass)#2193 (3) { ["full"]=> object(stdClass)#2192 (3) { ["src"]=> string(68) "https://extranet.afaia.fr/wp-content/uploads/2020/02/florentaise.jpg" ["width"]=> int(400) ["height"]=> int(76) } ["medium"]=> object(stdClass)#2194 (3) { ["src"]=> string(75) "https://extranet.afaia.fr/wp-content/uploads/2020/02/florentaise-300x57.jpg" ["width"]=> int(300) ["height"]=> int(57) } ["thumbnail"]=> object(stdClass)#2195 (3) { ["src"]=> string(75) "https://extranet.afaia.fr/wp-content/uploads/2020/02/florentaise-150x76.jpg" ["width"]=> int(150) ["height"]=> int(76) } } }
object(stdClass)#2196 (12) { ["name"]=> string(5) "FNDCV" ["website"]=> string(12) "www.fndcv.fr" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> string(0) "" ["zoho_id"]=> string(18) "246999000000253207" ["address"]=> object(stdClass)#2197 (4) { ["street"]=> NULL ["postalcode"]=> NULL ["city"]=> NULL ["country"]=> NULL } ["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"]=> object(stdClass)#2199 (3) { ["full"]=> object(stdClass)#2198 (3) { ["src"]=> string(62) "https://extranet.afaia.fr/wp-content/uploads/2020/02/fndcv.jpg" ["width"]=> int(131) ["height"]=> int(152) } ["medium"]=> object(stdClass)#2200 (3) { ["src"]=> string(62) "https://extranet.afaia.fr/wp-content/uploads/2020/02/fndcv.jpg" ["width"]=> int(131) ["height"]=> int(152) } ["thumbnail"]=> object(stdClass)#2201 (3) { ["src"]=> string(70) "https://extranet.afaia.fr/wp-content/uploads/2020/02/fndcv-131x150.jpg" ["width"]=> int(131) ["height"]=> int(150) } } }
object(stdClass)#2202 (12) { ["name"]=> string(10) "FRAYSSINET" ["website"]=> string(36) "https://www.groupe-frayssinet.fr/fr/" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> string(0) "" ["zoho_id"]=> string(18) "246999000002519016" ["address"]=> object(stdClass)#2203 (4) { ["street"]=> NULL ["postalcode"]=> NULL ["city"]=> NULL ["country"]=> NULL } ["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)#2205 (3) { ["full"]=> object(stdClass)#2204 (3) { ["src"]=> string(72) "https://extranet.afaia.fr/wp-content/uploads/2020/12/logo-frayssinet.png" ["width"]=> int(552) ["height"]=> int(370) } ["medium"]=> object(stdClass)#2206 (3) { ["src"]=> string(80) "https://extranet.afaia.fr/wp-content/uploads/2020/12/logo-frayssinet-300x201.png" ["width"]=> int(300) ["height"]=> int(201) } ["thumbnail"]=> object(stdClass)#2207 (3) { ["src"]=> string(80) "https://extranet.afaia.fr/wp-content/uploads/2020/12/logo-frayssinet-150x150.png" ["width"]=> int(150) ["height"]=> int(150) } } }