string(666) "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 '{1f3b11840593627e9d193a865cc0eb0fcf9ad6cbec1b01f0b042d5206319de4d}Supports de culture{1f3b11840593627e9d193a865cc0eb0fcf9ad6cbec1b01f0b042d5206319de4d}'  OR pmr.meta_value LIKE '{1f3b11840593627e9d193a865cc0eb0fcf9ad6cbec1b01f0b042d5206319de4d}Paillages{1f3b11840593627e9d193a865cc0eb0fcf9ad6cbec1b01f0b042d5206319de4d}'  ) );"
  • object(stdClass)#7040 (12) {
      ["name"]=>
      string(14) "4 VAULX JARDIN"
      ["website"]=>
      string(28) "http://www.4vaulx-jardin.com"
      ["twitter"]=>
      string(0) ""
      ["image"]=>
      string(0) ""
      ["phone"]=>
      string(0) ""
      ["zoho_id"]=>
      string(18) "246999000000253095"
      ["address"]=>
      object(stdClass)#7031 (4) {
        ["street"]=>
        NULL
        ["postalcode"]=>
        NULL
        ["city"]=>
        NULL
        ["country"]=>
        NULL
      }
      ["adherents"]=>
      array(1) {
        [0]=>
        string(9) "Adhérent"
      }
      ["produits_fabriques"]=>
      array(4) {
        [0]=>
        string(19) "Supports de culture"
        [1]=>
        string(22) "Amendements organiques"
        [2]=>
        string(18) "Engrais organiques"
        [3]=>
        string(24) "Engrais organo-minéraux"
      }
      ["contributeurs_statistiques"]=>
      array(0) {
      }
      ["tag"]=>
      array(0) {
      }
      ["logo"]=>
      object(stdClass)#7062 (3) {
        ["full"]=>
        object(stdClass)#7034 (3) {
          ["src"]=>
          string(87) "https://extranet-afaia.atm-com.fr/wp-content/uploads/2020/02/logo-esat-quatre-vaulx.png"
          ["width"]=>
          int(300)
          ["height"]=>
          int(210)
        }
        ["medium"]=>
        object(stdClass)#7077 (3) {
          ["src"]=>
          string(87) "https://extranet-afaia.atm-com.fr/wp-content/uploads/2020/02/logo-esat-quatre-vaulx.png"
          ["width"]=>
          int(300)
          ["height"]=>
          int(210)
        }
        ["thumbnail"]=>
        object(stdClass)#7177 (3) {
          ["src"]=>
          string(95) "https://extranet-afaia.atm-com.fr/wp-content/uploads/2020/02/logo-esat-quatre-vaulx-150x150.png"
          ["width"]=>
          int(150)
          ["height"]=>
          int(150)
        }
      }
    }
    
    4 VAULX JARDIN
    4 VAULX JARDIN Supports de culture, Amendements organiques, Engrais organiques, Engrais organo-minéraux http://www.4vaulx-jardin.com
  • object(stdClass)#7149 (12) {
      ["name"]=>
      string(11) "AESEA Group"
      ["website"]=>
      string(19) "https://aquiland.fr"
      ["twitter"]=>
      string(0) ""
      ["image"]=>
      string(160) "059391a948e106a794bb0a6189605be71a6a5fbefeb3671c1062b2e38eb34bfe75f5ab41159331b28a55e50cae502e93d6b15d97a46708b0689ccf31d9b54c339a33c922c0cac9081a5db70cb3d60c29"
      ["phone"]=>
      string(0) ""
      ["zoho_id"]=>
      string(18) "246999000000253098"
      ["address"]=>
      object(stdClass)#7121 (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"]=>
      array(0) {
      }
      ["tag"]=>
      array(0) {
      }
      ["logo"]=>
      object(stdClass)#7204 (3) {
        ["full"]=>
        object(stdClass)#7093 (3) {
          ["src"]=>
          string(78) "https://extranet-afaia.atm-com.fr/wp-content/uploads/2020/02/logo-aquiland.jpg"
          ["width"]=>
          int(333)
          ["height"]=>
          int(123)
        }
        ["medium"]=>
        object(stdClass)#7029 (3) {
          ["src"]=>
          string(86) "https://extranet-afaia.atm-com.fr/wp-content/uploads/2020/02/logo-aquiland-300x111.jpg"
          ["width"]=>
          int(300)
          ["height"]=>
          int(111)
        }
        ["thumbnail"]=>
        object(stdClass)#7069 (3) {
          ["src"]=>
          string(86) "https://extranet-afaia.atm-com.fr/wp-content/uploads/2020/02/logo-aquiland-150x123.jpg"
          ["width"]=>
          int(150)
          ["height"]=>
          int(123)
        }
      }
    }
    
    AESEA Group
    AESEA Group Supports de culture https://aquiland.fr
  • object(stdClass)#7068 (12) {
      ["name"]=>
      string(6) "AGARIS"
      ["website"]=>
      string(13) "www.agaris.eu"
      ["twitter"]=>
      string(0) ""
      ["image"]=>
      string(160) "059391a948e106a794bb0a6189605be71a6a5fbefeb3671c1062b2e38eb34bfe77e1597800669400fa7fc6032ef7621c74ce91903cb40a935e3995f148ad99106808466fca943470cdd78c737109f06b"
      ["phone"]=>
      object(stdClass)#7076 (2) {
        ["internationalFormat"]=>
        string(12) "+33490189728"
        ["frenchFormat"]=>
        string(14) "04 90 18 97 28"
      }
      ["zoho_id"]=>
      string(18) "246999000000253106"
      ["address"]=>
      object(stdClass)#7061 (4) {
        ["street"]=>
        NULL
        ["postalcode"]=>
        NULL
        ["city"]=>
        NULL
        ["country"]=>
        NULL
      }
      ["adherents"]=>
      array(1) {
        [0]=>
        string(9) "Adhérent"
      }
      ["produits_fabriques"]=>
      array(4) {
        [0]=>
        string(19) "Supports de culture"
        [1]=>
        string(9) "Paillages"
        [2]=>
        string(22) "Amendements organiques"
        [3]=>
        string(18) "Engrais organiques"
      }
      ["contributeurs_statistiques"]=>
      array(0) {
      }
      ["tag"]=>
      array(0) {
      }
      ["logo"]=>
      NULL
    }
    
    AGARIS Supports de culture, Paillages, Amendements organiques, Engrais organiques http://www.agaris.eu
  • object(stdClass)#7067 (12) {
      ["name"]=>
      string(17) "AGRIVER - TONUSOL"
      ["website"]=>
      string(23) "https://www.tonusol.com"
      ["twitter"]=>
      string(0) ""
      ["image"]=>
      string(0) ""
      ["phone"]=>
      string(0) ""
      ["zoho_id"]=>
      string(18) "246999000000253115"
      ["address"]=>
      object(stdClass)#7066 (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"]=>
      array(0) {
      }
      ["tag"]=>
      array(0) {
      }
      ["logo"]=>
      NULL
    }
    
    AGRIVER - TONUSOL Supports de culture, Paillages, Amendements organiques https://www.tonusol.com
  • object(stdClass)#7218 (12) {
      ["name"]=>
      string(9) "BIOFERTIL"
      ["website"]=>
      string(21) "https://biofertil.fr/"
      ["twitter"]=>
      string(0) ""
      ["image"]=>
      string(0) ""
      ["phone"]=>
      string(0) ""
      ["zoho_id"]=>
      string(18) "246999000000253146"
      ["address"]=>
      object(stdClass)#7107 (4) {
        ["street"]=>
        NULL
        ["postalcode"]=>
        NULL
        ["city"]=>
        NULL
        ["country"]=>
        NULL
      }
      ["adherents"]=>
      array(1) {
        [0]=>
        string(9) "Adhérent"
      }
      ["produits_fabriques"]=>
      array(2) {
        [0]=>
        string(19) "Supports de culture"
        [1]=>
        string(22) "Amendements organiques"
      }
      ["contributeurs_statistiques"]=>
      array(0) {
      }
      ["tag"]=>
      array(0) {
      }
      ["logo"]=>
      NULL
    }
    
    BIOFERTIL Supports de culture, Amendements organiques https://biofertil.fr/
  • object(stdClass)#7135 (12) {
      ["name"]=>
      string(19) "BIOLANDES PIN DECOR"
      ["website"]=>
      string(25) "https://www.biolandes.com"
      ["twitter"]=>
      string(0) ""
      ["image"]=>
      string(0) ""
      ["phone"]=>
      object(stdClass)#7163 (2) {
        ["internationalFormat"]=>
        string(12) "+33558510000"
        ["frenchFormat"]=>
        string(14) "05 58 51 00 00"
      }
      ["zoho_id"]=>
      string(18) "246999000000253147"
      ["address"]=>
      object(stdClass)#7191 (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
  • object(stdClass)#7070 (12) {
      ["name"]=>
      string(12) "BRILL FRANCE"
      ["website"]=>
      string(32) "https://www.brill-substrate.com/"
      ["twitter"]=>
      string(0) ""
      ["image"]=>
      string(0) ""
      ["phone"]=>
      object(stdClass)#7030 (2) {
        ["internationalFormat"]=>
        string(12) "+33472775277"
        ["frenchFormat"]=>
        string(14) "04 72 77 52 77"
      }
      ["zoho_id"]=>
      string(18) "246999000000253156"
      ["address"]=>
      object(stdClass)#7065 (4) {
        ["street"]=>
        string(21) "21 Rue de l'Industrie"
        ["postalcode"]=>
        string(5) "69530"
        ["city"]=>
        string(8) "Brignais"
        ["country"]=>
        NULL
      }
      ["adherents"]=>
      array(1) {
        [0]=>
        string(9) "Adhérent"
      }
      ["produits_fabriques"]=>
      array(1) {
        [0]=>
        string(19) "Supports de culture"
      }
      ["contributeurs_statistiques"]=>
      array(0) {
      }
      ["tag"]=>
      array(0) {
      }
      ["logo"]=>
      NULL
    }
    
    BRILL FRANCE Supports de culture https://www.brill-substrate.com/
  • object(stdClass)#7219 (12) {
      ["name"]=>
      string(12) "DCM SOPRIMEX"
      ["website"]=>
      string(23) "http://www.soprimex.com"
      ["twitter"]=>
      string(0) ""
      ["image"]=>
      string(0) ""
      ["phone"]=>
      object(stdClass)#7220 (2) {
        ["internationalFormat"]=>
        string(12) "+33490240424"
        ["frenchFormat"]=>
        string(14) "04 90 24 04 24"
      }
      ["zoho_id"]=>
      string(18) "246999000000253175"
      ["address"]=>
      object(stdClass)#7221 (4) {
        ["street"]=>
        NULL
        ["postalcode"]=>
        NULL
        ["city"]=>
        NULL
        ["country"]=>
        NULL
      }
      ["adherents"]=>
      array(1) {
        [0]=>
        string(9) "Adhérent"
      }
      ["produits_fabriques"]=>
      array(5) {
        [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"
      }
      ["contributeurs_statistiques"]=>
      array(0) {
      }
      ["tag"]=>
      array(0) {
      }
      ["logo"]=>
      NULL
    }
    
    DCM SOPRIMEX Supports de culture, Paillages, Amendements organiques, Engrais organiques, Engrais organo-minéraux http://www.soprimex.com
  • object(stdClass)#7222 (12) {
      ["name"]=>
      string(6) "DUMONA"
      ["website"]=>
      string(23) "https://www.dumona.com/"
      ["twitter"]=>
      string(0) ""
      ["image"]=>
      string(0) ""
      ["phone"]=>
      object(stdClass)#7223 (2) {
        ["internationalFormat"]=>
        string(12) "+33474808155"
        ["frenchFormat"]=>
        string(14) "04 74 80 81 55"
      }
      ["zoho_id"]=>
      string(18) "246999000000253176"
      ["address"]=>
      object(stdClass)#7224 (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"]=>
      array(0) {
      }
      ["tag"]=>
      array(0) {
      }
      ["logo"]=>
      NULL
    }
    
    DUMONA Supports de culture https://www.dumona.com/
  • object(stdClass)#7225 (12) {
      ["name"]=>
      string(13) "ELEPHANT VERT"
      ["website"]=>
      string(21) "www.elephant-vert.com"
      ["twitter"]=>
      string(0) ""
      ["image"]=>
      string(0) ""
      ["phone"]=>
      string(0) ""
      ["zoho_id"]=>
      string(18) "246999000000253177"
      ["address"]=>
      object(stdClass)#7226 (4) {
        ["street"]=>
        NULL
        ["postalcode"]=>
        NULL
        ["city"]=>
        NULL
        ["country"]=>
        NULL
      }
      ["adherents"]=>
      array(1) {
        [0]=>
        string(9) "Adhérent"
      }
      ["produits_fabriques"]=>
      array(5) {
        [0]=>
        string(19) "Supports de culture"
        [1]=>
        string(9) "Paillages"
        [2]=>
        string(22) "Amendements organiques"
        [3]=>
        string(18) "Engrais organiques"
        [4]=>
        string(13) "Biostimulants"
      }
      ["contributeurs_statistiques"]=>
      array(0) {
      }
      ["tag"]=>
      array(0) {
      }
      ["logo"]=>
      NULL
    }
    
    ELEPHANT VERT Supports de culture, Paillages, Amendements organiques, Engrais organiques, Biostimulants http://www.elephant-vert.com
  • object(stdClass)#7227 (12) {
      ["name"]=>
      string(13) "EVADEA GROUPE"
      ["website"]=>
      string(26) "http://www.tourbieres.com/"
      ["twitter"]=>
      string(58) "http://www.tourbieres.com/PagePF.asp?niv0=1&niv1=2&niv2=91"
      ["image"]=>
      string(0) ""
      ["phone"]=>
      string(0) ""
      ["zoho_id"]=>
      string(18) "246999000000253187"
      ["address"]=>
      object(stdClass)#7228 (4) {
        ["street"]=>
        NULL
        ["postalcode"]=>
        NULL
        ["city"]=>
        NULL
        ["country"]=>
        NULL
      }
      ["adherents"]=>
      array(1) {
        [0]=>
        string(9) "Adhérent"
      }
      ["produits_fabriques"]=>
      array(5) {
        [0]=>
        string(19) "Supports de culture"
        [1]=>
        string(9) "Paillages"
        [2]=>
        string(22) "Amendements organiques"
        [3]=>
        string(18) "Engrais organiques"
        [4]=>
        string(13) "Biostimulants"
      }
      ["contributeurs_statistiques"]=>
      array(0) {
      }
      ["tag"]=>
      array(0) {
      }
      ["logo"]=>
      NULL
    }
    
    EVADEA GROUPE Supports de culture, Paillages, Amendements organiques, Engrais organiques, Biostimulants http://www.tourbieres.com/
  • object(stdClass)#7229 (12) {
      ["name"]=>
      string(6) "FERTIL"
      ["website"]=>
      string(16) "http://fertil.fr"
      ["twitter"]=>
      string(0) ""
      ["image"]=>
      string(0) ""
      ["phone"]=>
      string(0) ""
      ["zoho_id"]=>
      string(18) "246999000000253196"
      ["address"]=>
      object(stdClass)#7230 (4) {
        ["street"]=>
        NULL
        ["postalcode"]=>
        NULL
        ["city"]=>
        NULL
        ["country"]=>
        NULL
      }
      ["adherents"]=>
      array(1) {
        [0]=>
        string(9) "Adhérent"
      }
      ["produits_fabriques"]=>
      array(2) {
        [0]=>
        string(9) "Paillages"
        [1]=>
        string(18) "Engrais organiques"
      }
      ["contributeurs_statistiques"]=>
      array(0) {
      }
      ["tag"]=>
      array(0) {
      }
      ["logo"]=>
      NULL
    }
    
    FERTIL Paillages, Engrais organiques http://fertil.fr