info@insideoutcasa.com

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 (120) AND a.Status IN (4) AND a.Flags='3' AND a.LanguageID='1' group by ArticleID ORDER BY b.ord DESC LIMIT 0,12 )