- 企业
- 供应
- 求购
- 资讯
SELECT a.*,FROM_UNIXTIME(`k_release_time`, '%Y-%m-%d' )as fbsj FROM k_content as a LEFT JOIN k_content_extendfield AS b ON a.id=b.content_id WHERE a.k_state=1 AND a.k_channel IN (174,142,141,139,140) AND b.e_author like '%罗旭东%' ORDER BY k_release_time DESC,id DESC LIMIT 0,18