SELECT * FROM records WHERE Rec_Page_ID = 217 AND Rec_Page_Content = 0 AND Rec_Active = 0 AND Rec_Title <> '' UNION SELECT records.* FROM pages, records, related_pages WHERE Related_Page_ID = 217 AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Active = 0 AND Rec_Page_Content = 0 AND Rec_Title <> ''
ΦΙΛΤΡΑ
ΕΧΕΤΕ ΑΝΑΚΑΛΥΨΕΙ
ΤΥΠΟΣ
ΥΛΙΚΟ
SELECT * FROM recs_att_tables WHERE Rat_SubCat = 'MultTable1' AND Rat_List_ID = '9' AND Rat_Lang = 'el' ORDER BY Rat_Order ASC, Rat_Title ASC
ΧΡΩΜΑ
SELECT * FROM recs_att_tables WHERE Rat_SubCat = 'MultTable2' AND Rat_List_ID = '9' AND Rat_Lang = 'el' ORDER BY Rat_Order ASC, Rat_Title ASC
BRAND
SELECT * FROM recs_att_tables WHERE Rat_SubCat = 'MultTable3' AND Rat_List_ID = '9' AND Rat_Lang = 'el' ORDER BY Rat_Order ASC, Rat_Title ASC
ΣΥΛΛΟΓΕΣ
SELECT * FROM recs_att_tables WHERE Rat_SubCat = 'MultTable4' AND Rat_List_ID = '9' AND Rat_Lang = 'el' ORDER BY Rat_Order ASC, Rat_Title ASC
SELECT records.*,pages.Page_Order, Rec_Price - (Rec_Price * Rec_Discount/100) AS finalprice FROM pages,records WHERE Parent_Page_ID = 217 AND Rec_Page_ID=Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 UNION SELECT records.*,pages.Page_Order,Rec_Price - (Rec_Price * Rec_Discount/100) AS finalprice FROM pages, records, related_pages WHERE Parent_Page_ID = 217 AND Rec_ID = Related_Rec_ID AND Related_Page_ID = Page_ID AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 Order by Rec_Page_ID ASC, Rec_Order ASC, Rec_DateStart Desc LIMIT 0 , 64