string(492) "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 '{f37a71c084a20b4e8765ebd1435c96e5d02d6302b08a20a34c665920589acbc3}Biostimulants{f37a71c084a20b4e8765ebd1435c96e5d02d6302b08a20a34c665920589acbc3}'  ) );"
  • object(stdClass)#7036 (12) {
      ["name"]=>
      string(9) "AGRAUXINE"
      ["website"]=>
      string(21) "https://agrauxine.com"
      ["twitter"]=>
      string(0) ""
      ["image"]=>
      string(0) ""
      ["phone"]=>
      string(0) ""
      ["zoho_id"]=>
      string(18) "246999000000253107"
      ["address"]=>
      object(stdClass)#7027 (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"]=>
      array(0) {
      }
      ["tag"]=>
      array(0) {
      }
      ["logo"]=>
      NULL
    }
    
    AGRAUXINE Biostimulants https://agrauxine.com
  • object(stdClass)#7030 (12) {
      ["name"]=>
      string(7) "AGRIMER"
      ["website"]=>
      string(22) "http://www.agrimer.com"
      ["twitter"]=>
      string(0) ""
      ["image"]=>
      string(0) ""
      ["phone"]=>
      string(0) ""
      ["zoho_id"]=>
      string(18) "246999000000253108"
      ["address"]=>
      object(stdClass)#7058 (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"]=>
      array(0) {
      }
      ["tag"]=>
      array(0) {
      }
      ["logo"]=>
      NULL
    }
    
    AGRIMER Biostimulants http://www.agrimer.com
  • object(stdClass)#7073 (12) {
      ["name"]=>
      string(47) "AGRO INNOVATION INTERNATIONAL (Groupe Roullier)"
      ["website"]=>
      string(24) "https://www.roullier.com"
      ["twitter"]=>
      string(0) ""
      ["image"]=>
      string(0) ""
      ["phone"]=>
      string(0) ""
      ["zoho_id"]=>
      string(18) "246999000000452103"
      ["address"]=>
      object(stdClass)#7173 (4) {
        ["street"]=>
        NULL
        ["postalcode"]=>
        NULL
        ["city"]=>
        NULL
        ["country"]=>
        NULL
      }
      ["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"]=>
      array(0) {
      }
      ["tag"]=>
      array(0) {
      }
      ["logo"]=>
      NULL
    }
    
    AGRO INNOVATION INTERNATIONAL (Groupe Roullier) Amendements organiques, Engrais organiques, Engrais organo-minéraux, Biostimulants https://www.roullier.com
  • object(stdClass)#7145 (12) {
      ["name"]=>
      string(16) "AGRONUTRITION SA"
      ["website"]=>
      string(28) "http://www.agronutrition.com"
      ["twitter"]=>
      string(0) ""
      ["image"]=>
      string(0) ""
      ["phone"]=>
      string(0) ""
      ["zoho_id"]=>
      string(18) "246999000000253117"
      ["address"]=>
      object(stdClass)#7117 (4) {
        ["street"]=>
        NULL
        ["postalcode"]=>
        NULL
        ["city"]=>
        NULL
        ["country"]=>
        NULL
      }
      ["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"]=>
      array(0) {
      }
      ["tag"]=>
      array(0) {
      }
      ["logo"]=>
      NULL
    }
    
    AGRONUTRITION SA Engrais organiques, Engrais organo-minéraux, Biostimulants http://www.agronutrition.com
  • object(stdClass)#7089 (12) {
      ["name"]=>
      string(7) "ALGAÏA"
      ["website"]=>
      string(22) "https://www.algaia.com"
      ["twitter"]=>
      string(0) ""
      ["image"]=>
      string(0) ""
      ["phone"]=>
      string(0) ""
      ["zoho_id"]=>
      string(18) "246999000000253118"
      ["address"]=>
      object(stdClass)#7200 (4) {
        ["street"]=>
        string(21) "91 Rue Edouard Branly"
        ["postalcode"]=>
        string(6) "50 000"
        ["city"]=>
        string(8) "SAINT LO"
        ["country"]=>
        string(6) "FRANCE"
      }
      ["adherents"]=>
      array(1) {
        [0]=>
        string(9) "Adhérent"
      }
      ["produits_fabriques"]=>
      array(1) {
        [0]=>
        string(13) "Biostimulants"
      }
      ["contributeurs_statistiques"]=>
      array(0) {
      }
      ["tag"]=>
      array(0) {
      }
      ["logo"]=>
      NULL
    }
    
    ALGAÏA Biostimulants https://www.algaia.com
  • object(stdClass)#7025 (12) {
      ["name"]=>
      string(16) "ANDERMATT France"
      ["website"]=>
      string(24) "https://www.andermatt.fr"
      ["twitter"]=>
      string(0) ""
      ["image"]=>
      string(0) ""
      ["phone"]=>
      string(0) ""
      ["zoho_id"]=>
      string(18) "246999000000253126"
      ["address"]=>
      object(stdClass)#7065 (4) {
        ["street"]=>
        string(55) "80 Chemin de l’Aviation - Domaine du Makila – Bat B"
        ["postalcode"]=>
        string(5) "64200"
        ["city"]=>
        string(11) "BASSUSSARRY"
        ["country"]=>
        string(6) "France"
      }
      ["adherents"]=>
      array(1) {
        [0]=>
        string(9) "Adhérent"
      }
      ["produits_fabriques"]=>
      array(1) {
        [0]=>
        string(13) "Biostimulants"
      }
      ["contributeurs_statistiques"]=>
      array(0) {
      }
      ["tag"]=>
      array(0) {
      }
      ["logo"]=>
      NULL
    }
    
    ANDERMATT France Biostimulants https://www.andermatt.fr
  • object(stdClass)#7064 (12) {
      ["name"]=>
      string(8) "ANGIBAUD"
      ["website"]=>
      string(15) "www.angibaud.fr"
      ["twitter"]=>
      string(0) ""
      ["image"]=>
      string(0) ""
      ["phone"]=>
      string(0) ""
      ["zoho_id"]=>
      string(18) "246999000000253127"
      ["address"]=>
      object(stdClass)#7072 (4) {
        ["street"]=>
        NULL
        ["postalcode"]=>
        NULL
        ["city"]=>
        NULL
        ["country"]=>
        NULL
      }
      ["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"]=>
      array(0) {
      }
      ["tag"]=>
      array(0) {
      }
      ["logo"]=>
      NULL
    }
    
    ANGIBAUD Amendements organiques, Engrais organiques, Engrais organo-minéraux, Biostimulants http://www.angibaud.fr
  • object(stdClass)#7057 (12) {
      ["name"]=>
      string(18) "ATLANTICA AGRICOLA"
      ["website"]=>
      string(32) "http://www.atlanticaagricola.com"
      ["twitter"]=>
      string(14) "@AtlanticaAGRI"
      ["image"]=>
      string(0) ""
      ["phone"]=>
      string(0) ""
      ["zoho_id"]=>
      string(18) "246999000000253128"
      ["address"]=>
      object(stdClass)#7063 (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"]=>
      array(0) {
      }
      ["tag"]=>
      array(0) {
      }
      ["logo"]=>
      NULL
    }
    
    ATLANTICA AGRICOLA Biostimulants http://www.atlanticaagricola.com
  • object(stdClass)#7062 (12) {
      ["name"]=>
      string(13) "AXIOMA FRANCE"
      ["website"]=>
      string(21) "www.axioma-france.com"
      ["twitter"]=>
      string(10) "@AXIOMABIO"
      ["image"]=>
      string(0) ""
      ["phone"]=>
      string(0) ""
      ["zoho_id"]=>
      string(18) "246999000000253137"
      ["address"]=>
      object(stdClass)#7214 (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"]=>
      array(0) {
      }
      ["tag"]=>
      array(0) {
      }
      ["logo"]=>
      NULL
    }
    
    AXIOMA FRANCE Biostimulants http://www.axioma-france.com
  • object(stdClass)#7103 (12) {
      ["name"]=>
      string(5) "BIO3G"
      ["website"]=>
      string(12) "www.bio3g.fr"
      ["twitter"]=>
      string(0) ""
      ["image"]=>
      string(0) ""
      ["phone"]=>
      string(0) ""
      ["zoho_id"]=>
      string(18) "246999000000253138"
      ["address"]=>
      object(stdClass)#7131 (4) {
        ["street"]=>
        NULL
        ["postalcode"]=>
        NULL
        ["city"]=>
        NULL
        ["country"]=>
        NULL
      }
      ["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"]=>
      array(0) {
      }
      ["tag"]=>
      array(0) {
      }
      ["logo"]=>
      NULL
    }
    
    BIO3G Amendements organiques, Engrais organiques, Engrais organo-minéraux, Biostimulants http://www.bio3g.fr
  • object(stdClass)#7159 (12) {
      ["name"]=>
      string(21) "BIODEVAS LABORATOIRES"
      ["website"]=>
      string(15) "www.biodevas.fr"
      ["twitter"]=>
      string(0) ""
      ["image"]=>
      string(0) ""
      ["phone"]=>
      string(0) ""
      ["zoho_id"]=>
      string(18) "246999000000253145"
      ["address"]=>
      object(stdClass)#7187 (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"]=>
      array(0) {
      }
      ["tag"]=>
      array(0) {
      }
      ["logo"]=>
      NULL
    }
    
    BIODEVAS LABORATOIRES Biostimulants http://www.biodevas.fr
  • object(stdClass)#7066 (12) {
      ["name"]=>
      string(19) "BIOLANDES PIN DECOR"
      ["website"]=>
      string(25) "https://www.biolandes.com"
      ["twitter"]=>
      string(0) ""
      ["image"]=>
      string(0) ""
      ["phone"]=>
      object(stdClass)#7026 (2) {
        ["internationalFormat"]=>
        string(12) "+33558510000"
        ["frenchFormat"]=>
        string(14) "05 58 51 00 00"
      }
      ["zoho_id"]=>
      string(18) "246999000000253147"
      ["address"]=>
      object(stdClass)#7061 (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(13) "Biostimulants"
        [4]=>
        string(18) "Engrais organiques"
        [5]=>
        string(24) "Engrais organo-minéraux"
      }
      ["contributeurs_statistiques"]=>
      array(0) {
      }
      ["tag"]=>
      array(0) {
      }
      ["logo"]=>
      NULL
    }
    
    BIOLANDES PIN DECOR Supports de culture, Paillages, Amendements organiques, Biostimulants, Engrais organiques, Engrais organo-minéraux https://www.biolandes.com