SELECT * 
FROM catalog 
WHERE city_id = '170' AND moderate = 'Y'
AND (subcat_id = '1001' OR subcat2_id = '1001' OR subcat3_id = '1001')
ORDER BY rating DESC LIMIT 0, 20