SELECT p.im_folder,p.im_name,p.cf_price_check, p.category_id,p.classifieds_id,p.cf_price_check, p.classifieds_id, p.cf_title, p.cf_addeddate, p.cf_price,
             (SELECT c.cf_condition FROM as_classifieds as c WHERE c.classifieds_id = p.classifieds_id),
             (SELECT c.cf_condition_value FROM as_classifieds as c WHERE c.classifieds_id = p.classifieds_id),
             (SELECT c.cf_warranty FROM as_classifieds as c WHERE c.classifieds_id = p.classifieds_id)
                FROM as_index_classifieds as p
                WHERE p.cf_IsDailyDeal=1 ";