string(861) "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 '{6340eb92480706ed8ad7fa95f4e977ddafd6b79562ef0577d1db0dc352bd465a}Amendements organiques{6340eb92480706ed8ad7fa95f4e977ddafd6b79562ef0577d1db0dc352bd465a}'  OR pmr.meta_value LIKE '{6340eb92480706ed8ad7fa95f4e977ddafd6b79562ef0577d1db0dc352bd465a}Engrais organiques{6340eb92480706ed8ad7fa95f4e977ddafd6b79562ef0577d1db0dc352bd465a}'  OR pmr.meta_value LIKE '{6340eb92480706ed8ad7fa95f4e977ddafd6b79562ef0577d1db0dc352bd465a}Engrais organo-minéraux{6340eb92480706ed8ad7fa95f4e977ddafd6b79562ef0577d1db0dc352bd465a}'  ) );"
  • object(stdClass)#7036 (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)#7027 (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)#7058 (3) {
        ["full"]=>
        object(stdClass)#7030 (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)#7073 (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)#7173 (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)#7145 (12) {
      ["name"]=>
      string(6) "AGARIS"
      ["website"]=>
      string(13) "www.agaris.eu"
      ["twitter"]=>
      string(0) ""
      ["image"]=>
      string(160) "059391a948e106a794bb0a6189605be71a6a5fbefeb3671c1062b2e38eb34bfe77e1597800669400fa7fc6032ef7621c74ce91903cb40a935e3995f148ad99106808466fca943470cdd78c737109f06b"
      ["phone"]=>
      object(stdClass)#7117 (2) {
        ["internationalFormat"]=>
        string(12) "+33490189728"
        ["frenchFormat"]=>
        string(14) "04 90 18 97 28"
      }
      ["zoho_id"]=>
      string(18) "246999000000253106"
      ["address"]=>
      object(stdClass)#7089 (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)#7200 (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)#7025 (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)#7065 (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)#7064 (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)#7072 (12) {
      ["name"]=>
      string(10) "AGRONUTRIS"
      ["website"]=>
      string(26) "https://www.agronutris.com"
      ["twitter"]=>
      string(0) ""
      ["image"]=>
      string(0) ""
      ["phone"]=>
      object(stdClass)#7057 (2) {
        ["internationalFormat"]=>
        string(12) "+33531543288"
        ["frenchFormat"]=>
        string(14) "05 31 54 32 88"
      }
      ["zoho_id"]=>
      string(18) "246999000000390060"
      ["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(18) "Engrais organiques"
      }
      ["contributeurs_statistiques"]=>
      array(0) {
      }
      ["tag"]=>
      array(0) {
      }
      ["logo"]=>
      NULL
    }
    
    AGRONUTRIS Engrais organiques https://www.agronutris.com
  • object(stdClass)#7062 (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)#7214 (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)#7103 (12) {
      ["name"]=>
      string(13) "AKIOLIS Group"
      ["website"]=>
      string(26) "https://www.akiolis.com/fr"
      ["twitter"]=>
      string(0) ""
      ["image"]=>
      string(0) ""
      ["phone"]=>
      object(stdClass)#7131 (2) {
        ["internationalFormat"]=>
        string(12) "+33244815010"
        ["frenchFormat"]=>
        string(14) "02 44 81 50 10"
      }
      ["zoho_id"]=>
      string(18) "246999000002925037"
      ["address"]=>
      object(stdClass)#7159 (4) {
        ["street"]=>
        string(26) "72 avenue Olivier Messiaen"
        ["postalcode"]=>
        string(5) "72000"
        ["city"]=>
        string(7) "Le Mans"
        ["country"]=>
        NULL
      }
      ["adherents"]=>
      array(1) {
        [0]=>
        string(9) "Adhérent"
      }
      ["produits_fabriques"]=>
      array(2) {
        [0]=>
        string(18) "Engrais organiques"
        [1]=>
        string(24) "Engrais organo-minéraux"
      }
      ["contributeurs_statistiques"]=>
      array(0) {
      }
      ["tag"]=>
      array(0) {
      }
      ["logo"]=>
      NULL
    }
    
    AKIOLIS Group Engrais organiques, Engrais organo-minéraux https://www.akiolis.com/fr
  • object(stdClass)#7187 (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)#7066 (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)#7026 (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)#7061 (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)#7215 (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)#7216 (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)#7217 (12) {
      ["name"]=>
      string(19) "BIOLANDES PIN DECOR"
      ["website"]=>
      string(25) "https://www.biolandes.com"
      ["twitter"]=>
      string(0) ""
      ["image"]=>
      string(0) ""
      ["phone"]=>
      object(stdClass)#7218 (2) {
        ["internationalFormat"]=>
        string(12) "+33558510000"
        ["frenchFormat"]=>
        string(14) "05 58 51 00 00"
      }
      ["zoho_id"]=>
      string(18) "246999000000253147"
      ["address"]=>
      object(stdClass)#7219 (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)#7220 (12) {
      ["name"]=>
      string(14) "CLER VERTS SAS"
      ["website"]=>
      string(24) "http://www.cler-verts.fr"
      ["twitter"]=>
      string(0) ""
      ["image"]=>
      string(0) ""
      ["phone"]=>
      string(0) ""
      ["zoho_id"]=>
      string(18) "246999000000253165"
      ["address"]=>
      object(stdClass)#7221 (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"]=>
      array(0) {
      }
      ["tag"]=>
      array(0) {
      }
      ["logo"]=>
      NULL
    }
    
    CLER VERTS SAS Amendements organiques http://www.cler-verts.fr