ou até 2x de R$ 40,00 (sem juros)
store
products
filter
query
sortBy
showCases
obLevel
__env
app
errors
marketplace
loggedUser
seo
pageName
dlUser
option
product
script_header
style_body
style_checkout_cart
socialMedia
sections
cartTotalPrice
categories
featuredStores
menuItems
brands
key
category
subCategory
subCategoryChildren
script_body
trackingCode
select * from `cad_store` where `cad_store`.`deleted_at` is null and `slug` = 'acj-black' and `status` = '1' and `percent` >= '6.5' and (select count(*) from `cad_product` where `cad_product`.`store_id` = `cad_store`.`id` 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_product`.`deleted_at` is null) >= 1 limit 1
SELECT *
LIMIT
ORDER BY
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 `store_id` = '2093' 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 ISNULL(store_sequence), store_sequence ASC, 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 ('5597', '5608', '5563', '5551', '5542', '5553', '5595', '5493', '5495', '5544', '5594', '5596', '5603', '5489', '5543', '5571', '5572', '5573', '5531', '5623', '5624', '5532', '5625', '5626', '5627', '5669', '5500', '5641', '5642', '5643', '5644', '5645', '5646', '5648', '5660', '5667', '5552', '5600', '5606', '5541', '5550', '5661', '5668', '5530', '5539', '5540', '5562', '5568', '5570', '5590', '5591', '5498', '5569', '5481', '5502', '5525', '5631', '5460', '5497', '5528', '5533', '5534', '5537', '5560', '5561', '5604', '5490', '5491', '5492', '5522', '5523', '5524', '5526', '5527', '5555', '5556', '5557', '5558', '5559', '5554', '5529', '5574', '5589', '5592', '5593', '5549', '5605', '5535', '5538', '5506', '5507', '5586', '5520', '5564', '5565', '5566', '5567', '5585', '5486', '5488', '5501', '5521', '5581', '5582', '5583', '5584') 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 ('5597', '5608', '5563', '5551', '5542', '5553', '5595', '5493', '5495', '5544', '5594', '5596', '5603', '5489', '5543', '5571', '5572', '5573', '5531', '5623', '5624', '5532', '5625', '5626', '5627', '5669', '5500', '5641', '5642', '5643', '5644', '5645', '5646', '5648', '5660', '5667', '5552', '5600', '5606', '5541', '5550', '5661', '5668', '5530', '5539', '5540', '5562', '5568', '5570', '5590', '5591', '5498', '5569', '5481', '5502', '5525', '5631', '5460', '5497', '5528', '5533', '5534', '5537', '5560', '5561', '5604', '5490', '5491', '5492', '5522', '5523', '5524', '5526', '5527', '5555', '5556', '5557', '5558', '5559', '5554', '5529', '5574', '5589', '5592', '5593', '5549', '5605', '5535', '5538', '5506', '5507', '5586', '5520', '5564', '5565', '5566', '5567', '5585', '5486', '5488', '5501', '5521', '5581', '5582', '5583', '5584') 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 ('5597', '5608', '5563', '5551', '5542', '5553', '5595', '5493', '5495', '5544', '5594', '5596', '5603', '5489', '5543', '5571', '5572', '5573', '5531', '5623', '5624', '5532', '5625', '5626', '5627', '5669', '5500', '5641', '5642', '5643', '5644', '5645', '5646', '5648', '5660', '5667', '5552', '5600', '5606', '5541', '5550', '5661', '5668', '5530', '5539', '5540', '5562', '5568', '5570', '5590', '5591', '5498', '5569', '5481', '5502', '5525', '5631', '5460', '5497', '5528', '5533', '5534', '5537', '5560', '5561', '5604', '5490', '5491', '5492', '5522', '5523', '5524', '5526', '5527', '5555', '5556', '5557', '5558', '5559', '5554', '5529', '5574', '5589', '5592', '5593', '5549', '5605', '5535', '5538', '5506', '5507', '5586', '5520', '5564', '5565', '5566', '5567', '5585', '5486', '5488', '5501', '5521', '5581', '5582', '5583', '5584') 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 ('5597', '5608', '5563', '5551', '5542', '5553', '5595', '5493', '5495', '5544', '5594', '5596', '5603', '5489', '5543', '5571', '5572', '5573', '5531', '5623', '5624', '5532', '5625', '5626', '5627', '5669', '5500', '5641', '5642', '5643', '5644', '5645', '5646', '5648', '5660', '5667', '5552', '5600', '5606', '5541', '5550', '5661', '5668', '5530', '5539', '5540', '5562', '5568', '5570', '5590', '5591', '5498', '5569', '5481', '5502', '5525', '5631', '5460', '5497', '5528', '5533', '5534', '5537', '5560', '5561', '5604', '5490', '5491', '5492', '5522', '5523', '5524', '5526', '5527', '5555', '5556', '5557', '5558', '5559', '5554', '5529', '5574', '5589', '5592', '5593', '5549', '5605', '5535', '5538', '5506', '5507', '5586', '5520', '5564', '5565', '5566', '5567', '5585', '5486', '5488', '5501', '5521', '5581', '5582', '5583', '5584') 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 ('5597', '5608', '5563', '5551', '5542', '5553', '5595', '5493', '5495', '5544', '5594', '5596', '5603', '5489', '5543', '5571', '5572', '5573', '5531', '5623', '5624', '5532', '5625', '5626', '5627', '5669', '5500', '5641', '5642', '5643', '5644', '5645', '5646', '5648', '5660', '5667', '5552', '5600', '5606', '5541', '5550', '5661', '5668', '5530', '5539', '5540', '5562', '5568', '5570', '5590', '5591', '5498', '5569', '5481', '5502', '5525', '5631', '5460', '5497', '5528', '5533', '5534', '5537', '5560', '5561', '5604', '5490', '5491', '5492', '5522', '5523', '5524', '5526', '5527', '5555', '5556', '5557', '5558', '5559', '5554', '5529', '5574', '5589', '5592', '5593', '5549', '5605', '5535', '5538', '5506', '5507', '5586', '5520', '5564', '5565', '5566', '5567', '5585', '5486', '5488', '5501', '5521', '5581', '5582', '5583', '5584') 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 * from `cad_attribute` where `cad_attribute`.`deleted_at` is null and (select count(*) from `cad_attribute` as `self_1eedd8979dbd447f31e1dd186d574e8d` where `cad_attribute`.`deleted_at` is null and `self_1eedd8979dbd447f31e1dd186d574e8d`.`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_1eedd8979dbd447f31e1dd186d574e8d`.`id` and `product_id` in ('5597', '5608', '5563', '5551', '5542', '5553', '5595', '5493', '5495', '5544', '5594', '5596', '5603', '5489', '5543', '5571', '5572', '5573', '5531', '5623', '5624', '5532', '5625', '5626', '5627', '5669', '5500', '5641', '5642', '5643', '5644', '5645', '5646', '5648', '5660', '5667', '5552', '5600', '5606', '5541', '5550', '5661', '5668', '5530', '5539', '5540', '5562', '5568', '5570', '5590', '5591', '5498', '5569', '5481', '5502', '5525', '5631', '5460', '5497', '5528', '5533', '5534', '5537', '5560', '5561', '5604', '5490', '5491', '5492', '5522', '5523', '5524', '5526', '5527', '5555', '5556', '5557', '5558', '5559', '5554', '5529', '5574', '5589', '5592', '5593', '5549', '5605', '5535', '5538', '5506', '5507', '5586', '5520', '5564', '5565', '5566', '5567', '5585', '5486', '5488', '5501', '5521', '5581', '5582', '5583', '5584') 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 ('5597', '5608', '5563', '5551', '5542', '5553', '5595', '5493', '5495', '5544', '5594', '5596', '5603', '5489', '5543', '5571', '5572', '5573', '5531', '5623', '5624', '5532', '5625', '5626', '5627', '5669', '5500', '5641', '5642', '5643', '5644', '5645', '5646', '5648', '5660', '5667', '5552', '5600', '5606', '5541', '5550', '5661', '5668', '5530', '5539', '5540', '5562', '5568', '5570', '5590', '5591', '5498', '5569', '5481', '5502', '5525', '5631', '5460', '5497', '5528', '5533', '5534', '5537', '5560', '5561', '5604', '5490', '5491', '5492', '5522', '5523', '5524', '5526', '5527', '5555', '5556', '5557', '5558', '5559', '5554', '5529', '5574', '5589', '5592', '5593', '5549', '5605', '5535', '5538', '5506', '5507', '5586', '5520', '5564', '5565', '5566', '5567', '5585', '5486', '5488', '5501', '5521', '5581', '5582', '5583', '5584')
select * from `cad_product` where `cad_product`.`deleted_at` is null and `id` in ('5597', '5608', '5563', '5551', '5542', '5553', '5595', '5493', '5495', '5544', '5594', '5596', '5603', '5489', '5543', '5571', '5572', '5573', '5531', '5623', '5624', '5532', '5625', '5626', '5627', '5669', '5500', '5641', '5642', '5643', '5644', '5645', '5646', '5648', '5660', '5667', '5552', '5600', '5606', '5541', '5550', '5661', '5668', '5530', '5539', '5540', '5562', '5568', '5570', '5590', '5591', '5498', '5569', '5481', '5502', '5525', '5631', '5460', '5497', '5528', '5533', '5534', '5537', '5560', '5561', '5604', '5490', '5491', '5492', '5522', '5523', '5524', '5526', '5527', '5555', '5556', '5557', '5558', '5559', '5554', '5529', '5574', '5589', '5592', '5593', '5549', '5605', '5535', '5538', '5506', '5507', '5586', '5520', '5564', '5565', '5566', '5567', '5585', '5486', '5488', '5501', '5521', '5581', '5582', '5583', '5584') order by FIELD(id, 5597,5608,5563,5551,5542,5553,5595,5493,5495,5544,5594,5596,5603,5489,5543,5571,5572,5573,5531,5623,5624,5532,5625,5626,5627,5669,5500,5641,5642,5643,5644,5645,5646,5648,5660,5667,5552,5600,5606,5541,5550,5661,5668,5530,5539,5540,5562,5568,5570,5590,5591,5498,5569,5481,5502,5525,5631,5460,5497,5528,5533,5534,5537,5560,5561,5604,5490,5491,5492,5522,5523,5524,5526,5527,5555,5556,5557,5558,5559,5554,5529,5574,5589,5592,5593,5549,5605,5535,5538,5506,5507,5586,5520,5564,5565,5566,5567,5585,5486,5488,5501,5521,5581,5582,5583,5584) limit 20 offset 40
select * from `cad_product_image` where `cad_product_image`.`deleted_at` is null and `cad_product_image`.`product_id` in ('5550', '5661', '5668', '5530', '5539', '5540', '5562', '5568', '5570', '5590', '5591', '5498', '5569', '5481', '5502', '5525', '5631', '5460', '5497', '5528') 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 ('5550', '5661', '5668', '5530', '5539', '5540', '5562', '5568', '5570', '5590', '5591', '5498', '5569', '5481', '5502', '5525', '5631', '5460', '5497', '5528') 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 ('5661', '5497', '5460', '5528', '5481', '5631', '5525', '5502', '5569', '5498', '5530', '5539', '5540', '5562', '5568', '5570', '5590', '5591', '5668', '5550')
select * from `cad_store` where `cad_store`.`deleted_at` is null and `cad_store`.`id` in ('2093')
select * from `cad_price_table_sku` where `cad_price_table_sku`.`deleted_at` is null and `cad_price_table_sku`.`sku_id` in ('7511', '7337', '7292', '7368', '7314', '7481', '7365', '7342', '7418', '7338', '7370', '7379', '7380', '7402', '7417', '7419', '7439', '7440', '7518', '7390')
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 ('5550', '5661', '5668', '5530', '5539', '5540', '5562', '5568', '5570', '5590', '5591', '5498', '5569', '5481', '5502', '5525', '5631', '5460', '5497', '5528')
select * from `cad_show_case` where `cad_show_case`.`deleted_at` is null and `store_id` = '2093' and `status` = '1' order by `sequence` asc
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` = '5550'
select * from `cad_payment_recipient` where `cad_payment_recipient`.`deleted_at` is null and `cad_payment_recipient`.`store_id` = '2093' 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` = '5661'
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` = '5668'
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` = '5530'
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` = '5539'
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` = '5540'
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` = '5562'
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` = '5568'
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` = '5570'
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` = '5590'
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` = '5591'
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` = '5498'
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` = '5569'
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` = '5481'
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` = '5502'
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` = '5525'
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` = '5631'
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` = '5460'
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` = '5497'
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` = '5528'
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'