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 (1184259) 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 (1184259) 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 (1184259) 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 (1184259) 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 (1184259) 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 (1184259) 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 (1184259) 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 (1184259) and `cms_medias`.`deleted_at` isnull
selectcount(*) as aggregate from `cms_node_articles` where `node_id` =3119and `status` ='publish'and `published_at` <= (select `published_at` from `cms_node_articles` where `node_id` =3119and `old_article_id` ='1184259'and `deleted_at` isnull) and `deleted_at` isnulland `cms_node_articles`.`deleted_at` isnull
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 (3119) and `cms_terms`.`deleted_at` isnullorderby `tag_sort_order` asc
select*from `pb_kobobooks` where `pb_kobobooks`.`kobo_id` in ('4046831790', '4336038900310', '4339476900310', 'B0CM6DCC5Y', 'B0CQNCLZFZ', 'B0DK6GQ45Y') and `pb_kobobooks`.`deleted_at` isnull
select*from `pb_book_m` where `pb_book_m`.`asin` in ('4046831790', '4336038900310', '4339476900310', 'B0CM6DCC5Y', 'B0CQNCLZFZ', 'B0DK6GQ45Y') and `pb_book_m`.`del_flg` =0