- 企業(yè)
- 供應(yīng)
- 求購
- 資訊
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