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