select 
if(SOAP_CONTENTS_SET.STID is not null,SOAP_CONTENTS_SET.ST_ORD,SOAP_CONTENTS.C_ORDER) as 'ORD',
SOAP_CONTENTS.CTID,
SOAP_CONTENTS.C_KEY,
SOAP_CONTENTS.C_TITLE,
SOAP_CONTENTS.C_INFO_TITLE,
SOAP_CONTENTS.C_KEP,
SOAP_CONTENTS.C_INTRO,
SOAP_CONTENTS.C_INFO_INTRO,
SOAP_CONTENTS.C_TAGS,
CAT1.CAT_KEY AS 'CAT1_KEY',
CAT1.CAT_LABEL AS 'CAT1_LABEL',
CAT1.CAT_INFO AS 'CAT1_INFO',
CAT2.CAT_KEY AS 'CAT2_KEY',
CAT2.CAT_LABEL as 'CAT2_LABEL',
CAT2.CAT_INFO as 'CAT2_INFO',
date_format(SOAP_CONTENTS.C_LHD,'%Y.%m.%d') as 'C_LHD' from SOAP_CONTENTS
left join SOAP_CONTENTS_SET ON SOAP_CONTENTS_SET.CTID=SOAP_CONTENTS.CTID
left JOIN SOAP_CONTENTS_CAT CAT1 ON CAT1.CATID=SOAP_CONTENTS.C_CAT1
left JOIN SOAP_CONTENTS_CAT CAT2 ON CAT2.CATID=SOAP_CONTENTS.C_CAT2 where  ( (SOAP_CONTENTS.C_STATUSZ=1)  and  (SOAP_CONTENTS.C_TIP=2)  and  (SOAP_CONTENTS_SET.STID is not null) )  order by 1 ASC limit 20