SELECT  o.`merchant_id`, o.`domain`,m.domain as domain_merchant, o.`coupon_code`,
                m.`merchant_img`,o.`submitted_date`, o.`keywords`, o.`description` as o_description, o.`active`, o.`cat_id`, 
                m.`merchant_name`, m.`domain_name` ,m.`description`,m.`merchant_img`,
                m.`description` as m_description, o.`redirect_link`,o.image_url,m.is_online
                FROM `offers` o 
                LEFT JOIN `merchant` m ON (o.`merchant_id` = m.`merchant_id`)
                WHERE 1=1 AND o.`active`=1 AND domain_name='amberpieces.com' AND o.`offer_id`='13587'
                ORDER BY o.`submitted_date` DESC