Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT art.id,art_data.last_comment_event_date,art.article_type_id,art.category_id,art.creator,art.modifier,art.news_event_date,art.name,art.meta_data,
- art_type.code,art_type.name as type_name,art_type.category_root_id,
- art_data.title_pub,art_data.body_html_pub,art_data.body_plain_pub,art_data.culture,art_data.status_id,
- art.user_name,art.user_email,art.user_phone,art.thumbnail,art.user_site
- FROM cm_articles AS art
- JOIN cm_article_types AS art_type
- ON art.article_type_id = art_type.id
- JOIN cm_article_data AS art_data
- ON art.id = art_data.article_id
- WHERE
- art.id in (SELECT art.id
- FROM cm_articles AS art
- JOIN cm_article_types AS art_type
- ON art.article_type_id = art_type.id
- JOIN cm_article_data AS art_data
- ON art.id = art_data.article_id
- WHERE
- art_data.status_id=3 AND
- art_type.code = 'FinancialNews' AND
- art_data.culture = 'bg-BG')
- ORDER BY art_data.last_comment_event_date DESC, art.news_event_date DESC
- LIMIT 5
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement