category
products
filter
sortBy
query
bannersGroup
seo
showCases
obLevel
__env
app
errors
marketplace
loggedUser
pageName
dlUser
option
product
script_header
style_body
style_checkout_cart
socialMedia
sections
cartTotalPrice
categories
featuredStores
menuItems
brands
key
subCategory
subCategoryChildren
script_body
trackingCode
select * from `cad_category` where `cad_category`.`deleted_at` is null and `slug` = 'infantil' and `status` = '1' order by `sequence` asc limit 1
SELECT *
select * from `cad_category` where `cad_category`.`deleted_at` is null and `cad_category`.`parent_id` in ('10') order by `sequence` asc
select * from `cad_banner_group` where `cad_banner_group`.`deleted_at` is null and (select count(*) from `cad_category` inner join `cad_category_banner_group` on `cad_category`.`id` = `cad_category_banner_group`.`category_id` where `cad_category_banner_group`.`banner_group_id` = `cad_banner_group`.`id` and `id` = '10' and `cad_category`.`deleted_at` is null) >= 1 and `status` <> '0' order by `created_at` desc
select `cad_product`.`id` from `cad_product` inner join `cad_store` on `cad_product`.`store_id` = `cad_store`.`id` inner join `cad_sku` on `cad_product`.`id` = `cad_sku`.`product_id` inner join `cad_price_table_sku` on `cad_sku`.`id` = `cad_price_table_sku`.`sku_id` where `cad_product`.`deleted_at` is null and (select count(*) from `cad_category` inner join `cad_product_category` on `cad_category`.`id` = `cad_product_category`.`category_id` where `cad_product_category`.`product_id` = `cad_product`.`id` and `category_id` in ('10') and `cad_category`.`deleted_at` is null) >= 1 and (`cad_product`.`publish` = '1' and `cad_product`.`deleted_at` is null) and (select count(*) from `cad_category` inner join `cad_product_category` on `cad_category`.`id` = `cad_product_category`.`category_id` where `cad_product_category`.`product_id` = `cad_product`.`id` and `status` = '1' and `cad_category`.`deleted_at` is null) >= 1 and (select count(*) from `cad_sku` where `cad_sku`.`product_id` = `cad_product`.`id` and `stock` > '0' and `cad_sku`.`status` = '1' and (select count(*) from `cad_price_table_sku` where `cad_price_table_sku`.`sku_id` = `cad_sku`.`id` and ((`retail` > '0' and (select count(*) from `cad_sku` where `cad_price_table_sku`.`sku_id` = `cad_sku`.`id` and (select count(*) from `cad_product` where `cad_sku`.`product_id` = `cad_product`.`id` and (select count(*) from `cad_store` where `cad_product`.`store_id` = `cad_store`.`id` and `business_model` in ('B2C', 'B2BB2C') and `cad_store`.`deleted_at` is null) >= 1 and `cad_product`.`deleted_at` is null) >= 1 and `cad_sku`.`deleted_at` is null) >= 1) or (`wholesale` > '0' and (select count(*) from `cad_sku` where `cad_price_table_sku`.`sku_id` = `cad_sku`.`id` and (select count(*) from `cad_product` where `cad_sku`.`product_id` = `cad_product`.`id` and (select count(*) from `cad_store` where `cad_product`.`store_id` = `cad_store`.`id` and `business_model` in ('B2B', 'B2BB2C') and `cad_store`.`deleted_at` is null) >= 1 and `cad_product`.`deleted_at` is null) >= 1 and `cad_sku`.`deleted_at` is null) >= 1)) and `cad_price_table_sku`.`deleted_at` is null) >= 1 and `cad_sku`.`deleted_at` is null) >= 1 and (select count(*) from `cad_store` where `cad_product`.`store_id` = `cad_store`.`id` and `status` = '1' and `percent` >= '6.5' and `cad_store`.`deleted_at` is null) >= 1 and `cad_sku`.`status` = '1' and (`cad_price_table_sku`.`retail` > '0' or `cad_price_table_sku`.`wholesale` > '0') group by `cad_sku`.`product_id` order by (SELECT -sequence from cad_product_category where category_id = 10 and product_id = cad_product.id LIMIT 1) desc, CASE WHEN (cad_store.business_model = "B2C" AND cad_price_table_sku.sale_retail > 0) THEN cad_price_table_sku.sale_retail WHEN (cad_store.business_model = "B2C" AND cad_price_table_sku.sale_retail <= 0) THEN cad_price_table_sku.retail WHEN (cad_store.business_model = "B2B" AND cad_price_table_sku.sale_wholesale > 0) THEN cad_price_table_sku.sale_wholesale WHEN (cad_store.business_model = "B2B" AND cad_price_table_sku.sale_wholesale <= 0) THEN cad_price_table_sku.wholesale WHEN (cad_store.business_model = "B2BB2C" AND cad_price_table_sku.sale_retail > 0) THEN cad_price_table_sku.sale_retail WHEN (cad_store.business_model = "B2BB2C" AND cad_price_table_sku.sale_retail <= 0 AND cad_price_table_sku.retail > 0) THEN cad_price_table_sku.retail WHEN (cad_store.business_model = "B2BB2C" AND cad_price_table_sku.sale_wholesale > 0) THEN cad_price_table_sku.sale_wholesale WHEN (cad_store.business_model = "B2BB2C" AND cad_price_table_sku.sale_wholesale <= 0 AND cad_price_table_sku.wholesale > 0) THEN cad_price_table_sku.wholesale END desc
select `id`, `name`, `parent_id`, `slug`, `sequence` from `cad_category` where `cad_category`.`deleted_at` is null and (select count(*) from `cad_product` inner join `cad_product_category` on `cad_product`.`id` = `cad_product_category`.`product_id` where `cad_product_category`.`category_id` = `cad_category`.`id` and `product_id` in ('1769', '1770', '2505', '2287', '3015', '2508', '3963', '2509', '2506', '2516', '3958', '3917', '3961', '3962', '2283', '3959', '2510', '1768', '2285', '2286', '2602', '3524', '4392', '4394', '4396', '1798', '2568', '4390', '4399', '2382', '2511', '3874', '3875', '3876', '2288', '4391', '3523', '4397', '6232', '4398', '4400', '4403', '2605', '2824', '4395', '4405', '4411', '3966', '2289', '4343', '5767', '5768', '6034', '6035', '6036', '4393', '3921', '3957', '4578', '4286', '4287', '3922', '3322', '3323', '3324', '3480', '3723', '3724', '3725', '3726', '3727', '3728', '3729', '3730', '4288', '4357', '4615', '2203', '4298', '3389', '4300', '5405', '2201', '3685', '4297', '4346', '3923', '4293', '4296', '4299', '4345', '4402', '4575', '4576', '4577', '3680', '3681', '3682', '4289', '4291', '4301', '4302', '4292', '4443', '4659', '4660', '4661', '5535', '5693', '3683', '4290', '4342', '3647', '4401', '3684', '2197') and `cad_product`.`deleted_at` is null) >= 1 and `status` = '1'
select distinct `id`, `name` from `cad_brand` where `cad_brand`.`deleted_at` is null and (select count(*) from `cad_product` where `cad_product`.`brand_id` = `cad_brand`.`id` and `id` in ('1769', '1770', '2505', '2287', '3015', '2508', '3963', '2509', '2506', '2516', '3958', '3917', '3961', '3962', '2283', '3959', '2510', '1768', '2285', '2286', '2602', '3524', '4392', '4394', '4396', '1798', '2568', '4390', '4399', '2382', '2511', '3874', '3875', '3876', '2288', '4391', '3523', '4397', '6232', '4398', '4400', '4403', '2605', '2824', '4395', '4405', '4411', '3966', '2289', '4343', '5767', '5768', '6034', '6035', '6036', '4393', '3921', '3957', '4578', '4286', '4287', '3922', '3322', '3323', '3324', '3480', '3723', '3724', '3725', '3726', '3727', '3728', '3729', '3730', '4288', '4357', '4615', '2203', '4298', '3389', '4300', '5405', '2201', '3685', '4297', '4346', '3923', '4293', '4296', '4299', '4345', '4402', '4575', '4576', '4577', '3680', '3681', '3682', '4289', '4291', '4301', '4302', '4292', '4443', '4659', '4660', '4661', '5535', '5693', '3683', '4290', '4342', '3647', '4401', '3684', '2197') and `cad_product`.`deleted_at` is null) >= 1 order by `name` asc
select exists(select * from `cad_product` where `cad_product`.`deleted_at` is null and `id` in ('1769', '1770', '2505', '2287', '3015', '2508', '3963', '2509', '2506', '2516', '3958', '3917', '3961', '3962', '2283', '3959', '2510', '1768', '2285', '2286', '2602', '3524', '4392', '4394', '4396', '1798', '2568', '4390', '4399', '2382', '2511', '3874', '3875', '3876', '2288', '4391', '3523', '4397', '6232', '4398', '4400', '4403', '2605', '2824', '4395', '4405', '4411', '3966', '2289', '4343', '5767', '5768', '6034', '6035', '6036', '4393', '3921', '3957', '4578', '4286', '4287', '3922', '3322', '3323', '3324', '3480', '3723', '3724', '3725', '3726', '3727', '3728', '3729', '3730', '4288', '4357', '4615', '2203', '4298', '3389', '4300', '5405', '2201', '3685', '4297', '4346', '3923', '4293', '4296', '4299', '4345', '4402', '4575', '4576', '4577', '3680', '3681', '3682', '4289', '4291', '4301', '4302', '4292', '4443', '4659', '4660', '4661', '5535', '5693', '3683', '4290', '4342', '3647', '4401', '3684', '2197') and (select count(*) from `cad_sku` where `cad_sku`.`product_id` = `cad_product`.`id` and `cad_sku`.`status` = '1' and (select count(*) from `cad_price_table_sku` where `cad_price_table_sku`.`sku_id` = `cad_sku`.`id` and ((`wholesale` > '0' and (select count(*) from `cad_sku` where `cad_price_table_sku`.`sku_id` = `cad_sku`.`id` and (select count(*) from `cad_product` where `cad_sku`.`product_id` = `cad_product`.`id` and (select count(*) from `cad_store` where `cad_product`.`store_id` = `cad_store`.`id` and `business_model` in ('B2B', 'B2BB2C') and `cad_store`.`deleted_at` is null) >= 1 and `cad_product`.`deleted_at` is null) >= 1 and `cad_sku`.`deleted_at` is null) >= 1)) and `cad_price_table_sku`.`deleted_at` is null) >= 1 and `cad_sku`.`deleted_at` is null) >= 1) as `exists`
select exists(select * from `cad_product` where `cad_product`.`deleted_at` is null and `id` in ('1769', '1770', '2505', '2287', '3015', '2508', '3963', '2509', '2506', '2516', '3958', '3917', '3961', '3962', '2283', '3959', '2510', '1768', '2285', '2286', '2602', '3524', '4392', '4394', '4396', '1798', '2568', '4390', '4399', '2382', '2511', '3874', '3875', '3876', '2288', '4391', '3523', '4397', '6232', '4398', '4400', '4403', '2605', '2824', '4395', '4405', '4411', '3966', '2289', '4343', '5767', '5768', '6034', '6035', '6036', '4393', '3921', '3957', '4578', '4286', '4287', '3922', '3322', '3323', '3324', '3480', '3723', '3724', '3725', '3726', '3727', '3728', '3729', '3730', '4288', '4357', '4615', '2203', '4298', '3389', '4300', '5405', '2201', '3685', '4297', '4346', '3923', '4293', '4296', '4299', '4345', '4402', '4575', '4576', '4577', '3680', '3681', '3682', '4289', '4291', '4301', '4302', '4292', '4443', '4659', '4660', '4661', '5535', '5693', '3683', '4290', '4342', '3647', '4401', '3684', '2197') and (select count(*) from `cad_sku` where `cad_sku`.`product_id` = `cad_product`.`id` and `cad_sku`.`status` = '1' and (select count(*) from `cad_price_table_sku` where `cad_price_table_sku`.`sku_id` = `cad_sku`.`id` and ((`retail` > '0' and (select count(*) from `cad_sku` where `cad_price_table_sku`.`sku_id` = `cad_sku`.`id` and (select count(*) from `cad_product` where `cad_sku`.`product_id` = `cad_product`.`id` and (select count(*) from `cad_store` where `cad_product`.`store_id` = `cad_store`.`id` and `business_model` in ('B2C', 'B2BB2C') and `cad_store`.`deleted_at` is null) >= 1 and `cad_product`.`deleted_at` is null) >= 1 and `cad_sku`.`deleted_at` is null) >= 1)) and `cad_price_table_sku`.`deleted_at` is null) >= 1 and `cad_sku`.`deleted_at` is null) >= 1) as `exists`
select `id`, `name`, `main_id` from `cad_variant` where `cad_variant`.`deleted_at` is null and (select count(*) from `cad_sku` inner join `cad_sku_variant` on `cad_sku`.`id` = `cad_sku_variant`.`sku_id` where `cad_sku_variant`.`variant_id` = `cad_variant`.`id` and `cad_sku`.`product_id` in ('1769', '1770', '2505', '2287', '3015', '2508', '3963', '2509', '2506', '2516', '3958', '3917', '3961', '3962', '2283', '3959', '2510', '1768', '2285', '2286', '2602', '3524', '4392', '4394', '4396', '1798', '2568', '4390', '4399', '2382', '2511', '3874', '3875', '3876', '2288', '4391', '3523', '4397', '6232', '4398', '4400', '4403', '2605', '2824', '4395', '4405', '4411', '3966', '2289', '4343', '5767', '5768', '6034', '6035', '6036', '4393', '3921', '3957', '4578', '4286', '4287', '3922', '3322', '3323', '3324', '3480', '3723', '3724', '3725', '3726', '3727', '3728', '3729', '3730', '4288', '4357', '4615', '2203', '4298', '3389', '4300', '5405', '2201', '3685', '4297', '4346', '3923', '4293', '4296', '4299', '4345', '4402', '4575', '4576', '4577', '3680', '3681', '3682', '4289', '4291', '4301', '4302', '4292', '4443', '4659', '4660', '4661', '5535', '5693', '3683', '4290', '4342', '3647', '4401', '3684', '2197') and `stock` > '0' and `cad_sku`.`status` = '1' and (select count(*) from `cad_price_table_sku` where `cad_price_table_sku`.`sku_id` = `cad_sku`.`id` and ((`retail` > '0' and (select count(*) from `cad_sku` where `cad_price_table_sku`.`sku_id` = `cad_sku`.`id` and (select count(*) from `cad_product` where `cad_sku`.`product_id` = `cad_product`.`id` and (select count(*) from `cad_store` where `cad_product`.`store_id` = `cad_store`.`id` and `business_model` in ('B2C', 'B2BB2C') and `cad_store`.`deleted_at` is null) >= 1 and `cad_product`.`deleted_at` is null) >= 1 and `cad_sku`.`deleted_at` is null) >= 1) or (`wholesale` > '0' and (select count(*) from `cad_sku` where `cad_price_table_sku`.`sku_id` = `cad_sku`.`id` and (select count(*) from `cad_product` where `cad_sku`.`product_id` = `cad_product`.`id` and (select count(*) from `cad_store` where `cad_product`.`store_id` = `cad_store`.`id` and `business_model` in ('B2B', 'B2BB2C') and `cad_store`.`deleted_at` is null) >= 1 and `cad_product`.`deleted_at` is null) >= 1 and `cad_sku`.`deleted_at` is null) >= 1)) and `cad_price_table_sku`.`deleted_at` is null) >= 1 and `cad_sku`.`deleted_at` is null) >= 1
select `id`, `name` from `cad_variant` where `cad_variant`.`deleted_at` is null and `cad_variant`.`id` in ('1', '14', '537', '620', '254')
select * from `cad_attribute` where `cad_attribute`.`deleted_at` is null and (select count(*) from `cad_attribute` as `self_1d71e53f39616a18a0f483c99d7d48a7` where `cad_attribute`.`deleted_at` is null and `self_1d71e53f39616a18a0f483c99d7d48a7`.`main_id` = `cad_attribute`.`id` and (select count(*) from `cad_product` inner join `cad_product_attributes` on `cad_product`.`id` = `cad_product_attributes`.`product_id` where `cad_product_attributes`.`attribute_id` = `self_1d71e53f39616a18a0f483c99d7d48a7`.`id` and `product_id` in ('1769', '1770', '2505', '2287', '3015', '2508', '3963', '2509', '2506', '2516', '3958', '3917', '3961', '3962', '2283', '3959', '2510', '1768', '2285', '2286', '2602', '3524', '4392', '4394', '4396', '1798', '2568', '4390', '4399', '2382', '2511', '3874', '3875', '3876', '2288', '4391', '3523', '4397', '6232', '4398', '4400', '4403', '2605', '2824', '4395', '4405', '4411', '3966', '2289', '4343', '5767', '5768', '6034', '6035', '6036', '4393', '3921', '3957', '4578', '4286', '4287', '3922', '3322', '3323', '3324', '3480', '3723', '3724', '3725', '3726', '3727', '3728', '3729', '3730', '4288', '4357', '4615', '2203', '4298', '3389', '4300', '5405', '2201', '3685', '4297', '4346', '3923', '4293', '4296', '4299', '4345', '4402', '4575', '4576', '4577', '3680', '3681', '3682', '4289', '4291', '4301', '4302', '4292', '4443', '4659', '4660', '4661', '5535', '5693', '3683', '4290', '4342', '3647', '4401', '3684', '2197') and `cad_product`.`deleted_at` is null) >= 1 and `cad_attribute`.`deleted_at` is null) >= 1 and `main_id` is null order by `name` asc
select count(*) as aggregate from `cad_product` where `cad_product`.`deleted_at` is null and `id` in ('1769', '1770', '2505', '2287', '3015', '2508', '3963', '2509', '2506', '2516', '3958', '3917', '3961', '3962', '2283', '3959', '2510', '1768', '2285', '2286', '2602', '3524', '4392', '4394', '4396', '1798', '2568', '4390', '4399', '2382', '2511', '3874', '3875', '3876', '2288', '4391', '3523', '4397', '6232', '4398', '4400', '4403', '2605', '2824', '4395', '4405', '4411', '3966', '2289', '4343', '5767', '5768', '6034', '6035', '6036', '4393', '3921', '3957', '4578', '4286', '4287', '3922', '3322', '3323', '3324', '3480', '3723', '3724', '3725', '3726', '3727', '3728', '3729', '3730', '4288', '4357', '4615', '2203', '4298', '3389', '4300', '5405', '2201', '3685', '4297', '4346', '3923', '4293', '4296', '4299', '4345', '4402', '4575', '4576', '4577', '3680', '3681', '3682', '4289', '4291', '4301', '4302', '4292', '4443', '4659', '4660', '4661', '5535', '5693', '3683', '4290', '4342', '3647', '4401', '3684', '2197')
select * from `cad_product` where `cad_product`.`deleted_at` is null and `id` in ('1769', '1770', '2505', '2287', '3015', '2508', '3963', '2509', '2506', '2516', '3958', '3917', '3961', '3962', '2283', '3959', '2510', '1768', '2285', '2286', '2602', '3524', '4392', '4394', '4396', '1798', '2568', '4390', '4399', '2382', '2511', '3874', '3875', '3876', '2288', '4391', '3523', '4397', '6232', '4398', '4400', '4403', '2605', '2824', '4395', '4405', '4411', '3966', '2289', '4343', '5767', '5768', '6034', '6035', '6036', '4393', '3921', '3957', '4578', '4286', '4287', '3922', '3322', '3323', '3324', '3480', '3723', '3724', '3725', '3726', '3727', '3728', '3729', '3730', '4288', '4357', '4615', '2203', '4298', '3389', '4300', '5405', '2201', '3685', '4297', '4346', '3923', '4293', '4296', '4299', '4345', '4402', '4575', '4576', '4577', '3680', '3681', '3682', '4289', '4291', '4301', '4302', '4292', '4443', '4659', '4660', '4661', '5535', '5693', '3683', '4290', '4342', '3647', '4401', '3684', '2197') order by FIELD(id, 1769,1770,2505,2287,3015,2508,3963,2509,2506,2516,3958,3917,3961,3962,2283,3959,2510,1768,2285,2286,2602,3524,4392,4394,4396,1798,2568,4390,4399,2382,2511,3874,3875,3876,2288,4391,3523,4397,6232,4398,4400,4403,2605,2824,4395,4405,4411,3966,2289,4343,5767,5768,6034,6035,6036,4393,3921,3957,4578,4286,4287,3922,3322,3323,3324,3480,3723,3724,3725,3726,3727,3728,3729,3730,4288,4357,4615,2203,4298,3389,4300,5405,2201,3685,4297,4346,3923,4293,4296,4299,4345,4402,4575,4576,4577,3680,3681,3682,4289,4291,4301,4302,4292,4443,4659,4660,4661,5535,5693,3683,4290,4342,3647,4401,3684,2197) limit 20 offset 60
select * from `cad_product_image` where `cad_product_image`.`deleted_at` is null and `cad_product_image`.`product_id` in ('4287', '3922', '3322', '3323', '3324', '3480', '3723', '3724', '3725', '3726', '3727', '3728', '3729', '3730', '4288', '4357', '4615', '2203', '4298', '3389') order by `sequence` asc
select `cad_sku`.* from `cad_sku` inner join `cad_product` on `cad_sku`.`product_id` = `cad_product`.`id` inner join `cad_store` on `cad_product`.`store_id` = `cad_store`.`id` inner join `cad_price_table_sku` on `cad_sku`.`id` = `cad_price_table_sku`.`sku_id` where `cad_sku`.`deleted_at` is null and `cad_sku`.`product_id` in ('4287', '3922', '3322', '3323', '3324', '3480', '3723', '3724', '3725', '3726', '3727', '3728', '3729', '3730', '4288', '4357', '4615', '2203', '4298', '3389') and `cad_sku`.`status` = '1' and `stock` > '0' and `cad_sku`.`status` = '1' and (select count(*) from `cad_price_table_sku` where `cad_price_table_sku`.`sku_id` = `cad_sku`.`id` and ((`retail` > '0' and (select count(*) from `cad_sku` where `cad_price_table_sku`.`sku_id` = `cad_sku`.`id` and (select count(*) from `cad_product` where `cad_sku`.`product_id` = `cad_product`.`id` and (select count(*) from `cad_store` where `cad_product`.`store_id` = `cad_store`.`id` and `business_model` in ('B2C', 'B2BB2C') and `cad_store`.`deleted_at` is null) >= 1 and `cad_product`.`deleted_at` is null) >= 1 and `cad_sku`.`deleted_at` is null) >= 1) or (`wholesale` > '0' and (select count(*) from `cad_sku` where `cad_price_table_sku`.`sku_id` = `cad_sku`.`id` and (select count(*) from `cad_product` where `cad_sku`.`product_id` = `cad_product`.`id` and (select count(*) from `cad_store` where `cad_product`.`store_id` = `cad_store`.`id` and `business_model` in ('B2B', 'B2BB2C') and `cad_store`.`deleted_at` is null) >= 1 and `cad_product`.`deleted_at` is null) >= 1 and `cad_sku`.`deleted_at` is null) >= 1)) and `cad_price_table_sku`.`deleted_at` is null) >= 1 order by cad_price_table_sku.retail = 0, cad_price_table_sku.wholesale = 0, CASE WHEN (cad_store.business_model = "B2C" AND cad_price_table_sku.sale_retail > 0) THEN cad_price_table_sku.sale_retail WHEN (cad_store.business_model = "B2C" AND cad_price_table_sku.sale_retail <= 0) THEN cad_price_table_sku.retail WHEN (cad_store.business_model = "B2B" AND cad_price_table_sku.sale_wholesale > 0) THEN cad_price_table_sku.sale_wholesale WHEN (cad_store.business_model = "B2B" AND cad_price_table_sku.sale_wholesale <= 0) THEN cad_price_table_sku.wholesale WHEN (cad_store.business_model = "B2BB2C" AND cad_price_table_sku.sale_retail > 0) THEN cad_price_table_sku.sale_retail WHEN (cad_store.business_model = "B2BB2C" AND cad_price_table_sku.sale_retail <= 0 AND cad_price_table_sku.retail > 0) THEN cad_price_table_sku.retail WHEN (cad_store.business_model = "B2BB2C" AND cad_price_table_sku.sale_wholesale > 0) THEN cad_price_table_sku.sale_wholesale WHEN (cad_store.business_model = "B2BB2C" AND cad_price_table_sku.sale_wholesale <= 0 AND cad_price_table_sku.wholesale > 0) THEN cad_price_table_sku.wholesale END asc
select * from `cad_product` where `cad_product`.`deleted_at` is null and `cad_product`.`id` in ('3389', '2203', '4298', '4615', '4357', '4288', '3480', '3730', '3728', '3322', '3323', '3324', '3723', '3724', '3725', '3726', '3727', '3729', '3922', '4287')
select * from `cad_store` where `cad_store`.`deleted_at` is null and `cad_store`.`id` in ('795', '789', '741', '1173', '1545', '1593', '1096', '63')
select * from `cad_price_table_sku` where `cad_price_table_sku`.`deleted_at` is null and `cad_price_table_sku`.`sku_id` in ('4535', '4555', '4554', '4553', '4552', '4551', '4550', '4549', '4538', '4537', '4536', '4534', '4533', '4532', '4531', '4529', '4556', '4557', '4558', '4530', '3030', '5779', '5778', '5668', '6284', '5873', '5815', '5814', '5813', '4646', '4938', '4936', '4456', '4457', '4458', '4931', '4932', '4933', '4934', '4935', '4937', '5164', '5162', '5161', '5817', '5657', '5816', '5163')
select `cad_category`.*, `cad_product_category`.`product_id` as `pivot_product_id`, `cad_product_category`.`category_id` as `pivot_category_id`, `cad_product_category`.`sequence` as `pivot_sequence`, `cad_product_category`.`user_id` as `pivot_user_id` from `cad_category` inner join `cad_product_category` on `cad_category`.`id` = `cad_product_category`.`category_id` where `cad_category`.`deleted_at` is null and `cad_product_category`.`product_id` in ('4287', '3922', '3322', '3323', '3324', '3480', '3723', '3724', '3725', '3726', '3727', '3728', '3729', '3730', '4288', '4357', '4615', '2203', '4298', '3389')
select * from `cad_store` where `cad_store`.`deleted_at` is null and `cad_store`.`id` in ('1593', '1545', '789', '1173', '1096', '63', '795', '741')
select * from `cad_show_case` where `cad_show_case`.`deleted_at` is null and (select count(*) from `cad_category` inner join `cad_category_show_case` on `cad_category`.`id` = `cad_category_show_case`.`category_id` where `cad_category_show_case`.`show_case_id` = `cad_show_case`.`id` and `category_id` = '10' and `cad_category`.`deleted_at` is null) >= 1 and `status` = '1' order by `sequence` asc
select * from `cad_category` where `cad_category`.`deleted_at` is null and `cad_category`.`id` = '1' limit 1
LIMIT
ORDER BY
select * from `cad_category` where `cad_category`.`deleted_at` is null and `cad_category`.`id` is null limit 1
select * from `cad_payment_installment_settings` where `cad_payment_installment_settings`.`deleted_at` is null and `cad_payment_installment_settings`.`id` = '3' limit 1
select `cad_category`.*, `cad_product_category`.`product_id` as `pivot_product_id`, `cad_product_category`.`category_id` as `pivot_category_id`, `cad_product_category`.`sequence` as `pivot_sequence`, `cad_product_category`.`user_id` as `pivot_user_id` from `cad_category` inner join `cad_product_category` on `cad_category`.`id` = `cad_product_category`.`category_id` where `cad_category`.`deleted_at` is null and `cad_product_category`.`product_id` = '4287'
select * from `cad_payment_recipient` where `cad_payment_recipient`.`deleted_at` is null and `cad_payment_recipient`.`store_id` = '1593' and `cad_payment_recipient`.`store_id` is not null
select `cad_category`.*, `cad_product_category`.`product_id` as `pivot_product_id`, `cad_product_category`.`category_id` as `pivot_category_id`, `cad_product_category`.`sequence` as `pivot_sequence`, `cad_product_category`.`user_id` as `pivot_user_id` from `cad_category` inner join `cad_product_category` on `cad_category`.`id` = `cad_product_category`.`category_id` where `cad_category`.`deleted_at` is null and `cad_product_category`.`product_id` = '3922'
select * from `cad_payment_recipient` where `cad_payment_recipient`.`deleted_at` is null and `cad_payment_recipient`.`store_id` = '1545' and `cad_payment_recipient`.`store_id` is not null
select `cad_category`.*, `cad_product_category`.`product_id` as `pivot_product_id`, `cad_product_category`.`category_id` as `pivot_category_id`, `cad_product_category`.`sequence` as `pivot_sequence`, `cad_product_category`.`user_id` as `pivot_user_id` from `cad_category` inner join `cad_product_category` on `cad_category`.`id` = `cad_product_category`.`category_id` where `cad_category`.`deleted_at` is null and `cad_product_category`.`product_id` = '3322'
select * from `cad_payment_recipient` where `cad_payment_recipient`.`deleted_at` is null and `cad_payment_recipient`.`store_id` = '789' and `cad_payment_recipient`.`store_id` is not null
select `cad_category`.*, `cad_product_category`.`product_id` as `pivot_product_id`, `cad_product_category`.`category_id` as `pivot_category_id`, `cad_product_category`.`sequence` as `pivot_sequence`, `cad_product_category`.`user_id` as `pivot_user_id` from `cad_category` inner join `cad_product_category` on `cad_category`.`id` = `cad_product_category`.`category_id` where `cad_category`.`deleted_at` is null and `cad_product_category`.`product_id` = '3323'
select `cad_category`.*, `cad_product_category`.`product_id` as `pivot_product_id`, `cad_product_category`.`category_id` as `pivot_category_id`, `cad_product_category`.`sequence` as `pivot_sequence`, `cad_product_category`.`user_id` as `pivot_user_id` from `cad_category` inner join `cad_product_category` on `cad_category`.`id` = `cad_product_category`.`category_id` where `cad_category`.`deleted_at` is null and `cad_product_category`.`product_id` = '3324'
select `cad_category`.*, `cad_product_category`.`product_id` as `pivot_product_id`, `cad_product_category`.`category_id` as `pivot_category_id`, `cad_product_category`.`sequence` as `pivot_sequence`, `cad_product_category`.`user_id` as `pivot_user_id` from `cad_category` inner join `cad_product_category` on `cad_category`.`id` = `cad_product_category`.`category_id` where `cad_category`.`deleted_at` is null and `cad_product_category`.`product_id` = '3480'
select * from `cad_payment_recipient` where `cad_payment_recipient`.`deleted_at` is null and `cad_payment_recipient`.`store_id` = '1173' and `cad_payment_recipient`.`store_id` is not null
select `cad_category`.*, `cad_product_category`.`product_id` as `pivot_product_id`, `cad_product_category`.`category_id` as `pivot_category_id`, `cad_product_category`.`sequence` as `pivot_sequence`, `cad_product_category`.`user_id` as `pivot_user_id` from `cad_category` inner join `cad_product_category` on `cad_category`.`id` = `cad_product_category`.`category_id` where `cad_category`.`deleted_at` is null and `cad_product_category`.`product_id` = '3723'
select `cad_category`.*, `cad_product_category`.`product_id` as `pivot_product_id`, `cad_product_category`.`category_id` as `pivot_category_id`, `cad_product_category`.`sequence` as `pivot_sequence`, `cad_product_category`.`user_id` as `pivot_user_id` from `cad_category` inner join `cad_product_category` on `cad_category`.`id` = `cad_product_category`.`category_id` where `cad_category`.`deleted_at` is null and `cad_product_category`.`product_id` = '3724'
select `cad_category`.*, `cad_product_category`.`product_id` as `pivot_product_id`, `cad_product_category`.`category_id` as `pivot_category_id`, `cad_product_category`.`sequence` as `pivot_sequence`, `cad_product_category`.`user_id` as `pivot_user_id` from `cad_category` inner join `cad_product_category` on `cad_category`.`id` = `cad_product_category`.`category_id` where `cad_category`.`deleted_at` is null and `cad_product_category`.`product_id` = '3725'
select `cad_category`.*, `cad_product_category`.`product_id` as `pivot_product_id`, `cad_product_category`.`category_id` as `pivot_category_id`, `cad_product_category`.`sequence` as `pivot_sequence`, `cad_product_category`.`user_id` as `pivot_user_id` from `cad_category` inner join `cad_product_category` on `cad_category`.`id` = `cad_product_category`.`category_id` where `cad_category`.`deleted_at` is null and `cad_product_category`.`product_id` = '3726'
select `cad_category`.*, `cad_product_category`.`product_id` as `pivot_product_id`, `cad_product_category`.`category_id` as `pivot_category_id`, `cad_product_category`.`sequence` as `pivot_sequence`, `cad_product_category`.`user_id` as `pivot_user_id` from `cad_category` inner join `cad_product_category` on `cad_category`.`id` = `cad_product_category`.`category_id` where `cad_category`.`deleted_at` is null and `cad_product_category`.`product_id` = '3727'
select `cad_category`.*, `cad_product_category`.`product_id` as `pivot_product_id`, `cad_product_category`.`category_id` as `pivot_category_id`, `cad_product_category`.`sequence` as `pivot_sequence`, `cad_product_category`.`user_id` as `pivot_user_id` from `cad_category` inner join `cad_product_category` on `cad_category`.`id` = `cad_product_category`.`category_id` where `cad_category`.`deleted_at` is null and `cad_product_category`.`product_id` = '3728'
select `cad_category`.*, `cad_product_category`.`product_id` as `pivot_product_id`, `cad_product_category`.`category_id` as `pivot_category_id`, `cad_product_category`.`sequence` as `pivot_sequence`, `cad_product_category`.`user_id` as `pivot_user_id` from `cad_category` inner join `cad_product_category` on `cad_category`.`id` = `cad_product_category`.`category_id` where `cad_category`.`deleted_at` is null and `cad_product_category`.`product_id` = '3729'
select `cad_category`.*, `cad_product_category`.`product_id` as `pivot_product_id`, `cad_product_category`.`category_id` as `pivot_category_id`, `cad_product_category`.`sequence` as `pivot_sequence`, `cad_product_category`.`user_id` as `pivot_user_id` from `cad_category` inner join `cad_product_category` on `cad_category`.`id` = `cad_product_category`.`category_id` where `cad_category`.`deleted_at` is null and `cad_product_category`.`product_id` = '3730'
select `cad_category`.*, `cad_product_category`.`product_id` as `pivot_product_id`, `cad_product_category`.`category_id` as `pivot_category_id`, `cad_product_category`.`sequence` as `pivot_sequence`, `cad_product_category`.`user_id` as `pivot_user_id` from `cad_category` inner join `cad_product_category` on `cad_category`.`id` = `cad_product_category`.`category_id` where `cad_category`.`deleted_at` is null and `cad_product_category`.`product_id` = '4288'
select `cad_category`.*, `cad_product_category`.`product_id` as `pivot_product_id`, `cad_product_category`.`category_id` as `pivot_category_id`, `cad_product_category`.`sequence` as `pivot_sequence`, `cad_product_category`.`user_id` as `pivot_user_id` from `cad_category` inner join `cad_product_category` on `cad_category`.`id` = `cad_product_category`.`category_id` where `cad_category`.`deleted_at` is null and `cad_product_category`.`product_id` = '4357'
select * from `cad_payment_recipient` where `cad_payment_recipient`.`deleted_at` is null and `cad_payment_recipient`.`store_id` = '1096' and `cad_payment_recipient`.`store_id` is not null
select `cad_category`.*, `cad_product_category`.`product_id` as `pivot_product_id`, `cad_product_category`.`category_id` as `pivot_category_id`, `cad_product_category`.`sequence` as `pivot_sequence`, `cad_product_category`.`user_id` as `pivot_user_id` from `cad_category` inner join `cad_product_category` on `cad_category`.`id` = `cad_product_category`.`category_id` where `cad_category`.`deleted_at` is null and `cad_product_category`.`product_id` = '4615'
select * from `cad_payment_recipient` where `cad_payment_recipient`.`deleted_at` is null and `cad_payment_recipient`.`store_id` = '63' and `cad_payment_recipient`.`store_id` is not null
select `cad_category`.*, `cad_product_category`.`product_id` as `pivot_product_id`, `cad_product_category`.`category_id` as `pivot_category_id`, `cad_product_category`.`sequence` as `pivot_sequence`, `cad_product_category`.`user_id` as `pivot_user_id` from `cad_category` inner join `cad_product_category` on `cad_category`.`id` = `cad_product_category`.`category_id` where `cad_category`.`deleted_at` is null and `cad_product_category`.`product_id` = '2203'
select * from `cad_payment_recipient` where `cad_payment_recipient`.`deleted_at` is null and `cad_payment_recipient`.`store_id` = '795' and `cad_payment_recipient`.`store_id` is not null
select `cad_category`.*, `cad_product_category`.`product_id` as `pivot_product_id`, `cad_product_category`.`category_id` as `pivot_category_id`, `cad_product_category`.`sequence` as `pivot_sequence`, `cad_product_category`.`user_id` as `pivot_user_id` from `cad_category` inner join `cad_product_category` on `cad_category`.`id` = `cad_product_category`.`category_id` where `cad_category`.`deleted_at` is null and `cad_product_category`.`product_id` = '4298'
select `cad_category`.*, `cad_product_category`.`product_id` as `pivot_product_id`, `cad_product_category`.`category_id` as `pivot_category_id`, `cad_product_category`.`sequence` as `pivot_sequence`, `cad_product_category`.`user_id` as `pivot_user_id` from `cad_category` inner join `cad_product_category` on `cad_category`.`id` = `cad_product_category`.`category_id` where `cad_category`.`deleted_at` is null and `cad_product_category`.`product_id` = '3389'
select * from `cad_payment_recipient` where `cad_payment_recipient`.`deleted_at` is null and `cad_payment_recipient`.`store_id` = '741' and `cad_payment_recipient`.`store_id` is not null
select * from `cad_appearance` where `cad_appearance`.`deleted_at` is null and `name` = 'cssEditor' and `attribute` = '' limit 1
select * from `cad_appearance` where `cad_appearance`.`deleted_at` is null and `name` not like 'cssEditor'
select * from `cad_social_media` where `status` = '1' order by `sequence` asc
select * from `cad_menu_items` where `cad_menu_items`.`deleted_at` is null and `active` = '1'