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 >8897 ) 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 =8897 ) ORDER BY b.CatPartID ) AS d) as e LEFT JOIN `g_Catalog` as f ON (e.BCatPartID = f.CatPartID) LIMIT 3