-- QUERY:SELECT * FROM ( ( SELECT product_sku FROM #__{vm}_product,#__{vm}_product_relations WHERE #__{vm}_product_relations.product_id='20362' AND product_publish='Y' AND FIND_IN_SET(#__{vm}_product.product_id, REPLACE(related_products, '|', ',' )) LIMIT 0, 6 ) UNION ( SELECT DISTINCT product_sku FROM #__{vm}_product, #__{vm}_product_category_xref, #__{vm}_category WHERE 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 #__{vm}_category.category_id IN(871,755,793,874,873,876,875,792,791,867,865,862,866,864,863,780,783,899,987,900,901,902,893,896,895,898,894,903,897,891,892,993,997,1006,784,790,872,871,870,868,869,789,787,786,781,785,794,782,856,855,854,853,859,861,860,858,852,857,795,788,984) AND #__{vm}_product.product_publish='Y' AND #__{vm}_product.product_id != 20362 ORDER BY RAND() LIMIT 0, 6 ) ) as tbl LIMIT 0, 6 -->