string(763) "select CTID, C_STATUSZ, C_KEY, C_TIP, C_CAT1, C_CAT2, C_TITLE, C_KEP, C_INTRO, CONTENT, C_ORDER, C_INFO_TITLE, C_INFO_INTRO, C_INFO, C_TAGS, C_NOTE, C_STAT, 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', C_DATA1,C_DATA2,C_DATA3, DATE_FORMAT(C_PDT, '%Y.%m.%d') as 'C_PDT', DATE_FORMAT(C_UMD, '%Y.%m.%d') as 'C_UMD', DATE_FORMAT(C_LHD, '%Y.%m.%d') as 'C_LHD', DATEDIFF(now(), C_LHD) as 'AGE' from SOAP_CONTENTS 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 (C_KEY=404) and (C_STATUSZ=1) limit 1" Vári Kovács Ágnes | Agivari Art & Design