select `product_code`, `product_slug`, `allow_back_order` from `products` where `product_code` in ('MX62SSTWHITE', 'MX62WHITE', 'MX66BLACK', 'MX66WHITE', 'MX86BLACK', 'MX86WHITE', 'DSP8-130MKIII', 'DSP2-150MKIII') and `products`.`deleted_at` isnull
select `menus`.*, `pages`.`slug` as `page_slug` from `menus` leftjoin `pages` on `pages`.`id` = `menus`.`page_id` where `menus`.`group_id` in (7) orderby `menus`.`lft` asc
select `menus`.*, `pages`.`slug` as `page_slug` from `menus` leftjoin `pages` on `pages`.`id` = `menus`.`page_id` where `menus`.`group_id` in (5) orderby `menus`.`lft` asc
select `menus`.*, `pages`.`slug` as `page_slug` from `menus` innerjoin `pages` on `pages`.`id` = `menus`.`page_id` where `menus`.`parent_id` in (56, 71, 72, 73, 84, 85, 98)
select `menus`.*, `pages`.`slug` as `page_slug` from `menus` leftjoin `pages` on `pages`.`id` = `menus`.`page_id` where `menus`.`group_id` in (6) orderby `menus`.`lft` asc
select `menus`.*, `pages`.`slug` as `page_slug` from `menus` innerjoin `pages` on `pages`.`id` = `menus`.`page_id` where `menus`.`parent_id` in (59, 61, 65, 69, 70, 97)