Запрос SQL на выборку данных без повторов

Есть запрос SQL:

SELECT a.virtuemart_product_id as 'vm_product_id', a.product_sku as 'vm_product_sku', b.product_name as 'vm_product_name', c.product_price as 'cost', c.product_price as 'price', a.low_stock_notification as 'vm_low_stock_alert', f.file_url as 'vm_product_picture', d.virtuemart_category_id as 'vm_category_id', g.parent_id as 'vm_subcategory_id', a.product_in_stock as 'vm_product_in_stock', b.product_s_desc as 'vm_product_s_desc', '1', b.product_desc as 'vm_product_desc', a.product_sales as 'vm_product_sales', b.slug as 'vm_slug' 
FROM `gk1zd_virtuemart_products` as a  
LEFT JOIN `gk1zd_virtuemart_products_ru_ru` as b ON b.virtuemart_product_id = a.virtuemart_product_id 
LEFT JOIN `gk1zd_virtuemart_product_prices` as c ON c.virtuemart_product_id = a.virtuemart_product_id 
LEFT JOIN `gk1zd_virtuemart_product_categories` as d ON d.virtuemart_product_id = a.virtuemart_product_id 
LEFT JOIN `gk1zd_virtuemart_product_medias` as e ON e.virtuemart_product_id = a.virtuemart_product_id 
LEFT JOIN `gk1zd_virtuemart_medias` as f ON f.virtuemart_media_id = e.virtuemart_media_id 
LEFT JOIN `sma_categories` as g ON g.id = d.virtuemart_category_id 
LEFT JOIN `sma_products` as h ON h.id = a.virtuemart_product_id 
WHERE a.published = 1 AND h.id IS NULL

Необходимо пропустить дублирующие значения, например: первую запись с id=2 запрос должен вывести на экран, если дальше есть поле с id=2 запрос должен запись пропустить(не выводить).

DISTINCT, GROUP BY - не подходит.