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(16) "SBM LIFE SCIENCE" ["website"]=> string(22) "http://sbm-company.com" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> string(0) "" ["zoho_id"]=> string(18) "246999000000253258" ["address"]=> object(stdClass)#9802 (4) { ["street"]=> string(22) "60 chemin des Mouilles" ["postalcode"]=> string(5) "69130" ["city"]=> string(6) "ECULLY" ["country"]=> string(6) "FRANCE" } ["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)#9858 (3) { ["full"]=> object(stdClass)#9830 (3) { ["src"]=> string(65) "https://extranet.afaia.fr/wp-content/uploads/2022/08/logo sbm.jpg" ["width"]=> int(204) ["height"]=> int(62) } ["medium"]=> object(stdClass)#9774 (3) { ["src"]=> string(65) "https://extranet.afaia.fr/wp-content/uploads/2022/08/logo sbm.jpg" ["width"]=> int(204) ["height"]=> int(62) } ["thumbnail"]=> object(stdClass)#9773 (3) { ["src"]=> string(72) "https://extranet.afaia.fr/wp-content/uploads/2022/08/logo sbm-150x62.jpg" ["width"]=> int(150) ["height"]=> int(62) } } }
object(stdClass)#9772 (12) { ["name"]=> string(18) "SEDE ENVIRONNEMENT" ["website"]=> string(27) "https://www.sede.veolia.com" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> string(0) "" ["zoho_id"]=> string(18) "246999000000253265" ["address"]=> object(stdClass)#9771 (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)#9769 (3) { ["full"]=> object(stdClass)#9770 (3) { ["src"]=> string(73) "https://extranet.afaia.fr/wp-content/uploads/2020/02/logo-sede-veolia.jpg" ["width"]=> int(400) ["height"]=> int(250) } ["medium"]=> object(stdClass)#9872 (3) { ["src"]=> string(81) "https://extranet.afaia.fr/wp-content/uploads/2020/02/logo-sede-veolia-300x188.jpg" ["width"]=> int(300) ["height"]=> int(188) } ["thumbnail"]=> object(stdClass)#9915 (3) { ["src"]=> string(81) "https://extranet.afaia.fr/wp-content/uploads/2020/02/logo-sede-veolia-150x150.jpg" ["width"]=> int(150) ["height"]=> int(150) } } }
object(stdClass)#362 (12) { ["name"]=> string(8) "SOFRAPAR" ["website"]=> string(32) "https://www.ecobios-sofrapar.com" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> string(0) "" ["zoho_id"]=> string(18) "246999000000253267" ["address"]=> object(stdClass)#9942 (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)#9944 (3) { ["full"]=> object(stdClass)#9943 (3) { ["src"]=> string(73) "https://extranet.afaia.fr/wp-content/uploads/2020/02/logo-sofrapar220.gif" ["width"]=> int(220) ["height"]=> int(143) } ["medium"]=> object(stdClass)#9945 (3) { ["src"]=> string(73) "https://extranet.afaia.fr/wp-content/uploads/2020/02/logo-sofrapar220.gif" ["width"]=> int(220) ["height"]=> int(143) } ["thumbnail"]=> object(stdClass)#9946 (3) { ["src"]=> string(81) "https://extranet.afaia.fr/wp-content/uploads/2020/02/logo-sofrapar220-150x143.gif" ["width"]=> int(150) ["height"]=> int(143) } } }
object(stdClass)#9947 (12) { ["name"]=> string(8) "SOILTECH" ["website"]=> string(23) "https://soiltech.nl/fr/" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> string(0) "" ["zoho_id"]=> string(18) "246999000005167103" ["address"]=> object(stdClass)#9948 (4) { ["street"]=> string(23) "Biezenmortelsestraat 57" ["postalcode"]=> string(4) "5074" ["city"]=> string(15) "RJ Biezenmortel" ["country"]=> string(11) "Netherlands" } ["adherents"]=> array(1) { [0]=> string(9) "Adhérent" } ["produits_fabriques"]=> array(2) { [0]=> string(24) "Engrais organo-minéraux" [1]=> string(13) "Biostimulants" } ["contributeurs_statistiques"]=> string(0) "" ["tag"]=> array(0) { } ["logo"]=> object(stdClass)#9950 (3) { ["full"]=> object(stdClass)#9949 (3) { ["src"]=> string(75) "https://extranet.afaia.fr/wp-content/uploads/2021/09/soiltech-solutions.png" ["width"]=> int(311) ["height"]=> int(126) } ["medium"]=> object(stdClass)#9951 (3) { ["src"]=> string(83) "https://extranet.afaia.fr/wp-content/uploads/2021/09/soiltech-solutions-300x122.png" ["width"]=> int(300) ["height"]=> int(122) } ["thumbnail"]=> object(stdClass)#9952 (3) { ["src"]=> string(83) "https://extranet.afaia.fr/wp-content/uploads/2021/09/soiltech-solutions-150x126.png" ["width"]=> int(150) ["height"]=> int(126) } } }
object(stdClass)#9953 (12) { ["name"]=> string(10) "SOPROPECHE" ["website"]=> string(26) "https://www.sopropeche.com" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> object(stdClass)#9954 (2) { ["internationalFormat"]=> string(12) "+33321322727" ["frenchFormat"]=> string(14) "03 21 32 27 27" } ["zoho_id"]=> string(18) "246999000000253268" ["address"]=> object(stdClass)#9955 (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)#9957 (3) { ["full"]=> object(stdClass)#9956 (3) { ["src"]=> string(72) "https://extranet.afaia.fr/wp-content/uploads/2020/02/logo-sopropeche.jpg" ["width"]=> int(419) ["height"]=> int(65) } ["medium"]=> object(stdClass)#9958 (3) { ["src"]=> string(79) "https://extranet.afaia.fr/wp-content/uploads/2020/02/logo-sopropeche-300x47.jpg" ["width"]=> int(300) ["height"]=> int(47) } ["thumbnail"]=> object(stdClass)#9959 (3) { ["src"]=> string(79) "https://extranet.afaia.fr/wp-content/uploads/2020/02/logo-sopropeche-150x65.jpg" ["width"]=> int(150) ["height"]=> int(65) } } }
object(stdClass)#9960 (12) { ["name"]=> string(20) "SOUFFLET AGRICULTURE" ["website"]=> string(16) "www.soufflet.com" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> string(0) "" ["zoho_id"]=> string(18) "246999000000253275" ["address"]=> object(stdClass)#9961 (4) { ["street"]=> string(19) "Quai Sarrail - BP12" ["postalcode"]=> string(5) "10402" ["city"]=> string(16) "NOGENT SUR SEINE" ["country"]=> string(6) "France" } ["adherents"]=> array(2) { [0]=> string(9) "Adhérent" [1]=> string(15) "Membre Associé" } ["produits_fabriques"]=> array(5) { [0]=> string(22) "Amendements organiques" [1]=> string(18) "Engrais organiques" [2]=> string(24) "Engrais organo-minéraux" [3]=> string(13) "Biostimulants" [4]=> string(24) "Membre associé d'Afaïa" } ["contributeurs_statistiques"]=> string(0) "" ["tag"]=> array(0) { } ["logo"]=> object(stdClass)#9963 (3) { ["full"]=> object(stdClass)#9962 (3) { ["src"]=> string(83) "https://extranet.afaia.fr/wp-content/uploads/2020/02/logo-soufflet-agriculture.jpeg" ["width"]=> int(267) ["height"]=> int(189) } ["medium"]=> object(stdClass)#9964 (3) { ["src"]=> string(83) "https://extranet.afaia.fr/wp-content/uploads/2020/02/logo-soufflet-agriculture.jpeg" ["width"]=> int(267) ["height"]=> int(189) } ["thumbnail"]=> object(stdClass)#9965 (3) { ["src"]=> string(91) "https://extranet.afaia.fr/wp-content/uploads/2020/02/logo-soufflet-agriculture-150x150.jpeg" ["width"]=> int(150) ["height"]=> int(150) } } }
object(stdClass)#9966 (12) { ["name"]=> string(18) "STI BIOTECHNOLOGIE" ["website"]=> string(0) "" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> string(0) "" ["zoho_id"]=> string(18) "246999000005308057" ["address"]=> object(stdClass)#9967 (4) { ["street"]=> string(13) "ZA du Coglais" ["postalcode"]=> string(5) "35460" ["city"]=> string(9) "MAEN ROCH" ["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)#9969 (3) { ["full"]=> object(stdClass)#9968 (3) { ["src"]=> string(83) "https://extranet.afaia.fr/wp-content/uploads/2021/09/sti-logo-couleurs250x111-1.png" ["width"]=> int(250) ["height"]=> int(111) } ["medium"]=> object(stdClass)#9970 (3) { ["src"]=> string(83) "https://extranet.afaia.fr/wp-content/uploads/2021/09/sti-logo-couleurs250x111-1.png" ["width"]=> int(250) ["height"]=> int(111) } ["thumbnail"]=> object(stdClass)#9971 (3) { ["src"]=> string(91) "https://extranet.afaia.fr/wp-content/uploads/2021/09/sti-logo-couleurs250x111-1-150x111.png" ["width"]=> int(150) ["height"]=> int(111) } } }
object(stdClass)#9972 (12) { ["name"]=> string(14) "SUEZ ORGANIQUE" ["website"]=> string(19) "https://www.suez.fr" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> string(0) "" ["zoho_id"]=> string(18) "246999000000253277" ["address"]=> object(stdClass)#9973 (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)#9975 (3) { ["full"]=> object(stdClass)#9974 (3) { ["src"]=> string(66) "https://extranet.afaia.fr/wp-content/uploads/2020/02/logo-suez.png" ["width"]=> int(334) ["height"]=> int(85) } ["medium"]=> object(stdClass)#9976 (3) { ["src"]=> string(73) "https://extranet.afaia.fr/wp-content/uploads/2020/02/logo-suez-300x76.png" ["width"]=> int(300) ["height"]=> int(76) } ["thumbnail"]=> object(stdClass)#9977 (3) { ["src"]=> string(73) "https://extranet.afaia.fr/wp-content/uploads/2020/02/logo-suez-150x85.png" ["width"]=> int(150) ["height"]=> int(85) } } }
object(stdClass)#9978 (12) { ["name"]=> string(14) "SYLVA FERTILIS" ["website"]=> string(29) "https://www.terrafertilis.com" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> string(0) "" ["zoho_id"]=> string(18) "246999000000253278" ["address"]=> object(stdClass)#9979 (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)#9981 (3) { ["full"]=> object(stdClass)#9980 (3) { ["src"]=> string(71) "https://extranet.afaia.fr/wp-content/uploads/2020/02/sylva-fertilis.png" ["width"]=> int(300) ["height"]=> int(120) } ["medium"]=> object(stdClass)#9982 (3) { ["src"]=> string(71) "https://extranet.afaia.fr/wp-content/uploads/2020/02/sylva-fertilis.png" ["width"]=> int(300) ["height"]=> int(120) } ["thumbnail"]=> object(stdClass)#9983 (3) { ["src"]=> string(79) "https://extranet.afaia.fr/wp-content/uploads/2020/02/sylva-fertilis-150x120.png" ["width"]=> int(150) ["height"]=> int(120) } } }
object(stdClass)#9984 (12) { ["name"]=> string(7) "SYMBORG" ["website"]=> string(23) "https://symborg.com/fr/" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> object(stdClass)#9985 (2) { ["internationalFormat"]=> string(15) "+33+34968899250" ["frenchFormat"]=> string(13) "0+34968899250" } ["zoho_id"]=> string(18) "246999000003338003" ["address"]=> object(stdClass)#9986 (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)#9988 (3) { ["full"]=> object(stdClass)#9987 (3) { ["src"]=> string(76) "https://extranet.afaia.fr/wp-content/uploads/2022/03/Logo Symborg-scaled.jpg" ["width"]=> int(2560) ["height"]=> int(565) } ["medium"]=> object(stdClass)#9989 (3) { ["src"]=> string(76) "https://extranet.afaia.fr/wp-content/uploads/2022/03/Logo Symborg-300x66.jpg" ["width"]=> int(300) ["height"]=> int(66) } ["thumbnail"]=> object(stdClass)#9990 (3) { ["src"]=> string(77) "https://extranet.afaia.fr/wp-content/uploads/2022/03/Logo Symborg-150x150.jpg" ["width"]=> int(150) ["height"]=> int(150) } } }
object(stdClass)#9991 (12) { ["name"]=> string(8) "SYNOVIVO" ["website"]=> string(24) "https://www.synovivo.com" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> string(0) "" ["zoho_id"]=> string(18) "246999000001487005" ["address"]=> object(stdClass)#9992 (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)#9994 (3) { ["full"]=> object(stdClass)#9993 (3) { ["src"]=> string(75) "https://extranet.afaia.fr/wp-content/uploads/2020/08/logosynovivo300x91.png" ["width"]=> int(300) ["height"]=> int(91) } ["medium"]=> object(stdClass)#9995 (3) { ["src"]=> string(75) "https://extranet.afaia.fr/wp-content/uploads/2020/08/logosynovivo300x91.png" ["width"]=> int(300) ["height"]=> int(91) } ["thumbnail"]=> object(stdClass)#9996 (3) { ["src"]=> string(82) "https://extranet.afaia.fr/wp-content/uploads/2020/08/logosynovivo300x91-150x91.png" ["width"]=> int(150) ["height"]=> int(91) } } }
object(stdClass)#9997 (12) { ["name"]=> string(22) "SYNTECH RESEARCH GROUP" ["website"]=> string(32) "https://www.syntechresearch.com/" ["twitter"]=> string(0) "" ["image"]=> string(0) "" ["phone"]=> string(0) "" ["zoho_id"]=> string(18) "246999000001634051" ["address"]=> object(stdClass)#9998 (4) { ["street"]=> string(26) "613 route du Bois de Loyse" ["postalcode"]=> string(5) "71570" ["city"]=> string(23) "La Chapelle de Guinchay" ["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)#10000 (3) { ["full"]=> object(stdClass)#9999 (3) { ["src"]=> string(89) "https://extranet.afaia.fr/wp-content/uploads/2020/09/syntech-research-tm-group-logo-2.png" ["width"]=> int(190) ["height"]=> int(90) } ["medium"]=> object(stdClass)#10001 (3) { ["src"]=> string(89) "https://extranet.afaia.fr/wp-content/uploads/2020/09/syntech-research-tm-group-logo-2.png" ["width"]=> int(190) ["height"]=> int(90) } ["thumbnail"]=> object(stdClass)#10002 (3) { ["src"]=> string(96) "https://extranet.afaia.fr/wp-content/uploads/2020/09/syntech-research-tm-group-logo-2-150x90.png" ["width"]=> int(150) ["height"]=> int(90) } } }