All accessories

SELECT *, Rec_Price - (Rec_Price * Rec_Discount/100) AS finalprice FROM pages,records,related_pages WHERE Rec_Page_ID=Page_ID AND ( Page_ID IN (315,316,317,396,397) OR records.Rec_ID IN (SELECT Related_Rec_ID FROM related_pages WHERE Related_Page_ID = 314) OR ( records.Rec_ID IN( SELECT Related_Rec_ID FROM related_pages WHERE Related_Page_ID IN (337) ) AND records.Rec_ID = related_pages.Related_Rec_ID ) ) AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 GROUP BY records.Rec_ID ORDER BY pages.Page_Order ASC,related_pages.Related_Rec_Order ASC