icms_db Object
(
[conn] => Resource id #7
[res] =>
[row] =>
[connected] => 1
[sql] =>
SELECT SQL_CALC_FOUND_ROWS a.ArticleID,a.ArticleTitle,a.ArticleSum,a.ArticleFull,a.startdt,a.enddt,a.Flags,a.ORD,a.Status,a.Created,a.CreatedBy,a.LastUpdated,a.LastUpdatedBY,a.Hash,a.oldid,a.price,a.priceb2b,a.discount,a.discountb2b,a.final_price,a.final_priceb2b,a.seo_title,a.seo_keywords,a.seo_description
FROM icms_articles as a inner join icms_art_cat b on b.ArticleID=a.ArticleID WHERE a.ArticleID > 0 AND b.CategoryID IN (304) AND a.Status IN (4) AND a.Flags='3' AND a.LanguageID='1' group by ArticleID ORDER BY b.ord DESC LIMIT 0,12
)
- HOME
- Products
- KITCHENS
- QUALITY AND MATERIALS
QUALITY AND MATERIALS
ΦΙΛΤΡΑ [+]
NUMBER OF SEATER PER SOFA
Δυστυχώς δεν υπάρχουν προϊόντα.
