| cache_article_search | | struct | | 0CF9CD28388B0EC2DB72704A917DEBB1 | | 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: | 281 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
|
| | 0FD458A5D9B32C10DA15F2053B5B0685 | | 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: | 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
|
| | 129ED3FBCD6AFD91EA83FEB0EAFCE276 | | 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
|
| | 2B114317CF79FE0331AA08BEC717E95E | | query [short version] | | Query Source: | SQL Query | | Datasource: | SCIDEV_PRODUCTION | | Query: | select
distinct
a.id,
a.status_id,
a.type_id,
a.canonical_section_id,
a.created_at,
a.publish_at,
a.created_by,
a.author,
a.source,
a.editor_notes,
a.citations,
a.affiliation,
at.name as type,
at.slug as type_slug,
atr.language_id,
atr.status_id as translation_status_id,
atr.translation_type_id,
atr.title,
atr.slug,
atr.blurb,
atr.body,
case
when ifnull(af.file_name,'') <> '' then af.file_name
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then kd.document_url
else ''
end as keydocument_url,
case
when ifnull(af.file_name,'') <> '' then 'file'
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then 'url'
else ''
end as keydocument_type,
kd.publication_date,
ifnull(ali.link_url,'') as link_url
,
sa.is_highlighted,
sa.display_order,
sa.section_id
,
ats.en_slug,
ats.en_transtypeid,
ats.fr_slug,
ats.fr_transtypeid,
ats.zh_slug,
ats.zh_transtypeid,
ats.es_slug,
ats.es_transtypeid,
ats.po_slug,
ats.po_transtypeid,
ats.ar_slug,
ats.ar_transtypeid
,'' AS section_slug
,'' AS sub_section_slug
,'' AS canonical_link
from
articles a
inner join
article_translations atr
on atr.article_id = a.id
and atr.language_id =
?
and atr.status_id = 2
inner join
article_types at
on a.type_id = at.id
inner join
article_statuses ast
on ast.id = a.status_id
inner join
users u
on u.id = a.created_by
left outer join
sections_articles sa
on sa.article_id = a.id
and sa.section_id = ?
left outer join
article_links ali
on ali.article_id = a.id
left outer join
article_files af
on af.article_id = a.id
left outer join
key_documents kd
on kd.article_id = a.id
inner join
article_translation_slugs ats
on ats.article_id = a.id
where
1=1
and a.status_id = ?
and a.type_id IN (?)
and a.type_id NOT IN (?)
and sa.section_id = ?
and a.is_deleted = ?
and (
a.expire_at > now()
or a.expire_at is null
or a.expire_at = '0000-00-00 00:00:00'
)
and a.publish_at <= now()
order by
a.publish_at desc
limit
?,
? | | Time: | 63 ms | | Records: | 0 | | Columns: | id, status_id, type_id, canonical_section_id, created_at, publish_at, created_by
author, source, editor_notes, citations, affiliation, type
type_slug, language_id, translation_status_id, translation_type_id, title, slug
blurb, body, keydocument_url, keydocument_type, publication_date, link_url
is_highlighted, display_order, section_id, en_slug, en_transtypeid, fr_slug
fr_transtypeid, zh_slug, zh_transtypeid, es_slug, es_transtypeid, po_slug
po_transtypeid, ar_slug, ar_transtypeid, section_slug, sub_section_slug, canonical_link
|
| | 346FF962989F5E3EE92FF38A622CC365 | | 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: | 125 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: | 94 ms | | Records: | 8 | | Columns: | id, status_id, type_id, canonical_section_id, created_at, publish_at, created_by
author, source, editor_notes, citations, affiliation, type
type_slug, language_id, translation_status_id, translation_type_id, title, slug
blurb, body, keydocument_url, keydocument_type, publication_date, link_url
is_highlighted, display_order, section_id, en_slug, en_transtypeid, fr_slug
fr_transtypeid, zh_slug, zh_transtypeid, es_slug, es_transtypeid, po_slug
po_transtypeid, ar_slug, ar_transtypeid, section_slug, sub_section_slug, canonical_link
|
| | 3AF1E87F41A61AEB598D9EEE64593238 | | query [short version] | | Query Source: | SQL Query | | Datasource: | SCIDEV_PRODUCTION | | Query: | select
distinct
a.id,
a.status_id,
a.type_id,
a.canonical_section_id,
a.created_at,
a.publish_at,
a.created_by,
a.author,
a.source,
a.editor_notes,
a.citations,
a.affiliation,
at.name as type,
at.slug as type_slug,
atr.language_id,
atr.status_id as translation_status_id,
atr.translation_type_id,
atr.title,
atr.slug,
atr.blurb,
atr.body,
case
when ifnull(af.file_name,'') <> '' then af.file_name
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then kd.document_url
else ''
end as keydocument_url,
case
when ifnull(af.file_name,'') <> '' then 'file'
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then 'url'
else ''
end as keydocument_type,
kd.publication_date,
ifnull(ali.link_url,'') as link_url
,
sa.is_highlighted,
sa.display_order,
sa.section_id
,
ats.en_slug,
ats.en_transtypeid,
ats.fr_slug,
ats.fr_transtypeid,
ats.zh_slug,
ats.zh_transtypeid,
ats.es_slug,
ats.es_transtypeid,
ats.po_slug,
ats.po_transtypeid,
ats.ar_slug,
ats.ar_transtypeid
,'' AS section_slug
,'' AS sub_section_slug
,'' AS canonical_link
from
articles a
inner join
article_translations atr
on atr.article_id = a.id
and atr.language_id =
?
and atr.status_id = 2
inner join
article_types at
on a.type_id = at.id
inner join
article_statuses ast
on ast.id = a.status_id
inner join
users u
on u.id = a.created_by
left outer join
sections_articles sa
on sa.article_id = a.id
and sa.section_id = ?
left outer join
article_links ali
on ali.article_id = a.id
left outer join
article_files af
on af.article_id = a.id
left outer join
key_documents kd
on kd.article_id = a.id
inner join
article_translation_slugs ats
on ats.article_id = a.id
where
1=1
and a.status_id = ?
and a.type_id IN (?)
and a.type_id NOT IN (?)
and sa.section_id = ?
and a.is_deleted = ?
and (
a.expire_at > now()
or a.expire_at is null
or a.expire_at = '0000-00-00 00:00:00'
)
and a.publish_at <= now()
order by
a.publish_at desc
limit
?,
? | | Time: | 125 ms | | Records: | 20 | | Columns: | id, status_id, type_id, canonical_section_id, created_at, publish_at, created_by
author, source, editor_notes, citations, affiliation, type
type_slug, language_id, translation_status_id, translation_type_id, title, slug
blurb, body, keydocument_url, keydocument_type, publication_date, link_url
is_highlighted, display_order, section_id, en_slug, en_transtypeid, fr_slug
fr_transtypeid, zh_slug, zh_transtypeid, es_slug, es_transtypeid, po_slug
po_transtypeid, ar_slug, ar_transtypeid, section_slug, sub_section_slug, canonical_link
|
| | 3DBF238E9B8E0EB5775CA8BEE11ACC06 | | 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: | 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
|
| | 4A4337AB8313E50BE3EC1E67297818D0 | | 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: | 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
|
| | 4FCE41DC89018C40CD4B1E9E553778E0 | | 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 |
| | 53BCB0309C19F045DA93C7E1865DCF33 | | 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
|
| | 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: | 125 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
|
| | 596CB5BEC1014A7A5EA7E8F97F7D16C7 | | 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
|
| | 5DB89F0FDB039AD408C55C317FFF2539 | | query [short version] | | Query Source: | SQL Query | | Datasource: | SCIDEV_PRODUCTION | | Query: | select
count(distinct a.id) as count
from
articles a
inner join
article_translations atr
on atr.article_id = a.id
and atr.language_id =
?
inner join
article_types at
on a.type_id = at.id
inner join
article_statuses ast
on ast.id = a.status_id
inner join
users u
on u.id = a.created_by
left outer join
sections_articles sa
on sa.article_id = a.id
and sa.section_id = ?
left outer join
article_links ali
on ali.article_id = a.id
left outer join
article_files af
on af.article_id = a.id
left outer join
key_documents kd
on kd.article_id = a.id
where
1=1
and a.status_id = ?
and a.type_id IN (?)
and sa.section_id = ?
and a.is_deleted = ?
and (
a.expire_at > now()
or a.expire_at is null
or a.expire_at = '0000-00-00 00:00:00'
)
and a.publish_at <= now()
order by
a.publish_at desc | | Time: | 0 ms | | Records: | 1 | | Columns: | count |
| | 6304E10C5DE487B573E390155FB83D35 | | query [short version] | | Query Source: | SQL Query | | Datasource: | SCIDEV_PRODUCTION | | Query: | select
distinct
a.id,
a.status_id,
a.type_id,
a.canonical_section_id,
a.created_at,
a.publish_at,
a.created_by,
a.author,
a.source,
a.editor_notes,
a.citations,
a.affiliation,
at.name as type,
at.slug as type_slug,
atr.language_id,
atr.status_id as translation_status_id,
atr.translation_type_id,
atr.title,
atr.slug,
atr.blurb,
atr.body,
case
when ifnull(af.file_name,'') <> '' then af.file_name
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then kd.document_url
else ''
end as keydocument_url,
case
when ifnull(af.file_name,'') <> '' then 'file'
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then 'url'
else ''
end as keydocument_type,
kd.publication_date,
ifnull(ali.link_url,'') as link_url
,
sa.is_highlighted,
sa.display_order,
sa.section_id
,
ats.en_slug,
ats.en_transtypeid,
ats.fr_slug,
ats.fr_transtypeid,
ats.zh_slug,
ats.zh_transtypeid,
ats.es_slug,
ats.es_transtypeid,
ats.po_slug,
ats.po_transtypeid,
ats.ar_slug,
ats.ar_transtypeid
,'' AS section_slug
,'' AS sub_section_slug
,'' AS canonical_link
from
articles a
inner join
article_translations atr
on atr.article_id = a.id
and atr.language_id =
?
and atr.status_id = 2
inner join
article_types at
on a.type_id = at.id
inner join
article_statuses ast
on ast.id = a.status_id
inner join
users u
on u.id = a.created_by
left outer join
sections_articles sa
on sa.article_id = a.id
and sa.section_id = ?
left outer join
article_links ali
on ali.article_id = a.id
left outer join
article_files af
on af.article_id = a.id
left outer join
key_documents kd
on kd.article_id = a.id
inner join
article_translation_slugs ats
on ats.article_id = a.id
where
1=1
and a.status_id = ?
and a.type_id IN (?)
and a.type_id NOT IN (?)
and sa.section_id = ?
and a.is_deleted = ?
and (
a.expire_at > now()
or a.expire_at is null
or a.expire_at = '0000-00-00 00:00:00'
)
and a.publish_at <= now()
order by
a.publish_at desc
limit
?,
? | | Time: | 110 ms | | Records: | 20 | | Columns: | id, status_id, type_id, canonical_section_id, created_at, publish_at, created_by
author, source, editor_notes, citations, affiliation, type
type_slug, language_id, translation_status_id, translation_type_id, title, slug
blurb, body, keydocument_url, keydocument_type, publication_date, link_url
is_highlighted, display_order, section_id, en_slug, en_transtypeid, fr_slug
fr_transtypeid, zh_slug, zh_transtypeid, es_slug, es_transtypeid, po_slug
po_transtypeid, ar_slug, ar_transtypeid, section_slug, sub_section_slug, canonical_link
|
| | 64D5A0C04F8767D1E6B5047FA9AE5DA8 | | 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
|
| | 64FE7B86A654B9331C73258093EFD2FC | | 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
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
atr.title asc
limit
?,
? | | Time: | 0 ms | | Records: | 13 | | Columns: | letter, section_slug, sub_section_slug, canonical_link |
| | 6EB239EBD91EB3B5F923B6A5309D8CA2 | | 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: | 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 |
| | 71878C7D518F80A85E1DDA44D043C1DD | | query [short version] | | Query Source: | SQL Query | | Datasource: | SCIDEV_PRODUCTION | | Query: | select
distinct
a.id,
a.status_id,
a.type_id,
a.canonical_section_id,
a.created_at,
a.publish_at,
a.created_by,
a.author,
a.source,
a.editor_notes,
a.citations,
a.affiliation,
at.name as type,
at.slug as type_slug,
atr.language_id,
atr.status_id as translation_status_id,
atr.translation_type_id,
atr.title,
atr.slug,
atr.blurb,
atr.body,
case
when ifnull(af.file_name,'') <> '' then af.file_name
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then kd.document_url
else ''
end as keydocument_url,
case
when ifnull(af.file_name,'') <> '' then 'file'
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then 'url'
else ''
end as keydocument_type,
kd.publication_date,
ifnull(ali.link_url,'') as link_url
,
sa.is_highlighted,
sa.display_order,
sa.section_id
,
ats.en_slug,
ats.en_transtypeid,
ats.fr_slug,
ats.fr_transtypeid,
ats.zh_slug,
ats.zh_transtypeid,
ats.es_slug,
ats.es_transtypeid,
ats.po_slug,
ats.po_transtypeid,
ats.ar_slug,
ats.ar_transtypeid
,'' AS section_slug
,'' AS sub_section_slug
,'' AS canonical_link
from
articles a
inner join
article_translations atr
on atr.article_id = a.id
and atr.language_id =
?
and atr.status_id = 2
inner join
article_types at
on a.type_id = at.id
inner join
article_statuses ast
on ast.id = a.status_id
inner join
users u
on u.id = a.created_by
left outer join
sections_articles sa
on sa.article_id = a.id
and sa.section_id = ?
left outer join
article_links ali
on ali.article_id = a.id
left outer join
article_files af
on af.article_id = a.id
left outer join
key_documents kd
on kd.article_id = a.id
inner join
article_translation_slugs ats
on ats.article_id = a.id
where
1=1
and a.status_id = ?
and a.type_id IN (?)
and a.type_id NOT IN (?)
and sa.section_id = ?
and a.is_deleted = ?
and (
a.expire_at > now()
or a.expire_at is null
or a.expire_at = '0000-00-00 00:00:00'
)
and a.publish_at <= now()
order by
a.publish_at desc
limit
?,
? | | Time: | 62 ms | | Records: | 0 | | Columns: | id, status_id, type_id, canonical_section_id, created_at, publish_at, created_by
author, source, editor_notes, citations, affiliation, type
type_slug, language_id, translation_status_id, translation_type_id, title, slug
blurb, body, keydocument_url, keydocument_type, publication_date, link_url
is_highlighted, display_order, section_id, en_slug, en_transtypeid, fr_slug
fr_transtypeid, zh_slug, zh_transtypeid, es_slug, es_transtypeid, po_slug
po_transtypeid, ar_slug, ar_transtypeid, section_slug, sub_section_slug, canonical_link
|
| | 7CB222118605EBD695D301A9FA046CD3 | | 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: | 46 ms | | Records: | 0 | | Columns: | id, status_id, type_id, canonical_section_id, created_at, publish_at, created_by
author, source, editor_notes, citations, affiliation, type
type_slug, language_id, translation_status_id, translation_type_id, title, slug
blurb, body, keydocument_url, keydocument_type, publication_date, link_url
is_highlighted, display_order, section_id, en_slug, en_transtypeid, fr_slug
fr_transtypeid, zh_slug, zh_transtypeid, es_slug, es_transtypeid, po_slug
po_transtypeid, ar_slug, ar_transtypeid, start_at, end_at, close_at
information_url, contact_details, location, organisation_name, organisation_url, section_slug
sub_section_slug, canonical_link |
| | 7D3B03C9B6031986D07A4231FAAD6074 | | 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: | 281 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
|
| | 825F7A947ED554F6E0762A4969F12256 | | 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: | 15 ms | | Records: | 0 | | Columns: | letter, section_slug, sub_section_slug, canonical_link |
| | 88FED280CCB409CC86734291D547099E | | 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: | 79 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
|
| | 8F6EAED0F594ECBCA95FFF09AFB27BE3 | | 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: | 16 ms | | Records: | 0 | | Columns: | id, status_id, type_id, canonical_section_id, created_at, publish_at, created_by
author, source, editor_notes, citations, affiliation, type
type_slug, language_id, translation_status_id, translation_type_id, title, slug
blurb, body, keydocument_url, keydocument_type, publication_date, link_url
is_highlighted, display_order, section_id, is_deleted, publish_at, expire_at
updated_at, updated_by, is_paid, firstname, lastname, email
original_language_id, status_name, section_slug, sub_section_slug, canonical_link |
| | 92E7534E86D8E006E0040C16F30ED14D | | 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: | 406 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
|
| | 9638962805E67250565C3B99C9419A8A | | 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: | 484 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 |
| | 98FF332A544A2D2934394C50FE91E526 | | 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 lower(atr.title) like ?
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: | 0 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, 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 |
| | 9979E92728F1ADAE7FC98310226D2C53 | | 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: | 13 | | 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
|
| | AA548A851666D148666418BA873F65C5 | | 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
|
| | AAF21FE63FE6A0701588601F1DBFEF8C | | 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: | 578 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
|
| | B3AFCA58FFFF7C79D31A41F1ECEE03C8 | | query [short version] | | Query Source: | Query of Queries | | Records: | 6 | | 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
|
| | BAA6E5A4089DE984F6ED6F2D2A12A22E | | 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: | 140 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
|
| | BC31574E206BEAB14FCAC048C28D6191 | | query [short version] | | Query Source: | SQL Query | | Datasource: | SCIDEV_PRODUCTION | | Query: | select
distinct
a.id,
a.status_id,
a.type_id,
a.canonical_section_id,
a.created_at,
a.publish_at,
a.created_by,
a.author,
a.source,
a.editor_notes,
a.citations,
a.affiliation,
at.name as type,
at.slug as type_slug,
atr.language_id,
atr.status_id as translation_status_id,
atr.translation_type_id,
atr.title,
atr.slug,
atr.blurb,
atr.body,
case
when ifnull(af.file_name,'') <> '' then af.file_name
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then kd.document_url
else ''
end as keydocument_url,
case
when ifnull(af.file_name,'') <> '' then 'file'
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then 'url'
else ''
end as keydocument_type,
kd.publication_date,
ifnull(ali.link_url,'') as link_url
,
sa.is_highlighted,
sa.display_order,
sa.section_id
,
ats.en_slug,
ats.en_transtypeid,
ats.fr_slug,
ats.fr_transtypeid,
ats.zh_slug,
ats.zh_transtypeid,
ats.es_slug,
ats.es_transtypeid,
ats.po_slug,
ats.po_transtypeid,
ats.ar_slug,
ats.ar_transtypeid
,'' AS section_slug
,'' AS sub_section_slug
,'' AS canonical_link
from
articles a
inner join
article_translations atr
on atr.article_id = a.id
and atr.language_id =
?
and atr.status_id = 2
inner join
article_types at
on a.type_id = at.id
inner join
article_statuses ast
on ast.id = a.status_id
inner join
users u
on u.id = a.created_by
left outer join
sections_articles sa
on sa.article_id = a.id
and sa.section_id = ?
left outer join
article_links ali
on ali.article_id = a.id
left outer join
article_files af
on af.article_id = a.id
left outer join
key_documents kd
on kd.article_id = a.id
inner join
article_translation_slugs ats
on ats.article_id = a.id
where
1=1
and a.status_id = ?
and a.type_id IN (?)
and a.type_id NOT IN (?)
and sa.section_id = ?
and a.is_deleted = ?
and (
a.expire_at > now()
or a.expire_at is null
or a.expire_at = '0000-00-00 00:00:00'
)
and a.publish_at <= now()
order by
a.publish_at desc
limit
?,
? | | Time: | 31 ms | | Records: | 1 | | Columns: | id, status_id, type_id, canonical_section_id, created_at, publish_at, created_by
author, source, editor_notes, citations, affiliation, type
type_slug, language_id, translation_status_id, translation_type_id, title, slug
blurb, body, keydocument_url, keydocument_type, publication_date, link_url
is_highlighted, display_order, section_id, en_slug, en_transtypeid, fr_slug
fr_transtypeid, zh_slug, zh_transtypeid, es_slug, es_transtypeid, po_slug
po_transtypeid, ar_slug, ar_transtypeid, section_slug, sub_section_slug, canonical_link
|
| | BDE834C4F78EA76C9078A5FC6FEAD319 | | 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
|
| | C3764D2CF63FA10FECF0ADE2EB31DD93 | | 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
|
| | C3D4A7AE003214F0F3A466DA0FD71675 | | 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 lower(atr.title) like ?
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 |
| | C7EBCAA59422574B72565659F847F87A | | 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
|
| | D6D5BCFB1163C3EECC7DC6A78EEEB477 | | 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: | 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
|
| | 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: | 234 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
|
| | EC01646A105638E00A20CF8F285184FC | | 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 |
| | ED5AA302D67226BDD179C01A0483FF3F | | query [short version] | | Query Source: | SQL Query | | Datasource: | SCIDEV_PRODUCTION | | Query: | select
distinct
a.id,
a.status_id,
a.type_id,
a.canonical_section_id,
a.created_at,
a.publish_at,
a.created_by,
a.author,
a.source,
a.editor_notes,
a.citations,
a.affiliation,
at.name as type,
at.slug as type_slug,
atr.language_id,
atr.status_id as translation_status_id,
atr.translation_type_id,
atr.title,
atr.slug,
atr.blurb,
atr.body,
case
when ifnull(af.file_name,'') <> '' then af.file_name
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then kd.document_url
else ''
end as keydocument_url,
case
when ifnull(af.file_name,'') <> '' then 'file'
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then 'url'
else ''
end as keydocument_type,
kd.publication_date,
ifnull(ali.link_url,'') as link_url
,
sa.is_highlighted,
sa.display_order,
sa.section_id
,
ats.en_slug,
ats.en_transtypeid,
ats.fr_slug,
ats.fr_transtypeid,
ats.zh_slug,
ats.zh_transtypeid,
ats.es_slug,
ats.es_transtypeid,
ats.po_slug,
ats.po_transtypeid,
ats.ar_slug,
ats.ar_transtypeid
,'' AS section_slug
,'' AS sub_section_slug
,'' AS canonical_link
from
articles a
inner join
article_translations atr
on atr.article_id = a.id
and atr.language_id =
?
and atr.status_id = 2
inner join
article_types at
on a.type_id = at.id
inner join
article_statuses ast
on ast.id = a.status_id
inner join
users u
on u.id = a.created_by
left outer join
sections_articles sa
on sa.article_id = a.id
and sa.section_id = ?
left outer join
article_links ali
on ali.article_id = a.id
left outer join
article_files af
on af.article_id = a.id
left outer join
key_documents kd
on kd.article_id = a.id
inner join
article_translation_slugs ats
on ats.article_id = a.id
where
1=1
and a.status_id = ?
and a.type_id IN (?)
and a.type_id NOT IN (?)
and sa.section_id = ?
and a.is_deleted = ?
and (
a.expire_at > now()
or a.expire_at is null
or a.expire_at = '0000-00-00 00:00:00'
)
and a.publish_at <= now()
order by
a.publish_at desc
limit
?,
? | | Time: | 110 ms | | Records: | 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
|
| | ED9254F989DAB416A6DD2FDFF70213B6 | | 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
|
| | F196E29C7E0DED1AA9D5AF2053C5FE8B | | 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
|
| | 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: | 953 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
|
| | FCC2B1D5A2FBB8D76F30E7B09F9D72FA | | 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 |
|
|