SELECT * FROM a_product2category LEFT JOIN
a_product ON
( a_product2category.id_product = a_product.id_product ) LEFT JOIN
a_category ON
( a_product2category.id_category = a_category.id_category ) WHERE
a_product.featured_product = 1 AND
a_product.active_product = 1
ORDER BY order_product2category ASC
Systém ochrany pre motorkárov - Motoairbag
