SELECT *
FROM `goods`
WHERE (`gc_id_1` = 1 OR `gc_id_2` = 1 OR `gc_id_3` = 1)
AND (comm_id =123 or comm_name like '%123%')
AND (user='admin' or tel= 'admin')
AND `goods_state` = 1 AND `riqi` > '2016-05-04'
GROUP BY comm_id
LIMIT 0,10 最佳答案
