Advertisement
Guest User

Untitled

a guest
Apr 17th, 2019
125
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 1.02 KB | None | 0 0
  1.     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,
  2.     art_type.code,art_type.name as type_name,art_type.category_root_id,
  3.     art_data.title_pub,art_data.body_html_pub,art_data.body_plain_pub,art_data.culture,art_data.status_id,
  4.     art.user_name,art.user_email,art.user_phone,art.thumbnail,art.user_site
  5.     FROM cm_articles AS art
  6.     JOIN cm_article_types AS art_type
  7.     ON art.article_type_id = art_type.id
  8.     JOIN cm_article_data AS art_data
  9.     ON art.id = art_data.article_id
  10.     WHERE
  11.        art.id in (SELECT  art.id
  12.             FROM cm_articles AS art
  13.             JOIN cm_article_types AS art_type
  14.             ON art.article_type_id = art_type.id
  15.             JOIN cm_article_data AS art_data
  16.             ON art.id = art_data.article_id
  17.             WHERE
  18.                art_data.status_id=3 AND
  19.                art_type.code = 'FinancialNews' AND
  20.                art_data.culture = 'bg-BG')
  21.       ORDER BY art_data.last_comment_event_date DESC, art.news_event_date DESC
  22.       LIMIT 5
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement