Advertisement
Guest User

Untitled

a guest
Sep 26th, 2016
69
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 2.60 KB | None | 0 0
  1.  
  2.         SELECT
  3.  
  4.             article.ID_entity,
  5.             article.ID,
  6.             article_attrs.ID AS attrs_ID,
  7.             article_content.ID AS content_ID,
  8.  
  9.             article_attrs.ID_category,
  10.             article_cat.ID AS cat_ID,
  11.             article_cat.name AS cat_name,
  12.             article_cat.name_url AS cat_name_url,
  13.  
  14.             article_ent.posix_owner,
  15.             article_ent.ID_author AS posix_author,
  16.             article_ent.visits,
  17.             article_ent.sources,
  18.             article_ent.metadata,
  19.             article_content.ID_editor AS posix_editor,
  20.  
  21.             article_content.datetime_create AS content_datetime_create,
  22.             article_attrs.datetime_start,
  23.             article_attrs.datetime_stop,
  24.             article_content.datetime_modified,
  25.  
  26.             article_attrs.priority_A,
  27.             article_attrs.priority_B,
  28.             article_attrs.priority_C,
  29.  
  30.             article_attrs.name,
  31.             article_attrs.name_url,
  32.             article_attrs.name_hyphens,
  33.             article_attrs.alias_url,
  34.  
  35.             article_content.subtitle,
  36.             article_content.subtitle_hyphens,
  37.             article_content.mimetype,
  38.             article_content.abstract,
  39.             article_content.abstract_hyphens,
  40.             article_content.body,
  41.             article_content.body_hyphens,
  42.             article_content.keywords,
  43.             article_content.lng,
  44.  
  45.             IF(
  46.                 round((`article_ent`.rating_score / `article_ent`.rating_votes),2),
  47.                 round((`article_ent`.rating_score / `article_ent`.rating_votes),2), '0.00'
  48.             ) as rating,
  49.             rating_score,
  50.             rating_votes,
  51.             article_ent.published_mark,
  52.             article_ent.visits,
  53.  
  54.             article_attrs.status,
  55.  
  56.             IF
  57.             (
  58.                 (
  59.                     article.status LIKE 'Y' AND
  60.                     article_attrs.status LIKE 'Y'
  61.                 ),
  62.                 'Y', 'U'
  63.             ) AS status_all,
  64.  
  65.             `ACL_world`.`perm_R` AS status_world
  66.  
  67.         FROM muziker_com.a401_article_ent AS article_ent
  68.         INNER JOIN muziker_com.a401_article AS article ON
  69.         (
  70.             article_ent.ID_entity = article.ID_entity
  71.         )
  72.         INNER JOIN muziker_com.a401_article_attrs AS article_attrs ON
  73.         (
  74.             article_attrs.ID_entity = article.ID AND
  75.             article_attrs.status IN ('Y',',','N',',','L',',','W') AND
  76.             article_attrs.lng = 'sk'
  77.         )
  78.         INNER JOIN muziker_com.a401_article_content AS article_content ON
  79.         (
  80.             article_content.ID_entity = article.ID_entity AND
  81.             article_content.status = 'Y' AND
  82.             article_content.lng = article_attrs.lng
  83.         )
  84.         INNER JOIN muziker_com.a401_article_cat AS article_cat ON
  85.         (
  86.             article_cat.ID = article_attrs.ID_category
  87.         )
  88.         LEFT JOIN muziker_com.a301_ACL_user_group AS ACL_world ON
  89.         (
  90.             ACL_world.ID_entity = 0 AND
  91.             r_prefix = 'a401' AND
  92.             r_table = 'article' AND
  93.             r_ID_entity = article.ID_entity
  94.         )
  95.         WHERE
  96.             article_ent.status = 'Y'
  97.             AND article.status = 'Y'
  98.             AND article.ID_entity=84
  99.         ORDER BY
  100.             article_attrs.datetime_start DESC
  101.         LIMIT
  102.             1
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement