select distinct clf.folder_name, cp.parent, cd.docid, contentlabel, content, cat.label as category, cc.lang, cld.main_title, cld.title_tail, cld.sub_title, CASE WHEN cc.lang='en' THEN 1 ELSE 0 END as lang_sort from cms_language cl, CMS_CATEGORY cat, CMS_DATA_INET cd, cms_lang_doc cld, CMS_CONTENT_INET cc, product2doc pd, CMS_PARENTS cp, cms_lang_folder clf where pd.product_id in (1267) and pd.doc_id = cc.docid and pd.doc_id = cd.docid and pd.doc_id = cld.docid and pd.doc_id = cp.docid and cp.parent= clf.folderid and cld.lang = cc.lang and cld.lang = clf.lang and cld.lang = cl.id and pd.type = 0 and cd.doctype = 'main_document' and cat.name = cd.search_doctype and cld.active = 1 and cd.active = 1 and cd.checked = 1 and cl.active = 1 and (cc.lang='en' OR cc.lang='en') and contentlabel like '*%' and content!='' order by cl.id, cd.importance desc, search_doctype, cd.docid asc, lang_sort desc, contentid asc No database selected
