SELECT *, Rec_Price - (Rec_Price * Rec_Discount/100) AS finalprice
FROM pages,records
WHERE
Rec_Page_ID=Page_ID
AND (
Page_ID = 322
OR records.Rec_ID IN (SELECT Related_Rec_ID FROM related_pages WHERE Related_Page_ID = 322)
)
AND Rec_Page_Content = 0 AND Rec_Title <> ''
AND Rec_Active = 0
GROUP BY records.Rec_ID ORDER BY pages.Page_Order,records.Rec_Order ASC