SELECT a.*,CONCAT('【',a.k_category,'】',a.k_title) AS final_title
, b.e_author
, b.e_applicant
, b.e_designperson
, b.e_mainclass
, b.e_standardnumber
, b.e_releasetime
, b.e_applytime
, b.e_implementationtime
, b.ext1
, b.ext2
, b.ext3
, b.ext4
, b.ext5
, b.ext6
, b.ext7
, b.ext8
, b.ext9
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 8 SELECT a.*,CONCAT('【',a.k_category,'】',a.k_title) AS final_title
, b.e_author
, b.e_applicant
, b.e_designperson
, b.e_mainclass
, b.e_standardnumber
, b.e_releasetime
, b.e_applytime
, b.e_implementationtime
, b.ext1
, b.ext2
, b.ext3
, b.ext4
, b.ext5
, b.ext6
, b.ext7
, b.ext8
, b.ext9
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 8 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 (22) AND b.e_author like '%陈荣石%' ORDER BY k_release_time DESC,id DESC LIMIT 0,18
工业矿物
