SELECT
pk.SKU
FROM
PackageModels AS pm
INNER JOIN tbl_products AS p ON ( pm.Model = p.SKU )
INNER JOIN ModelPrice AS mp ON ( mp.SKU = p.SKU )
INNER JOIN tbl_products AS pk ON (pm.PackageID = pk.id AND pk.is_package = 1)
INNER JOIN ModelPrice AS pkMP ON (pk.SKU = pkMP.SKU)
WHERE mp.sale <= 1 AND mp.MSRP <= 1
ORDER BY
pm.PackageID,
p.CommonBrandName,
pk.SKU,
p.SKU
Query execution was interrupted