SELECT cl.name AS "nome categoria", pl.id_product AS "id prodotto", pl.id_shop AS "id shop", pl.description AS "descrizione", pl.description_short AS "descrizione corta", pl.link_rewrite AS "url", pl.meta_description, pl.meta_keywords, pl.meta_title, pl.name
    FROM
      ps_product_lang pl
        INNER JOIN ps_category_product cp ON cp.id_product = pl.id_product
        INNER JOIN ps_category_lang cl ON cl.id_category = cp.id_category
            WHERE pl.id_lang = ?