SELECT SQL_CALC_FOUND_ROWS t1.title as `cat-title`,t1.add_title, t1.text as `cat-text`, t3.*, t2.id_catalog_cat , t4.id_photo, t1.is_horizontal,t1.is_quick_order
FROM `com_catalog_cats` t1
LEFT JOIN `com_catalog_link_cats` t2
ON (t1.id=t2.id_catalog_cat)
LEFT JOIN `com_catalog` t3
ON (t2.id_catalog=t3.id AND t3.status=1)
LEFT JOIN `com_catalog_photos` t4
ON (t4.id_catalog=t3.id AND t4.is_main=1)
LEFT JOIN `com_catalog_link_property_size` size ON (size.id_catalog=t3.id)
WHERE t3.is_sale_week>0 AND t3.id IS NOT NULL AND ( t3.title LIKE '%%')
GROUP BY t3.id ORDER BY IF(size.id IS NOT NULL, 0, 1) ASC, t2.ord2 ASC, t3.is_sale_week_ord ASC, t3.ts DESC, t3.id DESC
