- 企业
- 供应
- 求购
- 资讯
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 (158,157,156) AND b.e_author like '%陈荣石%' ORDER BY k_release_time DESC,id DESC LIMIT 0,18