select `product_code`, `product_slug`, `allow_back_order` from `products` where `product_code` in ('HWB650', 'SONOS RAY BLACK', 'SONOS RAY WHITE', 'TSA1300C', 'F300IW6MOUNT', 'F100ICW5MOUNT', 'F100ICLCR5MOUNT', 'E10G1US1BLK', 'E30G1US1', 'E30G1US1BLK') 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)