| cache_article_search | | struct | | 29A059CE4D8BE1EDC76552BE07AF13F8 | | 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: | 203 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
|
| | 2B4204B0FE12B27C27C1494CB25B0D1B | | 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
book_reviews br
on br.article_id = a.id
left outer join
article_links ali
on ali.article_id = a.id
left outer join
article_files af
on af.article_id = a.id
left outer join
key_documents kd
on kd.article_id = a.id
inner join
article_translation_slugs ats
on ats.article_id = a.id
where
1=1
and a.status_id = ?
and a.type_id IN (?)
and a.type_id NOT IN (?)
and sa.section_id = ?
and a.is_deleted = ?
and (
a.expire_at > now()
or a.expire_at is null
or a.expire_at = '0000-00-00 00:00:00'
)
and a.publish_at <= now()
order by
a.publish_at desc | | Time: | 15 ms | | Records: | 1 | | Columns: | count |
| | 2D918FAA90F590E55937D2CA0DA21466 | | 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
,
br.publisher,
br.author_name,
br.publication_date as book_publication_date,
br.reviewer_name,
br.price
,'' 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
book_reviews br
on br.article_id = a.id
left outer join
article_links ali
on ali.article_id = a.id
left outer join
article_files af
on af.article_id = a.id
left outer join
key_documents kd
on kd.article_id = a.id
inner join
article_translation_slugs ats
on ats.article_id = a.id
where
1=1
and a.status_id = ?
and a.type_id IN (?)
and a.type_id NOT IN (?)
and sa.section_id = ?
and a.is_deleted = ?
and (
a.expire_at > now()
or a.expire_at is null
or a.expire_at = '0000-00-00 00:00:00'
)
and a.publish_at <= now()
order by
a.publish_at desc
limit
?,
? | | Time: | 47 ms | | Records: | 0 | | Columns: | id, status_id, type_id, canonical_section_id, created_at, publish_at, created_by
author, source, editor_notes, citations, affiliation, type
type_slug, language_id, translation_status_id, translation_type_id, title, slug
blurb, body, keydocument_url, keydocument_type, publication_date, link_url
is_highlighted, display_order, section_id, en_slug, en_transtypeid, fr_slug
fr_transtypeid, zh_slug, zh_transtypeid, es_slug, es_transtypeid, po_slug
po_transtypeid, ar_slug, ar_transtypeid, publisher, author_name, book_publication_date
reviewer_name, price, section_slug, sub_section_slug, canonical_link |
| | 349D628EF89434AD745FDF5446F82954 | | 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: | 187 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
|
| | 3A1F0849254C5D9B02EA82CC9F2C6179 | | 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
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 a.is_deleted = ?
and (
a.expire_at > now()
or a.expire_at is null
or a.expire_at = '0000-00-00 00:00:00'
)
and a.publish_at <= now()
order by
a.publish_at desc | | Time: | 31 ms | | Records: | 1 | | Columns: | count |
| | 3D9AEE354F35BBE1C8693F0FD44AE852 | | 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
|
| | 3E15A8C456F433260838835998CBC999 | | query [short version] | | Query Source: | SQL Query | | Datasource: | SCIDEV_PRODUCTION | | Query: | select
distinct
a.id,
a.status_id,
a.type_id,
a.canonical_section_id,
a.created_at,
a.publish_at,
a.created_by,
a.author,
a.source,
a.editor_notes,
a.citations,
a.affiliation,
at.name as type,
at.slug as type_slug,
atr.language_id,
atr.status_id as translation_status_id,
atr.translation_type_id,
atr.title,
atr.slug,
atr.blurb,
atr.body,
case
when ifnull(af.file_name,'') <> '' then af.file_name
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then kd.document_url
else ''
end as keydocument_url,
case
when ifnull(af.file_name,'') <> '' then 'file'
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then 'url'
else ''
end as keydocument_type,
kd.publication_date,
ifnull(ali.link_url,'') as link_url
,
sa.is_highlighted,
sa.display_order,
sa.section_id
,
ats.en_slug,
ats.en_transtypeid,
ats.fr_slug,
ats.fr_transtypeid,
ats.zh_slug,
ats.zh_transtypeid,
ats.es_slug,
ats.es_transtypeid,
ats.po_slug,
ats.po_transtypeid,
ats.ar_slug,
ats.ar_transtypeid
,
n.start_at,
n.end_at,
n.close_at,
nt.information_url,
n.contact_details,
nt.location,
nt.organisation_name,
nt.organisation_url
,'' AS section_slug
,'' AS sub_section_slug
,'' AS canonical_link
from
articles a
inner join
article_translations atr
on atr.article_id = a.id
and atr.language_id =
?
and atr.status_id = 2
inner join
article_types at
on a.type_id = at.id
inner join
article_statuses ast
on ast.id = a.status_id
inner join
users u
on u.id = a.created_by
left outer join
sections_articles sa
on sa.article_id = a.id
and sa.section_id = ?
left outer join
article_links ali
on ali.article_id = a.id
left outer join
article_files af
on af.article_id = a.id
left outer join
key_documents kd
on kd.article_id = a.id
left outer join
notices n
on n.article_id = a.id
left outer join
notice_translations nt
on nt.article_id = n.article_id
and nt.language_id =
?
inner join
article_translation_slugs ats
on ats.article_id = a.id
where
1=1
and a.status_id = ?
and a.type_id IN (?)
and a.type_id NOT IN (?)
and sa.section_id = ?
and a.is_deleted = ?
and (
a.expire_at > now()
or a.expire_at is null
or a.expire_at = '0000-00-00 00:00:00'
)
and a.publish_at <= now()
order by
a.publish_at desc
limit
?,
? | | Time: | 47 ms | | Records: | 0 | | Columns: | id, status_id, type_id, canonical_section_id, created_at, publish_at, created_by
author, source, editor_notes, citations, affiliation, type
type_slug, language_id, translation_status_id, translation_type_id, title, slug
blurb, body, keydocument_url, keydocument_type, publication_date, link_url
is_highlighted, display_order, section_id, en_slug, en_transtypeid, fr_slug
fr_transtypeid, zh_slug, zh_transtypeid, es_slug, es_transtypeid, po_slug
po_transtypeid, ar_slug, ar_transtypeid, start_at, end_at, close_at
information_url, contact_details, location, organisation_name, organisation_url, section_slug
sub_section_slug, canonical_link |
| | 43ED0725605BD4089ACBAF73383762F2 | | query [short version] | | Query Source: | SQL Query | | Datasource: | SCIDEV_PRODUCTION | | Query: | select
distinct
a.id,
a.status_id,
a.type_id,
a.canonical_section_id,
a.created_at,
a.publish_at,
a.created_by,
a.author,
a.source,
a.editor_notes,
a.citations,
a.affiliation,
at.name as type,
at.slug as type_slug,
atr.language_id,
atr.status_id as translation_status_id,
atr.translation_type_id,
atr.title,
atr.slug,
atr.blurb,
atr.body,
case
when ifnull(af.file_name,'') <> '' then af.file_name
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then kd.document_url
else ''
end as keydocument_url,
case
when ifnull(af.file_name,'') <> '' then 'file'
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then 'url'
else ''
end as keydocument_type,
kd.publication_date,
ifnull(ali.link_url,'') as link_url
,
sa.is_highlighted,
sa.display_order,
sa.section_id
,
a.is_deleted,
a.publish_at,
a.expire_at,
a.updated_at,
a.updated_by,
a.is_paid,
u.firstname,
u.lastname,
u.email
,
(select language_id from article_translations atr_temp where atr_temp.article_id = a.id and is_original = 1 limit 1) as original_language_id
,
ast.name as status_name
,'' AS section_slug
,'' AS sub_section_slug
,'' AS canonical_link
from
articles a
inner join
article_translations atr
on atr.article_id = a.id
and atr.language_id =
?
inner join
article_types at
on a.type_id = at.id
inner join
article_statuses ast
on ast.id = a.status_id
inner join
users u
on u.id = a.created_by
left outer join
sections_articles sa
on sa.article_id = a.id
and sa.section_id = ?
left outer join
sections_articles sla
on sla.article_id = a.id
and sla.section_id = ?
left outer join
article_links ali
on ali.article_id = a.id
left outer join
article_files af
on af.article_id = a.id
left outer join
key_documents kd
on kd.article_id = a.id
where
1=1
and a.status_id = ?
and a.type_id IN (?)
and sa.section_id = ?
and sla.section_id = ?
and a.is_deleted = ?
and (
a.expire_at > now()
or a.expire_at is null
or a.expire_at = '0000-00-00 00:00:00'
)
and a.publish_at <= now()
order by
atr.title asc
limit
?,
? | | Time: | 16 ms | | Records: | 1 | | Columns: | id, status_id, type_id, canonical_section_id, created_at, publish_at, created_by
author, source, editor_notes, citations, affiliation, type
type_slug, language_id, translation_status_id, translation_type_id, title, slug
blurb, body, keydocument_url, keydocument_type, publication_date, link_url
is_highlighted, display_order, section_id, is_deleted, publish_at, expire_at
updated_at, updated_by, is_paid, firstname, lastname, email
original_language_id, status_name, section_slug, sub_section_slug, canonical_link |
| | 48CD767604F2FE1FF1C0432650652D67 | | query [short version] | | Query Source: | SQL Query | | Datasource: | SCIDEV_PRODUCTION | | Query: | select
count(distinct a.id) as count
from
articles a
inner join
article_translations atr
on atr.article_id = a.id
and atr.language_id =
?
inner join
article_types at
on a.type_id = at.id
inner join
article_statuses ast
on ast.id = a.status_id
inner join
users u
on u.id = a.created_by
left outer join
sections_articles sa
on sa.article_id = a.id
and sa.section_id = ?
left outer join
sections_articles sla
on sla.article_id = a.id
and sla.section_id = ?
left outer join
article_links ali
on ali.article_id = a.id
left outer join
article_files af
on af.article_id = a.id
left outer join
key_documents kd
on kd.article_id = a.id
where
1=1
and a.status_id = ?
and a.type_id IN (?)
and sa.section_id = ?
and sla.section_id = ?
and a.is_deleted = ?
and (
a.expire_at > now()
or a.expire_at is null
or a.expire_at = '0000-00-00 00:00:00'
)
and a.publish_at <= now()
order by
a.publish_at desc | | Time: | 0 ms | | Records: | 1 | | Columns: | count |
| | 4A701F90454B31BA5D146DD3F679B72E | | 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: | 1219 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
|
| | 4B9676F2A65784666AE2D9C476DB1411 | | 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
|
| | 5D37EC49761A6BD8413DE871396433B7 | | query [short version] | | Query Source: | SQL Query | | Datasource: | SCIDEV_PRODUCTION | | Query: | select
count(distinct a.id) as count
from
articles a
inner join
article_translations atr
on atr.article_id = a.id
and atr.language_id =
?
and atr.status_id = 2
inner join
article_types at
on a.type_id = at.id
inner join
article_statuses ast
on ast.id = a.status_id
inner join
users u
on u.id = a.created_by
left outer join
sections_articles sa
on sa.article_id = a.id
and sa.section_id = ?
left outer join
article_links ali
on ali.article_id = a.id
left outer join
article_files af
on af.article_id = a.id
left outer join
key_documents kd
on kd.article_id = a.id
left outer join
notices n
on n.article_id = a.id
left outer join
notice_translations nt
on nt.article_id = n.article_id
and nt.language_id =
?
inner join
article_translation_slugs ats
on ats.article_id = a.id
where
1=1
and a.status_id = ?
and a.type_id IN (?)
and a.type_id NOT IN (?)
and sa.section_id = ?
and a.is_deleted = ?
and (
a.expire_at > now()
or a.expire_at is null
or a.expire_at = '0000-00-00 00:00:00'
)
and a.publish_at <= now()
order by
a.publish_at desc | | Time: | 16 ms | | Records: | 1 | | Columns: | count |
| | 6AE50C33F028A392439D4F1090F3667F | | query [short version] | | Query Source: | SQL Query | | Datasource: | SCIDEV_PRODUCTION | | Query: | select
count(distinct a.id) as count
from
articles a
inner join
article_translations atr
on atr.article_id = a.id
and atr.language_id =
?
and atr.status_id = 2
inner join
article_types at
on a.type_id = at.id
inner join
article_statuses ast
on ast.id = a.status_id
inner join
users u
on u.id = a.created_by
left outer join
sections_articles sa
on sa.article_id = a.id
and sa.section_id = ?
left outer join
article_links ali
on ali.article_id = a.id
left outer join
article_files af
on af.article_id = a.id
left outer join
key_documents kd
on kd.article_id = a.id
left outer join
notices n
on n.article_id = a.id
left outer join
notice_translations nt
on nt.article_id = n.article_id
and nt.language_id =
?
inner join
article_translation_slugs ats
on ats.article_id = a.id
where
1=1
and a.status_id = ?
and a.type_id IN (?)
and a.type_id NOT IN (?)
and sa.section_id = ?
and a.is_deleted = ?
and (
a.expire_at > now()
or a.expire_at is null
or a.expire_at = '0000-00-00 00:00:00'
)
and a.publish_at <= now()
order by
a.publish_at desc | | Time: | 47 ms | | Records: | 1 | | Columns: | count |
| | 996180EF46EC30A90B9298FA2C69C356 | | 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
|
| | A99096A0A465F56AA005FFEFAFAF5136 | | 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
|
| | B34CD328BFA0E80DFFE52474386EAB31 | | query [short version] | | Query Source: | SQL Query | | Datasource: | SCIDEV_PRODUCTION | | Query: | select
distinct
a.id,
a.status_id,
a.type_id,
a.canonical_section_id,
a.created_at,
a.publish_at,
a.created_by,
a.author,
a.source,
a.editor_notes,
a.citations,
a.affiliation,
at.name as type,
at.slug as type_slug,
atr.language_id,
atr.status_id as translation_status_id,
atr.translation_type_id,
atr.title,
atr.slug,
atr.blurb,
atr.body,
case
when ifnull(af.file_name,'') <> '' then af.file_name
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then kd.document_url
else ''
end as keydocument_url,
case
when ifnull(af.file_name,'') <> '' then 'file'
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then 'url'
else ''
end as keydocument_type,
kd.publication_date,
ifnull(ali.link_url,'') as link_url
,
sa.is_highlighted,
sa.display_order,
sa.section_id
,
a.is_deleted,
a.publish_at,
a.expire_at,
a.updated_at,
a.updated_by,
a.is_paid,
u.firstname,
u.lastname,
u.email
,
(select language_id from article_translations atr_temp where atr_temp.article_id = a.id and is_original = 1 limit 1) as original_language_id
,
ast.name as status_name
,'' AS section_slug
,'' AS sub_section_slug
,'' AS canonical_link
from
articles a
inner join
article_translations atr
on atr.article_id = a.id
and atr.language_id =
?
inner join
article_types at
on a.type_id = at.id
inner join
article_statuses ast
on ast.id = a.status_id
inner join
users u
on u.id = a.created_by
left outer join
sections_articles sa
on sa.article_id = a.id
and sa.section_id = ?
left outer join
article_links ali
on ali.article_id = a.id
left outer join
article_files af
on af.article_id = a.id
left outer join
key_documents kd
on kd.article_id = a.id
where
1=1
and a.status_id = ?
and a.type_id IN (?)
and sa.section_id = ?
and a.is_deleted = ?
and (
a.expire_at > now()
or a.expire_at is null
or a.expire_at = '0000-00-00 00:00:00'
)
and a.publish_at <= now()
order by
a.publish_at desc
limit
?,
? | | Time: | 31 ms | | Records: | 1 | | Columns: | id, status_id, type_id, canonical_section_id, created_at, publish_at, created_by
author, source, editor_notes, citations, affiliation, type
type_slug, language_id, translation_status_id, translation_type_id, title, slug
blurb, body, keydocument_url, keydocument_type, publication_date, link_url
is_highlighted, display_order, section_id, is_deleted, publish_at, expire_at
updated_at, updated_by, is_paid, firstname, lastname, email
original_language_id, status_name, section_slug, sub_section_slug, canonical_link |
| | BEB2B98807710E709A94BB9C3904C5FA | | 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
,
n.start_at,
n.end_at,
n.close_at,
nt.information_url,
n.contact_details,
nt.location,
nt.organisation_name,
nt.organisation_url
,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
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 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
n.start_at asc
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
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 |
| | CBCBDD65A7731DB816FDD545AFEF7641 | | query [short version] | | Query Source: | SQL Query | | Datasource: | SCIDEV_PRODUCTION | | Query: | select
distinct
a.id,
a.status_id,
a.type_id,
a.canonical_section_id,
a.created_at,
a.publish_at,
a.created_by,
a.author,
a.source,
a.editor_notes,
a.citations,
a.affiliation,
at.name as type,
at.slug as type_slug,
atr.language_id,
atr.status_id as translation_status_id,
atr.translation_type_id,
atr.title,
atr.slug,
atr.blurb,
atr.body,
case
when ifnull(af.file_name,'') <> '' then af.file_name
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then kd.document_url
else ''
end as keydocument_url,
case
when ifnull(af.file_name,'') <> '' then 'file'
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then 'url'
else ''
end as keydocument_type,
kd.publication_date,
ifnull(ali.link_url,'') as link_url
,
sa.is_highlighted,
sa.display_order,
sa.section_id
,
ats.en_slug,
ats.en_transtypeid,
ats.fr_slug,
ats.fr_transtypeid,
ats.zh_slug,
ats.zh_transtypeid,
ats.es_slug,
ats.es_transtypeid,
ats.po_slug,
ats.po_transtypeid,
ats.ar_slug,
ats.ar_transtypeid
,
n.start_at,
n.end_at,
n.close_at,
nt.information_url,
n.contact_details,
nt.location,
nt.organisation_name,
nt.organisation_url
,'' AS section_slug
,'' AS sub_section_slug
,'' AS canonical_link
from
articles a
inner join
article_translations atr
on atr.article_id = a.id
and atr.language_id =
?
and atr.status_id = 2
inner join
article_types at
on a.type_id = at.id
inner join
article_statuses ast
on ast.id = a.status_id
inner join
users u
on u.id = a.created_by
left outer join
sections_articles sa
on sa.article_id = a.id
and sa.section_id = ?
left outer join
article_links ali
on ali.article_id = a.id
left outer join
article_files af
on af.article_id = a.id
left outer join
key_documents kd
on kd.article_id = a.id
left outer join
notices n
on n.article_id = a.id
left outer join
notice_translations nt
on nt.article_id = n.article_id
and nt.language_id =
?
inner join
article_translation_slugs ats
on ats.article_id = a.id
where
1=1
and a.status_id = ?
and a.type_id IN (?)
and a.type_id NOT IN (?)
and sa.section_id = ?
and a.is_deleted = ?
and (
a.expire_at > now()
or a.expire_at is null
or a.expire_at = '0000-00-00 00:00:00'
)
and a.publish_at <= now()
order by
a.publish_at desc
limit
?,
? | | Time: | 31 ms | | Records: | 0 | | Columns: | id, status_id, type_id, canonical_section_id, created_at, publish_at, created_by
author, source, editor_notes, citations, affiliation, type
type_slug, language_id, translation_status_id, translation_type_id, title, slug
blurb, body, keydocument_url, keydocument_type, publication_date, link_url
is_highlighted, display_order, section_id, en_slug, en_transtypeid, fr_slug
fr_transtypeid, zh_slug, zh_transtypeid, es_slug, es_transtypeid, po_slug
po_transtypeid, ar_slug, ar_transtypeid, start_at, end_at, close_at
information_url, contact_details, location, organisation_name, organisation_url, section_slug
sub_section_slug, canonical_link |
| | D6B8EA59F20FAD7277C93BDAD043148A | | 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
|
| | E10997A9D9D81A19E0D4428B776A6F01 | | 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: | 188 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
|
| | E6BD4ED14226D2501447D6E65DEDC2D5 | | 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: | 172 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
|
| | ECE67033EF588C350D39107DA7E700E7 | | query [short version] | | Query Source: | SQL Query | | Datasource: | SCIDEV_PRODUCTION | | Query: | select
distinct
a.id,
a.status_id,
a.type_id,
a.canonical_section_id,
a.created_at,
a.publish_at,
a.created_by,
a.author,
a.source,
a.editor_notes,
a.citations,
a.affiliation,
at.name as type,
at.slug as type_slug,
atr.language_id,
atr.status_id as translation_status_id,
atr.translation_type_id,
atr.title,
atr.slug,
atr.blurb,
atr.body,
case
when ifnull(af.file_name,'') <> '' then af.file_name
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then kd.document_url
else ''
end as keydocument_url,
case
when ifnull(af.file_name,'') <> '' then 'file'
when (ifnull(kd.document_url,'') <> '' and kd.document_url <> 'http://') then 'url'
else ''
end as keydocument_type,
kd.publication_date,
ifnull(ali.link_url,'') as link_url
,
sa.is_highlighted,
sa.display_order,
sa.section_id
,
ats.en_slug,
ats.en_transtypeid,
ats.fr_slug,
ats.fr_transtypeid,
ats.zh_slug,
ats.zh_transtypeid,
ats.es_slug,
ats.es_transtypeid,
ats.po_slug,
ats.po_transtypeid,
ats.ar_slug,
ats.ar_transtypeid
,'' AS section_slug
,'' AS sub_section_slug
,'' AS canonical_link
from
articles a
inner join
article_translations atr
on atr.article_id = a.id
and atr.language_id =
?
and atr.status_id = 2
inner join
article_types at
on a.type_id = at.id
inner join
article_statuses ast
on ast.id = a.status_id
inner join
users u
on u.id = a.created_by
left outer join
sections_articles sa
on sa.article_id = a.id
and sa.section_id = ?
left outer join
article_links ali
on ali.article_id = a.id
left outer join
article_files af
on af.article_id = a.id
left outer join
key_documents kd
on kd.article_id = a.id
inner join
article_translation_slugs ats
on ats.article_id = a.id
where
1=1
and a.status_id = ?
and a.type_id IN (?)
and a.type_id NOT IN (?)
and sa.section_id = ?
and a.is_deleted = ?
and (
a.expire_at > now()
or a.expire_at is null
or a.expire_at = '0000-00-00 00:00:00'
)
and a.publish_at <= now()
order by
a.publish_at desc
limit
?,
? | | Time: | 31 ms | | Records: | 2 | | Columns: | id, status_id, type_id, canonical_section_id, created_at, publish_at, created_by
author, source, editor_notes, citations, affiliation, type
type_slug, language_id, translation_status_id, translation_type_id, title, slug
blurb, body, keydocument_url, keydocument_type, publication_date, link_url
is_highlighted, display_order, section_id, en_slug, en_transtypeid, fr_slug
fr_transtypeid, zh_slug, zh_transtypeid, es_slug, es_transtypeid, po_slug
po_transtypeid, ar_slug, ar_transtypeid, section_slug, sub_section_slug, canonical_link
|
|
|