| cache_article_search | | struct | | 04FDB333B18D2FB628EC102891DC068E | | query [short version] | | Query Source: | SQL Query | | Datasource: | SCIDEV_PRODUCTION | | Query: | select
distinct
a.id,
a.status_id,
a.type_id,
a.canonical_section_id,
a.created_at,
a.publish_at,
a.created_by,
a.author,
a.source,
a.editor_notes,
a.citations,
a.affiliation,
at.name as type,
at.slug as type_slug,
atr.language_id,
atr.status_id as translation_status_id,
atr.translation_type_id,
atr.title,
atr.slug,
atr.blurb,
atr.body,
case
when ifnull(af.file_name,'') <> '' then af.file_name
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then kd.document_url
else ''
end as keydocument_url,
case
when ifnull(af.file_name,'') <> '' then 'file'
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then 'url'
else ''
end as keydocument_type,
kd.publication_date,
ifnull(ali.link_url,'') as link_url
,
sa.is_highlighted,
sa.display_order,
sa.section_id
,
ats.en_slug,
ats.en_transtypeid,
ats.fr_slug,
ats.fr_transtypeid,
ats.zh_slug,
ats.zh_transtypeid,
ats.es_slug,
ats.es_transtypeid,
ats.po_slug,
ats.po_transtypeid,
ats.ar_slug,
ats.ar_transtypeid
,'' AS section_slug
,'' AS sub_section_slug
,'' AS canonical_link
from
articles a
inner join
article_translations atr
on atr.article_id = a.id
and atr.language_id =
?
and atr.status_id = 2
inner join
article_types at
on a.type_id = at.id
inner join
article_statuses ast
on ast.id = a.status_id
inner join
users u
on u.id = a.created_by
left outer join
sections_articles sa
on sa.article_id = a.id
and sa.section_id = ?
left outer join
article_links ali
on ali.article_id = a.id
left outer join
article_files af
on af.article_id = a.id
left outer join
key_documents kd
on kd.article_id = a.id
inner join
article_translation_slugs ats
on ats.article_id = a.id
where
1=1
and a.status_id = ?
and a.type_id IN (?,?)
and a.type_id NOT IN (?)
and sa.section_id = ?
and a.is_deleted = ?
and (
a.expire_at > now()
or a.expire_at is null
or a.expire_at = '0000-00-00 00:00:00'
)
and a.publish_at <= now()
order by
a.publish_at desc
limit
?,
? | | Time: | 125 ms | | Records: | 20 | | Columns: | id, status_id, type_id, canonical_section_id, created_at, publish_at, created_by
author, source, editor_notes, citations, affiliation, type
type_slug, language_id, translation_status_id, translation_type_id, title, slug
blurb, body, keydocument_url, keydocument_type, publication_date, link_url
is_highlighted, display_order, section_id, en_slug, en_transtypeid, fr_slug
fr_transtypeid, zh_slug, zh_transtypeid, es_slug, es_transtypeid, po_slug
po_transtypeid, ar_slug, ar_transtypeid, section_slug, sub_section_slug, canonical_link
|
| | 07378D9D73CFF57B2AB4927448D2850D | | query [short version] | | Query Source: | SQL Query | | Datasource: | SCIDEV_PRODUCTION | | Query: | select
distinct
a.id,
a.status_id,
a.type_id,
a.canonical_section_id,
a.created_at,
a.publish_at,
a.created_by,
a.author,
a.source,
a.editor_notes,
a.citations,
a.affiliation,
at.name as type,
at.slug as type_slug,
atr.language_id,
atr.status_id as translation_status_id,
atr.translation_type_id,
atr.title,
atr.slug,
atr.blurb,
atr.body,
case
when ifnull(af.file_name,'') <> '' then af.file_name
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then kd.document_url
else ''
end as keydocument_url,
case
when ifnull(af.file_name,'') <> '' then 'file'
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then 'url'
else ''
end as keydocument_type,
kd.publication_date,
ifnull(ali.link_url,'') as link_url
,
sa.is_highlighted,
sa.display_order,
sa.section_id
,
ats.en_slug,
ats.en_transtypeid,
ats.fr_slug,
ats.fr_transtypeid,
ats.zh_slug,
ats.zh_transtypeid,
ats.es_slug,
ats.es_transtypeid,
ats.po_slug,
ats.po_transtypeid,
ats.ar_slug,
ats.ar_transtypeid
,'' AS section_slug
,'' AS sub_section_slug
,'' AS canonical_link
from
articles a
inner join
article_translations atr
on atr.article_id = a.id
and atr.language_id =
?
and atr.status_id = 2
inner join
article_types at
on a.type_id = at.id
inner join
article_statuses ast
on ast.id = a.status_id
inner join
users u
on u.id = a.created_by
left outer join
sections_articles sa
on sa.article_id = a.id
and sa.section_id = ?
left outer join
article_links ali
on ali.article_id = a.id
left outer join
article_files af
on af.article_id = a.id
left outer join
key_documents kd
on kd.article_id = a.id
inner join
article_translation_slugs ats
on ats.article_id = a.id
where
1=1
and a.status_id = ?
and a.type_id IN (?)
and a.type_id NOT IN (?)
and sa.section_id = ?
and a.is_deleted = ?
and (
a.expire_at > now()
or a.expire_at is null
or a.expire_at = '0000-00-00 00:00:00'
)
and a.publish_at <= now()
order by
a.publish_at desc
limit
?,
? | | Time: | 15 ms | | Records: | 0 | | Columns: | id, status_id, type_id, canonical_section_id, created_at, publish_at, created_by
author, source, editor_notes, citations, affiliation, type
type_slug, language_id, translation_status_id, translation_type_id, title, slug
blurb, body, keydocument_url, keydocument_type, publication_date, link_url
is_highlighted, display_order, section_id, en_slug, en_transtypeid, fr_slug
fr_transtypeid, zh_slug, zh_transtypeid, es_slug, es_transtypeid, po_slug
po_transtypeid, ar_slug, ar_transtypeid, section_slug, sub_section_slug, canonical_link
|
| | 0B661D0C79D486A9A4122EE0EE44D249 | | query [short version] | | Query Source: | SQL Query | | Datasource: | SCIDEV_PRODUCTION | | Query: | select
distinct
a.id,
a.status_id,
a.type_id,
a.canonical_section_id,
a.created_at,
a.publish_at,
a.created_by,
a.author,
a.source,
a.editor_notes,
a.citations,
a.affiliation,
at.name as type,
at.slug as type_slug,
atr.language_id,
atr.status_id as translation_status_id,
atr.translation_type_id,
atr.title,
atr.slug,
atr.blurb,
atr.body,
case
when ifnull(af.file_name,'') <> '' then af.file_name
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then kd.document_url
else ''
end as keydocument_url,
case
when ifnull(af.file_name,'') <> '' then 'file'
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then 'url'
else ''
end as keydocument_type,
kd.publication_date,
ifnull(ali.link_url,'') as link_url
,
sa.is_highlighted,
sa.display_order,
sa.section_id
,
ats.en_slug,
ats.en_transtypeid,
ats.fr_slug,
ats.fr_transtypeid,
ats.zh_slug,
ats.zh_transtypeid,
ats.es_slug,
ats.es_transtypeid,
ats.po_slug,
ats.po_transtypeid,
ats.ar_slug,
ats.ar_transtypeid
,'' AS section_slug
,'' AS sub_section_slug
,'' AS canonical_link
from
articles a
inner join
article_translations atr
on atr.article_id = a.id
and atr.language_id =
?
and atr.status_id = 2
inner join
article_types at
on a.type_id = at.id
inner join
article_statuses ast
on ast.id = a.status_id
inner join
users u
on u.id = a.created_by
left outer join
sections_articles sa
on sa.article_id = a.id
and sa.section_id = ?
left outer join
article_links ali
on ali.article_id = a.id
left outer join
article_files af
on af.article_id = a.id
left outer join
key_documents kd
on kd.article_id = a.id
inner join
article_translation_slugs ats
on ats.article_id = a.id
where
1=1
and a.status_id = ?
and a.type_id IN (?,?)
and a.type_id NOT IN (?)
and sa.section_id = ?
and a.is_deleted = ?
and (
a.expire_at > now()
or a.expire_at is null
or a.expire_at = '0000-00-00 00:00:00'
)
and a.publish_at <= now()
order by
a.publish_at desc
limit
?,
? | | Time: | 15 ms | | Records: | 20 | | Columns: | id, status_id, type_id, canonical_section_id, created_at, publish_at, created_by
author, source, editor_notes, citations, affiliation, type
type_slug, language_id, translation_status_id, translation_type_id, title, slug
blurb, body, keydocument_url, keydocument_type, publication_date, link_url
is_highlighted, display_order, section_id, en_slug, en_transtypeid, fr_slug
fr_transtypeid, zh_slug, zh_transtypeid, es_slug, es_transtypeid, po_slug
po_transtypeid, ar_slug, ar_transtypeid, section_slug, sub_section_slug, canonical_link
|
| | 0C02872D2FB78C03691F37B551FDA1DB | | query [short version] | | Query Source: | SQL Query | | Datasource: | SCIDEV_PRODUCTION | | Query: | select
distinct
a.id,
a.status_id,
a.type_id,
a.canonical_section_id,
a.created_at,
a.publish_at,
a.created_by,
a.author,
a.source,
a.editor_notes,
a.citations,
a.affiliation,
at.name as type,
at.slug as type_slug,
atr.language_id,
atr.status_id as translation_status_id,
atr.translation_type_id,
atr.title,
atr.slug,
atr.blurb,
atr.body,
case
when ifnull(af.file_name,'') <> '' then af.file_name
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then kd.document_url
else ''
end as keydocument_url,
case
when ifnull(af.file_name,'') <> '' then 'file'
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then 'url'
else ''
end as keydocument_type,
kd.publication_date,
ifnull(ali.link_url,'') as link_url
,
sa.is_highlighted,
sa.display_order,
sa.section_id
,
ats.en_slug,
ats.en_transtypeid,
ats.fr_slug,
ats.fr_transtypeid,
ats.zh_slug,
ats.zh_transtypeid,
ats.es_slug,
ats.es_transtypeid,
ats.po_slug,
ats.po_transtypeid,
ats.ar_slug,
ats.ar_transtypeid
,'' AS section_slug
,'' AS sub_section_slug
,'' AS canonical_link
from
articles a
inner join
article_translations atr
on atr.article_id = a.id
and atr.language_id =
?
and atr.status_id = 2
inner join
article_types at
on a.type_id = at.id
inner join
article_statuses ast
on ast.id = a.status_id
inner join
users u
on u.id = a.created_by
left outer join
sections_articles sa
on sa.article_id = a.id
and sa.section_id = ?
left outer join
article_links ali
on ali.article_id = a.id
left outer join
article_files af
on af.article_id = a.id
left outer join
key_documents kd
on kd.article_id = a.id
inner join
article_translation_slugs ats
on ats.article_id = a.id
where
1=1
and a.status_id = ?
and a.type_id IN (?)
and a.type_id NOT IN (?)
and sa.section_id = ?
and a.is_deleted = ?
and (
a.expire_at > now()
or a.expire_at is null
or a.expire_at = '0000-00-00 00:00:00'
)
and a.publish_at <= now()
order by
a.publish_at desc
limit
?,
? | | Time: | 32 ms | | Records: | 0 | | Columns: | id, status_id, type_id, canonical_section_id, created_at, publish_at, created_by
author, source, editor_notes, citations, affiliation, type
type_slug, language_id, translation_status_id, translation_type_id, title, slug
blurb, body, keydocument_url, keydocument_type, publication_date, link_url
is_highlighted, display_order, section_id, en_slug, en_transtypeid, fr_slug
fr_transtypeid, zh_slug, zh_transtypeid, es_slug, es_transtypeid, po_slug
po_transtypeid, ar_slug, ar_transtypeid, section_slug, sub_section_slug, canonical_link
|
| | 1172233A15407EBB64B369FC7D690059 | | query [short version] | | Query Source: | SQL Query | | Datasource: | SCIDEV_PRODUCTION | | Query: | select
distinct
a.id,
a.status_id,
a.type_id,
a.canonical_section_id,
a.created_at,
a.publish_at,
a.created_by,
a.author,
a.source,
a.editor_notes,
a.citations,
a.affiliation,
at.name as type,
at.slug as type_slug,
atr.language_id,
atr.status_id as translation_status_id,
atr.translation_type_id,
atr.title,
atr.slug,
atr.blurb,
atr.body,
case
when ifnull(af.file_name,'') <> '' then af.file_name
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then kd.document_url
else ''
end as keydocument_url,
case
when ifnull(af.file_name,'') <> '' then 'file'
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then 'url'
else ''
end as keydocument_type,
kd.publication_date,
ifnull(ali.link_url,'') as link_url
,
sa.is_highlighted,
sa.display_order,
sa.section_id
,
ats.en_slug,
ats.en_transtypeid,
ats.fr_slug,
ats.fr_transtypeid,
ats.zh_slug,
ats.zh_transtypeid,
ats.es_slug,
ats.es_transtypeid,
ats.po_slug,
ats.po_transtypeid,
ats.ar_slug,
ats.ar_transtypeid
,'' AS section_slug
,'' AS sub_section_slug
,'' AS canonical_link
from
articles a
inner join
article_translations atr
on atr.article_id = a.id
and atr.language_id =
?
and atr.status_id = 2
inner join
article_types at
on a.type_id = at.id
inner join
article_statuses ast
on ast.id = a.status_id
inner join
users u
on u.id = a.created_by
left outer join
sections_articles sa
on sa.article_id = a.id
and sa.section_id = ?
left outer join
article_links ali
on ali.article_id = a.id
left outer join
article_files af
on af.article_id = a.id
left outer join
key_documents kd
on kd.article_id = a.id
inner join
article_translation_slugs ats
on ats.article_id = a.id
where
1=1
and a.status_id = ?
and a.type_id IN (?,?)
and a.type_id NOT IN (?)
and sa.section_id = ?
and a.is_deleted = ?
and (
a.expire_at > now()
or a.expire_at is null
or a.expire_at = '0000-00-00 00:00:00'
)
and a.publish_at <= now()
order by
a.publish_at desc
limit
?,
? | | Time: | 46 ms | | Records: | 20 | | Columns: | id, status_id, type_id, canonical_section_id, created_at, publish_at, created_by
author, source, editor_notes, citations, affiliation, type
type_slug, language_id, translation_status_id, translation_type_id, title, slug
blurb, body, keydocument_url, keydocument_type, publication_date, link_url
is_highlighted, display_order, section_id, en_slug, en_transtypeid, fr_slug
fr_transtypeid, zh_slug, zh_transtypeid, es_slug, es_transtypeid, po_slug
po_transtypeid, ar_slug, ar_transtypeid, section_slug, sub_section_slug, canonical_link
|
| | 15A3C67262C187A9AEC4F0CB995CFB35 | | query [short version] | | Query Source: | SQL Query | | Datasource: | SCIDEV_PRODUCTION | | Query: | select
distinct
a.id,
a.status_id,
a.type_id,
a.canonical_section_id,
a.created_at,
a.publish_at,
a.created_by,
a.author,
a.source,
a.editor_notes,
a.citations,
a.affiliation,
at.name as type,
at.slug as type_slug,
atr.language_id,
atr.status_id as translation_status_id,
atr.translation_type_id,
atr.title,
atr.slug,
atr.blurb,
atr.body,
case
when ifnull(af.file_name,'') <> '' then af.file_name
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then kd.document_url
else ''
end as keydocument_url,
case
when ifnull(af.file_name,'') <> '' then 'file'
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then 'url'
else ''
end as keydocument_type,
kd.publication_date,
ifnull(ali.link_url,'') as link_url
,
sa.is_highlighted,
sa.display_order,
sa.section_id
,
ats.en_slug,
ats.en_transtypeid,
ats.fr_slug,
ats.fr_transtypeid,
ats.zh_slug,
ats.zh_transtypeid,
ats.es_slug,
ats.es_transtypeid,
ats.po_slug,
ats.po_transtypeid,
ats.ar_slug,
ats.ar_transtypeid
,
n.start_at,
n.end_at,
n.close_at,
nt.information_url,
n.contact_details,
nt.location,
nt.organisation_name,
nt.organisation_url
,'' AS section_slug
,'' AS sub_section_slug
,'' AS canonical_link
from
articles a
inner join
article_translations atr
on atr.article_id = a.id
and atr.language_id =
?
and atr.status_id = 2
inner join
article_types at
on a.type_id = at.id
inner join
article_statuses ast
on ast.id = a.status_id
inner join
users u
on u.id = a.created_by
left outer join
sections_articles sa
on sa.article_id = a.id
and sa.section_id = ?
left outer join
article_links ali
on ali.article_id = a.id
left outer join
article_files af
on af.article_id = a.id
left outer join
key_documents kd
on kd.article_id = a.id
left outer join
notices n
on n.article_id = a.id
left outer join
notice_translations nt
on nt.article_id = n.article_id
and nt.language_id =
?
inner join
article_translation_slugs ats
on ats.article_id = a.id
where
1=1
and a.status_id = ?
and a.type_id IN (?)
and a.type_id NOT IN (?)
and sa.section_id = ?
and a.is_deleted = ?
and (
a.expire_at > now()
or a.expire_at is null
or a.expire_at = '0000-00-00 00:00:00'
)
and a.publish_at <= now()
order by
a.publish_at desc
limit
?,
? | | Time: | 47 ms | | Records: | 0 | | Columns: | id, status_id, type_id, canonical_section_id, created_at, publish_at, created_by
author, source, editor_notes, citations, affiliation, type
type_slug, language_id, translation_status_id, translation_type_id, title, slug
blurb, body, keydocument_url, keydocument_type, publication_date, link_url
is_highlighted, display_order, section_id, en_slug, en_transtypeid, fr_slug
fr_transtypeid, zh_slug, zh_transtypeid, es_slug, es_transtypeid, po_slug
po_transtypeid, ar_slug, ar_transtypeid, start_at, end_at, close_at
information_url, contact_details, location, organisation_name, organisation_url, section_slug
sub_section_slug, canonical_link |
| | 1AC68BBB672C5C8B15C4B3FE62B3427E | | query [short version] | | Query Source: | SQL Query | | Datasource: | SCIDEV_PRODUCTION | | Query: | select
distinct
a.id,
a.status_id,
a.type_id,
a.canonical_section_id,
a.created_at,
a.publish_at,
a.created_by,
a.author,
a.source,
a.editor_notes,
a.citations,
a.affiliation,
at.name as type,
at.slug as type_slug,
atr.language_id,
atr.status_id as translation_status_id,
atr.translation_type_id,
atr.title,
atr.slug,
atr.blurb,
atr.body,
case
when ifnull(af.file_name,'') <> '' then af.file_name
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then kd.document_url
else ''
end as keydocument_url,
case
when ifnull(af.file_name,'') <> '' then 'file'
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then 'url'
else ''
end as keydocument_type,
kd.publication_date,
ifnull(ali.link_url,'') as link_url
,
sa.is_highlighted,
sa.display_order,
sa.section_id
,
a.is_deleted,
a.publish_at,
a.expire_at,
a.updated_at,
a.updated_by,
a.is_paid,
u.firstname,
u.lastname,
u.email
,
(select language_id from article_translations atr_temp where atr_temp.article_id = a.id and is_original = 1 limit 1) as original_language_id
,
ast.name as status_name
,'' AS section_slug
,'' AS sub_section_slug
,'' AS canonical_link
from
articles a
inner join
article_translations atr
on atr.article_id = a.id
and atr.language_id =
?
inner join
article_types at
on a.type_id = at.id
inner join
article_statuses ast
on ast.id = a.status_id
inner join
users u
on u.id = a.created_by
left outer join
sections_articles sa
on sa.article_id = a.id
and sa.section_id = ?
left outer join
sections_articles sla
on sla.article_id = a.id
and sla.section_id = ?
left outer join
article_links ali
on ali.article_id = a.id
left outer join
article_files af
on af.article_id = a.id
left outer join
key_documents kd
on kd.article_id = a.id
where
1=1
and a.status_id = ?
and a.type_id IN (?)
and sa.section_id = ?
and sla.section_id = ?
and a.is_deleted = ?
and (
a.expire_at > now()
or a.expire_at is null
or a.expire_at = '0000-00-00 00:00:00'
)
and a.publish_at <= now()
order by
a.publish_at desc
limit
?,
? | | Time: | 16 ms | | Records: | 8 | | Columns: | id, status_id, type_id, canonical_section_id, created_at, publish_at, created_by
author, source, editor_notes, citations, affiliation, type
type_slug, language_id, translation_status_id, translation_type_id, title, slug
blurb, body, keydocument_url, keydocument_type, publication_date, link_url
is_highlighted, display_order, section_id, is_deleted, publish_at, expire_at
updated_at, updated_by, is_paid, firstname, lastname, email
original_language_id, status_name, section_slug, sub_section_slug, canonical_link |
| | 1C9A29B587FDFFB9F2CD60BA759944BA | | query [short version] | | Query Source: | SQL Query | | Datasource: | SCIDEV_PRODUCTION | | Query: | select
distinct
a.id,
a.status_id,
a.type_id,
a.canonical_section_id,
a.created_at,
a.publish_at,
a.created_by,
a.author,
a.source,
a.editor_notes,
a.citations,
a.affiliation,
at.name as type,
at.slug as type_slug,
atr.language_id,
atr.status_id as translation_status_id,
atr.translation_type_id,
atr.title,
atr.slug,
atr.blurb,
atr.body,
case
when ifnull(af.file_name,'') <> '' then af.file_name
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then kd.document_url
else ''
end as keydocument_url,
case
when ifnull(af.file_name,'') <> '' then 'file'
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then 'url'
else ''
end as keydocument_type,
kd.publication_date,
ifnull(ali.link_url,'') as link_url
,
sa.is_highlighted,
sa.display_order,
sa.section_id
,
ats.en_slug,
ats.en_transtypeid,
ats.fr_slug,
ats.fr_transtypeid,
ats.zh_slug,
ats.zh_transtypeid,
ats.es_slug,
ats.es_transtypeid,
ats.po_slug,
ats.po_transtypeid,
ats.ar_slug,
ats.ar_transtypeid
,
n.start_at,
n.end_at,
n.close_at,
nt.information_url,
n.contact_details,
nt.location,
nt.organisation_name,
nt.organisation_url
,'' AS section_slug
,'' AS sub_section_slug
,'' AS canonical_link
from
articles a
inner join
article_translations atr
on atr.article_id = a.id
and atr.language_id =
?
and atr.status_id = 2
inner join
article_types at
on a.type_id = at.id
inner join
article_statuses ast
on ast.id = a.status_id
inner join
users u
on u.id = a.created_by
left outer join
sections_articles sa
on sa.article_id = a.id
and sa.section_id = ?
left outer join
article_links ali
on ali.article_id = a.id
left outer join
article_files af
on af.article_id = a.id
left outer join
key_documents kd
on kd.article_id = a.id
left outer join
notices n
on n.article_id = a.id
left outer join
notice_translations nt
on nt.article_id = n.article_id
and nt.language_id =
?
inner join
article_translation_slugs ats
on ats.article_id = a.id
where
1=1
and a.status_id = ?
and a.type_id IN (?)
and a.type_id NOT IN (?)
and sa.section_id = ?
and a.is_deleted = ?
and (
a.expire_at > now()
or a.expire_at is null
or a.expire_at = '0000-00-00 00:00:00'
)
and a.publish_at <= now()
order by
a.publish_at desc
limit
?,
? | | Time: | 16 ms | | Records: | 0 | | Columns: | id, status_id, type_id, canonical_section_id, created_at, publish_at, created_by
author, source, editor_notes, citations, affiliation, type
type_slug, language_id, translation_status_id, translation_type_id, title, slug
blurb, body, keydocument_url, keydocument_type, publication_date, link_url
is_highlighted, display_order, section_id, en_slug, en_transtypeid, fr_slug
fr_transtypeid, zh_slug, zh_transtypeid, es_slug, es_transtypeid, po_slug
po_transtypeid, ar_slug, ar_transtypeid, start_at, end_at, close_at
information_url, contact_details, location, organisation_name, organisation_url, section_slug
sub_section_slug, canonical_link |
| | 1CA13C85E749D18DD31FAF7A02F8E4DA | | query [short version] | | Query Source: | SQL Query | | Datasource: | SCIDEV_PRODUCTION | | Query: | select
distinct
a.id,
a.status_id,
a.type_id,
a.canonical_section_id,
a.created_at,
a.publish_at,
a.created_by,
a.author,
a.source,
a.editor_notes,
a.citations,
a.affiliation,
at.name as type,
at.slug as type_slug,
atr.language_id,
atr.status_id as translation_status_id,
atr.translation_type_id,
atr.title,
atr.slug,
atr.blurb,
atr.body,
case
when ifnull(af.file_name,'') <> '' then af.file_name
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then kd.document_url
else ''
end as keydocument_url,
case
when ifnull(af.file_name,'') <> '' then 'file'
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then 'url'
else ''
end as keydocument_type,
kd.publication_date,
ifnull(ali.link_url,'') as link_url
,
sa.is_highlighted,
sa.display_order,
sa.section_id
,
ats.en_slug,
ats.en_transtypeid,
ats.fr_slug,
ats.fr_transtypeid,
ats.zh_slug,
ats.zh_transtypeid,
ats.es_slug,
ats.es_transtypeid,
ats.po_slug,
ats.po_transtypeid,
ats.ar_slug,
ats.ar_transtypeid
,'' AS section_slug
,'' AS sub_section_slug
,'' AS canonical_link
from
articles a
inner join
article_translations atr
on atr.article_id = a.id
and atr.language_id =
?
and atr.status_id = 2
inner join
article_types at
on a.type_id = at.id
inner join
article_statuses ast
on ast.id = a.status_id
inner join
users u
on u.id = a.created_by
left outer join
sections_articles sa
on sa.article_id = a.id
and sa.section_id = ?
left outer join
article_links ali
on ali.article_id = a.id
left outer join
article_files af
on af.article_id = a.id
left outer join
key_documents kd
on kd.article_id = a.id
inner join
article_translation_slugs ats
on ats.article_id = a.id
where
1=1
and a.status_id = ?
and a.type_id IN (?)
and a.type_id NOT IN (?)
and sa.section_id = ?
and a.is_deleted = ?
and (
a.expire_at > now()
or a.expire_at is null
or a.expire_at = '0000-00-00 00:00:00'
)
and a.publish_at <= now()
order by
a.publish_at desc
limit
?,
? | | Time: | 110 ms | | Records: | 20 | | Columns: | id, status_id, type_id, canonical_section_id, created_at, publish_at, created_by
author, source, editor_notes, citations, affiliation, type
type_slug, language_id, translation_status_id, translation_type_id, title, slug
blurb, body, keydocument_url, keydocument_type, publication_date, link_url
is_highlighted, display_order, section_id, en_slug, en_transtypeid, fr_slug
fr_transtypeid, zh_slug, zh_transtypeid, es_slug, es_transtypeid, po_slug
po_transtypeid, ar_slug, ar_transtypeid, section_slug, sub_section_slug, canonical_link
|
| | 1CCCEE9B30F9FC434C44C9A277606311 | | query [short version] | | Query Source: | SQL Query | | Datasource: | SCIDEV_PRODUCTION | | Query: | select
distinct
a.id,
a.status_id,
a.type_id,
a.canonical_section_id,
a.created_at,
a.publish_at,
a.created_by,
a.author,
a.source,
a.editor_notes,
a.citations,
a.affiliation,
at.name as type,
at.slug as type_slug,
atr.language_id,
atr.status_id as translation_status_id,
atr.translation_type_id,
atr.title,
atr.slug,
atr.blurb,
atr.body,
case
when ifnull(af.file_name,'') <> '' then af.file_name
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then kd.document_url
else ''
end as keydocument_url,
case
when ifnull(af.file_name,'') <> '' then 'file'
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then 'url'
else ''
end as keydocument_type,
kd.publication_date,
ifnull(ali.link_url,'') as link_url
,
sa.is_highlighted,
sa.display_order,
sa.section_id
,
ats.en_slug,
ats.en_transtypeid,
ats.fr_slug,
ats.fr_transtypeid,
ats.zh_slug,
ats.zh_transtypeid,
ats.es_slug,
ats.es_transtypeid,
ats.po_slug,
ats.po_transtypeid,
ats.ar_slug,
ats.ar_transtypeid
,'' AS section_slug
,'' AS sub_section_slug
,'' AS canonical_link
from
articles a
inner join
article_translations atr
on atr.article_id = a.id
and atr.language_id =
?
and atr.status_id = 2
inner join
article_types at
on a.type_id = at.id
inner join
article_statuses ast
on ast.id = a.status_id
inner join
users u
on u.id = a.created_by
left outer join
sections_articles sa
on sa.article_id = a.id
and sa.section_id = ?
left outer join
article_links ali
on ali.article_id = a.id
left outer join
article_files af
on af.article_id = a.id
left outer join
key_documents kd
on kd.article_id = a.id
inner join
article_translation_slugs ats
on ats.article_id = a.id
where
1=1
and a.status_id = ?
and a.type_id IN (?)
and a.type_id NOT IN (?)
and sa.section_id = ?
and a.is_deleted = ?
and (
a.expire_at > now()
or a.expire_at is null
or a.expire_at = '0000-00-00 00:00:00'
)
and a.publish_at <= now()
order by
a.publish_at desc
limit
?,
? | | Time: | 125 ms | | Records: | 20 | | Columns: | id, status_id, type_id, canonical_section_id, created_at, publish_at, created_by
author, source, editor_notes, citations, affiliation, type
type_slug, language_id, translation_status_id, translation_type_id, title, slug
blurb, body, keydocument_url, keydocument_type, publication_date, link_url
is_highlighted, display_order, section_id, en_slug, en_transtypeid, fr_slug
fr_transtypeid, zh_slug, zh_transtypeid, es_slug, es_transtypeid, po_slug
po_transtypeid, ar_slug, ar_transtypeid, section_slug, sub_section_slug, canonical_link
|
| | 1FF1926DB3ED66E3BE7B1EB7D8398215 | | query [short version] | | Query Source: | SQL Query | | Datasource: | SCIDEV_PRODUCTION | | Query: | select
distinct
a.id,
a.status_id,
a.type_id,
a.canonical_section_id,
a.created_at,
a.publish_at,
a.created_by,
a.author,
a.source,
a.editor_notes,
a.citations,
a.affiliation,
at.name as type,
at.slug as type_slug,
atr.language_id,
atr.status_id as translation_status_id,
atr.translation_type_id,
atr.title,
atr.slug,
atr.blurb,
atr.body,
case
when ifnull(af.file_name,'') <> '' then af.file_name
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then kd.document_url
else ''
end as keydocument_url,
case
when ifnull(af.file_name,'') <> '' then 'file'
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then 'url'
else ''
end as keydocument_type,
kd.publication_date,
ifnull(ali.link_url,'') as link_url
,
sa.is_highlighted,
sa.display_order,
sa.section_id
,
ats.en_slug,
ats.en_transtypeid,
ats.fr_slug,
ats.fr_transtypeid,
ats.zh_slug,
ats.zh_transtypeid,
ats.es_slug,
ats.es_transtypeid,
ats.po_slug,
ats.po_transtypeid,
ats.ar_slug,
ats.ar_transtypeid
,'' AS section_slug
,'' AS sub_section_slug
,'' AS canonical_link
from
articles a
inner join
article_translations atr
on atr.article_id = a.id
and atr.language_id =
?
and atr.status_id = 2
inner join
article_types at
on a.type_id = at.id
inner join
article_statuses ast
on ast.id = a.status_id
inner join
users u
on u.id = a.created_by
left outer join
sections_articles sa
on sa.article_id = a.id
and sa.section_id = ?
left outer join
article_links ali
on ali.article_id = a.id
left outer join
article_files af
on af.article_id = a.id
left outer join
key_documents kd
on kd.article_id = a.id
inner join
article_translation_slugs ats
on ats.article_id = a.id
where
1=1
and a.status_id = ?
and a.type_id IN (?)
and a.type_id NOT IN (?)
and sa.section_id = ?
and a.is_deleted = ?
and (
a.expire_at > now()
or a.expire_at is null
or a.expire_at = '0000-00-00 00:00:00'
)
and a.publish_at <= now()
order by
a.publish_at desc
limit
?,
? | | Time: | 47 ms | | Records: | 2 | | Columns: | id, status_id, type_id, canonical_section_id, created_at, publish_at, created_by
author, source, editor_notes, citations, affiliation, type
type_slug, language_id, translation_status_id, translation_type_id, title, slug
blurb, body, keydocument_url, keydocument_type, publication_date, link_url
is_highlighted, display_order, section_id, en_slug, en_transtypeid, fr_slug
fr_transtypeid, zh_slug, zh_transtypeid, es_slug, es_transtypeid, po_slug
po_transtypeid, ar_slug, ar_transtypeid, section_slug, sub_section_slug, canonical_link
|
| | 2170FA7B7D9A34C5E51E1F6B1A9DCFF6 | | query [short version] | | Query Source: | SQL Query | | Datasource: | SCIDEV_PRODUCTION | | Query: | select
distinct
a.id,
a.status_id,
a.type_id,
a.canonical_section_id,
a.created_at,
a.publish_at,
a.created_by,
a.author,
a.source,
a.editor_notes,
a.citations,
a.affiliation,
at.name as type,
at.slug as type_slug,
atr.language_id,
atr.status_id as translation_status_id,
atr.translation_type_id,
atr.title,
atr.slug,
atr.blurb,
atr.body,
case
when ifnull(af.file_name,'') <> '' then af.file_name
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then kd.document_url
else ''
end as keydocument_url,
case
when ifnull(af.file_name,'') <> '' then 'file'
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then 'url'
else ''
end as keydocument_type,
kd.publication_date,
ifnull(ali.link_url,'') as link_url
,
sa.is_highlighted,
sa.display_order,
sa.section_id
,
ats.en_slug,
ats.en_transtypeid,
ats.fr_slug,
ats.fr_transtypeid,
ats.zh_slug,
ats.zh_transtypeid,
ats.es_slug,
ats.es_transtypeid,
ats.po_slug,
ats.po_transtypeid,
ats.ar_slug,
ats.ar_transtypeid
,'' AS section_slug
,'' AS sub_section_slug
,'' AS canonical_link
from
articles a
inner join
article_translations atr
on atr.article_id = a.id
and atr.language_id =
?
and atr.status_id = 2
inner join
article_types at
on a.type_id = at.id
inner join
article_statuses ast
on ast.id = a.status_id
inner join
users u
on u.id = a.created_by
left outer join
sections_articles sa
on sa.article_id = a.id
and sa.section_id = ?
left outer join
article_links ali
on ali.article_id = a.id
left outer join
article_files af
on af.article_id = a.id
left outer join
key_documents kd
on kd.article_id = a.id
inner join
article_translation_slugs ats
on ats.article_id = a.id
where
1=1
and a.status_id = ?
and a.type_id IN (?)
and a.type_id NOT IN (?)
and sa.section_id = ?
and a.is_deleted = ?
and (
a.expire_at > now()
or a.expire_at is null
or a.expire_at = '0000-00-00 00:00:00'
)
and a.publish_at <= now()
order by
a.publish_at desc
limit
?,
? | | Time: | 94 ms | | Records: | 0 | | Columns: | id, status_id, type_id, canonical_section_id, created_at, publish_at, created_by
author, source, editor_notes, citations, affiliation, type
type_slug, language_id, translation_status_id, translation_type_id, title, slug
blurb, body, keydocument_url, keydocument_type, publication_date, link_url
is_highlighted, display_order, section_id, en_slug, en_transtypeid, fr_slug
fr_transtypeid, zh_slug, zh_transtypeid, es_slug, es_transtypeid, po_slug
po_transtypeid, ar_slug, ar_transtypeid, section_slug, sub_section_slug, canonical_link
|
| | 22D74B2691C76D44A2ADB3D07E76C867 | | query [short version] | | Query Source: | Query of Queries | | Records: | 20 | | Columns: | id, slug, type, type_slug, title, blurb, publish_at
ar_slug, ar_transtypeid, es_slug, en_slug, en_transtypeid, es_slug
es_transtypeid, fr_slug, fr_transtypeid, po_slug, po_transtypeid, zh_slug
zh_transtypeid, source, author, section_slug, sub_section_slug, canonical_link
|
| | 244A9120F4E53CE2BB466B66FAD7590F | | query [short version] | | Query Source: | SQL Query | | Datasource: | SCIDEV_PRODUCTION | | Query: | select
distinct
a.id,
a.status_id,
a.type_id,
a.canonical_section_id,
a.created_at,
a.publish_at,
a.created_by,
a.author,
a.source,
a.editor_notes,
a.citations,
a.affiliation,
at.name as type,
at.slug as type_slug,
atr.language_id,
atr.status_id as translation_status_id,
atr.translation_type_id,
atr.title,
atr.slug,
atr.blurb,
atr.body,
case
when ifnull(af.file_name,'') <> '' then af.file_name
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then kd.document_url
else ''
end as keydocument_url,
case
when ifnull(af.file_name,'') <> '' then 'file'
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then 'url'
else ''
end as keydocument_type,
kd.publication_date,
ifnull(ali.link_url,'') as link_url
,
sa.is_highlighted,
sa.display_order,
sa.section_id
,
ats.en_slug,
ats.en_transtypeid,
ats.fr_slug,
ats.fr_transtypeid,
ats.zh_slug,
ats.zh_transtypeid,
ats.es_slug,
ats.es_transtypeid,
ats.po_slug,
ats.po_transtypeid,
ats.ar_slug,
ats.ar_transtypeid
,'' AS section_slug
,'' AS sub_section_slug
,'' AS canonical_link
from
articles a
inner join
article_translations atr
on atr.article_id = a.id
and atr.language_id =
?
and atr.status_id = 2
inner join
article_types at
on a.type_id = at.id
inner join
article_statuses ast
on ast.id = a.status_id
inner join
users u
on u.id = a.created_by
left outer join
sections_articles sa
on sa.article_id = a.id
and sa.section_id = ?
left outer join
article_links ali
on ali.article_id = a.id
left outer join
article_files af
on af.article_id = a.id
left outer join
key_documents kd
on kd.article_id = a.id
inner join
article_translation_slugs ats
on ats.article_id = a.id
where
1=1
and a.status_id = ?
and a.type_id IN (?)
and a.type_id NOT IN (?)
and sa.section_id = ?
and a.is_deleted = ?
and (
a.expire_at > now()
or a.expire_at is null
or a.expire_at = '0000-00-00 00:00:00'
)
and a.publish_at <= now()
order by
a.publish_at desc
limit
?,
? | | Time: | 47 ms | | Records: | 0 | | Columns: | id, status_id, type_id, canonical_section_id, created_at, publish_at, created_by
author, source, editor_notes, citations, affiliation, type
type_slug, language_id, translation_status_id, translation_type_id, title, slug
blurb, body, keydocument_url, keydocument_type, publication_date, link_url
is_highlighted, display_order, section_id, en_slug, en_transtypeid, fr_slug
fr_transtypeid, zh_slug, zh_transtypeid, es_slug, es_transtypeid, po_slug
po_transtypeid, ar_slug, ar_transtypeid, section_slug, sub_section_slug, canonical_link
|
| | 273C3F2D4B4C3CC82421E334CA6B72A3 | | query [short version] | | Query Source: | SQL Query | | Datasource: | SCIDEV_PRODUCTION | | Query: | select
distinct
a.id,
a.status_id,
a.type_id,
a.canonical_section_id,
a.created_at,
a.publish_at,
a.created_by,
a.author,
a.source,
a.editor_notes,
a.citations,
a.affiliation,
at.name as type,
at.slug as type_slug,
atr.language_id,
atr.status_id as translation_status_id,
atr.translation_type_id,
atr.title,
atr.slug,
atr.blurb,
atr.body,
case
when ifnull(af.file_name,'') <> '' then af.file_name
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then kd.document_url
else ''
end as keydocument_url,
case
when ifnull(af.file_name,'') <> '' then 'file'
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then 'url'
else ''
end as keydocument_type,
kd.publication_date,
ifnull(ali.link_url,'') as link_url
,
sa.is_highlighted,
sa.display_order,
sa.section_id
,
ats.en_slug,
ats.en_transtypeid,
ats.fr_slug,
ats.fr_transtypeid,
ats.zh_slug,
ats.zh_transtypeid,
ats.es_slug,
ats.es_transtypeid,
ats.po_slug,
ats.po_transtypeid,
ats.ar_slug,
ats.ar_transtypeid
,'' AS section_slug
,'' AS sub_section_slug
,'' AS canonical_link
from
articles a
inner join
article_translations atr
on atr.article_id = a.id
and atr.language_id =
?
and atr.status_id = 2
inner join
article_types at
on a.type_id = at.id
inner join
article_statuses ast
on ast.id = a.status_id
inner join
users u
on u.id = a.created_by
left outer join
sections_articles sa
on sa.article_id = a.id
and sa.section_id = ?
left outer join
article_links ali
on ali.article_id = a.id
left outer join
article_files af
on af.article_id = a.id
left outer join
key_documents kd
on kd.article_id = a.id
inner join
article_translation_slugs ats
on ats.article_id = a.id
where
1=1
and a.status_id = ?
and a.type_id IN (?)
and a.type_id NOT IN (?)
and sa.section_id = ?
and a.is_deleted = ?
and (
a.expire_at > now()
or a.expire_at is null
or a.expire_at = '0000-00-00 00:00:00'
)
and a.publish_at <= now()
order by
a.publish_at desc
limit
?,
? | | Time: | 0 ms | | Records: | 4 | | Columns: | id, status_id, type_id, canonical_section_id, created_at, publish_at, created_by
author, source, editor_notes, citations, affiliation, type
type_slug, language_id, translation_status_id, translation_type_id, title, slug
blurb, body, keydocument_url, keydocument_type, publication_date, link_url
is_highlighted, display_order, section_id, en_slug, en_transtypeid, fr_slug
fr_transtypeid, zh_slug, zh_transtypeid, es_slug, es_transtypeid, po_slug
po_transtypeid, ar_slug, ar_transtypeid, section_slug, sub_section_slug, canonical_link
|
| | 27A1935D0F196ADBB4D8709BE98638B5 | | query [short version] | | Query Source: | SQL Query | | Datasource: | SCIDEV_PRODUCTION | | Query: | select
distinct
a.id,
a.status_id,
a.type_id,
a.canonical_section_id,
a.created_at,
a.publish_at,
a.created_by,
a.author,
a.source,
a.editor_notes,
a.citations,
a.affiliation,
at.name as type,
at.slug as type_slug,
atr.language_id,
atr.status_id as translation_status_id,
atr.translation_type_id,
atr.title,
atr.slug,
atr.blurb,
atr.body,
case
when ifnull(af.file_name,'') <> '' then af.file_name
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then kd.document_url
else ''
end as keydocument_url,
case
when ifnull(af.file_name,'') <> '' then 'file'
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then 'url'
else ''
end as keydocument_type,
kd.publication_date,
ifnull(ali.link_url,'') as link_url
,
sa.is_highlighted,
sa.display_order,
sa.section_id
,
ats.en_slug,
ats.en_transtypeid,
ats.fr_slug,
ats.fr_transtypeid,
ats.zh_slug,
ats.zh_transtypeid,
ats.es_slug,
ats.es_transtypeid,
ats.po_slug,
ats.po_transtypeid,
ats.ar_slug,
ats.ar_transtypeid
,'' AS section_slug
,'' AS sub_section_slug
,'' AS canonical_link
from
articles a
inner join
article_translations atr
on atr.article_id = a.id
and atr.language_id =
?
and atr.status_id = 2
inner join
article_types at
on a.type_id = at.id
inner join
article_statuses ast
on ast.id = a.status_id
inner join
users u
on u.id = a.created_by
left outer join
sections_articles sa
on sa.article_id = a.id
and sa.section_id = ?
left outer join
article_links ali
on ali.article_id = a.id
left outer join
article_files af
on af.article_id = a.id
left outer join
key_documents kd
on kd.article_id = a.id
inner join
article_translation_slugs ats
on ats.article_id = a.id
where
1=1
and a.status_id = ?
and a.type_id IN (?)
and a.type_id NOT IN (?)
and sa.section_id = ?
and a.is_deleted = ?
and (
a.expire_at > now()
or a.expire_at is null
or a.expire_at = '0000-00-00 00:00:00'
)
and a.publish_at <= now()
order by
a.publish_at desc
limit
?,
? | | Time: | 31 ms | | Records: | 0 | | Columns: | id, status_id, type_id, canonical_section_id, created_at, publish_at, created_by
author, source, editor_notes, citations, affiliation, type
type_slug, language_id, translation_status_id, translation_type_id, title, slug
blurb, body, keydocument_url, keydocument_type, publication_date, link_url
is_highlighted, display_order, section_id, en_slug, en_transtypeid, fr_slug
fr_transtypeid, zh_slug, zh_transtypeid, es_slug, es_transtypeid, po_slug
po_transtypeid, ar_slug, ar_transtypeid, section_slug, sub_section_slug, canonical_link
|
| | 2811EF4D8A750686ECC27064422C682C | | query [short version] | | Query Source: | SQL Query | | Datasource: | SCIDEV_PRODUCTION | | Query: | select
count(distinct a.id) as count
from
articles a
inner join
article_translations atr
on atr.article_id = a.id
and atr.language_id =
?
and atr.status_id = 2
inner join
article_types at
on a.type_id = at.id
inner join
article_statuses ast
on ast.id = a.status_id
inner join
users u
on u.id = a.created_by
left outer join
sections_articles sa
on sa.article_id = a.id
and sa.section_id = ?
left outer join
article_links ali
on ali.article_id = a.id
left outer join
article_files af
on af.article_id = a.id
left outer join
key_documents kd
on kd.article_id = a.id
inner join
article_translation_slugs ats
on ats.article_id = a.id
where
1=1
and a.status_id = ?
and a.type_id IN (?)
and a.type_id NOT IN (?)
and sa.section_id = ?
and a.is_deleted = ?
and (
a.expire_at > now()
or a.expire_at is null
or a.expire_at = '0000-00-00 00:00:00'
)
and a.publish_at <= now()
order by
a.publish_at desc | | Time: | 0 ms | | Records: | 1 | | Columns: | count |
| | 2A16BC711384279766935DC042CF58FD | | query [short version] | | Query Source: | SQL Query | | Datasource: | SCIDEV_PRODUCTION | | Query: | select
distinct
a.id,
a.status_id,
a.type_id,
a.canonical_section_id,
a.created_at,
a.publish_at,
a.created_by,
a.author,
a.source,
a.editor_notes,
a.citations,
a.affiliation,
at.name as type,
at.slug as type_slug,
atr.language_id,
atr.status_id as translation_status_id,
atr.translation_type_id,
atr.title,
atr.slug,
atr.blurb,
atr.body,
case
when ifnull(af.file_name,'') <> '' then af.file_name
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then kd.document_url
else ''
end as keydocument_url,
case
when ifnull(af.file_name,'') <> '' then 'file'
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then 'url'
else ''
end as keydocument_type,
kd.publication_date,
ifnull(ali.link_url,'') as link_url
,
sa.is_highlighted,
sa.display_order,
sa.section_id
,
ats.en_slug,
ats.en_transtypeid,
ats.fr_slug,
ats.fr_transtypeid,
ats.zh_slug,
ats.zh_transtypeid,
ats.es_slug,
ats.es_transtypeid,
ats.po_slug,
ats.po_transtypeid,
ats.ar_slug,
ats.ar_transtypeid
,'' AS section_slug
,'' AS sub_section_slug
,'' AS canonical_link
from
articles a
inner join
article_translations atr
on atr.article_id = a.id
and atr.language_id =
?
and atr.status_id = 2
inner join
article_types at
on a.type_id = at.id
inner join
article_statuses ast
on ast.id = a.status_id
inner join
users u
on u.id = a.created_by
left outer join
sections_articles sa
on sa.article_id = a.id
and sa.section_id = ?
left outer join
article_links ali
on ali.article_id = a.id
left outer join
article_files af
on af.article_id = a.id
left outer join
key_documents kd
on kd.article_id = a.id
inner join
article_translation_slugs ats
on ats.article_id = a.id
where
1=1
and a.status_id = ?
and a.type_id IN (?)
and a.type_id NOT IN (?)
and sa.section_id = ?
and a.is_deleted = ?
and (
a.expire_at > now()
or a.expire_at is null
or a.expire_at = '0000-00-00 00:00:00'
)
and a.publish_at <= now()
order by
a.publish_at desc
limit
?,
? | | Time: | 16 ms | | Records: | 0 | | Columns: | id, status_id, type_id, canonical_section_id, created_at, publish_at, created_by
author, source, editor_notes, citations, affiliation, type
type_slug, language_id, translation_status_id, translation_type_id, title, slug
blurb, body, keydocument_url, keydocument_type, publication_date, link_url
is_highlighted, display_order, section_id, en_slug, en_transtypeid, fr_slug
fr_transtypeid, zh_slug, zh_transtypeid, es_slug, es_transtypeid, po_slug
po_transtypeid, ar_slug, ar_transtypeid, section_slug, sub_section_slug, canonical_link
|
| | 2E8ADB9D30FF9B222EC441E09EBF93B8 | | query [short version] | | Query Source: | SQL Query | | Datasource: | SCIDEV_PRODUCTION | | Query: | select
distinct
a.id,
a.status_id,
a.type_id,
a.canonical_section_id,
a.created_at,
a.publish_at,
a.created_by,
a.author,
a.source,
a.editor_notes,
a.citations,
a.affiliation,
at.name as type,
at.slug as type_slug,
atr.language_id,
atr.status_id as translation_status_id,
atr.translation_type_id,
atr.title,
atr.slug,
atr.blurb,
atr.body,
case
when ifnull(af.file_name,'') <> '' then af.file_name
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then kd.document_url
else ''
end as keydocument_url,
case
when ifnull(af.file_name,'') <> '' then 'file'
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then 'url'
else ''
end as keydocument_type,
kd.publication_date,
ifnull(ali.link_url,'') as link_url
,
sa.is_highlighted,
sa.display_order,
sa.section_id
,
ats.en_slug,
ats.en_transtypeid,
ats.fr_slug,
ats.fr_transtypeid,
ats.zh_slug,
ats.zh_transtypeid,
ats.es_slug,
ats.es_transtypeid,
ats.po_slug,
ats.po_transtypeid,
ats.ar_slug,
ats.ar_transtypeid
,'' AS section_slug
,'' AS sub_section_slug
,'' AS canonical_link
from
articles a
inner join
article_translations atr
on atr.article_id = a.id
and atr.language_id =
?
and atr.status_id = 2
inner join
article_types at
on a.type_id = at.id
inner join
article_statuses ast
on ast.id = a.status_id
inner join
users u
on u.id = a.created_by
left outer join
sections_articles sa
on sa.article_id = a.id
and sa.section_id = ?
left outer join
article_links ali
on ali.article_id = a.id
left outer join
article_files af
on af.article_id = a.id
left outer join
key_documents kd
on kd.article_id = a.id
inner join
article_translation_slugs ats
on ats.article_id = a.id
where
1=1
and a.status_id = ?
and a.type_id IN (?)
and a.type_id NOT IN (?)
and sa.section_id = ?
and a.is_deleted = ?
and (
a.expire_at > now()
or a.expire_at is null
or a.expire_at = '0000-00-00 00:00:00'
)
and a.publish_at <= now()
order by
a.publish_at desc
limit
?,
? | | Time: | 47 ms | | Records: | 20 | | Columns: | id, status_id, type_id, canonical_section_id, created_at, publish_at, created_by
author, source, editor_notes, citations, affiliation, type
type_slug, language_id, translation_status_id, translation_type_id, title, slug
blurb, body, keydocument_url, keydocument_type, publication_date, link_url
is_highlighted, display_order, section_id, en_slug, en_transtypeid, fr_slug
fr_transtypeid, zh_slug, zh_transtypeid, es_slug, es_transtypeid, po_slug
po_transtypeid, ar_slug, ar_transtypeid, section_slug, sub_section_slug, canonical_link
|
| | 329F568C3DE7D0B4C52498D9DBECB351 | | query [short version] | | Query Source: | SQL Query | | Datasource: | SCIDEV_PRODUCTION | | Query: | select
distinct
a.id,
a.status_id,
a.type_id,
a.canonical_section_id,
a.created_at,
a.publish_at,
a.created_by,
a.author,
a.source,
a.editor_notes,
a.citations,
a.affiliation,
at.name as type,
at.slug as type_slug,
atr.language_id,
atr.status_id as translation_status_id,
atr.translation_type_id,
atr.title,
atr.slug,
atr.blurb,
atr.body,
case
when ifnull(af.file_name,'') <> '' then af.file_name
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then kd.document_url
else ''
end as keydocument_url,
case
when ifnull(af.file_name,'') <> '' then 'file'
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then 'url'
else ''
end as keydocument_type,
kd.publication_date,
ifnull(ali.link_url,'') as link_url
,
sa.is_highlighted,
sa.display_order,
sa.section_id
,
ats.en_slug,
ats.en_transtypeid,
ats.fr_slug,
ats.fr_transtypeid,
ats.zh_slug,
ats.zh_transtypeid,
ats.es_slug,
ats.es_transtypeid,
ats.po_slug,
ats.po_transtypeid,
ats.ar_slug,
ats.ar_transtypeid
,'' AS section_slug
,'' AS sub_section_slug
,'' AS canonical_link
from
articles a
inner join
article_translations atr
on atr.article_id = a.id
and atr.language_id =
?
and atr.status_id = 2
inner join
article_types at
on a.type_id = at.id
inner join
article_statuses ast
on ast.id = a.status_id
inner join
users u
on u.id = a.created_by
left outer join
sections_articles sa
on sa.article_id = a.id
and sa.section_id = ?
left outer join
article_links ali
on ali.article_id = a.id
left outer join
article_files af
on af.article_id = a.id
left outer join
key_documents kd
on kd.article_id = a.id
inner join
article_translation_slugs ats
on ats.article_id = a.id
where
1=1
and a.status_id = ?
and a.type_id IN (?)
and a.type_id NOT IN (?)
and sa.section_id = ?
and a.is_deleted = ?
and (
a.expire_at > now()
or a.expire_at is null
or a.expire_at = '0000-00-00 00:00:00'
)
and a.publish_at <= now()
order by
a.publish_at desc
limit
?,
? | | Time: | 78 ms | | Records: | 20 | | Columns: | id, status_id, type_id, canonical_section_id, created_at, publish_at, created_by
author, source, editor_notes, citations, affiliation, type
type_slug, language_id, translation_status_id, translation_type_id, title, slug
blurb, body, keydocument_url, keydocument_type, publication_date, link_url
is_highlighted, display_order, section_id, en_slug, en_transtypeid, fr_slug
fr_transtypeid, zh_slug, zh_transtypeid, es_slug, es_transtypeid, po_slug
po_transtypeid, ar_slug, ar_transtypeid, section_slug, sub_section_slug, canonical_link
|
| | 390356EB75C13C3FFEBE8576893DB521 | | query [short version] | | Query Source: | SQL Query | | Datasource: | SCIDEV_PRODUCTION | | Query: | select
distinct
a.id,
a.status_id,
a.type_id,
a.canonical_section_id,
a.created_at,
a.publish_at,
a.created_by,
a.author,
a.source,
a.editor_notes,
a.citations,
a.affiliation,
at.name as type,
at.slug as type_slug,
atr.language_id,
atr.status_id as translation_status_id,
atr.translation_type_id,
atr.title,
atr.slug,
atr.blurb,
atr.body,
case
when ifnull(af.file_name,'') <> '' then af.file_name
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then kd.document_url
else ''
end as keydocument_url,
case
when ifnull(af.file_name,'') <> '' then 'file'
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then 'url'
else ''
end as keydocument_type,
kd.publication_date,
ifnull(ali.link_url,'') as link_url
,
sa.is_highlighted,
sa.display_order,
sa.section_id
,
a.is_deleted,
a.publish_at,
a.expire_at,
a.updated_at,
a.updated_by,
a.is_paid,
u.firstname,
u.lastname,
u.email
,
(select language_id from article_translations atr_temp where atr_temp.article_id = a.id and is_original = 1 limit 1) as original_language_id
,
ast.name as status_name
,'' AS section_slug
,'' AS sub_section_slug
,'' AS canonical_link
from
articles a
inner join
article_translations atr
on atr.article_id = a.id
and atr.language_id =
?
inner join
article_types at
on a.type_id = at.id
inner join
article_statuses ast
on ast.id = a.status_id
inner join
users u
on u.id = a.created_by
left outer join
sections_articles sa
on sa.article_id = a.id
and sa.section_id = ?
left outer join
article_links ali
on ali.article_id = a.id
left outer join
article_files af
on af.article_id = a.id
left outer join
key_documents kd
on kd.article_id = a.id
where
1=1
and a.status_id = ?
and a.type_id IN (?)
and sa.section_id = ?
and a.is_deleted = ?
and (
a.expire_at > now()
or a.expire_at is null
or a.expire_at = '0000-00-00 00:00:00'
)
and a.publish_at <= now()
order by
a.publish_at desc
limit
?,
? | | Time: | 47 ms | | Records: | 1 | | Columns: | id, status_id, type_id, canonical_section_id, created_at, publish_at, created_by
author, source, editor_notes, citations, affiliation, type
type_slug, language_id, translation_status_id, translation_type_id, title, slug
blurb, body, keydocument_url, keydocument_type, publication_date, link_url
is_highlighted, display_order, section_id, is_deleted, publish_at, expire_at
updated_at, updated_by, is_paid, firstname, lastname, email
original_language_id, status_name, section_slug, sub_section_slug, canonical_link |
| | 39DEE2C1168D2FD42F0D85094EAD3BAC | | query [short version] | | Query Source: | SQL Query | | Datasource: | SCIDEV_PRODUCTION | | Query: | select
distinct
a.id,
a.status_id,
a.type_id,
a.canonical_section_id,
a.created_at,
a.publish_at,
a.created_by,
a.author,
a.source,
a.editor_notes,
a.citations,
a.affiliation,
at.name as type,
at.slug as type_slug,
atr.language_id,
atr.status_id as translation_status_id,
atr.translation_type_id,
atr.title,
atr.slug,
atr.blurb,
atr.body,
case
when ifnull(af.file_name,'') <> '' then af.file_name
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then kd.document_url
else ''
end as keydocument_url,
case
when ifnull(af.file_name,'') <> '' then 'file'
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then 'url'
else ''
end as keydocument_type,
kd.publication_date,
ifnull(ali.link_url,'') as link_url
,
sa.is_highlighted,
sa.display_order,
sa.section_id
,
a.is_deleted,
a.publish_at,
a.expire_at,
a.updated_at,
a.updated_by,
a.is_paid,
u.firstname,
u.lastname,
u.email
,
(select language_id from article_translations atr_temp where atr_temp.article_id = a.id and is_original = 1 limit 1) as original_language_id
,
ast.name as status_name
,'' AS section_slug
,'' AS sub_section_slug
,'' AS canonical_link
from
articles a
inner join
article_translations atr
on atr.article_id = a.id
and atr.language_id =
?
inner join
article_types at
on a.type_id = at.id
inner join
article_statuses ast
on ast.id = a.status_id
inner join
users u
on u.id = a.created_by
left outer join
sections_articles sa
on sa.article_id = a.id
and sa.section_id = ?
left outer join
article_links ali
on ali.article_id = a.id
left outer join
article_files af
on af.article_id = a.id
left outer join
key_documents kd
on kd.article_id = a.id
where
1=1
and a.status_id = ?
and a.type_id IN (?)
and sa.section_id = ?
and a.is_deleted = ?
and (
a.expire_at > now()
or a.expire_at is null
or a.expire_at = '0000-00-00 00:00:00'
)
and a.publish_at <= now()
order by
a.publish_at desc
limit
?,
? | | Time: | 62 ms | | Records: | 0 | | Columns: | id, status_id, type_id, canonical_section_id, created_at, publish_at, created_by
author, source, editor_notes, citations, affiliation, type
type_slug, language_id, translation_status_id, translation_type_id, title, slug
blurb, body, keydocument_url, keydocument_type, publication_date, link_url
is_highlighted, display_order, section_id, is_deleted, publish_at, expire_at
updated_at, updated_by, is_paid, firstname, lastname, email
original_language_id, status_name, section_slug, sub_section_slug, canonical_link |
| | 3B08D18203BDBC44CD6069F1560A7FC3 | | query [short version] | | Query Source: | SQL Query | | Datasource: | SCIDEV_PRODUCTION | | Query: | select
distinct
a.id,
a.status_id,
a.type_id,
a.canonical_section_id,
a.created_at,
a.publish_at,
a.created_by,
a.author,
a.source,
a.editor_notes,
a.citations,
a.affiliation,
at.name as type,
at.slug as type_slug,
atr.language_id,
atr.status_id as translation_status_id,
atr.translation_type_id,
atr.title,
atr.slug,
atr.blurb,
atr.body,
case
when ifnull(af.file_name,'') <> '' then af.file_name
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then kd.document_url
else ''
end as keydocument_url,
case
when ifnull(af.file_name,'') <> '' then 'file'
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then 'url'
else ''
end as keydocument_type,
kd.publication_date,
ifnull(ali.link_url,'') as link_url
,
sa.is_highlighted,
sa.display_order,
sa.section_id
,
ats.en_slug,
ats.en_transtypeid,
ats.fr_slug,
ats.fr_transtypeid,
ats.zh_slug,
ats.zh_transtypeid,
ats.es_slug,
ats.es_transtypeid,
ats.po_slug,
ats.po_transtypeid,
ats.ar_slug,
ats.ar_transtypeid
,'' AS section_slug
,'' AS sub_section_slug
,'' AS canonical_link
from
articles a
inner join
article_translations atr
on atr.article_id = a.id
and atr.language_id =
?
and atr.status_id = 2
inner join
article_types at
on a.type_id = at.id
inner join
article_statuses ast
on ast.id = a.status_id
inner join
users u
on u.id = a.created_by
left outer join
sections_articles sa
on sa.article_id = a.id
and sa.section_id = ?
left outer join
article_links ali
on ali.article_id = a.id
left outer join
article_files af
on af.article_id = a.id
left outer join
key_documents kd
on kd.article_id = a.id
inner join
article_translation_slugs ats
on ats.article_id = a.id
where
1=1
and a.status_id = ?
and a.type_id IN (?)
and a.type_id NOT IN (?)
and sa.section_id = ?
and a.is_deleted = ?
and (
a.expire_at > now()
or a.expire_at is null
or a.expire_at = '0000-00-00 00:00:00'
)
and a.publish_at <= now()
order by
a.publish_at desc
limit
?,
? | | Time: | 610 ms | | Records: | 20 | | Columns: | id, status_id, type_id, canonical_section_id, created_at, publish_at, created_by
author, source, editor_notes, citations, affiliation, type
type_slug, language_id, translation_status_id, translation_type_id, title, slug
blurb, body, keydocument_url, keydocument_type, publication_date, link_url
is_highlighted, display_order, section_id, en_slug, en_transtypeid, fr_slug
fr_transtypeid, zh_slug, zh_transtypeid, es_slug, es_transtypeid, po_slug
po_transtypeid, ar_slug, ar_transtypeid, section_slug, sub_section_slug, canonical_link
|
| | 3D3AA371CA8D72BF24910A908C957B26 | | query [short version] | | Query Source: | SQL Query | | Datasource: | SCIDEV_PRODUCTION | | Query: | select
distinct
a.id,
a.status_id,
a.type_id,
a.canonical_section_id,
a.created_at,
a.publish_at,
a.created_by,
a.author,
a.source,
a.editor_notes,
a.citations,
a.affiliation,
at.name as type,
at.slug as type_slug,
atr.language_id,
atr.status_id as translation_status_id,
atr.translation_type_id,
atr.title,
atr.slug,
atr.blurb,
atr.body,
case
when ifnull(af.file_name,'') <> '' then af.file_name
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then kd.document_url
else ''
end as keydocument_url,
case
when ifnull(af.file_name,'') <> '' then 'file'
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then 'url'
else ''
end as keydocument_type,
kd.publication_date,
ifnull(ali.link_url,'') as link_url
,
sa.is_highlighted,
sa.display_order,
sa.section_id
,
ats.en_slug,
ats.en_transtypeid,
ats.fr_slug,
ats.fr_transtypeid,
ats.zh_slug,
ats.zh_transtypeid,
ats.es_slug,
ats.es_transtypeid,
ats.po_slug,
ats.po_transtypeid,
ats.ar_slug,
ats.ar_transtypeid
,'' AS section_slug
,'' AS sub_section_slug
,'' AS canonical_link
from
articles a
inner join
article_translations atr
on atr.article_id = a.id
and atr.language_id =
?
and atr.status_id = 2
inner join
article_types at
on a.type_id = at.id
inner join
article_statuses ast
on ast.id = a.status_id
inner join
users u
on u.id = a.created_by
left outer join
sections_articles sa
on sa.article_id = a.id
and sa.section_id = ?
left outer join
article_links ali
on ali.article_id = a.id
left outer join
article_files af
on af.article_id = a.id
left outer join
key_documents kd
on kd.article_id = a.id
inner join
article_translation_slugs ats
on ats.article_id = a.id
where
1=1
and a.status_id = ?
and a.type_id IN (?)
and a.type_id NOT IN (?)
and sa.section_id = ?
and a.is_deleted = ?
and (
a.expire_at > now()
or a.expire_at is null
or a.expire_at = '0000-00-00 00:00:00'
)
and a.publish_at <= now()
order by
a.publish_at desc
limit
?,
? | | Time: | 16 ms | | Records: | 20 | | Columns: | id, status_id, type_id, canonical_section_id, created_at, publish_at, created_by
author, source, editor_notes, citations, affiliation, type
type_slug, language_id, translation_status_id, translation_type_id, title, slug
blurb, body, keydocument_url, keydocument_type, publication_date, link_url
is_highlighted, display_order, section_id, en_slug, en_transtypeid, fr_slug
fr_transtypeid, zh_slug, zh_transtypeid, es_slug, es_transtypeid, po_slug
po_transtypeid, ar_slug, ar_transtypeid, section_slug, sub_section_slug, canonical_link
|
| | 3DE0C2938C55561CE4DA097078CBB766 | | query [short version] | | Query Source: | SQL Query | | Datasource: | SCIDEV_PRODUCTION | | Query: | select
distinct
a.id,
a.status_id,
a.type_id,
a.canonical_section_id,
a.created_at,
a.publish_at,
a.created_by,
a.author,
a.source,
a.editor_notes,
a.citations,
a.affiliation,
at.name as type,
at.slug as type_slug,
atr.language_id,
atr.status_id as translation_status_id,
atr.translation_type_id,
atr.title,
atr.slug,
atr.blurb,
atr.body,
case
when ifnull(af.file_name,'') <> '' then af.file_name
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then kd.document_url
else ''
end as keydocument_url,
case
when ifnull(af.file_name,'') <> '' then 'file'
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then 'url'
else ''
end as keydocument_type,
kd.publication_date,
ifnull(ali.link_url,'') as link_url
,
sa.is_highlighted,
sa.display_order,
sa.section_id
,
ats.en_slug,
ats.en_transtypeid,
ats.fr_slug,
ats.fr_transtypeid,
ats.zh_slug,
ats.zh_transtypeid,
ats.es_slug,
ats.es_transtypeid,
ats.po_slug,
ats.po_transtypeid,
ats.ar_slug,
ats.ar_transtypeid
,'' AS section_slug
,'' AS sub_section_slug
,'' AS canonical_link
from
articles a
inner join
article_translations atr
on atr.article_id = a.id
and atr.language_id =
?
and atr.status_id = 2
inner join
article_types at
on a.type_id = at.id
inner join
article_statuses ast
on ast.id = a.status_id
inner join
users u
on u.id = a.created_by
left outer join
sections_articles sa
on sa.article_id = a.id
and sa.section_id = ?
left outer join
article_links ali
on ali.article_id = a.id
left outer join
article_files af
on af.article_id = a.id
left outer join
key_documents kd
on kd.article_id = a.id
inner join
article_translation_slugs ats
on ats.article_id = a.id
where
1=1
and a.status_id = ?
and a.type_id IN (?)
and a.type_id NOT IN (?)
and sa.section_id = ?
and a.is_deleted = ?
and (
a.expire_at > now()
or a.expire_at is null
or a.expire_at = '0000-00-00 00:00:00'
)
and a.publish_at <= now()
order by
a.publish_at desc
limit
?,
? | | Time: | 16 ms | | Records: | 20 | | Columns: | id, status_id, type_id, canonical_section_id, created_at, publish_at, created_by
author, source, editor_notes, citations, affiliation, type
type_slug, language_id, translation_status_id, translation_type_id, title, slug
blurb, body, keydocument_url, keydocument_type, publication_date, link_url
is_highlighted, display_order, section_id, en_slug, en_transtypeid, fr_slug
fr_transtypeid, zh_slug, zh_transtypeid, es_slug, es_transtypeid, po_slug
po_transtypeid, ar_slug, ar_transtypeid, section_slug, sub_section_slug, canonical_link
|
| | 4343E6E882BCA65F1AA6D503E528946D | | query [short version] | | Query Source: | SQL Query | | Datasource: | SCIDEV_PRODUCTION | | Query: | select
count(distinct a.id) as count
from
articles a
inner join
article_translations atr
on atr.article_id = a.id
and atr.language_id =
?
and atr.status_id = 2
inner join
article_types at
on a.type_id = at.id
inner join
article_statuses ast
on ast.id = a.status_id
inner join
users u
on u.id = a.created_by
left outer join
sections_articles sa
on sa.article_id = a.id
and sa.section_id = ?
left outer join
article_links ali
on ali.article_id = a.id
left outer join
article_files af
on af.article_id = a.id
left outer join
key_documents kd
on kd.article_id = a.id
left outer join
notices n
on n.article_id = a.id
left outer join
notice_translations nt
on nt.article_id = n.article_id
and nt.language_id =
?
inner join
article_translation_slugs ats
on ats.article_id = a.id
where
1=1
and a.status_id = ?
and a.type_id IN (?)
and a.type_id NOT IN (?)
and sa.section_id = ?
and a.is_deleted = ?
and (
a.expire_at > now()
or a.expire_at is null
or a.expire_at = '0000-00-00 00:00:00'
)
and a.publish_at <= now()
order by
a.publish_at desc | | Time: | 15 ms | | Records: | 1 | | Columns: | count |
| | 44E1F4D5FB94569C9955DF41C358C366 | | query [short version] | | Query Source: | SQL Query | | Datasource: | SCIDEV_PRODUCTION | | Query: | select
distinct
a.id,
a.status_id,
a.type_id,
a.canonical_section_id,
a.created_at,
a.publish_at,
a.created_by,
a.author,
a.source,
a.editor_notes,
a.citations,
a.affiliation,
at.name as type,
at.slug as type_slug,
atr.language_id,
atr.status_id as translation_status_id,
atr.translation_type_id,
atr.title,
atr.slug,
atr.blurb,
atr.body,
case
when ifnull(af.file_name,'') <> '' then af.file_name
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then kd.document_url
else ''
end as keydocument_url,
case
when ifnull(af.file_name,'') <> '' then 'file'
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then 'url'
else ''
end as keydocument_type,
kd.publication_date,
ifnull(ali.link_url,'') as link_url
,
sa.is_highlighted,
sa.display_order,
sa.section_id
,
ats.en_slug,
ats.en_transtypeid,
ats.fr_slug,
ats.fr_transtypeid,
ats.zh_slug,
ats.zh_transtypeid,
ats.es_slug,
ats.es_transtypeid,
ats.po_slug,
ats.po_transtypeid,
ats.ar_slug,
ats.ar_transtypeid
,'' AS section_slug
,'' AS sub_section_slug
,'' AS canonical_link
from
articles a
inner join
article_translations atr
on atr.article_id = a.id
and atr.language_id =
?
and atr.status_id = 2
inner join
article_types at
on a.type_id = at.id
inner join
article_statuses ast
on ast.id = a.status_id
inner join
users u
on u.id = a.created_by
left outer join
sections_articles sa
on sa.article_id = a.id
and sa.section_id = ?
left outer join
article_links ali
on ali.article_id = a.id
left outer join
article_files af
on af.article_id = a.id
left outer join
key_documents kd
on kd.article_id = a.id
inner join
article_translation_slugs ats
on ats.article_id = a.id
where
1=1
and a.status_id = ?
and a.type_id IN (?)
and a.type_id NOT IN (?)
and sa.section_id = ?
and a.is_deleted = ?
and (
a.expire_at > now()
or a.expire_at is null
or a.expire_at = '0000-00-00 00:00:00'
)
and a.publish_at <= now()
order by
a.publish_at desc
limit
?,
? | | Time: | 0 ms | | Records: | 0 | | Columns: | id, status_id, type_id, canonical_section_id, created_at, publish_at, created_by
author, source, editor_notes, citations, affiliation, type
type_slug, language_id, translation_status_id, translation_type_id, title, slug
blurb, body, keydocument_url, keydocument_type, publication_date, link_url
is_highlighted, display_order, section_id, en_slug, en_transtypeid, fr_slug
fr_transtypeid, zh_slug, zh_transtypeid, es_slug, es_transtypeid, po_slug
po_transtypeid, ar_slug, ar_transtypeid, section_slug, sub_section_slug, canonical_link
|
| | 4A21440347F3EF856E104B535A4B6F89 | | query [short version] | | Query Source: | SQL Query | | Datasource: | SCIDEV_PRODUCTION | | Query: | select
count(distinct a.id) as count
from
articles a
inner join
article_translations atr
on atr.article_id = a.id
and atr.language_id =
?
and atr.status_id = 2
inner join
article_types at
on a.type_id = at.id
inner join
article_statuses ast
on ast.id = a.status_id
inner join
users u
on u.id = a.created_by
left outer join
sections_articles sa
on sa.article_id = a.id
and sa.section_id = ?
left outer join
article_links ali
on ali.article_id = a.id
left outer join
article_files af
on af.article_id = a.id
left outer join
key_documents kd
on kd.article_id = a.id
inner join
article_translation_slugs ats
on ats.article_id = a.id
where
1=1
and a.status_id = ?
and a.type_id IN (?)
and a.type_id NOT IN (?)
and sa.section_id = ?
and a.is_deleted = ?
and (
a.expire_at > now()
or a.expire_at is null
or a.expire_at = '0000-00-00 00:00:00'
)
and a.publish_at <= now()
order by
a.publish_at desc | | Time: | 0 ms | | Records: | 1 | | Columns: | count |
| | 4AB21380EAADC9E770FF96DC49513CAE | | query [short version] | | Query Source: | SQL Query | | Datasource: | SCIDEV_PRODUCTION | | Query: | select
count(distinct a.id) as count
from
articles a
inner join
article_translations atr
on atr.article_id = a.id
and atr.language_id =
?
and atr.status_id = 2
inner join
article_types at
on a.type_id = at.id
inner join
article_statuses ast
on ast.id = a.status_id
inner join
users u
on u.id = a.created_by
left outer join
article_links ali
on ali.article_id = a.id
left outer join
article_files af
on af.article_id = a.id
left outer join
key_documents kd
on kd.article_id = a.id
inner join
article_translation_slugs ats
on ats.article_id = a.id
where
1=1
and a.status_id = ?
and a.type_id IN (?)
and a.type_id NOT IN (?)
and a.is_deleted = ?
and (
a.expire_at > now()
or a.expire_at is null
or a.expire_at = '0000-00-00 00:00:00'
)
and a.publish_at <= now()
order by
a.publish_at desc | | Time: | 78 ms | | Records: | 1 | | Columns: | count |
| | 523C6E2DEFDCAD701D029120973449E4 | | query [short version] | | Query Source: | SQL Query | | Datasource: | SCIDEV_PRODUCTION | | Query: | select
distinct
a.id,
a.status_id,
a.type_id,
a.canonical_section_id,
a.created_at,
a.publish_at,
a.created_by,
a.author,
a.source,
a.editor_notes,
a.citations,
a.affiliation,
at.name as type,
at.slug as type_slug,
atr.language_id,
atr.status_id as translation_status_id,
atr.translation_type_id,
atr.title,
atr.slug,
atr.blurb,
atr.body,
case
when ifnull(af.file_name,'') <> '' then af.file_name
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then kd.document_url
else ''
end as keydocument_url,
case
when ifnull(af.file_name,'') <> '' then 'file'
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then 'url'
else ''
end as keydocument_type,
kd.publication_date,
ifnull(ali.link_url,'') as link_url
,
sa.is_highlighted,
sa.display_order,
sa.section_id
,
ats.en_slug,
ats.en_transtypeid,
ats.fr_slug,
ats.fr_transtypeid,
ats.zh_slug,
ats.zh_transtypeid,
ats.es_slug,
ats.es_transtypeid,
ats.po_slug,
ats.po_transtypeid,
ats.ar_slug,
ats.ar_transtypeid
,'' AS section_slug
,'' AS sub_section_slug
,'' AS canonical_link
from
articles a
inner join
article_translations atr
on atr.article_id = a.id
and atr.language_id =
?
and atr.status_id = 2
inner join
article_types at
on a.type_id = at.id
inner join
article_statuses ast
on ast.id = a.status_id
inner join
users u
on u.id = a.created_by
left outer join
sections_articles sa
on sa.article_id = a.id
and sa.section_id = ?
left outer join
article_links ali
on ali.article_id = a.id
left outer join
article_files af
on af.article_id = a.id
left outer join
key_documents kd
on kd.article_id = a.id
inner join
article_translation_slugs ats
on ats.article_id = a.id
where
1=1
and a.status_id = ?
and a.type_id IN (?)
and a.type_id NOT IN (?)
and sa.section_id = ?
and a.is_deleted = ?
and (
a.expire_at > now()
or a.expire_at is null
or a.expire_at = '0000-00-00 00:00:00'
)
and a.publish_at <= now()
order by
a.publish_at desc
limit
?,
? | | Time: | 0 ms | | Records: | 5 | | Columns: | id, status_id, type_id, canonical_section_id, created_at, publish_at, created_by
author, source, editor_notes, citations, affiliation, type
type_slug, language_id, translation_status_id, translation_type_id, title, slug
blurb, body, keydocument_url, keydocument_type, publication_date, link_url
is_highlighted, display_order, section_id, en_slug, en_transtypeid, fr_slug
fr_transtypeid, zh_slug, zh_transtypeid, es_slug, es_transtypeid, po_slug
po_transtypeid, ar_slug, ar_transtypeid, section_slug, sub_section_slug, canonical_link
|
| | 56F9CA7E084934FC47046E0D3C8055CB | | query [short version] | | Query Source: | SQL Query | | Datasource: | SCIDEV_PRODUCTION | | Query: | select
distinct
a.id,
a.status_id,
a.type_id,
a.canonical_section_id,
a.created_at,
a.publish_at,
a.created_by,
a.author,
a.source,
a.editor_notes,
a.citations,
a.affiliation,
at.name as type,
at.slug as type_slug,
atr.language_id,
atr.status_id as translation_status_id,
atr.translation_type_id,
atr.title,
atr.slug,
atr.blurb,
atr.body,
case
when ifnull(af.file_name,'') <> '' then af.file_name
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then kd.document_url
else ''
end as keydocument_url,
case
when ifnull(af.file_name,'') <> '' then 'file'
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then 'url'
else ''
end as keydocument_type,
kd.publication_date,
ifnull(ali.link_url,'') as link_url
,
sa.is_highlighted,
sa.display_order,
sa.section_id
,
ats.en_slug,
ats.en_transtypeid,
ats.fr_slug,
ats.fr_transtypeid,
ats.zh_slug,
ats.zh_transtypeid,
ats.es_slug,
ats.es_transtypeid,
ats.po_slug,
ats.po_transtypeid,
ats.ar_slug,
ats.ar_transtypeid
,'' AS section_slug
,'' AS sub_section_slug
,'' AS canonical_link
from
articles a
inner join
article_translations atr
on atr.article_id = a.id
and atr.language_id =
?
and atr.status_id = 2
inner join
article_types at
on a.type_id = at.id
inner join
article_statuses ast
on ast.id = a.status_id
inner join
users u
on u.id = a.created_by
left outer join
sections_articles sa
on sa.article_id = a.id
and sa.section_id = ?
left outer join
article_links ali
on ali.article_id = a.id
left outer join
article_files af
on af.article_id = a.id
left outer join
key_documents kd
on kd.article_id = a.id
inner join
article_translation_slugs ats
on ats.article_id = a.id
where
1=1
and a.status_id = ?
and a.type_id IN (?,?)
and a.type_id NOT IN (?)
and sa.section_id = ?
and a.is_deleted = ?
and (
a.expire_at > now()
or a.expire_at is null
or a.expire_at = '0000-00-00 00:00:00'
)
and a.publish_at <= now()
order by
a.publish_at desc
limit
?,
? | | Time: | 15 ms | | Records: | 6 | | Columns: | id, status_id, type_id, canonical_section_id, created_at, publish_at, created_by
author, source, editor_notes, citations, affiliation, type
type_slug, language_id, translation_status_id, translation_type_id, title, slug
blurb, body, keydocument_url, keydocument_type, publication_date, link_url
is_highlighted, display_order, section_id, en_slug, en_transtypeid, fr_slug
fr_transtypeid, zh_slug, zh_transtypeid, es_slug, es_transtypeid, po_slug
po_transtypeid, ar_slug, ar_transtypeid, section_slug, sub_section_slug, canonical_link
|
| | 57D0962A5520BF563D470F9934F0E0BA | | query [short version] | | Query Source: | SQL Query | | Datasource: | SCIDEV_PRODUCTION | | Query: | select
distinct
a.id,
a.status_id,
a.type_id,
a.canonical_section_id,
a.created_at,
a.publish_at,
a.created_by,
a.author,
a.source,
a.editor_notes,
a.citations,
a.affiliation,
at.name as type,
at.slug as type_slug,
atr.language_id,
atr.status_id as translation_status_id,
atr.translation_type_id,
atr.title,
atr.slug,
atr.blurb,
atr.body,
case
when ifnull(af.file_name,'') <> '' then af.file_name
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then kd.document_url
else ''
end as keydocument_url,
case
when ifnull(af.file_name,'') <> '' then 'file'
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then 'url'
else ''
end as keydocument_type,
kd.publication_date,
ifnull(ali.link_url,'') as link_url
,
sa.is_highlighted,
sa.display_order,
sa.section_id
,
ats.en_slug,
ats.en_transtypeid,
ats.fr_slug,
ats.fr_transtypeid,
ats.zh_slug,
ats.zh_transtypeid,
ats.es_slug,
ats.es_transtypeid,
ats.po_slug,
ats.po_transtypeid,
ats.ar_slug,
ats.ar_transtypeid
,'' AS section_slug
,'' AS sub_section_slug
,'' AS canonical_link
from
articles a
inner join
article_translations atr
on atr.article_id = a.id
and atr.language_id =
?
and atr.status_id = 2
inner join
article_types at
on a.type_id = at.id
inner join
article_statuses ast
on ast.id = a.status_id
inner join
users u
on u.id = a.created_by
left outer join
sections_articles sa
on sa.article_id = a.id
and sa.section_id = ?
left outer join
article_links ali
on ali.article_id = a.id
left outer join
article_files af
on af.article_id = a.id
left outer join
key_documents kd
on kd.article_id = a.id
inner join
article_translation_slugs ats
on ats.article_id = a.id
where
1=1
and a.status_id = ?
and a.type_id IN (?)
and a.type_id NOT IN (?)
and sa.section_id = ?
and a.is_deleted = ?
and (
a.expire_at > now()
or a.expire_at is null
or a.expire_at = '0000-00-00 00:00:00'
)
and a.publish_at <= now()
order by
a.publish_at desc
limit
?,
? | | Time: | 15 ms | | Records: | 0 | | Columns: | id, status_id, type_id, canonical_section_id, created_at, publish_at, created_by
author, source, editor_notes, citations, affiliation, type
type_slug, language_id, translation_status_id, translation_type_id, title, slug
blurb, body, keydocument_url, keydocument_type, publication_date, link_url
is_highlighted, display_order, section_id, en_slug, en_transtypeid, fr_slug
fr_transtypeid, zh_slug, zh_transtypeid, es_slug, es_transtypeid, po_slug
po_transtypeid, ar_slug, ar_transtypeid, section_slug, sub_section_slug, canonical_link
|
| | 59483C75313BBF99F8DCA5CA8423DD3B | | query [short version] | | Query Source: | SQL Query | | Datasource: | SCIDEV_PRODUCTION | | Query: | select
distinct
a.id,
a.status_id,
a.type_id,
a.canonical_section_id,
a.created_at,
a.publish_at,
a.created_by,
a.author,
a.source,
a.editor_notes,
a.citations,
a.affiliation,
at.name as type,
at.slug as type_slug,
atr.language_id,
atr.status_id as translation_status_id,
atr.translation_type_id,
atr.title,
atr.slug,
atr.blurb,
atr.body,
case
when ifnull(af.file_name,'') <> '' then af.file_name
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then kd.document_url
else ''
end as keydocument_url,
case
when ifnull(af.file_name,'') <> '' then 'file'
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then 'url'
else ''
end as keydocument_type,
kd.publication_date,
ifnull(ali.link_url,'') as link_url
,
sa.is_highlighted,
sa.display_order,
sa.section_id
,
ats.en_slug,
ats.en_transtypeid,
ats.fr_slug,
ats.fr_transtypeid,
ats.zh_slug,
ats.zh_transtypeid,
ats.es_slug,
ats.es_transtypeid,
ats.po_slug,
ats.po_transtypeid,
ats.ar_slug,
ats.ar_transtypeid
,'' AS section_slug
,'' AS sub_section_slug
,'' AS canonical_link
from
articles a
inner join
article_translations atr
on atr.article_id = a.id
and atr.language_id =
?
and atr.status_id = 2
inner join
article_types at
on a.type_id = at.id
inner join
article_statuses ast
on ast.id = a.status_id
inner join
users u
on u.id = a.created_by
left outer join
sections_articles sa
on sa.article_id = a.id
and sa.section_id = ?
left outer join
article_links ali
on ali.article_id = a.id
left outer join
article_files af
on af.article_id = a.id
left outer join
key_documents kd
on kd.article_id = a.id
inner join
article_translation_slugs ats
on ats.article_id = a.id
where
1=1
and a.status_id = ?
and a.type_id IN (?)
and a.type_id NOT IN (?)
and sa.section_id = ?
and a.is_deleted = ?
and (
a.expire_at > now()
or a.expire_at is null
or a.expire_at = '0000-00-00 00:00:00'
)
and a.publish_at <= now()
order by
a.publish_at desc
limit
?,
? | | Time: | 47 ms | | Records: | 1 | | Columns: | id, status_id, type_id, canonical_section_id, created_at, publish_at, created_by
author, source, editor_notes, citations, affiliation, type
type_slug, language_id, translation_status_id, translation_type_id, title, slug
blurb, body, keydocument_url, keydocument_type, publication_date, link_url
is_highlighted, display_order, section_id, en_slug, en_transtypeid, fr_slug
fr_transtypeid, zh_slug, zh_transtypeid, es_slug, es_transtypeid, po_slug
po_transtypeid, ar_slug, ar_transtypeid, section_slug, sub_section_slug, canonical_link
|
| | 5967E0FDE9F6049BA980B25B70AA5D80 | | query [short version] | | Query Source: | SQL Query | | Datasource: | SCIDEV_PRODUCTION | | Query: | select
count(distinct a.id) as count
from
articles a
inner join
article_translations atr
on atr.article_id = a.id
and atr.language_id =
?
inner join
article_types at
on a.type_id = at.id
inner join
article_statuses ast
on ast.id = a.status_id
inner join
users u
on u.id = a.created_by
left outer join
sections_articles sa
on sa.article_id = a.id
and sa.section_id = ?
left outer join
article_links ali
on ali.article_id = a.id
left outer join
article_files af
on af.article_id = a.id
left outer join
key_documents kd
on kd.article_id = a.id
where
1=1
and a.status_id = ?
and a.type_id IN (?)
and sa.section_id = ?
and a.is_deleted = ?
and (
a.expire_at > now()
or a.expire_at is null
or a.expire_at = '0000-00-00 00:00:00'
)
and a.publish_at <= now()
order by
a.publish_at desc | | Time: | 0 ms | | Records: | 1 | | Columns: | count |
| | 59FE175D1CB19B7768662B945870D533 | | query [short version] | | Query Source: | SQL Query | | Datasource: | SCIDEV_PRODUCTION | | Query: | select
distinct
a.id,
a.status_id,
a.type_id,
a.canonical_section_id,
a.created_at,
a.publish_at,
a.created_by,
a.author,
a.source,
a.editor_notes,
a.citations,
a.affiliation,
at.name as type,
at.slug as type_slug,
atr.language_id,
atr.status_id as translation_status_id,
atr.translation_type_id,
atr.title,
atr.slug,
atr.blurb,
atr.body,
case
when ifnull(af.file_name,'') <> '' then af.file_name
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then kd.document_url
else ''
end as keydocument_url,
case
when ifnull(af.file_name,'') <> '' then 'file'
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then 'url'
else ''
end as keydocument_type,
kd.publication_date,
ifnull(ali.link_url,'') as link_url
,
sa.is_highlighted,
sa.display_order,
sa.section_id
,
ats.en_slug,
ats.en_transtypeid,
ats.fr_slug,
ats.fr_transtypeid,
ats.zh_slug,
ats.zh_transtypeid,
ats.es_slug,
ats.es_transtypeid,
ats.po_slug,
ats.po_transtypeid,
ats.ar_slug,
ats.ar_transtypeid
,'' AS section_slug
,'' AS sub_section_slug
,'' AS canonical_link
from
articles a
inner join
article_translations atr
on atr.article_id = a.id
and atr.language_id =
?
and atr.status_id = 2
inner join
article_types at
on a.type_id = at.id
inner join
article_statuses ast
on ast.id = a.status_id
inner join
users u
on u.id = a.created_by
left outer join
sections_articles sa
on sa.article_id = a.id
and sa.section_id = ?
left outer join
article_links ali
on ali.article_id = a.id
left outer join
article_files af
on af.article_id = a.id
left outer join
key_documents kd
on kd.article_id = a.id
inner join
article_translation_slugs ats
on ats.article_id = a.id
where
1=1
and a.status_id = ?
and a.type_id IN (?)
and a.type_id NOT IN (?)
and sa.section_id = ?
and a.is_deleted = ?
and (
a.expire_at > now()
or a.expire_at is null
or a.expire_at = '0000-00-00 00:00:00'
)
and a.publish_at <= now()
order by
a.publish_at desc
limit
?,
? | | Time: | 0 ms | | Records: | 0 | | Columns: | id, status_id, type_id, canonical_section_id, created_at, publish_at, created_by
author, source, editor_notes, citations, affiliation, type
type_slug, language_id, translation_status_id, translation_type_id, title, slug
blurb, body, keydocument_url, keydocument_type, publication_date, link_url
is_highlighted, display_order, section_id, en_slug, en_transtypeid, fr_slug
fr_transtypeid, zh_slug, zh_transtypeid, es_slug, es_transtypeid, po_slug
po_transtypeid, ar_slug, ar_transtypeid, section_slug, sub_section_slug, canonical_link
|
| | 5AB5D7FE9976CD990BDD5D21F1FBBEC8 | | query [short version] | | Query Source: | SQL Query | | Datasource: | SCIDEV_PRODUCTION | | Query: | select
distinct
a.id,
a.status_id,
a.type_id,
a.canonical_section_id,
a.created_at,
a.publish_at,
a.created_by,
a.author,
a.source,
a.editor_notes,
a.citations,
a.affiliation,
at.name as type,
at.slug as type_slug,
atr.language_id,
atr.status_id as translation_status_id,
atr.translation_type_id,
atr.title,
atr.slug,
atr.blurb,
atr.body,
case
when ifnull(af.file_name,'') <> '' then af.file_name
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then kd.document_url
else ''
end as keydocument_url,
case
when ifnull(af.file_name,'') <> '' then 'file'
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then 'url'
else ''
end as keydocument_type,
kd.publication_date,
ifnull(ali.link_url,'') as link_url
,
sa.is_highlighted,
sa.display_order,
sa.section_id
,
ats.en_slug,
ats.en_transtypeid,
ats.fr_slug,
ats.fr_transtypeid,
ats.zh_slug,
ats.zh_transtypeid,
ats.es_slug,
ats.es_transtypeid,
ats.po_slug,
ats.po_transtypeid,
ats.ar_slug,
ats.ar_transtypeid
,'' AS section_slug
,'' AS sub_section_slug
,'' AS canonical_link
from
articles a
inner join
article_translations atr
on atr.article_id = a.id
and atr.language_id =
?
and atr.status_id = 2
inner join
article_types at
on a.type_id = at.id
inner join
article_statuses ast
on ast.id = a.status_id
inner join
users u
on u.id = a.created_by
left outer join
sections_articles sa
on sa.article_id = a.id
and sa.section_id = ?
left outer join
article_links ali
on ali.article_id = a.id
left outer join
article_files af
on af.article_id = a.id
left outer join
key_documents kd
on kd.article_id = a.id
inner join
article_translation_slugs ats
on ats.article_id = a.id
where
1=1
and a.status_id = ?
and a.type_id IN (?)
and a.type_id NOT IN (?)
and sa.section_id = ?
and a.is_deleted = ?
and (
a.expire_at > now()
or a.expire_at is null
or a.expire_at = '0000-00-00 00:00:00'
)
and a.publish_at <= now()
order by
a.publish_at desc
limit
?,
? | | Time: | 16 ms | | Records: | 11 | | Columns: | id, status_id, type_id, canonical_section_id, created_at, publish_at, created_by
author, source, editor_notes, citations, affiliation, type
type_slug, language_id, translation_status_id, translation_type_id, title, slug
blurb, body, keydocument_url, keydocument_type, publication_date, link_url
is_highlighted, display_order, section_id, en_slug, en_transtypeid, fr_slug
fr_transtypeid, zh_slug, zh_transtypeid, es_slug, es_transtypeid, po_slug
po_transtypeid, ar_slug, ar_transtypeid, section_slug, sub_section_slug, canonical_link
|
| | 5E850CA3C2D1131C5FDE0CD1D104FA80 | | query [short version] | | Query Source: | SQL Query | | Datasource: | SCIDEV_PRODUCTION | | Query: | select
distinct
a.id,
a.status_id,
a.type_id,
a.canonical_section_id,
a.created_at,
a.publish_at,
a.created_by,
a.author,
a.source,
a.editor_notes,
a.citations,
a.affiliation,
at.name as type,
at.slug as type_slug,
atr.language_id,
atr.status_id as translation_status_id,
atr.translation_type_id,
atr.title,
atr.slug,
atr.blurb,
atr.body,
case
when ifnull(af.file_name,'') <> '' then af.file_name
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then kd.document_url
else ''
end as keydocument_url,
case
when ifnull(af.file_name,'') <> '' then 'file'
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then 'url'
else ''
end as keydocument_type,
kd.publication_date,
ifnull(ali.link_url,'') as link_url
,
sa.is_highlighted,
sa.display_order,
sa.section_id
,
ats.en_slug,
ats.en_transtypeid,
ats.fr_slug,
ats.fr_transtypeid,
ats.zh_slug,
ats.zh_transtypeid,
ats.es_slug,
ats.es_transtypeid,
ats.po_slug,
ats.po_transtypeid,
ats.ar_slug,
ats.ar_transtypeid
,'' AS section_slug
,'' AS sub_section_slug
,'' AS canonical_link
from
articles a
inner join
article_translations atr
on atr.article_id = a.id
and atr.language_id =
?
and atr.status_id = 2
inner join
article_types at
on a.type_id = at.id
inner join
article_statuses ast
on ast.id = a.status_id
inner join
users u
on u.id = a.created_by
left outer join
sections_articles sa
on sa.article_id = a.id
and sa.section_id = ?
left outer join
article_links ali
on ali.article_id = a.id
left outer join
article_files af
on af.article_id = a.id
left outer join
key_documents kd
on kd.article_id = a.id
inner join
article_translation_slugs ats
on ats.article_id = a.id
where
1=1
and a.status_id = ?
and a.type_id IN (?)
and a.type_id NOT IN (?)
and sa.section_id = ?
and a.is_deleted = ?
and (
a.expire_at > now()
or a.expire_at is null
or a.expire_at = '0000-00-00 00:00:00'
)
and a.publish_at <= now()
order by
a.publish_at desc
limit
?,
? | | Time: | 47 ms | | Records: | 20 | | Columns: | id, status_id, type_id, canonical_section_id, created_at, publish_at, created_by
author, source, editor_notes, citations, affiliation, type
type_slug, language_id, translation_status_id, translation_type_id, title, slug
blurb, body, keydocument_url, keydocument_type, publication_date, link_url
is_highlighted, display_order, section_id, en_slug, en_transtypeid, fr_slug
fr_transtypeid, zh_slug, zh_transtypeid, es_slug, es_transtypeid, po_slug
po_transtypeid, ar_slug, ar_transtypeid, section_slug, sub_section_slug, canonical_link
|
| | 607CB7AD1D6ACA51C3A299E4EE32A0A2 | | query [short version] | | Query Source: | SQL Query | | Datasource: | SCIDEV_PRODUCTION | | Query: | select
count(distinct a.id) as count
from
articles a
inner join
article_translations atr
on atr.article_id = a.id
and atr.language_id =
?
and atr.status_id = 2
inner join
article_types at
on a.type_id = at.id
inner join
article_statuses ast
on ast.id = a.status_id
inner join
users u
on u.id = a.created_by
left outer join
sections_articles sa
on sa.article_id = a.id
and sa.section_id = ?
left outer join
article_links ali
on ali.article_id = a.id
left outer join
article_files af
on af.article_id = a.id
left outer join
key_documents kd
on kd.article_id = a.id
inner join
article_translation_slugs ats
on ats.article_id = a.id
where
1=1
and a.status_id = ?
and a.type_id IN (?)
and a.type_id NOT IN (?)
and sa.section_id = ?
and a.is_deleted = ?
and (
a.expire_at > now()
or a.expire_at is null
or a.expire_at = '0000-00-00 00:00:00'
)
and a.publish_at <= now()
order by
a.publish_at desc | | Time: | 0 ms | | Records: | 1 | | Columns: | count |
| | 648AF7E0554922D49C84F25367A95AE5 | | query [short version] | | Query Source: | SQL Query | | Datasource: | SCIDEV_PRODUCTION | | Query: | select
distinct
a.id,
a.status_id,
a.type_id,
a.canonical_section_id,
a.created_at,
a.publish_at,
a.created_by,
a.author,
a.source,
a.editor_notes,
a.citations,
a.affiliation,
at.name as type,
at.slug as type_slug,
atr.language_id,
atr.status_id as translation_status_id,
atr.translation_type_id,
atr.title,
atr.slug,
atr.blurb,
atr.body,
case
when ifnull(af.file_name,'') <> '' then af.file_name
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then kd.document_url
else ''
end as keydocument_url,
case
when ifnull(af.file_name,'') <> '' then 'file'
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then 'url'
else ''
end as keydocument_type,
kd.publication_date,
ifnull(ali.link_url,'') as link_url
,
sa.is_highlighted,
sa.display_order,
sa.section_id
,
ats.en_slug,
ats.en_transtypeid,
ats.fr_slug,
ats.fr_transtypeid,
ats.zh_slug,
ats.zh_transtypeid,
ats.es_slug,
ats.es_transtypeid,
ats.po_slug,
ats.po_transtypeid,
ats.ar_slug,
ats.ar_transtypeid
,'' AS section_slug
,'' AS sub_section_slug
,'' AS canonical_link
from
articles a
inner join
article_translations atr
on atr.article_id = a.id
and atr.language_id =
?
and atr.status_id = 2
inner join
article_types at
on a.type_id = at.id
inner join
article_statuses ast
on ast.id = a.status_id
inner join
users u
on u.id = a.created_by
left outer join
sections_articles sa
on sa.article_id = a.id
and sa.section_id = ?
left outer join
article_links ali
on ali.article_id = a.id
left outer join
article_files af
on af.article_id = a.id
left outer join
key_documents kd
on kd.article_id = a.id
inner join
article_translation_slugs ats
on ats.article_id = a.id
where
1=1
and a.status_id = ?
and a.type_id IN (?)
and a.type_id NOT IN (?)
and sa.section_id = ?
and a.is_deleted = ?
and (
a.expire_at > now()
or a.expire_at is null
or a.expire_at = '0000-00-00 00:00:00'
)
and a.publish_at <= now()
order by
a.publish_at desc
limit
?,
? | | Time: | 47 ms | | Records: | 20 | | Columns: | id, status_id, type_id, canonical_section_id, created_at, publish_at, created_by
author, source, editor_notes, citations, affiliation, type
type_slug, language_id, translation_status_id, translation_type_id, title, slug
blurb, body, keydocument_url, keydocument_type, publication_date, link_url
is_highlighted, display_order, section_id, en_slug, en_transtypeid, fr_slug
fr_transtypeid, zh_slug, zh_transtypeid, es_slug, es_transtypeid, po_slug
po_transtypeid, ar_slug, ar_transtypeid, section_slug, sub_section_slug, canonical_link
|
| | 65007E55EA816AC12C0D332FBFF1FB84 | | query [short version] | | Query Source: | SQL Query | | Datasource: | SCIDEV_PRODUCTION | | Query: | select
distinct
a.id,
a.status_id,
a.type_id,
a.canonical_section_id,
a.created_at,
a.publish_at,
a.created_by,
a.author,
a.source,
a.editor_notes,
a.citations,
a.affiliation,
at.name as type,
at.slug as type_slug,
atr.language_id,
atr.status_id as translation_status_id,
atr.translation_type_id,
atr.title,
atr.slug,
atr.blurb,
atr.body,
case
when ifnull(af.file_name,'') <> '' then af.file_name
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then kd.document_url
else ''
end as keydocument_url,
case
when ifnull(af.file_name,'') <> '' then 'file'
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then 'url'
else ''
end as keydocument_type,
kd.publication_date,
ifnull(ali.link_url,'') as link_url
,
sa.is_highlighted,
sa.display_order,
sa.section_id
,
a.is_deleted,
a.publish_at,
a.expire_at,
a.updated_at,
a.updated_by,
a.is_paid,
u.firstname,
u.lastname,
u.email
,
(select language_id from article_translations atr_temp where atr_temp.article_id = a.id and is_original = 1 limit 1) as original_language_id
,
ast.name as status_name
,'' AS section_slug
,'' AS sub_section_slug
,'' AS canonical_link
from
articles a
inner join
article_translations atr
on atr.article_id = a.id
and atr.language_id =
?
inner join
article_types at
on a.type_id = at.id
inner join
article_statuses ast
on ast.id = a.status_id
inner join
users u
on u.id = a.created_by
left outer join
sections_articles sa
on sa.article_id = a.id
and sa.section_id = ?
left outer join
article_links ali
on ali.article_id = a.id
left outer join
article_files af
on af.article_id = a.id
left outer join
key_documents kd
on kd.article_id = a.id
where
1=1
and a.status_id = ?
and a.type_id IN (?)
and sa.section_id = ?
and a.is_deleted = ?
and (
a.expire_at > now()
or a.expire_at is null
or a.expire_at = '0000-00-00 00:00:00'
)
and a.publish_at <= now()
order by
a.publish_at desc
limit
?,
? | | Time: | 16 ms | | Records: | 1 | | Columns: | id, status_id, type_id, canonical_section_id, created_at, publish_at, created_by
author, source, editor_notes, citations, affiliation, type
type_slug, language_id, translation_status_id, translation_type_id, title, slug
blurb, body, keydocument_url, keydocument_type, publication_date, link_url
is_highlighted, display_order, section_id, is_deleted, publish_at, expire_at
updated_at, updated_by, is_paid, firstname, lastname, email
original_language_id, status_name, section_slug, sub_section_slug, canonical_link |
| | 6501B8FD23BD7AD6702756672B30A321 | | query [short version] | | Query Source: | SQL Query | | Datasource: | SCIDEV_PRODUCTION | | Query: | select
distinct
a.id,
a.status_id,
a.type_id,
a.canonical_section_id,
a.created_at,
a.publish_at,
a.created_by,
a.author,
a.source,
a.editor_notes,
a.citations,
a.affiliation,
at.name as type,
at.slug as type_slug,
atr.language_id,
atr.status_id as translation_status_id,
atr.translation_type_id,
atr.title,
atr.slug,
atr.blurb,
atr.body,
case
when ifnull(af.file_name,'') <> '' then af.file_name
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then kd.document_url
else ''
end as keydocument_url,
case
when ifnull(af.file_name,'') <> '' then 'file'
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then 'url'
else ''
end as keydocument_type,
kd.publication_date,
ifnull(ali.link_url,'') as link_url
,
sa.is_highlighted,
sa.display_order,
sa.section_id
,
ats.en_slug,
ats.en_transtypeid,
ats.fr_slug,
ats.fr_transtypeid,
ats.zh_slug,
ats.zh_transtypeid,
ats.es_slug,
ats.es_transtypeid,
ats.po_slug,
ats.po_transtypeid,
ats.ar_slug,
ats.ar_transtypeid
,'' AS section_slug
,'' AS sub_section_slug
,'' AS canonical_link
from
articles a
inner join
article_translations atr
on atr.article_id = a.id
and atr.language_id =
?
and atr.status_id = 2
inner join
article_types at
on a.type_id = at.id
inner join
article_statuses ast
on ast.id = a.status_id
inner join
users u
on u.id = a.created_by
left outer join
sections_articles sa
on sa.article_id = a.id
and sa.section_id = ?
left outer join
article_links ali
on ali.article_id = a.id
left outer join
article_files af
on af.article_id = a.id
left outer join
key_documents kd
on kd.article_id = a.id
inner join
article_translation_slugs ats
on ats.article_id = a.id
where
1=1
and a.status_id = ?
and a.type_id IN (?)
and a.type_id NOT IN (?)
and sa.section_id = ?
and a.is_deleted = ?
and (
a.expire_at > now()
or a.expire_at is null
or a.expire_at = '0000-00-00 00:00:00'
)
and a.publish_at <= now()
order by
a.publish_at desc
limit
?,
? | | Time: | 15 ms | | Records: | 0 | | Columns: | id, status_id, type_id, canonical_section_id, created_at, publish_at, created_by
author, source, editor_notes, citations, affiliation, type
type_slug, language_id, translation_status_id, translation_type_id, title, slug
blurb, body, keydocument_url, keydocument_type, publication_date, link_url
is_highlighted, display_order, section_id, en_slug, en_transtypeid, fr_slug
fr_transtypeid, zh_slug, zh_transtypeid, es_slug, es_transtypeid, po_slug
po_transtypeid, ar_slug, ar_transtypeid, section_slug, sub_section_slug, canonical_link
|
| | 6749EC6C00F04222B7B729FE30D6751F | | query [short version] | | Query Source: | SQL Query | | Datasource: | SCIDEV_PRODUCTION | | Query: | select
distinct
a.id,
a.status_id,
a.type_id,
a.canonical_section_id,
a.created_at,
a.publish_at,
a.created_by,
a.author,
a.source,
a.editor_notes,
a.citations,
a.affiliation,
at.name as type,
at.slug as type_slug,
atr.language_id,
atr.status_id as translation_status_id,
atr.translation_type_id,
atr.title,
atr.slug,
atr.blurb,
atr.body,
case
when ifnull(af.file_name,'') <> '' then af.file_name
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then kd.document_url
else ''
end as keydocument_url,
case
when ifnull(af.file_name,'') <> '' then 'file'
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then 'url'
else ''
end as keydocument_type,
kd.publication_date,
ifnull(ali.link_url,'') as link_url
,
ats.en_slug,
ats.en_transtypeid,
ats.fr_slug,
ats.fr_transtypeid,
ats.zh_slug,
ats.zh_transtypeid,
ats.es_slug,
ats.es_transtypeid,
ats.po_slug,
ats.po_transtypeid,
ats.ar_slug,
ats.ar_transtypeid
,acl.parent_section_slug AS section_slug
,acl.section_slug AS sub_section_slug
,acl.canonical_link
from
articles a
inner join
article_translations atr
on atr.article_id = a.id
and atr.language_id =
?
and atr.status_id = 2
LEFT JOIN article_canonical_link acl on a.id = acl.article_id AND atr.language_id = acl.language_id
inner join
article_types at
on a.type_id = at.id
inner join
article_statuses ast
on ast.id = a.status_id
inner join
users u
on u.id = a.created_by
left outer join
article_links ali
on ali.article_id = a.id
left outer join
article_files af
on af.article_id = a.id
left outer join
key_documents kd
on kd.article_id = a.id
inner join
article_translation_slugs ats
on ats.article_id = a.id
where
1=1
and a.status_id = ?
and a.type_id IN (?)
and a.type_id NOT IN (?)
and a.is_deleted = ?
and (
a.expire_at > now()
or a.expire_at is null
or a.expire_at = '0000-00-00 00:00:00'
)
and a.publish_at <= now()
order by
a.publish_at desc
limit
?,
? | | Time: | 265 ms | | Records: | 20 | | Columns: | id, status_id, type_id, canonical_section_id, created_at, publish_at, created_by
author, source, editor_notes, citations, affiliation, type
type_slug, language_id, translation_status_id, translation_type_id, title, slug
blurb, body, keydocument_url, keydocument_type, publication_date, link_url
en_slug, en_transtypeid, fr_slug, fr_transtypeid, zh_slug, zh_transtypeid
es_slug, es_transtypeid, po_slug, po_transtypeid, ar_slug, ar_transtypeid
section_slug, sub_section_slug, canonical_link |
| | 6C029E5E944283F2C162CD3E143E1821 | | query [short version] | | Query Source: | SQL Query | | Datasource: | SCIDEV_PRODUCTION | | Query: | select
distinct
a.id,
a.status_id,
a.type_id,
a.canonical_section_id,
a.created_at,
a.publish_at,
a.created_by,
a.author,
a.source,
a.editor_notes,
a.citations,
a.affiliation,
at.name as type,
at.slug as type_slug,
atr.language_id,
atr.status_id as translation_status_id,
atr.translation_type_id,
atr.title,
atr.slug,
atr.blurb,
atr.body,
case
when ifnull(af.file_name,'') <> '' then af.file_name
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then kd.document_url
else ''
end as keydocument_url,
case
when ifnull(af.file_name,'') <> '' then 'file'
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then 'url'
else ''
end as keydocument_type,
kd.publication_date,
ifnull(ali.link_url,'') as link_url
,
sa.is_highlighted,
sa.display_order,
sa.section_id
,
ats.en_slug,
ats.en_transtypeid,
ats.fr_slug,
ats.fr_transtypeid,
ats.zh_slug,
ats.zh_transtypeid,
ats.es_slug,
ats.es_transtypeid,
ats.po_slug,
ats.po_transtypeid,
ats.ar_slug,
ats.ar_transtypeid
,'' AS section_slug
,'' AS sub_section_slug
,'' AS canonical_link
from
articles a
inner join
article_translations atr
on atr.article_id = a.id
and atr.language_id =
?
and atr.status_id = 2
inner join
article_types at
on a.type_id = at.id
inner join
article_statuses ast
on ast.id = a.status_id
inner join
users u
on u.id = a.created_by
left outer join
sections_articles sa
on sa.article_id = a.id
and sa.section_id = ?
left outer join
article_links ali
on ali.article_id = a.id
left outer join
article_files af
on af.article_id = a.id
left outer join
key_documents kd
on kd.article_id = a.id
inner join
article_translation_slugs ats
on ats.article_id = a.id
where
1=1
and a.status_id = ?
and a.type_id IN (?)
and a.type_id NOT IN (?)
and sa.section_id = ?
and a.is_deleted = ?
and (
a.expire_at > now()
or a.expire_at is null
or a.expire_at = '0000-00-00 00:00:00'
)
and a.publish_at <= now()
order by
a.publish_at desc
limit
?,
? | | Time: | 15 ms | | Records: | 6 | | Columns: | id, status_id, type_id, canonical_section_id, created_at, publish_at, created_by
author, source, editor_notes, citations, affiliation, type
type_slug, language_id, translation_status_id, translation_type_id, title, slug
blurb, body, keydocument_url, keydocument_type, publication_date, link_url
is_highlighted, display_order, section_id, en_slug, en_transtypeid, fr_slug
fr_transtypeid, zh_slug, zh_transtypeid, es_slug, es_transtypeid, po_slug
po_transtypeid, ar_slug, ar_transtypeid, section_slug, sub_section_slug, canonical_link
|
| | 70559A3B1C0A63EE798CDB42F40C1B8B | | query [short version] | | Query Source: | SQL Query | | Datasource: | SCIDEV_PRODUCTION | | Query: | select
distinct
a.id,
a.status_id,
a.type_id,
a.canonical_section_id,
a.created_at,
a.publish_at,
a.created_by,
a.author,
a.source,
a.editor_notes,
a.citations,
a.affiliation,
at.name as type,
at.slug as type_slug,
atr.language_id,
atr.status_id as translation_status_id,
atr.translation_type_id,
atr.title,
atr.slug,
atr.blurb,
atr.body,
case
when ifnull(af.file_name,'') <> '' then af.file_name
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then kd.document_url
else ''
end as keydocument_url,
case
when ifnull(af.file_name,'') <> '' then 'file'
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then 'url'
else ''
end as keydocument_type,
kd.publication_date,
ifnull(ali.link_url,'') as link_url
,
sa.is_highlighted,
sa.display_order,
sa.section_id
,
ats.en_slug,
ats.en_transtypeid,
ats.fr_slug,
ats.fr_transtypeid,
ats.zh_slug,
ats.zh_transtypeid,
ats.es_slug,
ats.es_transtypeid,
ats.po_slug,
ats.po_transtypeid,
ats.ar_slug,
ats.ar_transtypeid
,'' AS section_slug
,'' AS sub_section_slug
,'' AS canonical_link
from
articles a
inner join
article_translations atr
on atr.article_id = a.id
and atr.language_id =
?
and atr.status_id = 2
inner join
article_types at
on a.type_id = at.id
inner join
article_statuses ast
on ast.id = a.status_id
inner join
users u
on u.id = a.created_by
left outer join
sections_articles sa
on sa.article_id = a.id
and sa.section_id = ?
left outer join
article_links ali
on ali.article_id = a.id
left outer join
article_files af
on af.article_id = a.id
left outer join
key_documents kd
on kd.article_id = a.id
inner join
article_translation_slugs ats
on ats.article_id = a.id
where
1=1
and a.status_id = ?
and a.type_id IN (?)
and a.type_id NOT IN (?)
and sa.section_id = ?
and a.is_deleted = ?
and (
a.expire_at > now()
or a.expire_at is null
or a.expire_at = '0000-00-00 00:00:00'
)
and a.publish_at <= now()
order by
a.publish_at desc
limit
?,
? | | Time: | 0 ms | | Records: | 1 | | Columns: | id, status_id, type_id, canonical_section_id, created_at, publish_at, created_by
author, source, editor_notes, citations, affiliation, type
type_slug, language_id, translation_status_id, translation_type_id, title, slug
blurb, body, keydocument_url, keydocument_type, publication_date, link_url
is_highlighted, display_order, section_id, en_slug, en_transtypeid, fr_slug
fr_transtypeid, zh_slug, zh_transtypeid, es_slug, es_transtypeid, po_slug
po_transtypeid, ar_slug, ar_transtypeid, section_slug, sub_section_slug, canonical_link
|
| | 70F833D05A97241BD7C10C686D0DDD9C | | query [short version] | | Query Source: | Query of Queries | | Records: | 20 | | Columns: | id, slug, type, type_slug, title, blurb, publish_at
ar_slug, ar_transtypeid, es_slug, en_slug, en_transtypeid, es_slug
es_transtypeid, fr_slug, fr_transtypeid, po_slug, po_transtypeid, zh_slug
zh_transtypeid, source, author, section_slug, sub_section_slug, canonical_link
|
| | 73DD5672CD5765E279D073007BE37497 | | query [short version] | | Query Source: | SQL Query | | Datasource: | SCIDEV_PRODUCTION | | Query: | select
distinct
a.id,
a.status_id,
a.type_id,
a.canonical_section_id,
a.created_at,
a.publish_at,
a.created_by,
a.author,
a.source,
a.editor_notes,
a.citations,
a.affiliation,
at.name as type,
at.slug as type_slug,
atr.language_id,
atr.status_id as translation_status_id,
atr.translation_type_id,
atr.title,
atr.slug,
atr.blurb,
atr.body,
case
when ifnull(af.file_name,'') <> '' then af.file_name
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then kd.document_url
else ''
end as keydocument_url,
case
when ifnull(af.file_name,'') <> '' then 'file'
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then 'url'
else ''
end as keydocument_type,
kd.publication_date,
ifnull(ali.link_url,'') as link_url
,
sa.is_highlighted,
sa.display_order,
sa.section_id
,
ats.en_slug,
ats.en_transtypeid,
ats.fr_slug,
ats.fr_transtypeid,
ats.zh_slug,
ats.zh_transtypeid,
ats.es_slug,
ats.es_transtypeid,
ats.po_slug,
ats.po_transtypeid,
ats.ar_slug,
ats.ar_transtypeid
,acl.parent_section_slug AS section_slug
,acl.section_slug AS sub_section_slug
,acl.canonical_link
from
articles a
inner join
article_translations atr
on atr.article_id = a.id
and atr.language_id =
?
and atr.status_id = 2
LEFT JOIN article_canonical_link acl on a.id = acl.article_id AND atr.language_id = acl.language_id
inner join
article_types at
on a.type_id = at.id
inner join
article_statuses ast
on ast.id = a.status_id
inner join
users u
on u.id = a.created_by
left outer join
sections_articles sa
on sa.article_id = a.id
and sa.section_id = ?
left outer join
article_links ali
on ali.article_id = a.id
left outer join
article_files af
on af.article_id = a.id
left outer join
key_documents kd
on kd.article_id = a.id
inner join
article_translation_slugs ats
on ats.article_id = a.id
where
1=1
and a.status_id = ?
and a.type_id IN (?)
and a.type_id NOT IN (?)
and sa.section_id = ?
and a.is_deleted = ?
and (
a.expire_at > now()
or a.expire_at is null
or a.expire_at = '0000-00-00 00:00:00'
)
and a.publish_at <= now()
order by
a.publish_at desc
limit
?,
? | | Time: | 78 ms | | Records: | 8 | | Columns: | id, status_id, type_id, canonical_section_id, created_at, publish_at, created_by
author, source, editor_notes, citations, affiliation, type
type_slug, language_id, translation_status_id, translation_type_id, title, slug
blurb, body, keydocument_url, keydocument_type, publication_date, link_url
is_highlighted, display_order, section_id, en_slug, en_transtypeid, fr_slug
fr_transtypeid, zh_slug, zh_transtypeid, es_slug, es_transtypeid, po_slug
po_transtypeid, ar_slug, ar_transtypeid, section_slug, sub_section_slug, canonical_link
|
| | 75D8919F7EE95183A5A1089026340884 | | query [short version] | | Query Source: | SQL Query | | Datasource: | SCIDEV_PRODUCTION | | Query: | select
count(distinct a.id) as count
from
articles a
inner join
article_translations atr
on atr.article_id = a.id
and atr.language_id =
?
and atr.status_id = 2
inner join
article_types at
on a.type_id = at.id
inner join
article_statuses ast
on ast.id = a.status_id
inner join
users u
on u.id = a.created_by
left outer join
sections_articles sa
on sa.article_id = a.id
and sa.section_id = ?
left outer join
article_links ali
on ali.article_id = a.id
left outer join
article_files af
on af.article_id = a.id
left outer join
key_documents kd
on kd.article_id = a.id
inner join
article_translation_slugs ats
on ats.article_id = a.id
where
1=1
and a.status_id = ?
and a.type_id IN (?)
and a.type_id NOT IN (?)
and sa.section_id = ?
and a.is_deleted = ?
and (
a.expire_at > now()
or a.expire_at is null
or a.expire_at = '0000-00-00 00:00:00'
)
and a.publish_at <= now()
order by
a.publish_at desc | | Time: | 16 ms | | Records: | 1 | | Columns: | count |
| | 7D16A66E629F3C059230A82EEF52D629 | | query [short version] | | Query Source: | SQL Query | | Datasource: | SCIDEV_PRODUCTION | | Query: | select
distinct
a.id,
a.status_id,
a.type_id,
a.canonical_section_id,
a.created_at,
a.publish_at,
a.created_by,
a.author,
a.source,
a.editor_notes,
a.citations,
a.affiliation,
at.name as type,
at.slug as type_slug,
atr.language_id,
atr.status_id as translation_status_id,
atr.translation_type_id,
atr.title,
atr.slug,
atr.blurb,
atr.body,
case
when ifnull(af.file_name,'') <> '' then af.file_name
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then kd.document_url
else ''
end as keydocument_url,
case
when ifnull(af.file_name,'') <> '' then 'file'
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then 'url'
else ''
end as keydocument_type,
kd.publication_date,
ifnull(ali.link_url,'') as link_url
,
sa.is_highlighted,
sa.display_order,
sa.section_id
,
ats.en_slug,
ats.en_transtypeid,
ats.fr_slug,
ats.fr_transtypeid,
ats.zh_slug,
ats.zh_transtypeid,
ats.es_slug,
ats.es_transtypeid,
ats.po_slug,
ats.po_transtypeid,
ats.ar_slug,
ats.ar_transtypeid
,'' AS section_slug
,'' AS sub_section_slug
,'' AS canonical_link
from
articles a
inner join
article_translations atr
on atr.article_id = a.id
and atr.language_id =
?
and atr.status_id = 2
inner join
article_types at
on a.type_id = at.id
inner join
article_statuses ast
on ast.id = a.status_id
inner join
users u
on u.id = a.created_by
left outer join
sections_articles sa
on sa.article_id = a.id
and sa.section_id = ?
left outer join
article_links ali
on ali.article_id = a.id
left outer join
article_files af
on af.article_id = a.id
left outer join
key_documents kd
on kd.article_id = a.id
inner join
article_translation_slugs ats
on ats.article_id = a.id
where
1=1
and a.status_id = ?
and a.type_id IN (?)
and a.type_id NOT IN (?)
and sa.section_id = ?
and a.is_deleted = ?
and (
a.expire_at > now()
or a.expire_at is null
or a.expire_at = '0000-00-00 00:00:00'
)
and a.publish_at <= now()
order by
a.publish_at desc
limit
?,
? | | Time: | 31 ms | | Records: | 20 | | Columns: | id, status_id, type_id, canonical_section_id, created_at, publish_at, created_by
author, source, editor_notes, citations, affiliation, type
type_slug, language_id, translation_status_id, translation_type_id, title, slug
blurb, body, keydocument_url, keydocument_type, publication_date, link_url
is_highlighted, display_order, section_id, en_slug, en_transtypeid, fr_slug
fr_transtypeid, zh_slug, zh_transtypeid, es_slug, es_transtypeid, po_slug
po_transtypeid, ar_slug, ar_transtypeid, section_slug, sub_section_slug, canonical_link
|
| | 7D4E3D98908CC7D642D5322014F2FFC2 | | query [short version] | | Query Source: | SQL Query | | Datasource: | SCIDEV_PRODUCTION | | Query: | select
distinct
a.id,
a.status_id,
a.type_id,
a.canonical_section_id,
a.created_at,
a.publish_at,
a.created_by,
a.author,
a.source,
a.editor_notes,
a.citations,
a.affiliation,
at.name as type,
at.slug as type_slug,
atr.language_id,
atr.status_id as translation_status_id,
atr.translation_type_id,
atr.title,
atr.slug,
atr.blurb,
atr.body,
case
when ifnull(af.file_name,'') <> '' then af.file_name
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then kd.document_url
else ''
end as keydocument_url,
case
when ifnull(af.file_name,'') <> '' then 'file'
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then 'url'
else ''
end as keydocument_type,
kd.publication_date,
ifnull(ali.link_url,'') as link_url
,
sa.is_highlighted,
sa.display_order,
sa.section_id
,
a.is_deleted,
a.publish_at,
a.expire_at,
a.updated_at,
a.updated_by,
a.is_paid,
u.firstname,
u.lastname,
u.email
,
(select language_id from article_translations atr_temp where atr_temp.article_id = a.id and is_original = 1 limit 1) as original_language_id
,
ast.name as status_name
,'' AS section_slug
,'' AS sub_section_slug
,'' AS canonical_link
from
articles a
inner join
article_translations atr
on atr.article_id = a.id
and atr.language_id =
?
inner join
article_types at
on a.type_id = at.id
inner join
article_statuses ast
on ast.id = a.status_id
inner join
users u
on u.id = a.created_by
left outer join
sections_articles sa
on sa.article_id = a.id
and sa.section_id = ?
left outer join
sections_articles sla
on sla.article_id = a.id
and sla.section_id = ?
left outer join
article_links ali
on ali.article_id = a.id
left outer join
article_files af
on af.article_id = a.id
left outer join
key_documents kd
on kd.article_id = a.id
where
1=1
and a.status_id = ?
and a.type_id IN (?)
and sa.section_id = ?
and sla.section_id = ?
and a.is_deleted = ?
and (
a.expire_at > now()
or a.expire_at is null
or a.expire_at = '0000-00-00 00:00:00'
)
and a.publish_at <= now()
order by
a.publish_at desc
limit
?,
? | | Time: | 47 ms | | Records: | 20 | | Columns: | id, status_id, type_id, canonical_section_id, created_at, publish_at, created_by
author, source, editor_notes, citations, affiliation, type
type_slug, language_id, translation_status_id, translation_type_id, title, slug
blurb, body, keydocument_url, keydocument_type, publication_date, link_url
is_highlighted, display_order, section_id, is_deleted, publish_at, expire_at
updated_at, updated_by, is_paid, firstname, lastname, email
original_language_id, status_name, section_slug, sub_section_slug, canonical_link |
| | 7E20843BCE411557CF68F6483BE0753D | | query [short version] | | Query Source: | SQL Query | | Datasource: | SCIDEV_PRODUCTION | | Query: | select
distinct
a.id,
a.status_id,
a.type_id,
a.canonical_section_id,
a.created_at,
a.publish_at,
a.created_by,
a.author,
a.source,
a.editor_notes,
a.citations,
a.affiliation,
at.name as type,
at.slug as type_slug,
atr.language_id,
atr.status_id as translation_status_id,
atr.translation_type_id,
atr.title,
atr.slug,
atr.blurb,
atr.body,
case
when ifnull(af.file_name,'') <> '' then af.file_name
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then kd.document_url
else ''
end as keydocument_url,
case
when ifnull(af.file_name,'') <> '' then 'file'
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then 'url'
else ''
end as keydocument_type,
kd.publication_date,
ifnull(ali.link_url,'') as link_url
,
sa.is_highlighted,
sa.display_order,
sa.section_id
,
ats.en_slug,
ats.en_transtypeid,
ats.fr_slug,
ats.fr_transtypeid,
ats.zh_slug,
ats.zh_transtypeid,
ats.es_slug,
ats.es_transtypeid,
ats.po_slug,
ats.po_transtypeid,
ats.ar_slug,
ats.ar_transtypeid
,'' AS section_slug
,'' AS sub_section_slug
,'' AS canonical_link
from
articles a
inner join
article_translations atr
on atr.article_id = a.id
and atr.language_id =
?
and atr.status_id = 2
inner join
article_types at
on a.type_id = at.id
inner join
article_statuses ast
on ast.id = a.status_id
inner join
users u
on u.id = a.created_by
left outer join
sections_articles sa
on sa.article_id = a.id
and sa.section_id = ?
left outer join
article_links ali
on ali.article_id = a.id
left outer join
article_files af
on af.article_id = a.id
left outer join
key_documents kd
on kd.article_id = a.id
inner join
article_translation_slugs ats
on ats.article_id = a.id
where
1=1
and a.status_id = ?
and a.type_id IN (?)
and a.type_id NOT IN (?)
and sa.section_id = ?
and a.is_deleted = ?
and (
a.expire_at > now()
or a.expire_at is null
or a.expire_at = '0000-00-00 00:00:00'
)
and a.publish_at <= now()
order by
a.publish_at desc
limit
?,
? | | Time: | 63 ms | | Records: | 20 | | Columns: | id, status_id, type_id, canonical_section_id, created_at, publish_at, created_by
author, source, editor_notes, citations, affiliation, type
type_slug, language_id, translation_status_id, translation_type_id, title, slug
blurb, body, keydocument_url, keydocument_type, publication_date, link_url
is_highlighted, display_order, section_id, en_slug, en_transtypeid, fr_slug
fr_transtypeid, zh_slug, zh_transtypeid, es_slug, es_transtypeid, po_slug
po_transtypeid, ar_slug, ar_transtypeid, section_slug, sub_section_slug, canonical_link
|
| | 7E53B9AF39D3DA21D47485DA146817FA | | query [short version] | | Query Source: | SQL Query | | Datasource: | SCIDEV_PRODUCTION | | Query: | select
count(distinct a.id) as count
from
articles a
inner join
article_translations atr
on atr.article_id = a.id
and atr.language_id =
?
and atr.status_id = 2
inner join
article_types at
on a.type_id = at.id
inner join
article_statuses ast
on ast.id = a.status_id
inner join
users u
on u.id = a.created_by
left outer join
sections_articles sa
on sa.article_id = a.id
and sa.section_id = ?
left outer join
article_links ali
on ali.article_id = a.id
left outer join
article_files af
on af.article_id = a.id
left outer join
key_documents kd
on kd.article_id = a.id
left outer join
notices n
on n.article_id = a.id
left outer join
notice_translations nt
on nt.article_id = n.article_id
and nt.language_id =
?
inner join
article_translation_slugs ats
on ats.article_id = a.id
where
1=1
and a.status_id = ?
and a.type_id IN (?)
and a.type_id NOT IN (?)
and sa.section_id = ?
and a.is_deleted = ?
and (
a.expire_at > now()
or a.expire_at is null
or a.expire_at = '0000-00-00 00:00:00'
)
and a.publish_at <= now()
order by
a.publish_at desc | | Time: | 31 ms | | Records: | 1 | | Columns: | count |
| | 885FD9CD9D5FFC7D02D51306E8EDB634 | | query [short version] | | Query Source: | SQL Query | | Datasource: | SCIDEV_PRODUCTION | | Query: | select
count(distinct a.id) as count
from
articles a
inner join
article_translations atr
on atr.article_id = a.id
and atr.language_id =
?
inner join
article_types at
on a.type_id = at.id
inner join
article_statuses ast
on ast.id = a.status_id
inner join
users u
on u.id = a.created_by
left outer join
sections_articles sa
on sa.article_id = a.id
and sa.section_id = ?
left outer join
sections_articles sla
on sla.article_id = a.id
and sla.section_id = ?
left outer join
article_links ali
on ali.article_id = a.id
left outer join
article_files af
on af.article_id = a.id
left outer join
key_documents kd
on kd.article_id = a.id
where
1=1
and a.status_id = ?
and a.type_id IN (?)
and sa.section_id = ?
and sla.section_id = ?
and a.is_deleted = ?
and (
a.expire_at > now()
or a.expire_at is null
or a.expire_at = '0000-00-00 00:00:00'
)
and a.publish_at <= now()
order by
a.publish_at desc | | Time: | 16 ms | | Records: | 1 | | Columns: | count |
| | 8FFEA1E6D06680EC1BEEFD29FBAD5271 | | query [short version] | | Query Source: | SQL Query | | Datasource: | SCIDEV_PRODUCTION | | Query: | select
distinct
a.id,
a.status_id,
a.type_id,
a.canonical_section_id,
a.created_at,
a.publish_at,
a.created_by,
a.author,
a.source,
a.editor_notes,
a.citations,
a.affiliation,
at.name as type,
at.slug as type_slug,
atr.language_id,
atr.status_id as translation_status_id,
atr.translation_type_id,
atr.title,
atr.slug,
atr.blurb,
atr.body,
case
when ifnull(af.file_name,'') <> '' then af.file_name
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then kd.document_url
else ''
end as keydocument_url,
case
when ifnull(af.file_name,'') <> '' then 'file'
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then 'url'
else ''
end as keydocument_type,
kd.publication_date,
ifnull(ali.link_url,'') as link_url
,
sa.is_highlighted,
sa.display_order,
sa.section_id
,
ats.en_slug,
ats.en_transtypeid,
ats.fr_slug,
ats.fr_transtypeid,
ats.zh_slug,
ats.zh_transtypeid,
ats.es_slug,
ats.es_transtypeid,
ats.po_slug,
ats.po_transtypeid,
ats.ar_slug,
ats.ar_transtypeid
,'' AS section_slug
,'' AS sub_section_slug
,'' AS canonical_link
from
articles a
inner join
article_translations atr
on atr.article_id = a.id
and atr.language_id =
?
and atr.status_id = 2
inner join
article_types at
on a.type_id = at.id
inner join
article_statuses ast
on ast.id = a.status_id
inner join
users u
on u.id = a.created_by
left outer join
sections_articles sa
on sa.article_id = a.id
and sa.section_id = ?
left outer join
article_links ali
on ali.article_id = a.id
left outer join
article_files af
on af.article_id = a.id
left outer join
key_documents kd
on kd.article_id = a.id
inner join
article_translation_slugs ats
on ats.article_id = a.id
where
1=1
and a.status_id = ?
and a.type_id IN (?)
and a.type_id NOT IN (?)
and sa.section_id = ?
and a.is_deleted = ?
and (
a.expire_at > now()
or a.expire_at is null
or a.expire_at = '0000-00-00 00:00:00'
)
and a.publish_at <= now()
order by
a.publish_at desc
limit
?,
? | | Time: | 16 ms | | Records: | 20 | | Columns: | id, status_id, type_id, canonical_section_id, created_at, publish_at, created_by
author, source, editor_notes, citations, affiliation, type
type_slug, language_id, translation_status_id, translation_type_id, title, slug
blurb, body, keydocument_url, keydocument_type, publication_date, link_url
is_highlighted, display_order, section_id, en_slug, en_transtypeid, fr_slug
fr_transtypeid, zh_slug, zh_transtypeid, es_slug, es_transtypeid, po_slug
po_transtypeid, ar_slug, ar_transtypeid, section_slug, sub_section_slug, canonical_link
|
| | 9745544888D3DE15ACCC32D18024F358 | | query [short version] | | Query Source: | SQL Query | | Datasource: | SCIDEV_PRODUCTION | | Query: | select
count(distinct a.id) as count
from
articles a
inner join
article_translations atr
on atr.article_id = a.id
and atr.language_id =
?
and atr.status_id = 2
inner join
article_types at
on a.type_id = at.id
inner join
article_statuses ast
on ast.id = a.status_id
inner join
users u
on u.id = a.created_by
left outer join
sections_articles sa
on sa.article_id = a.id
and sa.section_id = ?
left outer join
article_links ali
on ali.article_id = a.id
left outer join
article_files af
on af.article_id = a.id
left outer join
key_documents kd
on kd.article_id = a.id
inner join
article_translation_slugs ats
on ats.article_id = a.id
where
1=1
and a.status_id = ?
and a.type_id IN (?)
and a.type_id NOT IN (?)
and sa.section_id = ?
and a.is_deleted = ?
and (
a.expire_at > now()
or a.expire_at is null
or a.expire_at = '0000-00-00 00:00:00'
)
and a.publish_at <= now()
order by
a.publish_at desc | | Time: | 16 ms | | Records: | 1 | | Columns: | count |
| | 99EBB93A8F38981C99764CB7E7EE41F5 | | query [short version] | | Query Source: | SQL Query | | Datasource: | SCIDEV_PRODUCTION | | Query: | select
distinct
a.id,
a.status_id,
a.type_id,
a.canonical_section_id,
a.created_at,
a.publish_at,
a.created_by,
a.author,
a.source,
a.editor_notes,
a.citations,
a.affiliation,
at.name as type,
at.slug as type_slug,
atr.language_id,
atr.status_id as translation_status_id,
atr.translation_type_id,
atr.title,
atr.slug,
atr.blurb,
atr.body,
case
when ifnull(af.file_name,'') <> '' then af.file_name
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then kd.document_url
else ''
end as keydocument_url,
case
when ifnull(af.file_name,'') <> '' then 'file'
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then 'url'
else ''
end as keydocument_type,
kd.publication_date,
ifnull(ali.link_url,'') as link_url
,
sa.is_highlighted,
sa.display_order,
sa.section_id
,
ats.en_slug,
ats.en_transtypeid,
ats.fr_slug,
ats.fr_transtypeid,
ats.zh_slug,
ats.zh_transtypeid,
ats.es_slug,
ats.es_transtypeid,
ats.po_slug,
ats.po_transtypeid,
ats.ar_slug,
ats.ar_transtypeid
,'' AS section_slug
,'' AS sub_section_slug
,'' AS canonical_link
from
articles a
inner join
article_translations atr
on atr.article_id = a.id
and atr.language_id =
?
and atr.status_id = 2
inner join
article_types at
on a.type_id = at.id
inner join
article_statuses ast
on ast.id = a.status_id
inner join
users u
on u.id = a.created_by
left outer join
sections_articles sa
on sa.article_id = a.id
and sa.section_id = ?
left outer join
article_links ali
on ali.article_id = a.id
left outer join
article_files af
on af.article_id = a.id
left outer join
key_documents kd
on kd.article_id = a.id
inner join
article_translation_slugs ats
on ats.article_id = a.id
where
1=1
and a.status_id = ?
and a.type_id IN (?)
and a.type_id NOT IN (?)
and sa.section_id = ?
and a.is_deleted = ?
and (
a.expire_at > now()
or a.expire_at is null
or a.expire_at = '0000-00-00 00:00:00'
)
and a.publish_at <= now()
order by
a.publish_at desc
limit
?,
? | | Time: | 16 ms | | Records: | 0 | | Columns: | id, status_id, type_id, canonical_section_id, created_at, publish_at, created_by
author, source, editor_notes, citations, affiliation, type
type_slug, language_id, translation_status_id, translation_type_id, title, slug
blurb, body, keydocument_url, keydocument_type, publication_date, link_url
is_highlighted, display_order, section_id, en_slug, en_transtypeid, fr_slug
fr_transtypeid, zh_slug, zh_transtypeid, es_slug, es_transtypeid, po_slug
po_transtypeid, ar_slug, ar_transtypeid, section_slug, sub_section_slug, canonical_link
|
| | 9C12E9A59650E5D111DD0E395BC84A1F | | query [short version] | | Query Source: | SQL Query | | Datasource: | SCIDEV_PRODUCTION | | Query: | select
distinct
a.id,
a.status_id,
a.type_id,
a.canonical_section_id,
a.created_at,
a.publish_at,
a.created_by,
a.author,
a.source,
a.editor_notes,
a.citations,
a.affiliation,
at.name as type,
at.slug as type_slug,
atr.language_id,
atr.status_id as translation_status_id,
atr.translation_type_id,
atr.title,
atr.slug,
atr.blurb,
atr.body,
case
when ifnull(af.file_name,'') <> '' then af.file_name
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then kd.document_url
else ''
end as keydocument_url,
case
when ifnull(af.file_name,'') <> '' then 'file'
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then 'url'
else ''
end as keydocument_type,
kd.publication_date,
ifnull(ali.link_url,'') as link_url
,
sa.is_highlighted,
sa.display_order,
sa.section_id
,
ats.en_slug,
ats.en_transtypeid,
ats.fr_slug,
ats.fr_transtypeid,
ats.zh_slug,
ats.zh_transtypeid,
ats.es_slug,
ats.es_transtypeid,
ats.po_slug,
ats.po_transtypeid,
ats.ar_slug,
ats.ar_transtypeid
,'' AS section_slug
,'' AS sub_section_slug
,'' AS canonical_link
from
articles a
inner join
article_translations atr
on atr.article_id = a.id
and atr.language_id =
?
and atr.status_id = 2
inner join
article_types at
on a.type_id = at.id
inner join
article_statuses ast
on ast.id = a.status_id
inner join
users u
on u.id = a.created_by
left outer join
sections_articles sa
on sa.article_id = a.id
and sa.section_id = ?
left outer join
article_links ali
on ali.article_id = a.id
left outer join
article_files af
on af.article_id = a.id
left outer join
key_documents kd
on kd.article_id = a.id
inner join
article_translation_slugs ats
on ats.article_id = a.id
where
1=1
and a.status_id = ?
and a.type_id IN (?)
and a.type_id NOT IN (?)
and sa.section_id = ?
and a.is_deleted = ?
and (
a.expire_at > now()
or a.expire_at is null
or a.expire_at = '0000-00-00 00:00:00'
)
and a.publish_at <= now()
order by
a.publish_at desc
limit
?,
? | | Time: | 31 ms | | Records: | 11 | | Columns: | id, status_id, type_id, canonical_section_id, created_at, publish_at, created_by
author, source, editor_notes, citations, affiliation, type
type_slug, language_id, translation_status_id, translation_type_id, title, slug
blurb, body, keydocument_url, keydocument_type, publication_date, link_url
is_highlighted, display_order, section_id, en_slug, en_transtypeid, fr_slug
fr_transtypeid, zh_slug, zh_transtypeid, es_slug, es_transtypeid, po_slug
po_transtypeid, ar_slug, ar_transtypeid, section_slug, sub_section_slug, canonical_link
|
| | 9C32A6AA7AF9ED71CB85E6B09A33DA7E | | query [short version] | | Query Source: | SQL Query | | Datasource: | SCIDEV_PRODUCTION | | Query: | select
distinct
a.id,
a.status_id,
a.type_id,
a.canonical_section_id,
a.created_at,
a.publish_at,
a.created_by,
a.author,
a.source,
a.editor_notes,
a.citations,
a.affiliation,
at.name as type,
at.slug as type_slug,
atr.language_id,
atr.status_id as translation_status_id,
atr.translation_type_id,
atr.title,
atr.slug,
atr.blurb,
atr.body,
case
when ifnull(af.file_name,'') <> '' then af.file_name
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then kd.document_url
else ''
end as keydocument_url,
case
when ifnull(af.file_name,'') <> '' then 'file'
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then 'url'
else ''
end as keydocument_type,
kd.publication_date,
ifnull(ali.link_url,'') as link_url
,
sa.is_highlighted,
sa.display_order,
sa.section_id
,
a.is_deleted,
a.publish_at,
a.expire_at,
a.updated_at,
a.updated_by,
a.is_paid,
u.firstname,
u.lastname,
u.email
,
(select language_id from article_translations atr_temp where atr_temp.article_id = a.id and is_original = 1 limit 1) as original_language_id
,
ast.name as status_name
,'' AS section_slug
,'' AS sub_section_slug
,'' AS canonical_link
from
articles a
inner join
article_translations atr
on atr.article_id = a.id
and atr.language_id =
?
inner join
article_types at
on a.type_id = at.id
inner join
article_statuses ast
on ast.id = a.status_id
inner join
users u
on u.id = a.created_by
left outer join
sections_articles sa
on sa.article_id = a.id
and sa.section_id = ?
left outer join
article_links ali
on ali.article_id = a.id
left outer join
article_files af
on af.article_id = a.id
left outer join
key_documents kd
on kd.article_id = a.id
where
1=1
and a.status_id = ?
and a.type_id IN (?)
and sa.section_id = ?
and a.is_deleted = ?
and (
a.expire_at > now()
or a.expire_at is null
or a.expire_at = '0000-00-00 00:00:00'
)
and a.publish_at <= now()
order by
a.publish_at desc
limit
?,
? | | Time: | 31 ms | | Records: | 1 | | Columns: | id, status_id, type_id, canonical_section_id, created_at, publish_at, created_by
author, source, editor_notes, citations, affiliation, type
type_slug, language_id, translation_status_id, translation_type_id, title, slug
blurb, body, keydocument_url, keydocument_type, publication_date, link_url
is_highlighted, display_order, section_id, is_deleted, publish_at, expire_at
updated_at, updated_by, is_paid, firstname, lastname, email
original_language_id, status_name, section_slug, sub_section_slug, canonical_link |
| | 9D1E6712E26BD4A3B124A8BB7DF29FFE | | query [short version] | | Query Source: | SQL Query | | Datasource: | SCIDEV_PRODUCTION | | Query: | select
distinct
a.id,
a.status_id,
a.type_id,
a.canonical_section_id,
a.created_at,
a.publish_at,
a.created_by,
a.author,
a.source,
a.editor_notes,
a.citations,
a.affiliation,
at.name as type,
at.slug as type_slug,
atr.language_id,
atr.status_id as translation_status_id,
atr.translation_type_id,
atr.title,
atr.slug,
atr.blurb,
atr.body,
case
when ifnull(af.file_name,'') <> '' then af.file_name
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then kd.document_url
else ''
end as keydocument_url,
case
when ifnull(af.file_name,'') <> '' then 'file'
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then 'url'
else ''
end as keydocument_type,
kd.publication_date,
ifnull(ali.link_url,'') as link_url
,
sa.is_highlighted,
sa.display_order,
sa.section_id
,
ats.en_slug,
ats.en_transtypeid,
ats.fr_slug,
ats.fr_transtypeid,
ats.zh_slug,
ats.zh_transtypeid,
ats.es_slug,
ats.es_transtypeid,
ats.po_slug,
ats.po_transtypeid,
ats.ar_slug,
ats.ar_transtypeid
,'' AS section_slug
,'' AS sub_section_slug
,'' AS canonical_link
from
articles a
inner join
article_translations atr
on atr.article_id = a.id
and atr.language_id =
?
and atr.status_id = 2
inner join
article_types at
on a.type_id = at.id
inner join
article_statuses ast
on ast.id = a.status_id
inner join
users u
on u.id = a.created_by
left outer join
sections_articles sa
on sa.article_id = a.id
and sa.section_id = ?
left outer join
article_links ali
on ali.article_id = a.id
left outer join
article_files af
on af.article_id = a.id
left outer join
key_documents kd
on kd.article_id = a.id
inner join
article_translation_slugs ats
on ats.article_id = a.id
where
1=1
and a.status_id = ?
and a.type_id IN (?)
and a.type_id NOT IN (?)
and sa.section_id = ?
and a.is_deleted = ?
and (
a.expire_at > now()
or a.expire_at is null
or a.expire_at = '0000-00-00 00:00:00'
)
and a.publish_at <= now()
order by
a.publish_at desc
limit
?,
? | | Time: | 0 ms | | Records: | 4 | | Columns: | id, status_id, type_id, canonical_section_id, created_at, publish_at, created_by
author, source, editor_notes, citations, affiliation, type
type_slug, language_id, translation_status_id, translation_type_id, title, slug
blurb, body, keydocument_url, keydocument_type, publication_date, link_url
is_highlighted, display_order, section_id, en_slug, en_transtypeid, fr_slug
fr_transtypeid, zh_slug, zh_transtypeid, es_slug, es_transtypeid, po_slug
po_transtypeid, ar_slug, ar_transtypeid, section_slug, sub_section_slug, canonical_link
|
| | 9D7E5944A99F9040DC75EDBC36DF9FB9 | | query [short version] | | Query Source: | SQL Query | | Datasource: | SCIDEV_PRODUCTION | | Query: | select
count(distinct a.id) as count
from
articles a
inner join
article_translations atr
on atr.article_id = a.id
and atr.language_id =
?
inner join
article_types at
on a.type_id = at.id
inner join
article_statuses ast
on ast.id = a.status_id
inner join
users u
on u.id = a.created_by
left outer join
sections_articles sa
on sa.article_id = a.id
and sa.section_id = ?
left outer join
sections_articles sla
on sla.article_id = a.id
and sla.section_id = ?
left outer join
article_links ali
on ali.article_id = a.id
left outer join
article_files af
on af.article_id = a.id
left outer join
key_documents kd
on kd.article_id = a.id
where
1=1
and a.status_id = ?
and a.type_id IN (?)
and sa.section_id = ?
and sla.section_id = ?
and a.is_deleted = ?
and (
a.expire_at > now()
or a.expire_at is null
or a.expire_at = '0000-00-00 00:00:00'
)
and a.publish_at <= now()
order by
a.publish_at desc | | Time: | 0 ms | | Records: | 1 | | Columns: | count |
| | A77DE51947468C1B7EEA57801BA0498D | | query [short version] | | Query Source: | SQL Query | | Datasource: | SCIDEV_PRODUCTION | | Query: | select
count(distinct a.id) as count
from
articles a
inner join
article_translations atr
on atr.article_id = a.id
and atr.language_id =
?
inner join
article_types at
on a.type_id = at.id
inner join
article_statuses ast
on ast.id = a.status_id
inner join
users u
on u.id = a.created_by
left outer join
sections_articles sa
on sa.article_id = a.id
and sa.section_id = ?
left outer join
sections_articles sla
on sla.article_id = a.id
and sla.section_id = ?
left outer join
article_links ali
on ali.article_id = a.id
left outer join
article_files af
on af.article_id = a.id
left outer join
key_documents kd
on kd.article_id = a.id
where
1=1
and a.status_id = ?
and a.type_id IN (?)
and sa.section_id = ?
and sla.section_id = ?
and a.is_deleted = ?
and (
a.expire_at > now()
or a.expire_at is null
or a.expire_at = '0000-00-00 00:00:00'
)
and a.publish_at <= now()
order by
a.publish_at desc | | Time: | 16 ms | | Records: | 1 | | Columns: | count |
| | A8B81D5502C2F1FADEE7B2D87956AF49 | | query [short version] | | Query Source: | SQL Query | | Datasource: | SCIDEV_PRODUCTION | | Query: | select
distinct
a.id,
a.status_id,
a.type_id,
a.canonical_section_id,
a.created_at,
a.publish_at,
a.created_by,
a.author,
a.source,
a.editor_notes,
a.citations,
a.affiliation,
at.name as type,
at.slug as type_slug,
atr.language_id,
atr.status_id as translation_status_id,
atr.translation_type_id,
atr.title,
atr.slug,
atr.blurb,
atr.body,
case
when ifnull(af.file_name,'') <> '' then af.file_name
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then kd.document_url
else ''
end as keydocument_url,
case
when ifnull(af.file_name,'') <> '' then 'file'
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then 'url'
else ''
end as keydocument_type,
kd.publication_date,
ifnull(ali.link_url,'') as link_url
,
sa.is_highlighted,
sa.display_order,
sa.section_id
,
ats.en_slug,
ats.en_transtypeid,
ats.fr_slug,
ats.fr_transtypeid,
ats.zh_slug,
ats.zh_transtypeid,
ats.es_slug,
ats.es_transtypeid,
ats.po_slug,
ats.po_transtypeid,
ats.ar_slug,
ats.ar_transtypeid
,acl.parent_section_slug AS section_slug
,acl.section_slug AS sub_section_slug
,acl.canonical_link
from
articles a
inner join
article_translations atr
on atr.article_id = a.id
and atr.language_id =
?
and atr.status_id = 2
LEFT JOIN article_canonical_link acl on a.id = acl.article_id AND atr.language_id = acl.language_id
inner join
article_types at
on a.type_id = at.id
inner join
article_statuses ast
on ast.id = a.status_id
inner join
users u
on u.id = a.created_by
left outer join
sections_articles sa
on sa.article_id = a.id
and sa.section_id = ?
left outer join
article_links ali
on ali.article_id = a.id
left outer join
article_files af
on af.article_id = a.id
left outer join
key_documents kd
on kd.article_id = a.id
inner join
article_translation_slugs ats
on ats.article_id = a.id
where
1=1
and a.status_id = ?
and a.type_id IN (?)
and a.type_id NOT IN (?)
and sa.section_id = ?
and a.is_deleted = ?
and (
a.expire_at > now()
or a.expire_at is null
or a.expire_at = '0000-00-00 00:00:00'
)
and a.publish_at <= now()
order by
a.publish_at desc
limit
?,
? | | Time: | 703 ms | | Records: | 12 | | Columns: | id, status_id, type_id, canonical_section_id, created_at, publish_at, created_by
author, source, editor_notes, citations, affiliation, type
type_slug, language_id, translation_status_id, translation_type_id, title, slug
blurb, body, keydocument_url, keydocument_type, publication_date, link_url
is_highlighted, display_order, section_id, en_slug, en_transtypeid, fr_slug
fr_transtypeid, zh_slug, zh_transtypeid, es_slug, es_transtypeid, po_slug
po_transtypeid, ar_slug, ar_transtypeid, section_slug, sub_section_slug, canonical_link
|
| | A9998F882EB4EFDF86ABF06F5C07AC1B | | query [short version] | | Query Source: | SQL Query | | Datasource: | SCIDEV_PRODUCTION | | Query: | select
count(distinct a.id) as count
from
articles a
inner join
article_translations atr
on atr.article_id = a.id
and atr.language_id =
?
and atr.status_id = 2
inner join
article_types at
on a.type_id = at.id
inner join
article_statuses ast
on ast.id = a.status_id
inner join
users u
on u.id = a.created_by
left outer join
sections_articles sa
on sa.article_id = a.id
and sa.section_id = ?
left outer join
article_links ali
on ali.article_id = a.id
left outer join
article_files af
on af.article_id = a.id
left outer join
key_documents kd
on kd.article_id = a.id
inner join
article_translation_slugs ats
on ats.article_id = a.id
where
1=1
and a.status_id = ?
and a.type_id IN (?)
and a.type_id NOT IN (?)
and sa.section_id = ?
and a.is_deleted = ?
and (
a.expire_at > now()
or a.expire_at is null
or a.expire_at = '0000-00-00 00:00:00'
)
and a.publish_at <= now()
order by
a.publish_at desc | | Time: | 0 ms | | Records: | 1 | | Columns: | count |
| | AA4FAE30AEBC99A43FD32750D541396A | | query [short version] | | Query Source: | SQL Query | | Datasource: | SCIDEV_PRODUCTION | | Query: | select
distinct
a.id,
a.status_id,
a.type_id,
a.canonical_section_id,
a.created_at,
a.publish_at,
a.created_by,
a.author,
a.source,
a.editor_notes,
a.citations,
a.affiliation,
at.name as type,
at.slug as type_slug,
atr.language_id,
atr.status_id as translation_status_id,
atr.translation_type_id,
atr.title,
atr.slug,
atr.blurb,
atr.body,
case
when ifnull(af.file_name,'') <> '' then af.file_name
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then kd.document_url
else ''
end as keydocument_url,
case
when ifnull(af.file_name,'') <> '' then 'file'
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then 'url'
else ''
end as keydocument_type,
kd.publication_date,
ifnull(ali.link_url,'') as link_url
,
sa.is_highlighted,
sa.display_order,
sa.section_id
,
ats.en_slug,
ats.en_transtypeid,
ats.fr_slug,
ats.fr_transtypeid,
ats.zh_slug,
ats.zh_transtypeid,
ats.es_slug,
ats.es_transtypeid,
ats.po_slug,
ats.po_transtypeid,
ats.ar_slug,
ats.ar_transtypeid
,'' AS section_slug
,'' AS sub_section_slug
,'' AS canonical_link
from
articles a
inner join
article_translations atr
on atr.article_id = a.id
and atr.language_id =
?
and atr.status_id = 2
inner join
article_types at
on a.type_id = at.id
inner join
article_statuses ast
on ast.id = a.status_id
inner join
users u
on u.id = a.created_by
left outer join
sections_articles sa
on sa.article_id = a.id
and sa.section_id = ?
left outer join
article_links ali
on ali.article_id = a.id
left outer join
article_files af
on af.article_id = a.id
left outer join
key_documents kd
on kd.article_id = a.id
inner join
article_translation_slugs ats
on ats.article_id = a.id
where
1=1
and a.status_id = ?
and a.type_id IN (?)
and a.type_id NOT IN (?)
and sa.section_id = ?
and a.is_deleted = ?
and (
a.expire_at > now()
or a.expire_at is null
or a.expire_at = '0000-00-00 00:00:00'
)
and a.publish_at <= now()
order by
a.publish_at desc
limit
?,
? | | Time: | 16 ms | | Records: | 0 | | Columns: | id, status_id, type_id, canonical_section_id, created_at, publish_at, created_by
author, source, editor_notes, citations, affiliation, type
type_slug, language_id, translation_status_id, translation_type_id, title, slug
blurb, body, keydocument_url, keydocument_type, publication_date, link_url
is_highlighted, display_order, section_id, en_slug, en_transtypeid, fr_slug
fr_transtypeid, zh_slug, zh_transtypeid, es_slug, es_transtypeid, po_slug
po_transtypeid, ar_slug, ar_transtypeid, section_slug, sub_section_slug, canonical_link
|
| | AAA0F612561F6BEC64EBBA16685D2286 | | query [short version] | | Query Source: | SQL Query | | Datasource: | SCIDEV_PRODUCTION | | Query: | select
distinct
a.id,
a.status_id,
a.type_id,
a.canonical_section_id,
a.created_at,
a.publish_at,
a.created_by,
a.author,
a.source,
a.editor_notes,
a.citations,
a.affiliation,
at.name as type,
at.slug as type_slug,
atr.language_id,
atr.status_id as translation_status_id,
atr.translation_type_id,
atr.title,
atr.slug,
atr.blurb,
atr.body,
case
when ifnull(af.file_name,'') <> '' then af.file_name
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then kd.document_url
else ''
end as keydocument_url,
case
when ifnull(af.file_name,'') <> '' then 'file'
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then 'url'
else ''
end as keydocument_type,
kd.publication_date,
ifnull(ali.link_url,'') as link_url
,
sa.is_highlighted,
sa.display_order,
sa.section_id
,
ats.en_slug,
ats.en_transtypeid,
ats.fr_slug,
ats.fr_transtypeid,
ats.zh_slug,
ats.zh_transtypeid,
ats.es_slug,
ats.es_transtypeid,
ats.po_slug,
ats.po_transtypeid,
ats.ar_slug,
ats.ar_transtypeid
,'' AS section_slug
,'' AS sub_section_slug
,'' AS canonical_link
from
articles a
inner join
article_translations atr
on atr.article_id = a.id
and atr.language_id =
?
and atr.status_id = 2
inner join
article_types at
on a.type_id = at.id
inner join
article_statuses ast
on ast.id = a.status_id
inner join
users u
on u.id = a.created_by
left outer join
sections_articles sa
on sa.article_id = a.id
and sa.section_id = ?
left outer join
article_links ali
on ali.article_id = a.id
left outer join
article_files af
on af.article_id = a.id
left outer join
key_documents kd
on kd.article_id = a.id
inner join
article_translation_slugs ats
on ats.article_id = a.id
where
1=1
and a.status_id = ?
and a.type_id IN (?)
and a.type_id NOT IN (?)
and sa.section_id = ?
and a.is_deleted = ?
and (
a.expire_at > now()
or a.expire_at is null
or a.expire_at = '0000-00-00 00:00:00'
)
and a.publish_at <= now()
order by
a.publish_at desc
limit
?,
? | | Time: | 63 ms | | Records: | 20 | | Columns: | id, status_id, type_id, canonical_section_id, created_at, publish_at, created_by
author, source, editor_notes, citations, affiliation, type
type_slug, language_id, translation_status_id, translation_type_id, title, slug
blurb, body, keydocument_url, keydocument_type, publication_date, link_url
is_highlighted, display_order, section_id, en_slug, en_transtypeid, fr_slug
fr_transtypeid, zh_slug, zh_transtypeid, es_slug, es_transtypeid, po_slug
po_transtypeid, ar_slug, ar_transtypeid, section_slug, sub_section_slug, canonical_link
|
| | AB1B384A6264454C2752DAAA45CD3786 | | query [short version] | | Query Source: | SQL Query | | Datasource: | SCIDEV_PRODUCTION | | Query: | select
distinct
a.id,
a.status_id,
a.type_id,
a.canonical_section_id,
a.created_at,
a.publish_at,
a.created_by,
a.author,
a.source,
a.editor_notes,
a.citations,
a.affiliation,
at.name as type,
at.slug as type_slug,
atr.language_id,
atr.status_id as translation_status_id,
atr.translation_type_id,
atr.title,
atr.slug,
atr.blurb,
atr.body,
case
when ifnull(af.file_name,'') <> '' then af.file_name
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then kd.document_url
else ''
end as keydocument_url,
case
when ifnull(af.file_name,'') <> '' then 'file'
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then 'url'
else ''
end as keydocument_type,
kd.publication_date,
ifnull(ali.link_url,'') as link_url
,
sa.is_highlighted,
sa.display_order,
sa.section_id
,
ats.en_slug,
ats.en_transtypeid,
ats.fr_slug,
ats.fr_transtypeid,
ats.zh_slug,
ats.zh_transtypeid,
ats.es_slug,
ats.es_transtypeid,
ats.po_slug,
ats.po_transtypeid,
ats.ar_slug,
ats.ar_transtypeid
,'' AS section_slug
,'' AS sub_section_slug
,'' AS canonical_link
from
articles a
inner join
article_translations atr
on atr.article_id = a.id
and atr.language_id =
?
and atr.status_id = 2
inner join
article_types at
on a.type_id = at.id
inner join
article_statuses ast
on ast.id = a.status_id
inner join
users u
on u.id = a.created_by
left outer join
sections_articles sa
on sa.article_id = a.id
and sa.section_id = ?
left outer join
article_links ali
on ali.article_id = a.id
left outer join
article_files af
on af.article_id = a.id
left outer join
key_documents kd
on kd.article_id = a.id
inner join
article_translation_slugs ats
on ats.article_id = a.id
where
1=1
and a.status_id = ?
and a.type_id IN (?)
and a.type_id NOT IN (?)
and sa.section_id = ?
and a.is_deleted = ?
and (
a.expire_at > now()
or a.expire_at is null
or a.expire_at = '0000-00-00 00:00:00'
)
and a.publish_at <= now()
order by
a.publish_at desc
limit
?,
? | | Time: | 32 ms | | Records: | 15 | | Columns: | id, status_id, type_id, canonical_section_id, created_at, publish_at, created_by
author, source, editor_notes, citations, affiliation, type
type_slug, language_id, translation_status_id, translation_type_id, title, slug
blurb, body, keydocument_url, keydocument_type, publication_date, link_url
is_highlighted, display_order, section_id, en_slug, en_transtypeid, fr_slug
fr_transtypeid, zh_slug, zh_transtypeid, es_slug, es_transtypeid, po_slug
po_transtypeid, ar_slug, ar_transtypeid, section_slug, sub_section_slug, canonical_link
|
| | B024FADCDCB20A4CDF4F4817D10F7CB3 | | query [short version] | | Query Source: | SQL Query | | Datasource: | SCIDEV_PRODUCTION | | Query: | select
distinct
a.id,
a.status_id,
a.type_id,
a.canonical_section_id,
a.created_at,
a.publish_at,
a.created_by,
a.author,
a.source,
a.editor_notes,
a.citations,
a.affiliation,
at.name as type,
at.slug as type_slug,
atr.language_id,
atr.status_id as translation_status_id,
atr.translation_type_id,
atr.title,
atr.slug,
atr.blurb,
atr.body,
case
when ifnull(af.file_name,'') <> '' then af.file_name
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then kd.document_url
else ''
end as keydocument_url,
case
when ifnull(af.file_name,'') <> '' then 'file'
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then 'url'
else ''
end as keydocument_type,
kd.publication_date,
ifnull(ali.link_url,'') as link_url
,
sa.is_highlighted,
sa.display_order,
sa.section_id
,
ats.en_slug,
ats.en_transtypeid,
ats.fr_slug,
ats.fr_transtypeid,
ats.zh_slug,
ats.zh_transtypeid,
ats.es_slug,
ats.es_transtypeid,
ats.po_slug,
ats.po_transtypeid,
ats.ar_slug,
ats.ar_transtypeid
,'' AS section_slug
,'' AS sub_section_slug
,'' AS canonical_link
from
articles a
inner join
article_translations atr
on atr.article_id = a.id
and atr.language_id =
?
and atr.status_id = 2
inner join
article_types at
on a.type_id = at.id
inner join
article_statuses ast
on ast.id = a.status_id
inner join
users u
on u.id = a.created_by
left outer join
sections_articles sa
on sa.article_id = a.id
and sa.section_id = ?
left outer join
article_links ali
on ali.article_id = a.id
left outer join
article_files af
on af.article_id = a.id
left outer join
key_documents kd
on kd.article_id = a.id
inner join
article_translation_slugs ats
on ats.article_id = a.id
where
1=1
and a.status_id = ?
and a.type_id IN (?)
and a.type_id NOT IN (?)
and sa.section_id = ?
and a.is_deleted = ?
and (
a.expire_at > now()
or a.expire_at is null
or a.expire_at = '0000-00-00 00:00:00'
)
and a.publish_at <= now()
order by
a.publish_at desc
limit
?,
? | | Time: | 62 ms | | Records: | 0 | | Columns: | id, status_id, type_id, canonical_section_id, created_at, publish_at, created_by
author, source, editor_notes, citations, affiliation, type
type_slug, language_id, translation_status_id, translation_type_id, title, slug
blurb, body, keydocument_url, keydocument_type, publication_date, link_url
is_highlighted, display_order, section_id, en_slug, en_transtypeid, fr_slug
fr_transtypeid, zh_slug, zh_transtypeid, es_slug, es_transtypeid, po_slug
po_transtypeid, ar_slug, ar_transtypeid, section_slug, sub_section_slug, canonical_link
|
| | B164105317F4D2946C2285F7BC82D018 | | query [short version] | | Query Source: | SQL Query | | Datasource: | SCIDEV_PRODUCTION | | Query: | select
distinct
a.id,
a.status_id,
a.type_id,
a.canonical_section_id,
a.created_at,
a.publish_at,
a.created_by,
a.author,
a.source,
a.editor_notes,
a.citations,
a.affiliation,
at.name as type,
at.slug as type_slug,
atr.language_id,
atr.status_id as translation_status_id,
atr.translation_type_id,
atr.title,
atr.slug,
atr.blurb,
atr.body,
case
when ifnull(af.file_name,'') <> '' then af.file_name
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then kd.document_url
else ''
end as keydocument_url,
case
when ifnull(af.file_name,'') <> '' then 'file'
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then 'url'
else ''
end as keydocument_type,
kd.publication_date,
ifnull(ali.link_url,'') as link_url
,
sa.is_highlighted,
sa.display_order,
sa.section_id
,
ats.en_slug,
ats.en_transtypeid,
ats.fr_slug,
ats.fr_transtypeid,
ats.zh_slug,
ats.zh_transtypeid,
ats.es_slug,
ats.es_transtypeid,
ats.po_slug,
ats.po_transtypeid,
ats.ar_slug,
ats.ar_transtypeid
,'' AS section_slug
,'' AS sub_section_slug
,'' AS canonical_link
from
articles a
inner join
article_translations atr
on atr.article_id = a.id
and atr.language_id =
?
and atr.status_id = 2
inner join
article_types at
on a.type_id = at.id
inner join
article_statuses ast
on ast.id = a.status_id
inner join
users u
on u.id = a.created_by
left outer join
sections_articles sa
on sa.article_id = a.id
and sa.section_id = ?
left outer join
article_links ali
on ali.article_id = a.id
left outer join
article_files af
on af.article_id = a.id
left outer join
key_documents kd
on kd.article_id = a.id
inner join
article_translation_slugs ats
on ats.article_id = a.id
where
1=1
and a.status_id = ?
and a.type_id IN (?)
and a.type_id NOT IN (?)
and sa.section_id = ?
and a.is_deleted = ?
and (
a.expire_at > now()
or a.expire_at is null
or a.expire_at = '0000-00-00 00:00:00'
)
and a.publish_at <= now()
order by
a.publish_at desc
limit
?,
? | | Time: | 46 ms | | Records: | 0 | | Columns: | id, status_id, type_id, canonical_section_id, created_at, publish_at, created_by
author, source, editor_notes, citations, affiliation, type
type_slug, language_id, translation_status_id, translation_type_id, title, slug
blurb, body, keydocument_url, keydocument_type, publication_date, link_url
is_highlighted, display_order, section_id, en_slug, en_transtypeid, fr_slug
fr_transtypeid, zh_slug, zh_transtypeid, es_slug, es_transtypeid, po_slug
po_transtypeid, ar_slug, ar_transtypeid, section_slug, sub_section_slug, canonical_link
|
| | B36AF8262EC7C6A44F304BB2B613DF6C | | query [short version] | | Query Source: | SQL Query | | Datasource: | SCIDEV_PRODUCTION | | Query: | select
distinct
a.id,
a.status_id,
a.type_id,
a.canonical_section_id,
a.created_at,
a.publish_at,
a.created_by,
a.author,
a.source,
a.editor_notes,
a.citations,
a.affiliation,
at.name as type,
at.slug as type_slug,
atr.language_id,
atr.status_id as translation_status_id,
atr.translation_type_id,
atr.title,
atr.slug,
atr.blurb,
atr.body,
case
when ifnull(af.file_name,'') <> '' then af.file_name
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then kd.document_url
else ''
end as keydocument_url,
case
when ifnull(af.file_name,'') <> '' then 'file'
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then 'url'
else ''
end as keydocument_type,
kd.publication_date,
ifnull(ali.link_url,'') as link_url
,
sa.is_highlighted,
sa.display_order,
sa.section_id
,
ats.en_slug,
ats.en_transtypeid,
ats.fr_slug,
ats.fr_transtypeid,
ats.zh_slug,
ats.zh_transtypeid,
ats.es_slug,
ats.es_transtypeid,
ats.po_slug,
ats.po_transtypeid,
ats.ar_slug,
ats.ar_transtypeid
,'' AS section_slug
,'' AS sub_section_slug
,'' AS canonical_link
from
articles a
inner join
article_translations atr
on atr.article_id = a.id
and atr.language_id =
?
and atr.status_id = 2
inner join
article_types at
on a.type_id = at.id
inner join
article_statuses ast
on ast.id = a.status_id
inner join
users u
on u.id = a.created_by
left outer join
sections_articles sa
on sa.article_id = a.id
and sa.section_id = ?
left outer join
article_links ali
on ali.article_id = a.id
left outer join
article_files af
on af.article_id = a.id
left outer join
key_documents kd
on kd.article_id = a.id
inner join
article_translation_slugs ats
on ats.article_id = a.id
where
1=1
and a.status_id = ?
and a.type_id IN (?)
and a.type_id NOT IN (?)
and sa.section_id = ?
and a.is_deleted = ?
and (
a.expire_at > now()
or a.expire_at is null
or a.expire_at = '0000-00-00 00:00:00'
)
and a.publish_at <= now()
order by
a.publish_at desc
limit
?,
? | | Time: | 0 ms | | Records: | 0 | | Columns: | id, status_id, type_id, canonical_section_id, created_at, publish_at, created_by
author, source, editor_notes, citations, affiliation, type
type_slug, language_id, translation_status_id, translation_type_id, title, slug
blurb, body, keydocument_url, keydocument_type, publication_date, link_url
is_highlighted, display_order, section_id, en_slug, en_transtypeid, fr_slug
fr_transtypeid, zh_slug, zh_transtypeid, es_slug, es_transtypeid, po_slug
po_transtypeid, ar_slug, ar_transtypeid, section_slug, sub_section_slug, canonical_link
|
| | B65DD7B21F6875F39CBA035B61A5EC1C | | query [short version] | | Query Source: | SQL Query | | Datasource: | SCIDEV_PRODUCTION | | Query: | select
distinct
a.id,
a.status_id,
a.type_id,
a.canonical_section_id,
a.created_at,
a.publish_at,
a.created_by,
a.author,
a.source,
a.editor_notes,
a.citations,
a.affiliation,
at.name as type,
at.slug as type_slug,
atr.language_id,
atr.status_id as translation_status_id,
atr.translation_type_id,
atr.title,
atr.slug,
atr.blurb,
atr.body,
case
when ifnull(af.file_name,'') <> '' then af.file_name
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then kd.document_url
else ''
end as keydocument_url,
case
when ifnull(af.file_name,'') <> '' then 'file'
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then 'url'
else ''
end as keydocument_type,
kd.publication_date,
ifnull(ali.link_url,'') as link_url
,
sa.is_highlighted,
sa.display_order,
sa.section_id
,
ats.en_slug,
ats.en_transtypeid,
ats.fr_slug,
ats.fr_transtypeid,
ats.zh_slug,
ats.zh_transtypeid,
ats.es_slug,
ats.es_transtypeid,
ats.po_slug,
ats.po_transtypeid,
ats.ar_slug,
ats.ar_transtypeid
,'' AS section_slug
,'' AS sub_section_slug
,'' AS canonical_link
from
articles a
inner join
article_translations atr
on atr.article_id = a.id
and atr.language_id =
?
and atr.status_id = 2
inner join
article_types at
on a.type_id = at.id
inner join
article_statuses ast
on ast.id = a.status_id
inner join
users u
on u.id = a.created_by
left outer join
sections_articles sa
on sa.article_id = a.id
and sa.section_id = ?
left outer join
article_links ali
on ali.article_id = a.id
left outer join
article_files af
on af.article_id = a.id
left outer join
key_documents kd
on kd.article_id = a.id
inner join
article_translation_slugs ats
on ats.article_id = a.id
where
1=1
and a.status_id = ?
and a.type_id IN (?,?)
and a.type_id NOT IN (?)
and sa.section_id = ?
and a.is_deleted = ?
and (
a.expire_at > now()
or a.expire_at is null
or a.expire_at = '0000-00-00 00:00:00'
)
and a.publish_at <= now()
order by
a.publish_at desc
limit
?,
? | | Time: | 437 ms | | Records: | 20 | | Columns: | id, status_id, type_id, canonical_section_id, created_at, publish_at, created_by
author, source, editor_notes, citations, affiliation, type
type_slug, language_id, translation_status_id, translation_type_id, title, slug
blurb, body, keydocument_url, keydocument_type, publication_date, link_url
is_highlighted, display_order, section_id, en_slug, en_transtypeid, fr_slug
fr_transtypeid, zh_slug, zh_transtypeid, es_slug, es_transtypeid, po_slug
po_transtypeid, ar_slug, ar_transtypeid, section_slug, sub_section_slug, canonical_link
|
| | B9A50D73D37C52272B4169563B9703B4 | | query [short version] | | Query Source: | SQL Query | | Datasource: | SCIDEV_PRODUCTION | | Query: | select
distinct
a.id,
a.status_id,
a.type_id,
a.canonical_section_id,
a.created_at,
a.publish_at,
a.created_by,
a.author,
a.source,
a.editor_notes,
a.citations,
a.affiliation,
at.name as type,
at.slug as type_slug,
atr.language_id,
atr.status_id as translation_status_id,
atr.translation_type_id,
atr.title,
atr.slug,
atr.blurb,
atr.body,
case
when ifnull(af.file_name,'') <> '' then af.file_name
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then kd.document_url
else ''
end as keydocument_url,
case
when ifnull(af.file_name,'') <> '' then 'file'
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then 'url'
else ''
end as keydocument_type,
kd.publication_date,
ifnull(ali.link_url,'') as link_url
,
sa.is_highlighted,
sa.display_order,
sa.section_id
,
ats.en_slug,
ats.en_transtypeid,
ats.fr_slug,
ats.fr_transtypeid,
ats.zh_slug,
ats.zh_transtypeid,
ats.es_slug,
ats.es_transtypeid,
ats.po_slug,
ats.po_transtypeid,
ats.ar_slug,
ats.ar_transtypeid
,acl.parent_section_slug AS section_slug
,acl.section_slug AS sub_section_slug
,acl.canonical_link
from
articles a
inner join
article_translations atr
on atr.article_id = a.id
and atr.language_id =
?
and atr.status_id = 2
LEFT JOIN article_canonical_link acl on a.id = acl.article_id AND atr.language_id = acl.language_id
inner join
article_types at
on a.type_id = at.id
inner join
article_statuses ast
on ast.id = a.status_id
inner join
users u
on u.id = a.created_by
left outer join
sections_articles sa
on sa.article_id = a.id
and sa.section_id = ?
left outer join
article_links ali
on ali.article_id = a.id
left outer join
article_files af
on af.article_id = a.id
left outer join
key_documents kd
on kd.article_id = a.id
inner join
article_translation_slugs ats
on ats.article_id = a.id
where
1=1
and a.status_id = ?
and a.type_id IN (?)
and a.type_id NOT IN (?)
and sa.section_id = ?
and a.is_deleted = ?
and (
a.expire_at > now()
or a.expire_at is null
or a.expire_at = '0000-00-00 00:00:00'
)
and a.publish_at <= now()
order by
a.publish_at desc
limit
?,
? | | Time: | 172 ms | | Records: | 8 | | Columns: | id, status_id, type_id, canonical_section_id, created_at, publish_at, created_by
author, source, editor_notes, citations, affiliation, type
type_slug, language_id, translation_status_id, translation_type_id, title, slug
blurb, body, keydocument_url, keydocument_type, publication_date, link_url
is_highlighted, display_order, section_id, en_slug, en_transtypeid, fr_slug
fr_transtypeid, zh_slug, zh_transtypeid, es_slug, es_transtypeid, po_slug
po_transtypeid, ar_slug, ar_transtypeid, section_slug, sub_section_slug, canonical_link
|
| | BEF8D900500FE932740DD64CE3FD86CD | | query [short version] | | Query Source: | SQL Query | | Datasource: | SCIDEV_PRODUCTION | | Query: | select
count(distinct a.id) as count
from
articles a
inner join
article_translations atr
on atr.article_id = a.id
and atr.language_id =
?
and atr.status_id = 2
inner join
article_types at
on a.type_id = at.id
inner join
article_statuses ast
on ast.id = a.status_id
inner join
users u
on u.id = a.created_by
left outer join
sections_articles sa
on sa.article_id = a.id
and sa.section_id = ?
left outer join
article_links ali
on ali.article_id = a.id
left outer join
article_files af
on af.article_id = a.id
left outer join
key_documents kd
on kd.article_id = a.id
inner join
article_translation_slugs ats
on ats.article_id = a.id
where
1=1
and a.status_id = ?
and a.type_id IN (?)
and a.type_id NOT IN (?)
and sa.section_id = ?
and a.is_deleted = ?
and (
a.expire_at > now()
or a.expire_at is null
or a.expire_at = '0000-00-00 00:00:00'
)
and a.publish_at <= now()
order by
a.publish_at desc | | Time: | 16 ms | | Records: | 1 | | Columns: | count |
| | C3533A3F120D9873A333853C91361F23 | | query [short version] | | Query Source: | SQL Query | | Datasource: | SCIDEV_PRODUCTION | | Query: | select
distinct
a.id,
a.status_id,
a.type_id,
a.canonical_section_id,
a.created_at,
a.publish_at,
a.created_by,
a.author,
a.source,
a.editor_notes,
a.citations,
a.affiliation,
at.name as type,
at.slug as type_slug,
atr.language_id,
atr.status_id as translation_status_id,
atr.translation_type_id,
atr.title,
atr.slug,
atr.blurb,
atr.body,
case
when ifnull(af.file_name,'') <> '' then af.file_name
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then kd.document_url
else ''
end as keydocument_url,
case
when ifnull(af.file_name,'') <> '' then 'file'
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then 'url'
else ''
end as keydocument_type,
kd.publication_date,
ifnull(ali.link_url,'') as link_url
,
sa.is_highlighted,
sa.display_order,
sa.section_id
,
ats.en_slug,
ats.en_transtypeid,
ats.fr_slug,
ats.fr_transtypeid,
ats.zh_slug,
ats.zh_transtypeid,
ats.es_slug,
ats.es_transtypeid,
ats.po_slug,
ats.po_transtypeid,
ats.ar_slug,
ats.ar_transtypeid
,'' AS section_slug
,'' AS sub_section_slug
,'' AS canonical_link
from
articles a
inner join
article_translations atr
on atr.article_id = a.id
and atr.language_id =
?
and atr.status_id = 2
inner join
article_types at
on a.type_id = at.id
inner join
article_statuses ast
on ast.id = a.status_id
inner join
users u
on u.id = a.created_by
left outer join
sections_articles sa
on sa.article_id = a.id
and sa.section_id = ?
left outer join
article_links ali
on ali.article_id = a.id
left outer join
article_files af
on af.article_id = a.id
left outer join
key_documents kd
on kd.article_id = a.id
inner join
article_translation_slugs ats
on ats.article_id = a.id
where
1=1
and a.status_id = ?
and a.type_id IN (?,?)
and a.type_id NOT IN (?)
and sa.section_id = ?
and a.is_deleted = ?
and (
a.expire_at > now()
or a.expire_at is null
or a.expire_at = '0000-00-00 00:00:00'
)
and a.publish_at <= now()
order by
a.publish_at desc
limit
?,
? | | Time: | 78 ms | | Records: | 20 | | Columns: | id, status_id, type_id, canonical_section_id, created_at, publish_at, created_by
author, source, editor_notes, citations, affiliation, type
type_slug, language_id, translation_status_id, translation_type_id, title, slug
blurb, body, keydocument_url, keydocument_type, publication_date, link_url
is_highlighted, display_order, section_id, en_slug, en_transtypeid, fr_slug
fr_transtypeid, zh_slug, zh_transtypeid, es_slug, es_transtypeid, po_slug
po_transtypeid, ar_slug, ar_transtypeid, section_slug, sub_section_slug, canonical_link
|
| | C65C5B1E384CE0A61D03A4AE95BE2E75 | | query [short version] | | Query Source: | SQL Query | | Datasource: | SCIDEV_PRODUCTION | | Query: | select
distinct
a.id,
a.status_id,
a.type_id,
a.canonical_section_id,
a.created_at,
a.publish_at,
a.created_by,
a.author,
a.source,
a.editor_notes,
a.citations,
a.affiliation,
at.name as type,
at.slug as type_slug,
atr.language_id,
atr.status_id as translation_status_id,
atr.translation_type_id,
atr.title,
atr.slug,
atr.blurb,
atr.body,
case
when ifnull(af.file_name,'') <> '' then af.file_name
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then kd.document_url
else ''
end as keydocument_url,
case
when ifnull(af.file_name,'') <> '' then 'file'
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then 'url'
else ''
end as keydocument_type,
kd.publication_date,
ifnull(ali.link_url,'') as link_url
,
sa.is_highlighted,
sa.display_order,
sa.section_id
,
ats.en_slug,
ats.en_transtypeid,
ats.fr_slug,
ats.fr_transtypeid,
ats.zh_slug,
ats.zh_transtypeid,
ats.es_slug,
ats.es_transtypeid,
ats.po_slug,
ats.po_transtypeid,
ats.ar_slug,
ats.ar_transtypeid
,'' AS section_slug
,'' AS sub_section_slug
,'' AS canonical_link
from
articles a
inner join
article_translations atr
on atr.article_id = a.id
and atr.language_id =
?
and atr.status_id = 2
inner join
article_types at
on a.type_id = at.id
inner join
article_statuses ast
on ast.id = a.status_id
inner join
users u
on u.id = a.created_by
left outer join
sections_articles sa
on sa.article_id = a.id
and sa.section_id = ?
left outer join
article_links ali
on ali.article_id = a.id
left outer join
article_files af
on af.article_id = a.id
left outer join
key_documents kd
on kd.article_id = a.id
inner join
article_translation_slugs ats
on ats.article_id = a.id
where
1=1
and a.status_id = ?
and a.type_id IN (?,?)
and a.type_id NOT IN (?)
and sa.section_id = ?
and a.is_deleted = ?
and (
a.expire_at > now()
or a.expire_at is null
or a.expire_at = '0000-00-00 00:00:00'
)
and a.publish_at <= now()
order by
a.publish_at desc
limit
?,
? | | Time: | 47 ms | | Records: | 20 | | Columns: | id, status_id, type_id, canonical_section_id, created_at, publish_at, created_by
author, source, editor_notes, citations, affiliation, type
type_slug, language_id, translation_status_id, translation_type_id, title, slug
blurb, body, keydocument_url, keydocument_type, publication_date, link_url
is_highlighted, display_order, section_id, en_slug, en_transtypeid, fr_slug
fr_transtypeid, zh_slug, zh_transtypeid, es_slug, es_transtypeid, po_slug
po_transtypeid, ar_slug, ar_transtypeid, section_slug, sub_section_slug, canonical_link
|
| | C737497F4DE63A883012F7223691CCBF | | query [short version] | | Query Source: | SQL Query | | Datasource: | SCIDEV_PRODUCTION | | Query: | select
distinct
a.id,
a.status_id,
a.type_id,
a.canonical_section_id,
a.created_at,
a.publish_at,
a.created_by,
a.author,
a.source,
a.editor_notes,
a.citations,
a.affiliation,
at.name as type,
at.slug as type_slug,
atr.language_id,
atr.status_id as translation_status_id,
atr.translation_type_id,
atr.title,
atr.slug,
atr.blurb,
atr.body,
case
when ifnull(af.file_name,'') <> '' then af.file_name
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then kd.document_url
else ''
end as keydocument_url,
case
when ifnull(af.file_name,'') <> '' then 'file'
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then 'url'
else ''
end as keydocument_type,
kd.publication_date,
ifnull(ali.link_url,'') as link_url
,
sa.is_highlighted,
sa.display_order,
sa.section_id
,
ats.en_slug,
ats.en_transtypeid,
ats.fr_slug,
ats.fr_transtypeid,
ats.zh_slug,
ats.zh_transtypeid,
ats.es_slug,
ats.es_transtypeid,
ats.po_slug,
ats.po_transtypeid,
ats.ar_slug,
ats.ar_transtypeid
,'' AS section_slug
,'' AS sub_section_slug
,'' AS canonical_link
from
articles a
inner join
article_translations atr
on atr.article_id = a.id
and atr.language_id =
?
and atr.status_id = 2
inner join
article_types at
on a.type_id = at.id
inner join
article_statuses ast
on ast.id = a.status_id
inner join
users u
on u.id = a.created_by
left outer join
sections_articles sa
on sa.article_id = a.id
and sa.section_id = ?
left outer join
article_links ali
on ali.article_id = a.id
left outer join
article_files af
on af.article_id = a.id
left outer join
key_documents kd
on kd.article_id = a.id
inner join
article_translation_slugs ats
on ats.article_id = a.id
where
1=1
and a.status_id = ?
and a.type_id IN (?)
and a.type_id NOT IN (?)
and sa.section_id = ?
and a.is_deleted = ?
and (
a.expire_at > now()
or a.expire_at is null
or a.expire_at = '0000-00-00 00:00:00'
)
and a.publish_at <= now()
order by
a.publish_at desc
limit
?,
? | | Time: | 63 ms | | Records: | 20 | | Columns: | id, status_id, type_id, canonical_section_id, created_at, publish_at, created_by
author, source, editor_notes, citations, affiliation, type
type_slug, language_id, translation_status_id, translation_type_id, title, slug
blurb, body, keydocument_url, keydocument_type, publication_date, link_url
is_highlighted, display_order, section_id, en_slug, en_transtypeid, fr_slug
fr_transtypeid, zh_slug, zh_transtypeid, es_slug, es_transtypeid, po_slug
po_transtypeid, ar_slug, ar_transtypeid, section_slug, sub_section_slug, canonical_link
|
| | C84AEEC6819496271946D5E936B5CABF | | query [short version] | | Query Source: | SQL Query | | Datasource: | SCIDEV_PRODUCTION | | Query: | select
distinct
a.id,
a.status_id,
a.type_id,
a.canonical_section_id,
a.created_at,
a.publish_at,
a.created_by,
a.author,
a.source,
a.editor_notes,
a.citations,
a.affiliation,
at.name as type,
at.slug as type_slug,
atr.language_id,
atr.status_id as translation_status_id,
atr.translation_type_id,
atr.title,
atr.slug,
atr.blurb,
atr.body,
case
when ifnull(af.file_name,'') <> '' then af.file_name
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then kd.document_url
else ''
end as keydocument_url,
case
when ifnull(af.file_name,'') <> '' then 'file'
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then 'url'
else ''
end as keydocument_type,
kd.publication_date,
ifnull(ali.link_url,'') as link_url
,
sa.is_highlighted,
sa.display_order,
sa.section_id
,
ats.en_slug,
ats.en_transtypeid,
ats.fr_slug,
ats.fr_transtypeid,
ats.zh_slug,
ats.zh_transtypeid,
ats.es_slug,
ats.es_transtypeid,
ats.po_slug,
ats.po_transtypeid,
ats.ar_slug,
ats.ar_transtypeid
,'' AS section_slug
,'' AS sub_section_slug
,'' AS canonical_link
from
articles a
inner join
article_translations atr
on atr.article_id = a.id
and atr.language_id =
?
and atr.status_id = 2
inner join
article_types at
on a.type_id = at.id
inner join
article_statuses ast
on ast.id = a.status_id
inner join
users u
on u.id = a.created_by
left outer join
sections_articles sa
on sa.article_id = a.id
and sa.section_id = ?
left outer join
article_links ali
on ali.article_id = a.id
left outer join
article_files af
on af.article_id = a.id
left outer join
key_documents kd
on kd.article_id = a.id
inner join
article_translation_slugs ats
on ats.article_id = a.id
where
1=1
and a.status_id = ?
and a.type_id IN (?)
and a.type_id NOT IN (?)
and sa.section_id = ?
and a.is_deleted = ?
and (
a.expire_at > now()
or a.expire_at is null
or a.expire_at = '0000-00-00 00:00:00'
)
and a.publish_at <= now()
order by
a.publish_at desc
limit
?,
? | | Time: | 63 ms | | Records: | 0 | | Columns: | id, status_id, type_id, canonical_section_id, created_at, publish_at, created_by
author, source, editor_notes, citations, affiliation, type
type_slug, language_id, translation_status_id, translation_type_id, title, slug
blurb, body, keydocument_url, keydocument_type, publication_date, link_url
is_highlighted, display_order, section_id, en_slug, en_transtypeid, fr_slug
fr_transtypeid, zh_slug, zh_transtypeid, es_slug, es_transtypeid, po_slug
po_transtypeid, ar_slug, ar_transtypeid, section_slug, sub_section_slug, canonical_link
|
| | C9BD56C301375AB361071DDCC25E221E | | query [short version] | | Query Source: | SQL Query | | Datasource: | SCIDEV_PRODUCTION | | Query: | select
distinct
a.id,
a.status_id,
a.type_id,
a.canonical_section_id,
a.created_at,
a.publish_at,
a.created_by,
a.author,
a.source,
a.editor_notes,
a.citations,
a.affiliation,
at.name as type,
at.slug as type_slug,
atr.language_id,
atr.status_id as translation_status_id,
atr.translation_type_id,
atr.title,
atr.slug,
atr.blurb,
atr.body,
case
when ifnull(af.file_name,'') <> '' then af.file_name
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then kd.document_url
else ''
end as keydocument_url,
case
when ifnull(af.file_name,'') <> '' then 'file'
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then 'url'
else ''
end as keydocument_type,
kd.publication_date,
ifnull(ali.link_url,'') as link_url
,
sa.is_highlighted,
sa.display_order,
sa.section_id
,
ats.en_slug,
ats.en_transtypeid,
ats.fr_slug,
ats.fr_transtypeid,
ats.zh_slug,
ats.zh_transtypeid,
ats.es_slug,
ats.es_transtypeid,
ats.po_slug,
ats.po_transtypeid,
ats.ar_slug,
ats.ar_transtypeid
,'' AS section_slug
,'' AS sub_section_slug
,'' AS canonical_link
from
articles a
inner join
article_translations atr
on atr.article_id = a.id
and atr.language_id =
?
and atr.status_id = 2
inner join
article_types at
on a.type_id = at.id
inner join
article_statuses ast
on ast.id = a.status_id
inner join
users u
on u.id = a.created_by
left outer join
sections_articles sa
on sa.article_id = a.id
and sa.section_id = ?
left outer join
article_links ali
on ali.article_id = a.id
left outer join
article_files af
on af.article_id = a.id
left outer join
key_documents kd
on kd.article_id = a.id
inner join
article_translation_slugs ats
on ats.article_id = a.id
where
1=1
and a.status_id = ?
and a.type_id IN (?)
and a.type_id NOT IN (?)
and sa.section_id = ?
and a.is_deleted = ?
and (
a.expire_at > now()
or a.expire_at is null
or a.expire_at = '0000-00-00 00:00:00'
)
and a.publish_at <= now()
order by
a.publish_at desc
limit
?,
? | | Time: | 16 ms | | Records: | 20 | | Columns: | id, status_id, type_id, canonical_section_id, created_at, publish_at, created_by
author, source, editor_notes, citations, affiliation, type
type_slug, language_id, translation_status_id, translation_type_id, title, slug
blurb, body, keydocument_url, keydocument_type, publication_date, link_url
is_highlighted, display_order, section_id, en_slug, en_transtypeid, fr_slug
fr_transtypeid, zh_slug, zh_transtypeid, es_slug, es_transtypeid, po_slug
po_transtypeid, ar_slug, ar_transtypeid, section_slug, sub_section_slug, canonical_link
|
| | CB3E3522D643C0F6BFF385C13F6AB7DE | | query [short version] | | Query Source: | Query of Queries | | Records: | 5 | | Columns: | id, slug, type, type_slug, title, blurb, publish_at
ar_slug, ar_transtypeid, es_slug, en_slug, en_transtypeid, es_slug
es_transtypeid, fr_slug, fr_transtypeid, po_slug, po_transtypeid, zh_slug
zh_transtypeid, source, author, section_slug, sub_section_slug, canonical_link
|
| | CE190252D89480E4D14F9363766E8E91 | | query [short version] | | Query Source: | SQL Query | | Datasource: | SCIDEV_PRODUCTION | | Query: | select
distinct
a.id,
a.status_id,
a.type_id,
a.canonical_section_id,
a.created_at,
a.publish_at,
a.created_by,
a.author,
a.source,
a.editor_notes,
a.citations,
a.affiliation,
at.name as type,
at.slug as type_slug,
atr.language_id,
atr.status_id as translation_status_id,
atr.translation_type_id,
atr.title,
atr.slug,
atr.blurb,
atr.body,
case
when ifnull(af.file_name,'') <> '' then af.file_name
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then kd.document_url
else ''
end as keydocument_url,
case
when ifnull(af.file_name,'') <> '' then 'file'
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then 'url'
else ''
end as keydocument_type,
kd.publication_date,
ifnull(ali.link_url,'') as link_url
,
sa.is_highlighted,
sa.display_order,
sa.section_id
,
ats.en_slug,
ats.en_transtypeid,
ats.fr_slug,
ats.fr_transtypeid,
ats.zh_slug,
ats.zh_transtypeid,
ats.es_slug,
ats.es_transtypeid,
ats.po_slug,
ats.po_transtypeid,
ats.ar_slug,
ats.ar_transtypeid
,'' AS section_slug
,'' AS sub_section_slug
,'' AS canonical_link
from
articles a
inner join
article_translations atr
on atr.article_id = a.id
and atr.language_id =
?
and atr.status_id = 2
inner join
article_types at
on a.type_id = at.id
inner join
article_statuses ast
on ast.id = a.status_id
inner join
users u
on u.id = a.created_by
left outer join
sections_articles sa
on sa.article_id = a.id
and sa.section_id = ?
left outer join
article_links ali
on ali.article_id = a.id
left outer join
article_files af
on af.article_id = a.id
left outer join
key_documents kd
on kd.article_id = a.id
inner join
article_translation_slugs ats
on ats.article_id = a.id
where
1=1
and a.status_id = ?
and a.type_id IN (?)
and a.type_id NOT IN (?)
and sa.section_id = ?
and a.is_deleted = ?
and (
a.expire_at > now()
or a.expire_at is null
or a.expire_at = '0000-00-00 00:00:00'
)
and a.publish_at <= now()
order by
a.publish_at desc
limit
?,
? | | Time: | 15 ms | | Records: | 9 | | Columns: | id, status_id, type_id, canonical_section_id, created_at, publish_at, created_by
author, source, editor_notes, citations, affiliation, type
type_slug, language_id, translation_status_id, translation_type_id, title, slug
blurb, body, keydocument_url, keydocument_type, publication_date, link_url
is_highlighted, display_order, section_id, en_slug, en_transtypeid, fr_slug
fr_transtypeid, zh_slug, zh_transtypeid, es_slug, es_transtypeid, po_slug
po_transtypeid, ar_slug, ar_transtypeid, section_slug, sub_section_slug, canonical_link
|
| | CE5019071520D3BF1C79E005D9451DB8 | | query [short version] | | Query Source: | SQL Query | | Datasource: | SCIDEV_PRODUCTION | | Query: | select
distinct
a.id,
a.status_id,
a.type_id,
a.canonical_section_id,
a.created_at,
a.publish_at,
a.created_by,
a.author,
a.source,
a.editor_notes,
a.citations,
a.affiliation,
at.name as type,
at.slug as type_slug,
atr.language_id,
atr.status_id as translation_status_id,
atr.translation_type_id,
atr.title,
atr.slug,
atr.blurb,
atr.body,
case
when ifnull(af.file_name,'') <> '' then af.file_name
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then kd.document_url
else ''
end as keydocument_url,
case
when ifnull(af.file_name,'') <> '' then 'file'
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then 'url'
else ''
end as keydocument_type,
kd.publication_date,
ifnull(ali.link_url,'') as link_url
,
sa.is_highlighted,
sa.display_order,
sa.section_id
,
ats.en_slug,
ats.en_transtypeid,
ats.fr_slug,
ats.fr_transtypeid,
ats.zh_slug,
ats.zh_transtypeid,
ats.es_slug,
ats.es_transtypeid,
ats.po_slug,
ats.po_transtypeid,
ats.ar_slug,
ats.ar_transtypeid
,'' AS section_slug
,'' AS sub_section_slug
,'' AS canonical_link
from
articles a
inner join
article_translations atr
on atr.article_id = a.id
and atr.language_id =
?
and atr.status_id = 2
inner join
article_types at
on a.type_id = at.id
inner join
article_statuses ast
on ast.id = a.status_id
inner join
users u
on u.id = a.created_by
left outer join
sections_articles sa
on sa.article_id = a.id
and sa.section_id = ?
left outer join
article_links ali
on ali.article_id = a.id
left outer join
article_files af
on af.article_id = a.id
left outer join
key_documents kd
on kd.article_id = a.id
inner join
article_translation_slugs ats
on ats.article_id = a.id
where
1=1
and a.status_id = ?
and a.type_id IN (?,?)
and a.type_id NOT IN (?)
and sa.section_id = ?
and a.is_deleted = ?
and (
a.expire_at > now()
or a.expire_at is null
or a.expire_at = '0000-00-00 00:00:00'
)
and a.publish_at <= now()
order by
a.publish_at desc
limit
?,
? | | Time: | 32 ms | | Records: | 20 | | Columns: | id, status_id, type_id, canonical_section_id, created_at, publish_at, created_by
author, source, editor_notes, citations, affiliation, type
type_slug, language_id, translation_status_id, translation_type_id, title, slug
blurb, body, keydocument_url, keydocument_type, publication_date, link_url
is_highlighted, display_order, section_id, en_slug, en_transtypeid, fr_slug
fr_transtypeid, zh_slug, zh_transtypeid, es_slug, es_transtypeid, po_slug
po_transtypeid, ar_slug, ar_transtypeid, section_slug, sub_section_slug, canonical_link
|
| | D22091DC1FAE19215A583F5FF3A8A2CB | | query [short version] | | Query Source: | SQL Query | | Datasource: | SCIDEV_PRODUCTION | | Query: | select
distinct
a.id,
a.status_id,
a.type_id,
a.canonical_section_id,
a.created_at,
a.publish_at,
a.created_by,
a.author,
a.source,
a.editor_notes,
a.citations,
a.affiliation,
at.name as type,
at.slug as type_slug,
atr.language_id,
atr.status_id as translation_status_id,
atr.translation_type_id,
atr.title,
atr.slug,
atr.blurb,
atr.body,
case
when ifnull(af.file_name,'') <> '' then af.file_name
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then kd.document_url
else ''
end as keydocument_url,
case
when ifnull(af.file_name,'') <> '' then 'file'
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then 'url'
else ''
end as keydocument_type,
kd.publication_date,
ifnull(ali.link_url,'') as link_url
,
sa.is_highlighted,
sa.display_order,
sa.section_id
,
ats.en_slug,
ats.en_transtypeid,
ats.fr_slug,
ats.fr_transtypeid,
ats.zh_slug,
ats.zh_transtypeid,
ats.es_slug,
ats.es_transtypeid,
ats.po_slug,
ats.po_transtypeid,
ats.ar_slug,
ats.ar_transtypeid
,acl.parent_section_slug AS section_slug
,acl.section_slug AS sub_section_slug
,acl.canonical_link
from
articles a
inner join
article_translations atr
on atr.article_id = a.id
and atr.language_id =
?
and atr.status_id = 2
LEFT JOIN article_canonical_link acl on a.id = acl.article_id AND atr.language_id = acl.language_id
inner join
article_types at
on a.type_id = at.id
inner join
article_statuses ast
on ast.id = a.status_id
inner join
users u
on u.id = a.created_by
left outer join
sections_articles sa
on sa.article_id = a.id
and sa.section_id = ?
left outer join
article_links ali
on ali.article_id = a.id
left outer join
article_files af
on af.article_id = a.id
left outer join
key_documents kd
on kd.article_id = a.id
inner join
article_translation_slugs ats
on ats.article_id = a.id
where
1=1
and a.status_id = ?
and a.type_id IN (?)
and a.type_id NOT IN (?)
and sa.section_id = ?
and a.is_deleted = ?
and (
a.expire_at > now()
or a.expire_at is null
or a.expire_at = '0000-00-00 00:00:00'
)
and a.publish_at <= now()
order by
a.publish_at desc
limit
?,
? | | Time: | 94 ms | | Records: | 8 | | Columns: | id, status_id, type_id, canonical_section_id, created_at, publish_at, created_by
author, source, editor_notes, citations, affiliation, type
type_slug, language_id, translation_status_id, translation_type_id, title, slug
blurb, body, keydocument_url, keydocument_type, publication_date, link_url
is_highlighted, display_order, section_id, en_slug, en_transtypeid, fr_slug
fr_transtypeid, zh_slug, zh_transtypeid, es_slug, es_transtypeid, po_slug
po_transtypeid, ar_slug, ar_transtypeid, section_slug, sub_section_slug, canonical_link
|
| | D29ECE604B1D54B12697B9FB48C93ADD | | query [short version] | | Query Source: | SQL Query | | Datasource: | SCIDEV_PRODUCTION | | Query: | select
distinct
a.id,
a.status_id,
a.type_id,
a.canonical_section_id,
a.created_at,
a.publish_at,
a.created_by,
a.author,
a.source,
a.editor_notes,
a.citations,
a.affiliation,
at.name as type,
at.slug as type_slug,
atr.language_id,
atr.status_id as translation_status_id,
atr.translation_type_id,
atr.title,
atr.slug,
atr.blurb,
atr.body,
case
when ifnull(af.file_name,'') <> '' then af.file_name
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then kd.document_url
else ''
end as keydocument_url,
case
when ifnull(af.file_name,'') <> '' then 'file'
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then 'url'
else ''
end as keydocument_type,
kd.publication_date,
ifnull(ali.link_url,'') as link_url
,
sa.is_highlighted,
sa.display_order,
sa.section_id
,
ats.en_slug,
ats.en_transtypeid,
ats.fr_slug,
ats.fr_transtypeid,
ats.zh_slug,
ats.zh_transtypeid,
ats.es_slug,
ats.es_transtypeid,
ats.po_slug,
ats.po_transtypeid,
ats.ar_slug,
ats.ar_transtypeid
,'' AS section_slug
,'' AS sub_section_slug
,'' AS canonical_link
from
articles a
inner join
article_translations atr
on atr.article_id = a.id
and atr.language_id =
?
and atr.status_id = 2
inner join
article_types at
on a.type_id = at.id
inner join
article_statuses ast
on ast.id = a.status_id
inner join
users u
on u.id = a.created_by
left outer join
sections_articles sa
on sa.article_id = a.id
and sa.section_id = ?
left outer join
article_links ali
on ali.article_id = a.id
left outer join
article_files af
on af.article_id = a.id
left outer join
key_documents kd
on kd.article_id = a.id
inner join
article_translation_slugs ats
on ats.article_id = a.id
where
1=1
and a.status_id = ?
and a.type_id IN (?)
and a.type_id NOT IN (?)
and sa.section_id = ?
and a.is_deleted = ?
and (
a.expire_at > now()
or a.expire_at is null
or a.expire_at = '0000-00-00 00:00:00'
)
and a.publish_at <= now()
order by
a.publish_at desc
limit
?,
? | | Time: | 31 ms | | Records: | 3 | | Columns: | id, status_id, type_id, canonical_section_id, created_at, publish_at, created_by
author, source, editor_notes, citations, affiliation, type
type_slug, language_id, translation_status_id, translation_type_id, title, slug
blurb, body, keydocument_url, keydocument_type, publication_date, link_url
is_highlighted, display_order, section_id, en_slug, en_transtypeid, fr_slug
fr_transtypeid, zh_slug, zh_transtypeid, es_slug, es_transtypeid, po_slug
po_transtypeid, ar_slug, ar_transtypeid, section_slug, sub_section_slug, canonical_link
|
| | D3BD9A3441E1EC361178B1DC217316C9 | | query [short version] | | Query Source: | SQL Query | | Datasource: | SCIDEV_PRODUCTION | | Query: | select
distinct
a.id,
a.status_id,
a.type_id,
a.canonical_section_id,
a.created_at,
a.publish_at,
a.created_by,
a.author,
a.source,
a.editor_notes,
a.citations,
a.affiliation,
at.name as type,
at.slug as type_slug,
atr.language_id,
atr.status_id as translation_status_id,
atr.translation_type_id,
atr.title,
atr.slug,
atr.blurb,
atr.body,
case
when ifnull(af.file_name,'') <> '' then af.file_name
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then kd.document_url
else ''
end as keydocument_url,
case
when ifnull(af.file_name,'') <> '' then 'file'
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then 'url'
else ''
end as keydocument_type,
kd.publication_date,
ifnull(ali.link_url,'') as link_url
,
sa.is_highlighted,
sa.display_order,
sa.section_id
,
a.is_deleted,
a.publish_at,
a.expire_at,
a.updated_at,
a.updated_by,
a.is_paid,
u.firstname,
u.lastname,
u.email
,
(select language_id from article_translations atr_temp where atr_temp.article_id = a.id and is_original = 1 limit 1) as original_language_id
,
ast.name as status_name
,'' AS section_slug
,'' AS sub_section_slug
,'' AS canonical_link
from
articles a
inner join
article_translations atr
on atr.article_id = a.id
and atr.language_id =
?
inner join
article_types at
on a.type_id = at.id
inner join
article_statuses ast
on ast.id = a.status_id
inner join
users u
on u.id = a.created_by
left outer join
sections_articles sa
on sa.article_id = a.id
and sa.section_id = ?
left outer join
sections_articles sla
on sla.article_id = a.id
and sla.section_id = ?
left outer join
article_links ali
on ali.article_id = a.id
left outer join
article_files af
on af.article_id = a.id
left outer join
key_documents kd
on kd.article_id = a.id
where
1=1
and a.status_id = ?
and a.type_id IN (?)
and sa.section_id = ?
and sla.section_id = ?
and a.is_deleted = ?
and (
a.expire_at > now()
or a.expire_at is null
or a.expire_at = '0000-00-00 00:00:00'
)
and a.publish_at <= now()
order by
a.publish_at desc
limit
?,
? | | Time: | 31 ms | | Records: | 20 | | Columns: | id, status_id, type_id, canonical_section_id, created_at, publish_at, created_by
author, source, editor_notes, citations, affiliation, type
type_slug, language_id, translation_status_id, translation_type_id, title, slug
blurb, body, keydocument_url, keydocument_type, publication_date, link_url
is_highlighted, display_order, section_id, is_deleted, publish_at, expire_at
updated_at, updated_by, is_paid, firstname, lastname, email
original_language_id, status_name, section_slug, sub_section_slug, canonical_link |
| | DB0E7129D0749D172605EA61BECCD771 | | query [short version] | | Query Source: | SQL Query | | Datasource: | SCIDEV_PRODUCTION | | Query: | select
distinct
a.id,
a.status_id,
a.type_id,
a.canonical_section_id,
a.created_at,
a.publish_at,
a.created_by,
a.author,
a.source,
a.editor_notes,
a.citations,
a.affiliation,
at.name as type,
at.slug as type_slug,
atr.language_id,
atr.status_id as translation_status_id,
atr.translation_type_id,
atr.title,
atr.slug,
atr.blurb,
atr.body,
case
when ifnull(af.file_name,'') <> '' then af.file_name
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then kd.document_url
else ''
end as keydocument_url,
case
when ifnull(af.file_name,'') <> '' then 'file'
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then 'url'
else ''
end as keydocument_type,
kd.publication_date,
ifnull(ali.link_url,'') as link_url
,
sa.is_highlighted,
sa.display_order,
sa.section_id
,
ats.en_slug,
ats.en_transtypeid,
ats.fr_slug,
ats.fr_transtypeid,
ats.zh_slug,
ats.zh_transtypeid,
ats.es_slug,
ats.es_transtypeid,
ats.po_slug,
ats.po_transtypeid,
ats.ar_slug,
ats.ar_transtypeid
,'' AS section_slug
,'' AS sub_section_slug
,'' AS canonical_link
from
articles a
inner join
article_translations atr
on atr.article_id = a.id
and atr.language_id =
?
and atr.status_id = 2
inner join
article_types at
on a.type_id = at.id
inner join
article_statuses ast
on ast.id = a.status_id
inner join
users u
on u.id = a.created_by
left outer join
sections_articles sa
on sa.article_id = a.id
and sa.section_id = ?
left outer join
article_links ali
on ali.article_id = a.id
left outer join
article_files af
on af.article_id = a.id
left outer join
key_documents kd
on kd.article_id = a.id
inner join
article_translation_slugs ats
on ats.article_id = a.id
where
1=1
and a.status_id = ?
and a.type_id IN (?)
and a.type_id NOT IN (?)
and sa.section_id = ?
and a.is_deleted = ?
and (
a.expire_at > now()
or a.expire_at is null
or a.expire_at = '0000-00-00 00:00:00'
)
and a.publish_at <= now()
order by
a.publish_at desc
limit
?,
? | | Time: | 15 ms | | Records: | 8 | | Columns: | id, status_id, type_id, canonical_section_id, created_at, publish_at, created_by
author, source, editor_notes, citations, affiliation, type
type_slug, language_id, translation_status_id, translation_type_id, title, slug
blurb, body, keydocument_url, keydocument_type, publication_date, link_url
is_highlighted, display_order, section_id, en_slug, en_transtypeid, fr_slug
fr_transtypeid, zh_slug, zh_transtypeid, es_slug, es_transtypeid, po_slug
po_transtypeid, ar_slug, ar_transtypeid, section_slug, sub_section_slug, canonical_link
|
| | DB2FEC841B98C004074C09C3DD17952A | | query [short version] | | Query Source: | SQL Query | | Datasource: | SCIDEV_PRODUCTION | | Query: | select
count(distinct a.id) as count
from
articles a
inner join
article_translations atr
on atr.article_id = a.id
and atr.language_id =
?
and atr.status_id = 2
inner join
article_types at
on a.type_id = at.id
inner join
article_statuses ast
on ast.id = a.status_id
inner join
users u
on u.id = a.created_by
left outer join
sections_articles sa
on sa.article_id = a.id
and sa.section_id = ?
left outer join
article_links ali
on ali.article_id = a.id
left outer join
article_files af
on af.article_id = a.id
left outer join
key_documents kd
on kd.article_id = a.id
inner join
article_translation_slugs ats
on ats.article_id = a.id
where
1=1
and a.status_id = ?
and a.type_id IN (?)
and a.type_id NOT IN (?)
and sa.section_id = ?
and a.is_deleted = ?
and (
a.expire_at > now()
or a.expire_at is null
or a.expire_at = '0000-00-00 00:00:00'
)
and a.publish_at <= now()
order by
a.publish_at desc | | Time: | 32 ms | | Records: | 1 | | Columns: | count |
| | ED62D7C67FEC909227B4D9FECFCF0631 | | query [short version] | | Query Source: | SQL Query | | Datasource: | SCIDEV_PRODUCTION | | Query: | select
count(distinct a.id) as count
from
articles a
inner join
article_translations atr
on atr.article_id = a.id
and atr.language_id =
?
and atr.status_id = 2
inner join
article_types at
on a.type_id = at.id
inner join
article_statuses ast
on ast.id = a.status_id
inner join
users u
on u.id = a.created_by
left outer join
sections_articles sa
on sa.article_id = a.id
and sa.section_id = ?
left outer join
article_links ali
on ali.article_id = a.id
left outer join
article_files af
on af.article_id = a.id
left outer join
key_documents kd
on kd.article_id = a.id
inner join
article_translation_slugs ats
on ats.article_id = a.id
where
1=1
and a.status_id = ?
and a.type_id IN (?)
and a.type_id NOT IN (?)
and sa.section_id = ?
and a.is_deleted = ?
and (
a.expire_at > now()
or a.expire_at is null
or a.expire_at = '0000-00-00 00:00:00'
)
and a.publish_at <= now()
order by
a.publish_at desc | | Time: | 31 ms | | Records: | 1 | | Columns: | count |
| | EFBA151BEB5C791B3C86C54E8E65EBBD | | query [short version] | | Query Source: | SQL Query | | Datasource: | SCIDEV_PRODUCTION | | Query: | select
distinct
a.id,
a.status_id,
a.type_id,
a.canonical_section_id,
a.created_at,
a.publish_at,
a.created_by,
a.author,
a.source,
a.editor_notes,
a.citations,
a.affiliation,
at.name as type,
at.slug as type_slug,
atr.language_id,
atr.status_id as translation_status_id,
atr.translation_type_id,
atr.title,
atr.slug,
atr.blurb,
atr.body,
case
when ifnull(af.file_name,'') <> '' then af.file_name
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then kd.document_url
else ''
end as keydocument_url,
case
when ifnull(af.file_name,'') <> '' then 'file'
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then 'url'
else ''
end as keydocument_type,
kd.publication_date,
ifnull(ali.link_url,'') as link_url
,
sa.is_highlighted,
sa.display_order,
sa.section_id
,
ats.en_slug,
ats.en_transtypeid,
ats.fr_slug,
ats.fr_transtypeid,
ats.zh_slug,
ats.zh_transtypeid,
ats.es_slug,
ats.es_transtypeid,
ats.po_slug,
ats.po_transtypeid,
ats.ar_slug,
ats.ar_transtypeid
,'' AS section_slug
,'' AS sub_section_slug
,'' AS canonical_link
from
articles a
inner join
article_translations atr
on atr.article_id = a.id
and atr.language_id =
?
and atr.status_id = 2
inner join
article_types at
on a.type_id = at.id
inner join
article_statuses ast
on ast.id = a.status_id
inner join
users u
on u.id = a.created_by
left outer join
sections_articles sa
on sa.article_id = a.id
and sa.section_id = ?
left outer join
article_links ali
on ali.article_id = a.id
left outer join
article_files af
on af.article_id = a.id
left outer join
key_documents kd
on kd.article_id = a.id
inner join
article_translation_slugs ats
on ats.article_id = a.id
where
1=1
and a.status_id = ?
and a.type_id IN (?)
and a.type_id NOT IN (?)
and sa.section_id = ?
and a.is_deleted = ?
and (
a.expire_at > now()
or a.expire_at is null
or a.expire_at = '0000-00-00 00:00:00'
)
and a.publish_at <= now()
order by
a.publish_at desc
limit
?,
? | | Time: | 31 ms | | Records: | 1 | | Columns: | id, status_id, type_id, canonical_section_id, created_at, publish_at, created_by
author, source, editor_notes, citations, affiliation, type
type_slug, language_id, translation_status_id, translation_type_id, title, slug
blurb, body, keydocument_url, keydocument_type, publication_date, link_url
is_highlighted, display_order, section_id, en_slug, en_transtypeid, fr_slug
fr_transtypeid, zh_slug, zh_transtypeid, es_slug, es_transtypeid, po_slug
po_transtypeid, ar_slug, ar_transtypeid, section_slug, sub_section_slug, canonical_link
|
| | F9CED35055B339ECA84B53AF799B7804 | | query [short version] | | Query Source: | SQL Query | | Datasource: | SCIDEV_PRODUCTION | | Query: | select
distinct
a.id,
a.status_id,
a.type_id,
a.canonical_section_id,
a.created_at,
a.publish_at,
a.created_by,
a.author,
a.source,
a.editor_notes,
a.citations,
a.affiliation,
at.name as type,
at.slug as type_slug,
atr.language_id,
atr.status_id as translation_status_id,
atr.translation_type_id,
atr.title,
atr.slug,
atr.blurb,
atr.body,
case
when ifnull(af.file_name,'') <> '' then af.file_name
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then kd.document_url
else ''
end as keydocument_url,
case
when ifnull(af.file_name,'') <> '' then 'file'
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then 'url'
else ''
end as keydocument_type,
kd.publication_date,
ifnull(ali.link_url,'') as link_url
,
sa.is_highlighted,
sa.display_order,
sa.section_id
,
ats.en_slug,
ats.en_transtypeid,
ats.fr_slug,
ats.fr_transtypeid,
ats.zh_slug,
ats.zh_transtypeid,
ats.es_slug,
ats.es_transtypeid,
ats.po_slug,
ats.po_transtypeid,
ats.ar_slug,
ats.ar_transtypeid
,'' AS section_slug
,'' AS sub_section_slug
,'' AS canonical_link
from
articles a
inner join
article_translations atr
on atr.article_id = a.id
and atr.language_id =
?
and atr.status_id = 2
inner join
article_types at
on a.type_id = at.id
inner join
article_statuses ast
on ast.id = a.status_id
inner join
users u
on u.id = a.created_by
left outer join
sections_articles sa
on sa.article_id = a.id
and sa.section_id = ?
left outer join
article_links ali
on ali.article_id = a.id
left outer join
article_files af
on af.article_id = a.id
left outer join
key_documents kd
on kd.article_id = a.id
inner join
article_translation_slugs ats
on ats.article_id = a.id
where
1=1
and a.status_id = ?
and a.type_id IN (?)
and a.type_id NOT IN (?)
and sa.section_id = ?
and a.is_deleted = ?
and (
a.expire_at > now()
or a.expire_at is null
or a.expire_at = '0000-00-00 00:00:00'
)
and a.publish_at <= now()
order by
a.publish_at desc
limit
?,
? | | Time: | 141 ms | | Records: | 20 | | Columns: | id, status_id, type_id, canonical_section_id, created_at, publish_at, created_by
author, source, editor_notes, citations, affiliation, type
type_slug, language_id, translation_status_id, translation_type_id, title, slug
blurb, body, keydocument_url, keydocument_type, publication_date, link_url
is_highlighted, display_order, section_id, en_slug, en_transtypeid, fr_slug
fr_transtypeid, zh_slug, zh_transtypeid, es_slug, es_transtypeid, po_slug
po_transtypeid, ar_slug, ar_transtypeid, section_slug, sub_section_slug, canonical_link
|
| | FBD24CE3AFD78A5EE2BDF17695EB979C | | query [short version] | | Query Source: | SQL Query | | Datasource: | SCIDEV_PRODUCTION | | Query: | select
distinct
a.id,
a.status_id,
a.type_id,
a.canonical_section_id,
a.created_at,
a.publish_at,
a.created_by,
a.author,
a.source,
a.editor_notes,
a.citations,
a.affiliation,
at.name as type,
at.slug as type_slug,
atr.language_id,
atr.status_id as translation_status_id,
atr.translation_type_id,
atr.title,
atr.slug,
atr.blurb,
atr.body,
case
when ifnull(af.file_name,'') <> '' then af.file_name
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then kd.document_url
else ''
end as keydocument_url,
case
when ifnull(af.file_name,'') <> '' then 'file'
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then 'url'
else ''
end as keydocument_type,
kd.publication_date,
ifnull(ali.link_url,'') as link_url
,
sa.is_highlighted,
sa.display_order,
sa.section_id
,
ats.en_slug,
ats.en_transtypeid,
ats.fr_slug,
ats.fr_transtypeid,
ats.zh_slug,
ats.zh_transtypeid,
ats.es_slug,
ats.es_transtypeid,
ats.po_slug,
ats.po_transtypeid,
ats.ar_slug,
ats.ar_transtypeid
,'' AS section_slug
,'' AS sub_section_slug
,'' AS canonical_link
from
articles a
inner join
article_translations atr
on atr.article_id = a.id
and atr.language_id =
?
and atr.status_id = 2
inner join
article_types at
on a.type_id = at.id
inner join
article_statuses ast
on ast.id = a.status_id
inner join
users u
on u.id = a.created_by
left outer join
sections_articles sa
on sa.article_id = a.id
and sa.section_id = ?
left outer join
article_links ali
on ali.article_id = a.id
left outer join
article_files af
on af.article_id = a.id
left outer join
key_documents kd
on kd.article_id = a.id
inner join
article_translation_slugs ats
on ats.article_id = a.id
where
1=1
and a.status_id = ?
and a.type_id IN (?)
and a.type_id NOT IN (?)
and sa.section_id = ?
and a.is_deleted = ?
and (
a.expire_at > now()
or a.expire_at is null
or a.expire_at = '0000-00-00 00:00:00'
)
and a.publish_at <= now()
order by
a.publish_at desc
limit
?,
? | | Time: | 63 ms | | Records: | 20 | | Columns: | id, status_id, type_id, canonical_section_id, created_at, publish_at, created_by
author, source, editor_notes, citations, affiliation, type
type_slug, language_id, translation_status_id, translation_type_id, title, slug
blurb, body, keydocument_url, keydocument_type, publication_date, link_url
is_highlighted, display_order, section_id, en_slug, en_transtypeid, fr_slug
fr_transtypeid, zh_slug, zh_transtypeid, es_slug, es_transtypeid, po_slug
po_transtypeid, ar_slug, ar_transtypeid, section_slug, sub_section_slug, canonical_link
|
| | FD0BCDC9E4F662F8DA9765682A1B1940 | | query [short version] | | Query Source: | SQL Query | | Datasource: | SCIDEV_PRODUCTION | | Query: | select
distinct
a.id,
a.status_id,
a.type_id,
a.canonical_section_id,
a.created_at,
a.publish_at,
a.created_by,
a.author,
a.source,
a.editor_notes,
a.citations,
a.affiliation,
at.name as type,
at.slug as type_slug,
atr.language_id,
atr.status_id as translation_status_id,
atr.translation_type_id,
atr.title,
atr.slug,
atr.blurb,
atr.body,
case
when ifnull(af.file_name,'') <> '' then af.file_name
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then kd.document_url
else ''
end as keydocument_url,
case
when ifnull(af.file_name,'') <> '' then 'file'
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then 'url'
else ''
end as keydocument_type,
kd.publication_date,
ifnull(ali.link_url,'') as link_url
,
sa.is_highlighted,
sa.display_order,
sa.section_id
,
a.is_deleted,
a.publish_at,
a.expire_at,
a.updated_at,
a.updated_by,
a.is_paid,
u.firstname,
u.lastname,
u.email
,
(select language_id from article_translations atr_temp where atr_temp.article_id = a.id and is_original = 1 limit 1) as original_language_id
,
ast.name as status_name
,'' AS section_slug
,'' AS sub_section_slug
,'' AS canonical_link
from
articles a
inner join
article_translations atr
on atr.article_id = a.id
and atr.language_id =
?
inner join
article_types at
on a.type_id = at.id
inner join
article_statuses ast
on ast.id = a.status_id
inner join
users u
on u.id = a.created_by
left outer join
sections_articles sa
on sa.article_id = a.id
and sa.section_id = ?
left outer join
article_links ali
on ali.article_id = a.id
left outer join
article_files af
on af.article_id = a.id
left outer join
key_documents kd
on kd.article_id = a.id
where
1=1
and a.status_id = ?
and a.type_id IN (?)
and sa.section_id = ?
and a.is_deleted = ?
and (
a.expire_at > now()
or a.expire_at is null
or a.expire_at = '0000-00-00 00:00:00'
)
and a.publish_at <= now()
order by
a.publish_at desc
limit
?,
? | | Time: | 16 ms | | Records: | 0 | | Columns: | id, status_id, type_id, canonical_section_id, created_at, publish_at, created_by
author, source, editor_notes, citations, affiliation, type
type_slug, language_id, translation_status_id, translation_type_id, title, slug
blurb, body, keydocument_url, keydocument_type, publication_date, link_url
is_highlighted, display_order, section_id, is_deleted, publish_at, expire_at
updated_at, updated_by, is_paid, firstname, lastname, email
original_language_id, status_name, section_slug, sub_section_slug, canonical_link |
| | FEEEB06CCCB767D392245062D4A99F74 | | query [short version] | | Query Source: | SQL Query | | Datasource: | SCIDEV_PRODUCTION | | Query: | select
distinct
a.id,
a.status_id,
a.type_id,
a.canonical_section_id,
a.created_at,
a.publish_at,
a.created_by,
a.author,
a.source,
a.editor_notes,
a.citations,
a.affiliation,
at.name as type,
at.slug as type_slug,
atr.language_id,
atr.status_id as translation_status_id,
atr.translation_type_id,
atr.title,
atr.slug,
atr.blurb,
atr.body,
case
when ifnull(af.file_name,'') <> '' then af.file_name
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then kd.document_url
else ''
end as keydocument_url,
case
when ifnull(af.file_name,'') <> '' then 'file'
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then 'url'
else ''
end as keydocument_type,
kd.publication_date,
ifnull(ali.link_url,'') as link_url
,
sa.is_highlighted,
sa.display_order,
sa.section_id
,
ats.en_slug,
ats.en_transtypeid,
ats.fr_slug,
ats.fr_transtypeid,
ats.zh_slug,
ats.zh_transtypeid,
ats.es_slug,
ats.es_transtypeid,
ats.po_slug,
ats.po_transtypeid,
ats.ar_slug,
ats.ar_transtypeid
,'' AS section_slug
,'' AS sub_section_slug
,'' AS canonical_link
from
articles a
inner join
article_translations atr
on atr.article_id = a.id
and atr.language_id =
?
and atr.status_id = 2
inner join
article_types at
on a.type_id = at.id
inner join
article_statuses ast
on ast.id = a.status_id
inner join
users u
on u.id = a.created_by
left outer join
sections_articles sa
on sa.article_id = a.id
and sa.section_id = ?
left outer join
article_links ali
on ali.article_id = a.id
left outer join
article_files af
on af.article_id = a.id
left outer join
key_documents kd
on kd.article_id = a.id
inner join
article_translation_slugs ats
on ats.article_id = a.id
where
1=1
and a.status_id = ?
and a.type_id IN (?)
and a.type_id NOT IN (?)
and sa.section_id = ?
and a.is_deleted = ?
and (
a.expire_at > now()
or a.expire_at is null
or a.expire_at = '0000-00-00 00:00:00'
)
and a.publish_at <= now()
order by
a.publish_at desc
limit
?,
? | | Time: | 141 ms | | Records: | 20 | | Columns: | id, status_id, type_id, canonical_section_id, created_at, publish_at, created_by
author, source, editor_notes, citations, affiliation, type
type_slug, language_id, translation_status_id, translation_type_id, title, slug
blurb, body, keydocument_url, keydocument_type, publication_date, link_url
is_highlighted, display_order, section_id, en_slug, en_transtypeid, fr_slug
fr_transtypeid, zh_slug, zh_transtypeid, es_slug, es_transtypeid, po_slug
po_transtypeid, ar_slug, ar_transtypeid, section_slug, sub_section_slug, canonical_link
|
| | FF104E5BD530CF7A78E1AE211E378000 | | query [short version] | | Query Source: | SQL Query | | Datasource: | SCIDEV_PRODUCTION | | Query: | select
distinct
a.id,
a.status_id,
a.type_id,
a.canonical_section_id,
a.created_at,
a.publish_at,
a.created_by,
a.author,
a.source,
a.editor_notes,
a.citations,
a.affiliation,
at.name as type,
at.slug as type_slug,
atr.language_id,
atr.status_id as translation_status_id,
atr.translation_type_id,
atr.title,
atr.slug,
atr.blurb,
atr.body,
case
when ifnull(af.file_name,'') <> '' then af.file_name
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then kd.document_url
else ''
end as keydocument_url,
case
when ifnull(af.file_name,'') <> '' then 'file'
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then 'url'
else ''
end as keydocument_type,
kd.publication_date,
ifnull(ali.link_url,'') as link_url
,
sa.is_highlighted,
sa.display_order,
sa.section_id
,
ats.en_slug,
ats.en_transtypeid,
ats.fr_slug,
ats.fr_transtypeid,
ats.zh_slug,
ats.zh_transtypeid,
ats.es_slug,
ats.es_transtypeid,
ats.po_slug,
ats.po_transtypeid,
ats.ar_slug,
ats.ar_transtypeid
,'' AS section_slug
,'' AS sub_section_slug
,'' AS canonical_link
from
articles a
inner join
article_translations atr
on atr.article_id = a.id
and atr.language_id =
?
and atr.status_id = 2
inner join
article_types at
on a.type_id = at.id
inner join
article_statuses ast
on ast.id = a.status_id
inner join
users u
on u.id = a.created_by
left outer join
sections_articles sa
on sa.article_id = a.id
and sa.section_id = ?
left outer join
article_links ali
on ali.article_id = a.id
left outer join
article_files af
on af.article_id = a.id
left outer join
key_documents kd
on kd.article_id = a.id
inner join
article_translation_slugs ats
on ats.article_id = a.id
where
1=1
and a.status_id = ?
and a.type_id IN (?)
and a.type_id NOT IN (?)
and sa.section_id = ?
and a.is_deleted = ?
and (
a.expire_at > now()
or a.expire_at is null
or a.expire_at = '0000-00-00 00:00:00'
)
and a.publish_at <= now()
order by
a.publish_at desc
limit
?,
? | | Time: | 32 ms | | Records: | 3 | | Columns: | id, status_id, type_id, canonical_section_id, created_at, publish_at, created_by
author, source, editor_notes, citations, affiliation, type
type_slug, language_id, translation_status_id, translation_type_id, title, slug
blurb, body, keydocument_url, keydocument_type, publication_date, link_url
is_highlighted, display_order, section_id, en_slug, en_transtypeid, fr_slug
fr_transtypeid, zh_slug, zh_transtypeid, es_slug, es_transtypeid, po_slug
po_transtypeid, ar_slug, ar_transtypeid, section_slug, sub_section_slug, canonical_link
|
|
|