select `product_code`, `product_slug`, `allow_back_order` from `products` where `product_code` in ('F100IW6MOUNT', 'F300ICW6MOUNT', 'F300ICW8MOUNT', 'DMD35', 'BEAM2US1BLK', 'F1000IW6MOUNT', 'XED62', 'VIV60V2', 'HWB650', 'SONOS RAY BLACK') 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, 99)
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)