Query: LEFT JOIN `jos_{vm}_product_price` ON `jos_{vm}_product`.`product_id` = `jos_{vm}_product_price`.`product_id`
LEFT JOIN `jos_vm_product_discount`
ON (`jos_vm_product`.`product_discount_id` = `jos_vm_product_discount`.`discount_id` OR `jos_vm_product`.`product_discount_id` = '0') WHERE `jos_{vm}_product_category_xref`.`product_id`=`jos_{vm}_product`.`product_id`
AND `jos_{vm}_product_category_xref`.`category_id`=`jos_{vm}_category`.`category_id`
AND `jos_{vm}_product_category_xref`.`category_id`=31
AND `jos_vm_product`.`product_id` NOT IN (7712)
AND `jos_vm_product`.`product_id` NOT IN (7712)
AND ((`jos_{vm}_product`.`product_id`=`jos_{vm}_product_price`.`product_id` AND `jos_{vm}_shopper_group`.`shopper_group_id`=`jos_{vm}_product_price`.`shopper_group_id`) OR `jos_{vm}_product_price`.`product_id` IS NULL)
AND `jos_{vm}_shopper_group`.`default` = 1
AND ((`product_parent_id`='0') OR (`product_parent_id`=''))
AND (`product_publish`='Y')
AND `product_publish`='Y'
AND `category_publish`='Y'
GROUP BY `jos_{vm}_product`.`product_sku`
ORDER BY RAND() ASC