# User@Host: eurocremeRW[eurocremeRW] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 1  Rows_examined: 6287
select
     abstract_article.article_id
from
    abstract_article, abstract_article_data
where
                
        abstract_article_data.article_id IN
        (
                 select
                al.id_1
from
    abstract_article_link as al, 
    abstract_article as a
where
    al.link_id = 'gallerymovie' and
    al.id_2 = '3707548874' and
    al.id_1 = a.article_id and
    a.article_flag = 1

        )
     and
    abstract_article.article_flag ="1" and
    abstract_article.article_id = abstract_article_data.article_id and
    (

     and
    abstract_article.article_flag ="1" and
    abstract_article.article_id = abstract_article_data.article_id and
    (
        abstract_article_data.data_meta = "en" or
        abstract_article_data.data_meta = "all"
    ) and
    abstract_article.article_class ="gallery" and
    abstract_article_data.data_class ="publish_date"
order by
    abstract_article_data.dte desc;