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(10) "UPL FRANCE"
      ["website"]=>
      string(26) "https://www.upl-ltd.com/fr"
      ["twitter"]=>
      string(0) ""
      ["image"]=>
      string(0) ""
      ["phone"]=>
      object(stdClass)#9802 (2) {
        ["internationalFormat"]=>
        string(12) "+33145359200"
        ["frenchFormat"]=>
        string(14) "01 45 35 92 00"
      }
      ["zoho_id"]=>
      string(18) "246999000007789141"
      ["address"]=>
      object(stdClass)#9830 (4) {
        ["street"]=>
        string(36) "Tour Voltaire - 1, place des Degrés"
        ["postalcode"]=>
        string(5) "92800"
        ["city"]=>
        string(7) "PUTEAUX"
        ["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)#9775 (3) {
        ["full"]=>
        object(stdClass)#9858 (3) {
          ["src"]=>
          string(104) "https://extranet.afaia.fr/wp-content/uploads/2022/03/upl-primary-brand-mark-colourblack-logotype-rgb.png"
          ["width"]=>
          int(1448)
          ["height"]=>
          int(941)
        }
        ["medium"]=>
        object(stdClass)#9774 (3) {
          ["src"]=>
          string(112) "https://extranet.afaia.fr/wp-content/uploads/2022/03/upl-primary-brand-mark-colourblack-logotype-rgb-300x195.png"
          ["width"]=>
          int(300)
          ["height"]=>
          int(195)
        }
        ["thumbnail"]=>
        object(stdClass)#9773 (3) {
          ["src"]=>
          string(112) "https://extranet.afaia.fr/wp-content/uploads/2022/03/upl-primary-brand-mark-colourblack-logotype-rgb-150x150.png"
          ["width"]=>
          int(150)
          ["height"]=>
          int(150)
        }
      }
    }
    
    UPL FRANCE
    UPL FRANCE Biostimulants https://www.upl-ltd.com/fr
  • object(stdClass)#9772 (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)#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)#9872 (3) {
        ["full"]=>
        object(stdClass)#9770 (3) {
          ["src"]=>
          string(67) "https://extranet.afaia.fr/wp-content/uploads/2020/02/valavie150.png"
          ["width"]=>
          int(150)
          ["height"]=>
          int(71)
        }
        ["medium"]=>
        object(stdClass)#9915 (3) {
          ["src"]=>
          string(67) "https://extranet.afaia.fr/wp-content/uploads/2020/02/valavie150.png"
          ["width"]=>
          int(150)
          ["height"]=>
          int(71)
        }
        ["thumbnail"]=>
        object(stdClass)#9308 (3) {
          ["src"]=>
          string(67) "https://extranet.afaia.fr/wp-content/uploads/2020/02/valavie150.png"
          ["width"]=>
          int(150)
          ["height"]=>
          int(71)
        }
      }
    }
    
    VALAVIE
    VALAVIE Amendements organiques, Engrais organiques, Engrais organo-minéraux http://www.aviferme.re
  • object(stdClass)#9942 (12) {
      ["name"]=>
      string(10) "VAN ISRAEL"
      ["website"]=>
      string(23) "http://www.vanisrael.be"
      ["twitter"]=>
      string(0) ""
      ["image"]=>
      string(0) ""
      ["phone"]=>
      string(0) ""
      ["zoho_id"]=>
      string(18) "246999000000253305"
      ["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(69) "https://extranet.afaia.fr/wp-content/uploads/2020/02/vanisrae150l.png"
          ["width"]=>
          int(150)
          ["height"]=>
          int(150)
        }
        ["medium"]=>
        object(stdClass)#9946 (3) {
          ["src"]=>
          string(69) "https://extranet.afaia.fr/wp-content/uploads/2020/02/vanisrae150l.png"
          ["width"]=>
          int(150)
          ["height"]=>
          int(150)
        }
        ["thumbnail"]=>
        object(stdClass)#9947 (3) {
          ["src"]=>
          string(77) "https://extranet.afaia.fr/wp-content/uploads/2020/02/vanisrae150l-150x150.png"
          ["width"]=>
          int(150)
          ["height"]=>
          int(150)
        }
      }
    }
    
    VAN ISRAEL
    VAN ISRAEL Supports de culture, Paillages, Amendements organiques http://www.vanisrael.be
  • object(stdClass)#9948 (12) {
      ["name"]=>
      string(11) "VEGENOV BBV"
      ["website"]=>
      string(15) "www.vegenov.com"
      ["twitter"]=>
      string(0) ""
      ["image"]=>
      string(0) ""
      ["phone"]=>
      string(0) ""
      ["zoho_id"]=>
      string(18) "246999000000253306"
      ["address"]=>
      object(stdClass)#9949 (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)#9951 (3) {
        ["full"]=>
        object(stdClass)#9950 (3) {
          ["src"]=>
          string(64) "https://extranet.afaia.fr/wp-content/uploads/2020/02/vegenov.jpg"
          ["width"]=>
          int(226)
          ["height"]=>
          int(198)
        }
        ["medium"]=>
        object(stdClass)#9952 (3) {
          ["src"]=>
          string(64) "https://extranet.afaia.fr/wp-content/uploads/2020/02/vegenov.jpg"
          ["width"]=>
          int(226)
          ["height"]=>
          int(198)
        }
        ["thumbnail"]=>
        object(stdClass)#9953 (3) {
          ["src"]=>
          string(72) "https://extranet.afaia.fr/wp-content/uploads/2020/02/vegenov-150x150.jpg"
          ["width"]=>
          int(150)
          ["height"]=>
          int(150)
        }
      }
    }
    
    VEGENOV BBV
    VEGENOV BBV Membre associé d'Afaïa http://www.vegenov.com
  • object(stdClass)#9954 (12) {
      ["name"]=>
      string(16) "VEGEPOLYS VALLEY"
      ["website"]=>
      string(23) "www.vegepolys-valley.eu"
      ["twitter"]=>
      string(0) ""
      ["image"]=>
      string(0) ""
      ["phone"]=>
      string(0) ""
      ["zoho_id"]=>
      string(18) "246999000000253308"
      ["address"]=>
      object(stdClass)#9955 (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)#9957 (3) {
        ["full"]=>
        object(stdClass)#9956 (3) {
          ["src"]=>
          string(92) "https://extranet.afaia.fr/wp-content/uploads/2020/02/vegepolys-valley-logo-verticale-rvb.png"
          ["width"]=>
          int(1312)
          ["height"]=>
          int(1827)
        }
        ["medium"]=>
        object(stdClass)#9958 (3) {
          ["src"]=>
          string(100) "https://extranet.afaia.fr/wp-content/uploads/2020/02/vegepolys-valley-logo-verticale-rvb-215x300.png"
          ["width"]=>
          int(215)
          ["height"]=>
          int(300)
        }
        ["thumbnail"]=>
        object(stdClass)#9959 (3) {
          ["src"]=>
          string(100) "https://extranet.afaia.fr/wp-content/uploads/2020/02/vegepolys-valley-logo-verticale-rvb-150x150.png"
          ["width"]=>
          int(150)
          ["height"]=>
          int(150)
        }
      }
    }
    
    VEGEPOLYS VALLEY
    VEGEPOLYS VALLEY Membre associé d'Afaïa http://www.vegepolys-valley.eu
  • object(stdClass)#9960 (12) {
      ["name"]=>
      string(8) "VERAGROW"
      ["website"]=>
      string(20) "https://veragrow.fr/"
      ["twitter"]=>
      string(0) ""
      ["image"]=>
      string(0) ""
      ["phone"]=>
      object(stdClass)#9961 (2) {
        ["internationalFormat"]=>
        string(12) "+33646797477"
        ["frenchFormat"]=>
        string(14) "06 46 79 74 77"
      }
      ["zoho_id"]=>
      string(18) "246999000007791087"
      ["address"]=>
      object(stdClass)#9962 (4) {
        ["street"]=>
        string(50) "1 Voie des Vendaises - Parc d'activité du Vauvray"
        ["postalcode"]=>
        string(5) "27100"
        ["city"]=>
        string(12) "Val De Reuil"
        ["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)#9964 (3) {
        ["full"]=>
        object(stdClass)#9963 (3) {
          ["src"]=>
          string(65) "https://extranet.afaia.fr/wp-content/uploads/2022/03/veragrow.png"
          ["width"]=>
          int(108)
          ["height"]=>
          int(96)
        }
        ["medium"]=>
        object(stdClass)#9965 (3) {
          ["src"]=>
          string(65) "https://extranet.afaia.fr/wp-content/uploads/2022/03/veragrow.png"
          ["width"]=>
          int(108)
          ["height"]=>
          int(96)
        }
        ["thumbnail"]=>
        object(stdClass)#9966 (3) {
          ["src"]=>
          string(65) "https://extranet.afaia.fr/wp-content/uploads/2022/03/veragrow.png"
          ["width"]=>
          int(108)
          ["height"]=>
          int(96)
        }
      }
    }
    
    VERAGROW
    VERAGROW Amendements organiques, Biostimulants https://veragrow.fr/
  • object(stdClass)#9967 (12) {
      ["name"]=>
      string(7) "VIVAGRO"
      ["website"]=>
      string(14) "www.vivagro.eu"
      ["twitter"]=>
      string(0) ""
      ["image"]=>
      string(0) ""
      ["phone"]=>
      object(stdClass)#9968 (2) {
        ["internationalFormat"]=>
        string(12) "+33557783268"
        ["frenchFormat"]=>
        string(14) "05 57 78 32 68"
      }
      ["zoho_id"]=>
      string(18) "246999000003338040"
      ["address"]=>
      object(stdClass)#9969 (4) {
        ["street"]=>
        string(50) "Technopole Montesquieu - 5 allée Jacques Latrille"
        ["postalcode"]=>
        string(5) "33650"
        ["city"]=>
        string(9) "MARTILLAC"
        ["country"]=>
        string(6) "FRANCE"
      }
      ["adherents"]=>
      array(1) {
        [0]=>
        string(9) "Adhérent"
      }
      ["produits_fabriques"]=>
      array(3) {
        [0]=>
        string(18) "Engrais organiques"
        [1]=>
        string(24) "Engrais organo-minéraux"
        [2]=>
        string(13) "Biostimulants"
      }
      ["contributeurs_statistiques"]=>
      string(0) ""
      ["tag"]=>
      array(0) {
      }
      ["logo"]=>
      object(stdClass)#9971 (3) {
        ["full"]=>
        object(stdClass)#9970 (3) {
          ["src"]=>
          string(64) "https://extranet.afaia.fr/wp-content/uploads/2021/03/vivagro.jpg"
          ["width"]=>
          int(257)
          ["height"]=>
          int(141)
        }
        ["medium"]=>
        object(stdClass)#9972 (3) {
          ["src"]=>
          string(64) "https://extranet.afaia.fr/wp-content/uploads/2021/03/vivagro.jpg"
          ["width"]=>
          int(257)
          ["height"]=>
          int(141)
        }
        ["thumbnail"]=>
        object(stdClass)#9973 (3) {
          ["src"]=>
          string(72) "https://extranet.afaia.fr/wp-content/uploads/2021/03/vivagro-150x141.jpg"
          ["width"]=>
          int(150)
          ["height"]=>
          int(141)
        }
      }
    }
    
    VIVAGRO
    VIVAGRO Engrais organiques, Engrais organo-minéraux, Biostimulants http://www.vivagro.eu
  • object(stdClass)#9974 (12) {
      ["name"]=>
      string(8) "VIVESCIA"
      ["website"]=>
      string(16) "www.vivescia.com"
      ["twitter"]=>
      string(0) ""
      ["image"]=>
      string(0) ""
      ["phone"]=>
      string(0) ""
      ["zoho_id"]=>
      string(18) "246999000010330017"
      ["address"]=>
      object(stdClass)#9975 (4) {
        ["street"]=>
        string(27) "2 rue Clément-Ader BP 1017"
        ["postalcode"]=>
        string(5) "51685"
        ["city"]=>
        string(13) "REIMS Cedex 2"
        ["country"]=>
        NULL
      }
      ["adherents"]=>
      array(1) {
        [0]=>
        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)#9977 (3) {
        ["full"]=>
        object(stdClass)#9976 (3) {
          ["src"]=>
          string(70) "https://extranet.afaia.fr/wp-content/uploads/2022/09/logo-vivescia.jpg"
          ["width"]=>
          int(1902)
          ["height"]=>
          int(561)
        }
        ["medium"]=>
        object(stdClass)#9978 (3) {
          ["src"]=>
          string(77) "https://extranet.afaia.fr/wp-content/uploads/2022/09/logo-vivescia-300x88.jpg"
          ["width"]=>
          int(300)
          ["height"]=>
          int(88)
        }
        ["thumbnail"]=>
        object(stdClass)#9979 (3) {
          ["src"]=>
          string(78) "https://extranet.afaia.fr/wp-content/uploads/2022/09/logo-vivescia-150x150.jpg"
          ["width"]=>
          int(150)
          ["height"]=>
          int(150)
        }
      }
    }
    
    VIVESCIA
    VIVESCIA Membre associé d'Afaïa http://www.vivescia.com
  • object(stdClass)#9980 (12) {
      ["name"]=>
      string(7) "VOXGAIA"
      ["website"]=>
      string(23) "https://www.voxgaia.fr/"
      ["twitter"]=>
      string(0) ""
      ["image"]=>
      string(0) ""
      ["phone"]=>
      string(0) ""
      ["zoho_id"]=>
      string(18) "246999000001634120"
      ["address"]=>
      object(stdClass)#9981 (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)#9983 (3) {
        ["full"]=>
        object(stdClass)#9982 (3) {
          ["src"]=>
          string(65) "https://extranet.afaia.fr/wp-content/uploads/2020/09/voxgaia2.png"
          ["width"]=>
          int(220)
          ["height"]=>
          int(101)
        }
        ["medium"]=>
        object(stdClass)#9984 (3) {
          ["src"]=>
          string(65) "https://extranet.afaia.fr/wp-content/uploads/2020/09/voxgaia2.png"
          ["width"]=>
          int(220)
          ["height"]=>
          int(101)
        }
        ["thumbnail"]=>
        object(stdClass)#9985 (3) {
          ["src"]=>
          string(73) "https://extranet.afaia.fr/wp-content/uploads/2020/09/voxgaia2-150x101.png"
          ["width"]=>
          int(150)
          ["height"]=>
          int(101)
        }
      }
    }
    
    VOXGAIA
    VOXGAIA Membre associé d'Afaïa https://www.voxgaia.fr/
  • object(stdClass)#9986 (12) {
      ["name"]=>
      string(6) "YNSECT"
      ["website"]=>
      string(14) "www.ynsect.com"
      ["twitter"]=>
      string(0) ""
      ["image"]=>
      string(0) ""
      ["phone"]=>
      string(0) ""
      ["zoho_id"]=>
      string(18) "246999000000253316"
      ["address"]=>
      object(stdClass)#9987 (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(13) "Biostimulants"
      }
      ["contributeurs_statistiques"]=>
      string(0) ""
      ["tag"]=>
      array(0) {
      }
      ["logo"]=>
      object(stdClass)#9989 (3) {
        ["full"]=>
        object(stdClass)#9988 (3) {
          ["src"]=>
          string(69) "https://extranet.afaia.fr/wp-content/uploads/2020/02/logo-ynsect3.png"
          ["width"]=>
          int(200)
          ["height"]=>
          int(250)
        }
        ["medium"]=>
        object(stdClass)#9990 (3) {
          ["src"]=>
          string(69) "https://extranet.afaia.fr/wp-content/uploads/2020/02/logo-ynsect3.png"
          ["width"]=>
          int(200)
          ["height"]=>
          int(250)
        }
        ["thumbnail"]=>
        object(stdClass)#9991 (3) {
          ["src"]=>
          string(77) "https://extranet.afaia.fr/wp-content/uploads/2020/02/logo-ynsect3-150x150.png"
          ["width"]=>
          int(150)
          ["height"]=>
          int(150)
        }
      }
    }
    
    YNSECT
    YNSECT Amendements organiques, Engrais organiques, Biostimulants http://www.ynsect.com