Doplnění SQL query pro navraceni nazvu kategorie ke zbozi

[undeathquarteer]

Zdravim vsechny,

mam takovy dotaz, do XML exportu pro porovnavace zbozi jsme pridaval polozky jako EAN a Description, jeste bych chtel u kazdeho zbozi vypsat kategorii do ktere nalezi ale asi mam problem s JOINEM mezi bzoim a kategoriemi, tusil by nekdo jak to spravne zapsat?

 

Diky za kazdou radu.

$res = MySQL_Query("
       SELECT
               p.id_product,
               p.quantity,
               p.price,
               p.reduction_price,
               p.reduction_percent,
               p.reduction_from,
               p.reduction_to,
			p.supplier_reference,
               pl.name,
               pl.description_short,
               pl.link_rewrite,
               i.id_image
       FROM {$prefix}product p
       JOIN {$prefix}product_lang pl USING(id_product)
       JOIN {$prefix}image i USING(id_product)
       WHERE i.cover = 1 AND NOT (SELECT COUNT(*)
               FROM {$prefix}category_product cp
               WHERE cp.id_product = p.id_product
                       AND cp.id_category IN($noShowCategory))
       ORDER BY p.id_product", $db);