select `cms_nodes`.*, `cms_node_articles`.`old_article_id` as `pivot_old_article_id`, `cms_node_articles`.`node_id` as `pivot_node_id` from `cms_nodes` innerjoin `cms_node_articles` on `cms_nodes`.`id` = `cms_node_articles`.`node_id` where `cms_nodes`.`node_type_id` =3and `cms_node_articles`.`deleted_at` isnulland `cms_node_articles`.`old_article_id` in (1142677) and `cms_nodes`.`deleted_at` isnullorderby `id` asc
select `cms_nodes`.*, `cms_node_articles`.`old_article_id` as `pivot_old_article_id`, `cms_node_articles`.`node_id` as `pivot_node_id` from `cms_nodes` innerjoin `cms_node_articles` on `cms_nodes`.`id` = `cms_node_articles`.`node_id` where `cms_nodes`.`node_type_id` =4and `cms_node_articles`.`deleted_at` isnulland `cms_node_articles`.`old_article_id` in (1142677) and `cms_nodes`.`deleted_at` isnullorderby `id` asc
select `cms_terms`.*, `cms_old_article_terms`.`old_article_id` as `pivot_old_article_id`, `cms_old_article_terms`.`term_id` as `pivot_term_id` from `cms_terms` innerjoin `cms_old_article_terms` on `cms_terms`.`id` = `cms_old_article_terms`.`term_id` where `cms_terms`.`taxonomy_id` =1and `cms_old_article_terms`.`deleted_at` isnulland `cms_old_article_terms`.`old_article_id` in (1142677) and `cms_terms`.`deleted_at` isnullorderby `id` asc
select `cms_terms`.*, `cms_old_article_terms`.`old_article_id` as `pivot_old_article_id`, `cms_old_article_terms`.`term_id` as `pivot_term_id` from `cms_terms` innerjoin `cms_old_article_terms` on `cms_terms`.`id` = `cms_old_article_terms`.`term_id` where `cms_terms`.`taxonomy_id` =2and `cms_old_article_terms`.`deleted_at` isnulland `cms_old_article_terms`.`old_article_id` in (1142677) and `cms_terms`.`deleted_at` isnullorderby `id` asc
select `cms_terms`.*, `cms_old_article_terms`.`old_article_id` as `pivot_old_article_id`, `cms_old_article_terms`.`term_id` as `pivot_term_id` from `cms_terms` innerjoin `cms_old_article_terms` on `cms_terms`.`id` = `cms_old_article_terms`.`term_id` where `cms_terms`.`taxonomy_id` =3and `cms_old_article_terms`.`deleted_at` isnulland `cms_old_article_terms`.`old_article_id` in (1142677) and `cms_terms`.`deleted_at` isnullorderby `id` asc
select `cms_terms`.*, `cms_old_article_terms`.`old_article_id` as `pivot_old_article_id`, `cms_old_article_terms`.`term_id` as `pivot_term_id` from `cms_terms` innerjoin `cms_old_article_terms` on `cms_terms`.`id` = `cms_old_article_terms`.`term_id` where `cms_terms`.`taxonomy_id` =4and `cms_old_article_terms`.`deleted_at` isnulland `cms_old_article_terms`.`old_article_id` in (1142677) and `cms_terms`.`deleted_at` isnullorderby `id` asc
select `cms_terms`.*, `cms_old_article_terms`.`old_article_id` as `pivot_old_article_id`, `cms_old_article_terms`.`term_id` as `pivot_term_id` from `cms_terms` innerjoin `cms_old_article_terms` on `cms_terms`.`id` = `cms_old_article_terms`.`term_id` where `cms_terms`.`taxonomy_id` =5and `cms_old_article_terms`.`deleted_at` isnulland `cms_old_article_terms`.`old_article_id` in (1142677) and `cms_terms`.`deleted_at` isnullorderby `id` asc
select `cms_medias`.*, `cms_old_article_medias`.`old_article_id` as `pivot_old_article_id`, `cms_old_article_medias`.`media_id` as `pivot_media_id` from `cms_medias` innerjoin `cms_old_article_medias` on `cms_medias`.`id` = `cms_old_article_medias`.`media_id` where `cms_old_article_medias`.`old_article_id` in (1142677) and `cms_medias`.`deleted_at` isnull
selectcount(*) as aggregate from `cms_node_articles` where `node_id` =3053and `status` ='publish'and `published_at` <= (select `published_at` from `cms_node_articles` where `node_id` =3053and `old_article_id` ='1142677'and `deleted_at` isnull) and `deleted_at` isnulland `cms_node_articles`.`deleted_at` isnull
select `id` from `pb_book_m` where `asin` in ('B082D1KFC3', 'B093C7XLYV', 'B0B7JWRLK8', '4801968279', '4801972896', '4801976840') and `pb_book_m`.`del_flg` =0
select `cms_terms`.*, `cms_node_relation_terms`.`node_id` as `pivot_node_id`, `cms_node_relation_terms`.`term_id` as `pivot_term_id`, `cms_node_relation_terms`.`tab_name` as `pivot_tab_name`, `cms_node_relation_terms`.`tag_sort_order` as `pivot_tag_sort_order` from `cms_terms` innerjoin `cms_node_relation_terms` on `cms_terms`.`id` = `cms_node_relation_terms`.`term_id` where `cms_node_relation_terms`.`deleted_at` isnulland `cms_terms`.`deleted_at` isnulland `cms_node_relation_terms`.`node_id` in (3053) and `cms_terms`.`deleted_at` isnullorderby `tag_sort_order` asc