SELECT DISTINCT e.ACatPartID, e.ACatPartName, e.BCatPartID, e.BCatPartName FROM (SELECT *
FROM (
SELECT a.CatPartID AS ACatPartID, a.CatPartName AS ACatPartName, b.CatPartID AS BCatPartID, b.CatPartName AS BCatPartName
FROM `g_CatParts` AS a
LEFT JOIN `g_CatParts` AS b ON ( a.CatPartId = b.MainPartId )
WHERE a.`CatPartId` =
AND (
b.CatPartID >2711
)
ORDER BY b.CatPartID
) AS c
UNION
SELECT *
FROM (
SELECT a.CatPartID AS ACatPartID, a.CatPartName AS ACatPartName, b.CatPartID AS BCatPartID, b.CatPartName AS BCatPartName
FROM `g_CatParts` AS a
LEFT JOIN `g_CatParts` AS b ON ( a.CatPartId = b.MainPartId )
WHERE a.`CatPartId` =
AND NOT (
b.CatPartID =2711
)
ORDER BY b.CatPartID
) AS d) as e LEFT JOIN `g_Catalog` as f ON (e.BCatPartID = f.CatPartID)
LIMIT 3
