| cache_article_search | | struct | | 023A835220AEC20C724D5586B3920ABB | | 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: | 0 ms | | Records: | 1 | | Columns: | count |
| | 072348737013BD45A314381CD7C07521 | | 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: | 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
|
| | 0870829EE00D7AE8507CB7C0637CAB77 | | 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
|
| | 10A66D6E48CDA467118C076FC01099A8 | | 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: | 109 ms | | Records: | 18 | | 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
|
| | 1E28C2B03D03117371F776C046ACF9BF | | 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 |
| | 1F976D28196FB353358A063DCFC627BC | | 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: | 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
|
| | 1FFCAC1F0499F457D2B93039933AE598 | | 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
slug asc
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 |
| | 21120A16BC2C288CD2163858E9009059 | | 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
|
| | 224893324AF8C67CF0086F5361F5AEF5 | | 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
|
| | 2BD9B1D6AE7890FC46772135207B9D46 | | 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
|
| | 2EBE3853447AD0B19998F0779FBB8B17 | | 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
|
| | 2EF8A8EAFC9E1D84B46A7F4572E2AF44 | | 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: | 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, start_at, end_at, close_at
information_url, contact_details, location, organisation_name, organisation_url, section_slug
sub_section_slug, canonical_link |
| | 31BD838EDDB7C416865434600C8DD800 | | 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: | 63 ms | | Records: | 1 | | Columns: | count |
| | 389977D486B93846DBAAC757DB0411D1 | | 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: | 187 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
|
| | 3992ABA618DB5DEEBB163CD4D63ADE4D | | 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: | 93 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
|
| | 3A1D2C56B4A2BE1B2615919953892F0E | | 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 |
| | 3FB76DC838B78EECBF79C8F45CA271DE | | 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
|
| | 42F442D44701318981AA23A3FBA0C77C | | 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: | 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
|
| | 482D08742E573B9A2DF71666D3D28B6D | | 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
|
| | 485F2C3AAA59AE6427A679E6EBC54BBD | | 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
|
| | 4E3238B5661D565AF7B94944E6EFCFF2 | | 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: | 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
|
| | 525D8678468B0F9BCFC5855186A890D0 | | 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
|
| | 53302980B406EFF15EE1745499F3E035 | | 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
|
| | 545A9951AF2E00C892651D15D6EAE42B | | 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: | 453 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
|
| | 56129C0BDDA55A13C77233B861425100 | | 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: | 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
|
| | 5AB922927FCC0D284691D46EC0DC9ED7 | | 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
|
| | 5B790A7DE014CF3F8B137A711C315C79 | | 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: | 625 ms | | Records: | 1 | | Columns: | count |
| | 61BF08C15A837C156FC690E1666CC72D | | 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 |
| | 6868A8E15EF94CE6957A35DD56B157BF | | query [short version] | | Query Source: | SQL Query | | Datasource: | SCIDEV_PRODUCTION | | Query: | select
distinct
distinct left(trim(atr.title),1) as letter
,'' 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
atr.title asc
limit
?,
? | | Time: | 62 ms | | Records: | 0 | | Columns: | letter, section_slug, sub_section_slug, canonical_link |
| | 6AAA0875A23F659B438F909D22F24230 | | 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: | 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
|
| | 6B10436B81C1F3E7424BBA7400F66919 | | 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
|
| | 6FA9F4F48989DC298CDE7CE24FA939D4 | | 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
|
| | 70E8F64D8E0E1D788649645E1E663CD4 | | 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
|
| | 777EA9893DB5CC1E8FAF1BB71EB7F1A4 | | 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: | 32 ms | | Records: | 1 | | Columns: | count |
| | 78A95629F4795812DCC356B6A336C513 | | 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: | 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
|
| | 7918EF11DF9759AF0F553926FB00E6E8 | | 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: | 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
|
| | 807D65264DB179D42515FBA4962D6E38 | | 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
slug asc
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, 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 |
| | 814D03B6397AC80CEDD239F4B7FDAA19 | | 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: | 15 ms | | Records: | 1 | | Columns: | count |
| | 81B1B38BA848372D0FFA7C10A55347CD | | 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: | 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
|
| | 8368B6871ED768B74F2EC7FB93FA821A | | 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 |
| | 8B74D91A668801BE8C21DAAEDF00309A | | 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: | 156 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
|
| | 8F0D2054F2492E20AD245F882791694E | | 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: | 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, 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 |
| | 91731DF96D3D21489042BBB1115C696B | | 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: | 2047 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 |
| | 91A26D72FCC47CCB24A0073C5BF89F95 | | 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 |
| | 92238D3191C7BEAD8F24EE4D5038B3D9 | | 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: | 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, start_at, end_at, close_at
information_url, contact_details, location, organisation_name, organisation_url, section_slug
sub_section_slug, canonical_link |
| | 9476E3FC5989DB0653FC439E5249E684 | | 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: | 16 ms | | Records: | 1 | | Columns: | count |
| | 94B05CC3DE477C43DE2E03BD90DFA77E | | 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 |
| | 99A5307F0B8680F9082D81379E9F71D7 | | 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
|
| | 9B9FB817BAEBE8A8B9217A13888A8CB7 | | 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: | 15 ms | | Records: | 1 | | Columns: | count |
| | 9F03DED789BA63FD6E45F6C0878FB18D | | 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
atr.title asc
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, 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 |
| | A14A14F60A9E54B7E0771227498DAED6 | | 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
|
| | A195DFEC418EBC982B1F949C5D8F27BA | | 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
|
| | A2F03D21BA3485E154773B64DD9C52B2 | | 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: | 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, start_at, end_at, close_at
information_url, contact_details, location, organisation_name, organisation_url, section_slug
sub_section_slug, canonical_link |
| | A532DA35F39CF2FF9DE382B27D564253 | | 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: | 109 ms | | Records: | 18 | | 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
|
| | A59D85230435EF34AD19BA515D7E5FF3 | | 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
|
| | ACAD0383A4D5BA94443A8C24B855501B | | 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: | 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
|
| | ACBFDD17079499ECFDE1599B21DC3907 | | 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
|
| | B21BC4D797C6229887BDD8835BCFA80B | | 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
|
| | B7F48D5C3D0C18B5E79CAC11CC99A25C | | 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
|
| | B8F064AEED0762659E845958EFC19B2A | | 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
|
| | B90EE2EC0261C397B099C7E3702A6F4C | | 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
|
| | BA8637BC97AB03FD26432866AB7B5A92 | | 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: | 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
|
| | BAD5EDB86088817F609C8F352E4C3819 | | 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 |
| | BFD56E8EBB46C01BCD0C24540E4AE7DC | | 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: | 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
|
| | C192839FF534E6E9EB85A074FF2E337F | | 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: | 47 ms | | Records: | 1 | | Columns: | count |
| | C83A7E80BCD14EC7BD181B799469DBC1 | | 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: | 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
|
| | CF3B7B89073F92F7B8B206F58912309F | | 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: | 93 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
|
| | D8B8EC6FDC1F30D9D11241CD4FE2D6F9 | | 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: | 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
|
| | D95553621AF4E811B2EB9E1747AB106A | | 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
|
| | DBCB9E76FFBBBA805D05B1EAAEFF792E | | 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: | 469 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
|
| | DBE7E33DED57B39D68E43D67B3539E54 | | 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: | 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
|
| | DD39A1E09FFA80065FB383AE35BCADB4 | | 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: | 7 | | 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
|
| | DDE51BC5B172A4A475FFD7779BC78B10 | | 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: | 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
|
| | DF2C589247386910D0AD260CE1024329 | | 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 |
| | E203883057AF4827CBA84FD4A4A99C09 | | 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 |
| | EAD9BEA5B9D477B2BAB49CC36EB47B54 | | 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
|
| | EAFB72D2962A4EFA97E580ABBCC13D3A | | 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: | 32 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 |
| | EBBEFB0ADB961D3ABAB2A26E2BAD7466 | | 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
|
| | EC51B7B3002576DF6B7DBDE9229F273D | | 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: | 47 ms | | Records: | 1 | | Columns: | count |
| | EC6319989B220FEA1163843AF8055F7B | | query [short version] | | Query Source: | SQL Query | | Datasource: | SCIDEV_PRODUCTION | | Query: | select
distinct
distinct left(trim(atr.title),1) as letter
,'' 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
atr.title asc
limit
?,
? | | Time: | 0 ms | | Records: | 0 | | Columns: | letter, section_slug, sub_section_slug, canonical_link |
| | F2F83D3FD7B5B45D6CACB3FB8DD35E73 | | 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: | 1922 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
|
| | F3067BBADB356393B66AC3272139B2AB | | 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
|
| | F488EDA30D620BFAB460DA5303A7A257 | | 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 |
| | F78D6824C9E5FBB8E8886614B46007AC | | 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
|
| | F9EF26393750B1BD1FE9C069DD62C9C0 | | 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
|
| | FC6743FDEC9EB72E7C388004650C9DF1 | | 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 |
| | FD5910CAAD78605E19607B5C6F30CF81 | | 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
|
| | FF07265560F85180ADE1448040AFCFEC | | 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: | 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 |
| | FF706553B7EDD5C722354BFA948D860D | | 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
|
|
|