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
工业矿物
