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)#7034 (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)#7025 (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)#7056 (3) {
        ["full"]=>
        object(stdClass)#7028 (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)#7071 (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)#7171 (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)#7143 (12) {
      ["name"]=>
      string(7) "ACCERES"
      ["website"]=>
      string(19) "http://acceres.com/"
      ["twitter"]=>
      string(0) ""
      ["image"]=>
      string(0) ""
      ["phone"]=>
      string(0) ""
      ["zoho_id"]=>
      string(18) "246999000001634051"
      ["address"]=>
      object(stdClass)#7115 (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"]=>
      array(0) {
      }
      ["tag"]=>
      array(0) {
      }
      ["logo"]=>
      object(stdClass)#7198 (3) {
        ["full"]=>
        object(stdClass)#7087 (3) {
          ["src"]=>
          string(84) "https://extranet-afaia.atm-com.fr/wp-content/uploads/2020/09/acceres-logo400x186.jpg"
          ["width"]=>
          int(400)
          ["height"]=>
          int(186)
        }
        ["medium"]=>
        object(stdClass)#7023 (3) {
          ["src"]=>
          string(92) "https://extranet-afaia.atm-com.fr/wp-content/uploads/2020/09/acceres-logo400x186-300x140.jpg"
          ["width"]=>
          int(300)
          ["height"]=>
          int(140)
        }
        ["thumbnail"]=>
        object(stdClass)#7063 (3) {
          ["src"]=>
          string(92) "https://extranet-afaia.atm-com.fr/wp-content/uploads/2020/09/acceres-logo400x186-150x150.jpg"
          ["width"]=>
          int(150)
          ["height"]=>
          int(150)
        }
      }
    }
    
    ACCERES
    ACCERES Membre associé d'Afaïa http://acceres.com/
  • object(stdClass)#7060 (12) {
      ["name"]=>
      string(6) "ADIVET"
      ["website"]=>
      string(21) "http://www.adivet.net"
      ["twitter"]=>
      string(0) ""
      ["image"]=>
      string(0) ""
      ["phone"]=>
      string(0) ""
      ["zoho_id"]=>
      string(18) "246999000000253097"
      ["address"]=>
      object(stdClass)#7070 (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"]=>
      array(0) {
      }
      ["tag"]=>
      array(0) {
      }
      ["logo"]=>
      object(stdClass)#7061 (3) {
        ["full"]=>
        object(stdClass)#7055 (3) {
          ["src"]=>
          string(77) "https://extranet-afaia.atm-com.fr/wp-content/uploads/2020/02/logo-adivet1.gif"
          ["width"]=>
          int(1200)
          ["height"]=>
          int(855)
        }
        ["medium"]=>
        object(stdClass)#7059 (3) {
          ["src"]=>
          string(85) "https://extranet-afaia.atm-com.fr/wp-content/uploads/2020/02/logo-adivet1-300x214.gif"
          ["width"]=>
          int(300)
          ["height"]=>
          int(214)
        }
        ["thumbnail"]=>
        object(stdClass)#7212 (3) {
          ["src"]=>
          string(85) "https://extranet-afaia.atm-com.fr/wp-content/uploads/2020/02/logo-adivet1-150x150.gif"
          ["width"]=>
          int(150)
          ["height"]=>
          int(150)
        }
      }
    }
    
    ADIVET
    ADIVET Membre associé d'Afaïa http://www.adivet.net
  • object(stdClass)#7101 (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)#7129 (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)#7185 (3) {
        ["full"]=>
        object(stdClass)#7157 (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)#7064 (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)#7024 (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)#7062 (12) {
      ["name"]=>
      string(6) "AGARIS"
      ["website"]=>
      string(13) "www.agaris.eu"
      ["twitter"]=>
      string(0) ""
      ["image"]=>
      string(160) "059391a948e106a794bb0a6189605be71a6a5fbefeb3671c1062b2e38eb34bfe77e1597800669400fa7fc6032ef7621c74ce91903cb40a935e3995f148ad99106808466fca943470cdd78c737109f06b"
      ["phone"]=>
      object(stdClass)#7213 (2) {
        ["internationalFormat"]=>
        string(12) "+33490189728"
        ["frenchFormat"]=>
        string(14) "04 90 18 97 28"
      }
      ["zoho_id"]=>
      string(18) "246999000000253106"
      ["address"]=>
      object(stdClass)#7214 (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)#7215 (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)#7216 (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)#7217 (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)#7218 (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)#7219 (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)#7220 (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)#7221 (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)#7222 (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)#7223 (12) {
      ["name"]=>
      string(10) "AGRONUTRIS"
      ["website"]=>
      string(26) "https://www.agronutris.com"
      ["twitter"]=>
      string(0) ""
      ["image"]=>
      string(0) ""
      ["phone"]=>
      object(stdClass)#7224 (2) {
        ["internationalFormat"]=>
        string(12) "+33531543288"
        ["frenchFormat"]=>
        string(14) "05 31 54 32 88"
      }
      ["zoho_id"]=>
      string(18) "246999000000390060"
      ["address"]=>
      object(stdClass)#7225 (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)#7226 (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)#7227 (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)#7228 (12) {
      ["name"]=>
      string(13) "AKIOLIS Group"
      ["website"]=>
      string(26) "https://www.akiolis.com/fr"
      ["twitter"]=>
      string(0) ""
      ["image"]=>
      string(0) ""
      ["phone"]=>
      object(stdClass)#7229 (2) {
        ["internationalFormat"]=>
        string(12) "+33244815010"
        ["frenchFormat"]=>
        string(14) "02 44 81 50 10"
      }
      ["zoho_id"]=>
      string(18) "246999000002925037"
      ["address"]=>
      object(stdClass)#7230 (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