SELECT ofr.code, ofr.title, CONCAT('https://files.cataliws.com/wsng', '/get/', f._name) AS cover, COALESCE(( SELECT SUM(quantity) FROM `wsng_base`.orders WHERE offer IN ( SELECT `code` FROM wsng_enterprise.offer_variants WHERE offer = ofr.code ) ), 0) AS sold FROM wsng_enterprise.offers AS ofr LEFT JOIN `wsng_files`.file_default AS fd ON fd.id = ( SELECT id FROM `wsng_files`.file_default WHERE set_key = 'OFFER.ASSET-PHOTO' AND `user` = ofr.code LIMIT 1 ) LEFT JOIN `wsng_files`.file_meta AS f ON f.id = fd.file_id WHERE ofr.ws = '28966948392' AND ofr.status IN ('ACTIVE', 'PUBLISHED') AND ofr.category IN ('mugs-and-tea-cups', 'men-mugs-and-tea-cups', 'women-mugs-and-tea-cups', 'mens-mugs-and-tea-cups', 'womens-mugs-and-tea-cups', 'mugs-and-tea-cups.28966948392', 'men-mugs-and-tea-cups.28966948392', 'women-mugs-and-tea-cups.28966948392', 'mens-mugs-and-tea-cups.28966948392', 'womens-mugs-and-tea-cups.28966948392') GROUP BY ofr.code ORDER BY sold DESC, ofr._created DESC LIMIT 12