SELECT DISTINCT product_sku FROM jos_vm_product WHERE (jos_vm_product.product_parent_id='' OR jos_vm_product.product_parent_id='0') AND vendor_id='1' AND jos_vm_product.product_publish='Y' AND jos_vm_product.product_special='Y' ORDER BY product_sku desc LIMIT 0, 4
