Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- article.ID_entity,
- article.ID,
- article_attrs.ID AS attrs_ID,
- article_content.ID AS content_ID,
- article_attrs.ID_category,
- article_cat.ID AS cat_ID,
- article_cat.name AS cat_name,
- article_cat.name_url AS cat_name_url,
- article_ent.posix_owner,
- article_ent.ID_author AS posix_author,
- article_ent.visits,
- article_ent.sources,
- article_ent.metadata,
- article_content.ID_editor AS posix_editor,
- article_content.datetime_create AS content_datetime_create,
- article_attrs.datetime_start,
- article_attrs.datetime_stop,
- article_content.datetime_modified,
- article_attrs.priority_A,
- article_attrs.priority_B,
- article_attrs.priority_C,
- article_attrs.name,
- article_attrs.name_url,
- article_attrs.name_hyphens,
- article_attrs.alias_url,
- article_content.subtitle,
- article_content.subtitle_hyphens,
- article_content.mimetype,
- article_content.abstract,
- article_content.abstract_hyphens,
- article_content.body,
- article_content.body_hyphens,
- article_content.keywords,
- article_content.lng,
- IF(
- round((`article_ent`.rating_score / `article_ent`.rating_votes),2),
- round((`article_ent`.rating_score / `article_ent`.rating_votes),2), '0.00'
- ) as rating,
- rating_score,
- rating_votes,
- article_ent.published_mark,
- article_ent.visits,
- article_attrs.status,
- IF
- (
- (
- article.status LIKE 'Y' AND
- article_attrs.status LIKE 'Y'
- ),
- 'Y', 'U'
- ) AS status_all,
- `ACL_world`.`perm_R` AS status_world
- FROM muziker_com.a401_article_ent AS article_ent
- INNER JOIN muziker_com.a401_article AS article ON
- (
- article_ent.ID_entity = article.ID_entity
- )
- INNER JOIN muziker_com.a401_article_attrs AS article_attrs ON
- (
- article_attrs.ID_entity = article.ID AND
- article_attrs.status IN ('Y',',','N',',','L',',','W') AND
- article_attrs.lng = 'sk'
- )
- INNER JOIN muziker_com.a401_article_content AS article_content ON
- (
- article_content.ID_entity = article.ID_entity AND
- article_content.status = 'Y' AND
- article_content.lng = article_attrs.lng
- )
- INNER JOIN muziker_com.a401_article_cat AS article_cat ON
- (
- article_cat.ID = article_attrs.ID_category
- )
- LEFT JOIN muziker_com.a301_ACL_user_group AS ACL_world ON
- (
- ACL_world.ID_entity = 0 AND
- r_prefix = 'a401' AND
- r_table = 'article' AND
- r_ID_entity = article.ID_entity
- )
- WHERE
- article_ent.status = 'Y'
- AND article.status = 'Y'
- AND article.ID_entity=84
- ORDER BY
- article_attrs.datetime_start DESC
- LIMIT
- 1
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement