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)#9886 (12) { ["name"]=> string(6) "SYPREA" ["website"]=> string(17) "http://syprea.org" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> string(0) "" ["zoho_id"]=> string(18) "246999000000253285" ["address"]=> object(stdClass)#9802 (4) { ["street"]=> NULL ["postalcode"]=> NULL ["city"]=> NULL ["country"]=> NULL } ["adherents"]=> array(1) { [0]=> string(9) "Adhérent" } ["produits_fabriques"]=> array(1) { [0]=> string(24) "Membre associé d'Afaïa" } ["contributeurs_statistiques"]=> string(0) "" ["tag"]=> array(0) { } ["logo"]=> object(stdClass)#9858 (3) { ["full"]=> object(stdClass)#9830 (3) { ["src"]=> string(66) "https://extranet.afaia.fr/wp-content/uploads/2020/02/syprea537.png" ["width"]=> int(537) ["height"]=> int(178) } ["medium"]=> object(stdClass)#9774 (3) { ["src"]=> string(73) "https://extranet.afaia.fr/wp-content/uploads/2020/02/syprea537-300x99.png" ["width"]=> int(300) ["height"]=> int(99) } ["thumbnail"]=> object(stdClass)#9773 (3) { ["src"]=> string(74) "https://extranet.afaia.fr/wp-content/uploads/2020/02/syprea537-150x150.png" ["width"]=> int(150) ["height"]=> int(150) } } }
object(stdClass)#9772 (12) { ["name"]=> string(20) "TERRIAL Groupe AVRIL" ["website"]=> string(22) "https://www.terrial.fr" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> string(0) "" ["zoho_id"]=> string(18) "246999000000253286" ["address"]=> object(stdClass)#9771 (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)#9769 (3) { ["full"]=> object(stdClass)#9770 (3) { ["src"]=> string(68) "https://extranet.afaia.fr/wp-content/uploads/2020/02/terrial-273.jpg" ["width"]=> int(273) ["height"]=> int(184) } ["medium"]=> object(stdClass)#9872 (3) { ["src"]=> string(68) "https://extranet.afaia.fr/wp-content/uploads/2020/02/terrial-273.jpg" ["width"]=> int(273) ["height"]=> int(184) } ["thumbnail"]=> object(stdClass)#9915 (3) { ["src"]=> string(76) "https://extranet.afaia.fr/wp-content/uploads/2020/02/terrial-273-150x150.jpg" ["width"]=> int(150) ["height"]=> int(150) } } }
object(stdClass)#362 (12) { ["name"]=> string(6) "TERSEN" ["website"]=> string(23) "https://www.tersen.net/" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> object(stdClass)#9942 (2) { ["internationalFormat"]=> string(12) "+33603151311" ["frenchFormat"]=> string(14) "06 03 15 13 11" } ["zoho_id"]=> string(18) "246999000006422009" ["address"]=> object(stdClass)#9943 (4) { ["street"]=> string(14) "La Ridaudière" ["postalcode"]=> string(5) "49370" ["city"]=> string(18) "Bécon les Granits" ["country"]=> NULL } ["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)#9945 (3) { ["full"]=> object(stdClass)#9944 (3) { ["src"]=> string(63) "https://extranet.afaia.fr/wp-content/uploads/2022/01/tersen.jpg" ["width"]=> int(800) ["height"]=> int(200) } ["medium"]=> object(stdClass)#9946 (3) { ["src"]=> string(70) "https://extranet.afaia.fr/wp-content/uploads/2022/01/tersen-300x75.jpg" ["width"]=> int(300) ["height"]=> int(75) } ["thumbnail"]=> object(stdClass)#9947 (3) { ["src"]=> string(71) "https://extranet.afaia.fr/wp-content/uploads/2022/01/tersen-150x150.jpg" ["width"]=> int(150) ["height"]=> int(150) } } }
object(stdClass)#9948 (12) { ["name"]=> string(17) "TIMAC AGRO France" ["website"]=> string(25) "https://fr.timacagro.com/" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> object(stdClass)#9949 (2) { ["internationalFormat"]=> string(12) "+33299206520" ["frenchFormat"]=> string(14) "02 99 20 65 20" } ["zoho_id"]=> string(18) "246999000006165003" ["address"]=> object(stdClass)#9950 (4) { ["street"]=> string(25) "27 Av. Franklin Roosevelt" ["postalcode"]=> string(5) "35400" ["city"]=> string(10) "Saint-Malo" ["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)#9952 (3) { ["full"]=> object(stdClass)#9951 (3) { ["src"]=> string(67) "https://extranet.afaia.fr/wp-content/uploads/2021/12/timac-agro.jpg" ["width"]=> int(322) ["height"]=> int(95) } ["medium"]=> object(stdClass)#9953 (3) { ["src"]=> string(74) "https://extranet.afaia.fr/wp-content/uploads/2021/12/timac-agro-300x89.jpg" ["width"]=> int(300) ["height"]=> int(89) } ["thumbnail"]=> object(stdClass)#9954 (3) { ["src"]=> string(74) "https://extranet.afaia.fr/wp-content/uploads/2021/12/timac-agro-150x95.jpg" ["width"]=> int(150) ["height"]=> int(95) } } }
object(stdClass)#9955 (12) { ["name"]=> string(5) "TONYX" ["website"]=> string(12) "www.tonyx.fr" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> string(0) "" ["zoho_id"]=> string(18) "246999000005167147" ["address"]=> object(stdClass)#9956 (4) { ["street"]=> string(19) "58 rue de Fressines" ["postalcode"]=> string(5) "79370" ["city"]=> string(11) "Aigondigné" ["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)#9958 (3) { ["full"]=> object(stdClass)#9957 (3) { ["src"]=> string(62) "https://extranet.afaia.fr/wp-content/uploads/2021/09/tonyx.jpg" ["width"]=> int(1280) ["height"]=> int(878) } ["medium"]=> object(stdClass)#9959 (3) { ["src"]=> string(70) "https://extranet.afaia.fr/wp-content/uploads/2021/09/tonyx-300x206.jpg" ["width"]=> int(300) ["height"]=> int(206) } ["thumbnail"]=> object(stdClass)#9960 (3) { ["src"]=> string(70) "https://extranet.afaia.fr/wp-content/uploads/2021/09/tonyx-150x150.jpg" ["width"]=> int(150) ["height"]=> int(150) } } }
object(stdClass)#9961 (12) { ["name"]=> string(14) "TOOPI ORGANICS" ["website"]=> string(27) "https://toopi-organics.com/" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> object(stdClass)#9962 (2) { ["internationalFormat"]=> string(12) "+33630498837" ["frenchFormat"]=> string(14) "06 30 49 88 37" } ["zoho_id"]=> string(18) "246999000004560041" ["address"]=> object(stdClass)#9963 (4) { ["street"]=> string(30) "ZA Ecopole lieu dit aux Halies" ["postalcode"]=> string(5) "33190" ["city"]=> string(19) "Loupiac de la Reole" ["country"]=> NULL } ["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)#9965 (3) { ["full"]=> object(stdClass)#9964 (3) { ["src"]=> string(76) "https://extranet.afaia.fr/wp-content/uploads/2021/07/logo-toopi-organics.png" ["width"]=> int(600) ["height"]=> int(239) } ["medium"]=> object(stdClass)#9966 (3) { ["src"]=> string(84) "https://extranet.afaia.fr/wp-content/uploads/2021/07/logo-toopi-organics-300x120.png" ["width"]=> int(300) ["height"]=> int(120) } ["thumbnail"]=> object(stdClass)#9967 (3) { ["src"]=> string(84) "https://extranet.afaia.fr/wp-content/uploads/2021/07/logo-toopi-organics-150x150.png" ["width"]=> int(150) ["height"]=> int(150) } } }
object(stdClass)#9968 (12) { ["name"]=> string(16) "TRADECORP FRANCE" ["website"]=> string(19) "http://tradecorp.fr" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> string(0) "" ["zoho_id"]=> string(18) "246999000000253287" ["address"]=> object(stdClass)#9969 (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)#9971 (3) { ["full"]=> object(stdClass)#9970 (3) { ["src"]=> string(66) "https://extranet.afaia.fr/wp-content/uploads/2020/02/tradecorp.jpg" ["width"]=> int(472) ["height"]=> int(327) } ["medium"]=> object(stdClass)#9972 (3) { ["src"]=> string(74) "https://extranet.afaia.fr/wp-content/uploads/2020/02/tradecorp-300x208.jpg" ["width"]=> int(300) ["height"]=> int(208) } ["thumbnail"]=> object(stdClass)#9973 (3) { ["src"]=> string(74) "https://extranet.afaia.fr/wp-content/uploads/2020/02/tradecorp-150x150.jpg" ["width"]=> int(150) ["height"]=> int(150) } } }
object(stdClass)#9974 (12) { ["name"]=> string(18) "TRUFFAUT SELECTION" ["website"]=> string(24) "https://www.truffaut.com" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> object(stdClass)#9975 (2) { ["internationalFormat"]=> string(12) "+33169915370" ["frenchFormat"]=> string(14) "01 69 91 53 70" } ["zoho_id"]=> string(18) "246999000000253295" ["address"]=> object(stdClass)#9976 (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)#9978 (3) { ["full"]=> object(stdClass)#9977 (3) { ["src"]=> string(70) "https://extranet.afaia.fr/wp-content/uploads/2020/02/logo-truffaut.png" ["width"]=> int(134) ["height"]=> int(57) } ["medium"]=> object(stdClass)#9979 (3) { ["src"]=> string(70) "https://extranet.afaia.fr/wp-content/uploads/2020/02/logo-truffaut.png" ["width"]=> int(134) ["height"]=> int(57) } ["thumbnail"]=> object(stdClass)#9980 (3) { ["src"]=> string(70) "https://extranet.afaia.fr/wp-content/uploads/2020/02/logo-truffaut.png" ["width"]=> int(134) ["height"]=> int(57) } } }
object(stdClass)#9981 (12) { ["name"]=> string(26) "TURFTECH INTERNATIONAL Ltd" ["website"]=> string(23) "https://www.turftech.fr" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> string(0) "" ["zoho_id"]=> string(18) "246999000000253296" ["address"]=> object(stdClass)#9982 (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)#9984 (3) { ["full"]=> object(stdClass)#9983 (3) { ["src"]=> string(70) "https://extranet.afaia.fr/wp-content/uploads/2020/02/logo-turftech.jpg" ["width"]=> int(249) ["height"]=> int(143) } ["medium"]=> object(stdClass)#9985 (3) { ["src"]=> string(70) "https://extranet.afaia.fr/wp-content/uploads/2020/02/logo-turftech.jpg" ["width"]=> int(249) ["height"]=> int(143) } ["thumbnail"]=> object(stdClass)#9986 (3) { ["src"]=> string(78) "https://extranet.afaia.fr/wp-content/uploads/2020/02/logo-turftech-150x143.jpg" ["width"]=> int(150) ["height"]=> int(143) } } }
object(stdClass)#9987 (12) { ["name"]=> string(8) "UMR LSTM" ["website"]=> string(26) "https://umr-lstm.cirad.fr/" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> object(stdClass)#9988 (2) { ["internationalFormat"]=> string(12) "+33467593801" ["frenchFormat"]=> string(14) "04 67 59 38 01" } ["zoho_id"]=> string(18) "246999000007913126" ["address"]=> object(stdClass)#9989 (4) { ["street"]=> string(82) "UMR LSTM Institut Agro Montpellier - Campus international de Baillarguet TA A-82/J" ["postalcode"]=> string(5) "34398" ["city"]=> string(19) "MONTPELLIER Cedex 5" ["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)#9991 (3) { ["full"]=> object(stdClass)#9990 (3) { ["src"]=> string(69) "https://extranet.afaia.fr/wp-content/uploads/2022/04/logo-lstm361.png" ["width"]=> int(312) ["height"]=> int(161) } ["medium"]=> object(stdClass)#9992 (3) { ["src"]=> string(77) "https://extranet.afaia.fr/wp-content/uploads/2022/04/logo-lstm361-300x155.png" ["width"]=> int(300) ["height"]=> int(155) } ["thumbnail"]=> object(stdClass)#9993 (3) { ["src"]=> string(77) "https://extranet.afaia.fr/wp-content/uploads/2022/04/logo-lstm361-150x150.png" ["width"]=> int(150) ["height"]=> int(150) } } }
object(stdClass)#9994 (12) { ["name"]=> string(4) "UNDV" ["website"]=> string(18) "http://www.undv.fr" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> string(0) "" ["zoho_id"]=> string(18) "246999000000253297" ["address"]=> object(stdClass)#9995 (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)#9997 (3) { ["full"]=> object(stdClass)#9996 (3) { ["src"]=> string(82) "https://extranet.afaia.fr/wp-content/uploads/2020/02/undv-logo-2013-vecto-cmjn.jpg" ["width"]=> int(872) ["height"]=> int(969) } ["medium"]=> object(stdClass)#9998 (3) { ["src"]=> string(90) "https://extranet.afaia.fr/wp-content/uploads/2020/02/undv-logo-2013-vecto-cmjn-270x300.jpg" ["width"]=> int(270) ["height"]=> int(300) } ["thumbnail"]=> object(stdClass)#9999 (3) { ["src"]=> string(90) "https://extranet.afaia.fr/wp-content/uploads/2020/02/undv-logo-2013-vecto-cmjn-150x150.jpg" ["width"]=> int(150) ["height"]=> int(150) } } }
object(stdClass)#10000 (12) { ["name"]=> string(7) "VALAVIE" ["website"]=> string(22) "http://www.aviferme.re" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> string(0) "" ["zoho_id"]=> string(18) "246999000000253298" ["address"]=> object(stdClass)#10001 (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)#10003 (3) { ["full"]=> object(stdClass)#10002 (3) { ["src"]=> string(67) "https://extranet.afaia.fr/wp-content/uploads/2020/02/valavie150.png" ["width"]=> int(150) ["height"]=> int(71) } ["medium"]=> object(stdClass)#10004 (3) { ["src"]=> string(67) "https://extranet.afaia.fr/wp-content/uploads/2020/02/valavie150.png" ["width"]=> int(150) ["height"]=> int(71) } ["thumbnail"]=> object(stdClass)#10005 (3) { ["src"]=> string(67) "https://extranet.afaia.fr/wp-content/uploads/2020/02/valavie150.png" ["width"]=> int(150) ["height"]=> int(71) } } }