| Štitnici DIAMANT |  |
|
SELECT DISTINCT product_sku FROM #__{vm}_product, #__{vm}_product_category_xref, #__{vm}_category WHERE #__{vm}_product.product_parent_id = 0 AND #__{vm}_product.product_id=#__{vm}_product_category_xref.product_id AND #__{vm}_category.category_id=#__{vm}_product_category_xref.category_id AND product_in_stock > 0 AND #__{vm}_product.product_publish='Y' ORDER BY #__{vm}_product.product_id DESC LIMIT 0, 1
