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(12) "HELIOPOTASSE" ["website"]=> string(0) "" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> string(0) "" ["zoho_id"]=> string(18) "246999000005167034" ["address"]=> object(stdClass)#9802 (4) { ["street"]=> string(23) "25 place de la Réunion" ["postalcode"]=> string(5) "68100" ["city"]=> string(8) "Mulhouse" ["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)#9858 (3) { ["full"]=> object(stdClass)#9830 (3) { ["src"]=> string(69) "https://extranet.afaia.fr/wp-content/uploads/2021/09/heliopotasse.png" ["width"]=> int(274) ["height"]=> int(112) } ["medium"]=> object(stdClass)#9774 (3) { ["src"]=> string(69) "https://extranet.afaia.fr/wp-content/uploads/2021/09/heliopotasse.png" ["width"]=> int(274) ["height"]=> int(112) } ["thumbnail"]=> object(stdClass)#9773 (3) { ["src"]=> string(77) "https://extranet.afaia.fr/wp-content/uploads/2021/09/heliopotasse-150x112.png" ["width"]=> int(150) ["height"]=> int(112) } } }
object(stdClass)#9772 (12) { ["name"]=> string(12) "HELLO NATURE" ["website"]=> string(29) "https://www.hello-nature.com/" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> object(stdClass)#9771 (2) { ["internationalFormat"]=> string(12) "+33492967640" ["frenchFormat"]=> string(14) "04 92 96 76 40" } ["zoho_id"]=> string(18) "246999000000253225" ["address"]=> object(stdClass)#9770 (4) { ["street"]=> string(63) "Espace Beethoven - Bat 3 - 1er étage - 1208 Route des Lucioles" ["postalcode"]=> string(5) "06560" ["city"]=> string(8) "VALBONNE" ["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)#9872 (3) { ["full"]=> object(stdClass)#9769 (3) { ["src"]=> string(84) "https://extranet.afaia.fr/wp-content/uploads/2020/02/logo-hello-nature-2l-scaled.jpg" ["width"]=> int(2560) ["height"]=> int(1490) } ["medium"]=> object(stdClass)#9915 (3) { ["src"]=> string(85) "https://extranet.afaia.fr/wp-content/uploads/2020/02/logo-hello-nature-2l-300x175.jpg" ["width"]=> int(300) ["height"]=> int(175) } ["thumbnail"]=> object(stdClass)#362 (3) { ["src"]=> string(85) "https://extranet.afaia.fr/wp-content/uploads/2020/02/logo-hello-nature-2l-150x150.jpg" ["width"]=> int(150) ["height"]=> int(150) } } }
object(stdClass)#9942 (12) { ["name"]=> string(20) "HOLDEX ENVIRONNEMENT" ["website"]=> string(0) "" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> string(0) "" ["zoho_id"]=> string(18) "246999000010330049" ["address"]=> object(stdClass)#9943 (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(22) "Amendements organiques" } ["contributeurs_statistiques"]=> string(0) "" ["tag"]=> array(0) { } ["logo"]=> object(stdClass)#9945 (3) { ["full"]=> object(stdClass)#9944 (3) { ["src"]=> string(68) "https://extranet.afaia.fr/wp-content/uploads/2022/09/logo-holdex.jpg" ["width"]=> int(200) ["height"]=> int(100) } ["medium"]=> object(stdClass)#9946 (3) { ["src"]=> string(68) "https://extranet.afaia.fr/wp-content/uploads/2022/09/logo-holdex.jpg" ["width"]=> int(200) ["height"]=> int(100) } ["thumbnail"]=> object(stdClass)#9947 (3) { ["src"]=> string(76) "https://extranet.afaia.fr/wp-content/uploads/2022/09/logo-holdex-150x100.jpg" ["width"]=> int(150) ["height"]=> int(100) } } }
object(stdClass)#9948 (12) { ["name"]=> string(7) "IF TECH" ["website"]=> string(20) "http://www.iftech.fr" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> string(0) "" ["zoho_id"]=> string(18) "246999000000253215" ["address"]=> object(stdClass)#9949 (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)#9951 (3) { ["full"]=> object(stdClass)#9950 (3) { ["src"]=> string(68) "https://extranet.afaia.fr/wp-content/uploads/2020/02/logo-iftech.png" ["width"]=> int(272) ["height"]=> int(124) } ["medium"]=> object(stdClass)#9952 (3) { ["src"]=> string(68) "https://extranet.afaia.fr/wp-content/uploads/2020/02/logo-iftech.png" ["width"]=> int(272) ["height"]=> int(124) } ["thumbnail"]=> object(stdClass)#9953 (3) { ["src"]=> string(76) "https://extranet.afaia.fr/wp-content/uploads/2020/02/logo-iftech-150x124.png" ["width"]=> int(150) ["height"]=> int(124) } } }
object(stdClass)#9954 (12) { ["name"]=> string(4) "IF2O" ["website"]=> string(0) "" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> string(0) "" ["zoho_id"]=> string(18) "246999000000253216" ["address"]=> object(stdClass)#9955 (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)#9957 (3) { ["full"]=> object(stdClass)#9956 (3) { ["src"]=> string(68) "https://extranet.afaia.fr/wp-content/uploads/2020/02/if20-scaled.jpg" ["width"]=> int(1810) ["height"]=> int(2560) } ["medium"]=> object(stdClass)#9958 (3) { ["src"]=> string(69) "https://extranet.afaia.fr/wp-content/uploads/2020/02/if20-212x300.jpg" ["width"]=> int(212) ["height"]=> int(300) } ["thumbnail"]=> object(stdClass)#9959 (3) { ["src"]=> string(69) "https://extranet.afaia.fr/wp-content/uploads/2020/02/if20-150x150.jpg" ["width"]=> int(150) ["height"]=> int(150) } } }
object(stdClass)#9960 (12) { ["name"]=> string(17) "INOCULUM PLUS SAS" ["website"]=> string(22) "http://inoculumplus.eu" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> object(stdClass)#9961 (2) { ["internationalFormat"]=> string(12) "+33345831193" ["frenchFormat"]=> string(14) "03 45 83 11 93" } ["zoho_id"]=> string(18) "246999000000253217" ["address"]=> object(stdClass)#9962 (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)#9964 (3) { ["full"]=> object(stdClass)#9963 (3) { ["src"]=> string(70) "https://extranet.afaia.fr/wp-content/uploads/2020/02/inoculum-plus.jpg" ["width"]=> int(196) ["height"]=> int(169) } ["medium"]=> object(stdClass)#9965 (3) { ["src"]=> string(70) "https://extranet.afaia.fr/wp-content/uploads/2020/02/inoculum-plus.jpg" ["width"]=> int(196) ["height"]=> int(169) } ["thumbnail"]=> object(stdClass)#9966 (3) { ["src"]=> string(78) "https://extranet.afaia.fr/wp-content/uploads/2020/02/inoculum-plus-150x150.jpg" ["width"]=> int(150) ["height"]=> int(150) } } }
object(stdClass)#9967 (12) { ["name"]=> string(13) "JS Consulting" ["website"]=> string(22) "https://js-consult.fr/" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> object(stdClass)#9968 (2) { ["internationalFormat"]=> string(12) "+33782560714" ["frenchFormat"]=> string(14) "07 82 56 07 14" } ["zoho_id"]=> string(18) "246999000012780050" ["address"]=> object(stdClass)#9969 (4) { ["street"]=> string(24) "17 c Avenue Jean Jaurès" ["postalcode"]=> string(5) "31290" ["city"]=> string(25) "VILLEFRANCHE DE LAURAGAIS" ["country"]=> string(6) "FRANCE" } ["adherents"]=> array(2) { [0]=> string(9) "Adhérent" [1]=> string(15) "Membre Associé" } ["produits_fabriques"]=> array(0) { } ["contributeurs_statistiques"]=> string(0) "" ["tag"]=> array(0) { } ["logo"]=> object(stdClass)#9971 (3) { ["full"]=> object(stdClass)#9970 (3) { ["src"]=> string(91) "https://extranet.afaia.fr/wp-content/uploads/2023/04/logo-js-consulting-rd-bioscience-1.png" ["width"]=> int(6969) ["height"]=> int(1953) } ["medium"]=> object(stdClass)#9972 (3) { ["src"]=> string(98) "https://extranet.afaia.fr/wp-content/uploads/2023/04/logo-js-consulting-rd-bioscience-1-300x84.png" ["width"]=> int(300) ["height"]=> int(84) } ["thumbnail"]=> object(stdClass)#9973 (3) { ["src"]=> string(99) "https://extranet.afaia.fr/wp-content/uploads/2023/04/logo-js-consulting-rd-bioscience-1-150x150.png" ["width"]=> int(150) ["height"]=> int(150) } } }
object(stdClass)#9974 (12) { ["name"]=> string(29) "KLASMANN-DEILMANN FRANCE SARL" ["website"]=> string(28) "http://klasmann-deilmann.com" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> string(0) "" ["zoho_id"]=> string(18) "246999000000253226" ["address"]=> object(stdClass)#9975 (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)#9977 (3) { ["full"]=> object(stdClass)#9976 (3) { ["src"]=> string(86) "https://extranet.afaia.fr/wp-content/uploads/2020/02/logo-klasmann-deilmann-france.jpg" ["width"]=> int(871) ["height"]=> int(246) } ["medium"]=> object(stdClass)#9978 (3) { ["src"]=> string(93) "https://extranet.afaia.fr/wp-content/uploads/2020/02/logo-klasmann-deilmann-france-300x85.jpg" ["width"]=> int(300) ["height"]=> int(85) } ["thumbnail"]=> object(stdClass)#9979 (3) { ["src"]=> string(94) "https://extranet.afaia.fr/wp-content/uploads/2020/02/logo-klasmann-deilmann-france-150x150.jpg" ["width"]=> int(150) ["height"]=> int(150) } } }
object(stdClass)#9980 (12) { ["name"]=> string(14) "KOPPERT FRANCE" ["website"]=> string(22) "https://www.koppert.fr" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> string(0) "" ["zoho_id"]=> string(18) "246999000000253227" ["address"]=> object(stdClass)#9981 (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)#9983 (3) { ["full"]=> object(stdClass)#9982 (3) { ["src"]=> string(64) "https://extranet.afaia.fr/wp-content/uploads/2020/02/koppert.png" ["width"]=> int(400) ["height"]=> int(130) } ["medium"]=> object(stdClass)#9984 (3) { ["src"]=> string(71) "https://extranet.afaia.fr/wp-content/uploads/2020/02/koppert-300x98.png" ["width"]=> int(300) ["height"]=> int(98) } ["thumbnail"]=> object(stdClass)#9985 (3) { ["src"]=> string(72) "https://extranet.afaia.fr/wp-content/uploads/2020/02/koppert-150x130.png" ["width"]=> int(150) ["height"]=> int(130) } } }
object(stdClass)#9986 (12) { ["name"]=> string(8) "MEDINBIO" ["website"]=> string(23) "http://www.medinbio.com" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> string(0) "" ["zoho_id"]=> string(18) "246999000000253235" ["address"]=> object(stdClass)#9987 (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)#9989 (3) { ["full"]=> object(stdClass)#9988 (3) { ["src"]=> string(65) "https://extranet.afaia.fr/wp-content/uploads/2020/02/medinbio.png" ["width"]=> int(250) ["height"]=> int(92) } ["medium"]=> object(stdClass)#9990 (3) { ["src"]=> string(65) "https://extranet.afaia.fr/wp-content/uploads/2020/02/medinbio.png" ["width"]=> int(250) ["height"]=> int(92) } ["thumbnail"]=> object(stdClass)#9991 (3) { ["src"]=> string(72) "https://extranet.afaia.fr/wp-content/uploads/2020/02/medinbio-150x92.png" ["width"]=> int(150) ["height"]=> int(92) } } }
object(stdClass)#9992 (12) { ["name"]=> string(5) "MYCEA" ["website"]=> string(17) "https://mycea.fr/" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> object(stdClass)#9993 (2) { ["internationalFormat"]=> string(12) "+33467794784" ["frenchFormat"]=> string(14) "04 67 79 47 84" } ["zoho_id"]=> string(18) "246999000003887001" ["address"]=> object(stdClass)#9994 (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)#9996 (3) { ["full"]=> object(stdClass)#9995 (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)#9997 (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)#9998 (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)#9999 (12) { ["name"]=> string(10) "MYCELIANCE" ["website"]=> string(22) "https://myceliance.com" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> object(stdClass)#10000 (2) { ["internationalFormat"]=> string(12) "+33658573436" ["frenchFormat"]=> string(14) "06 58 57 34 36" } ["zoho_id"]=> string(18) "246999000011445232" ["address"]=> object(stdClass)#10001 (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)#10003 (3) { ["full"]=> object(stdClass)#10002 (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)#10004 (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)#10005 (3) { ["src"]=> string(80) "https://extranet.afaia.fr/wp-content/uploads/2022/12/logo-myceliance-150x150.png" ["width"]=> int(150) ["height"]=> int(150) } } }