category
products
filter
sortBy
query
bannersGroup
seo
showCases
obLevel
__env
app
errors
marketplace
loggedUser
pageName
dlUser
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` = 'nandyala' 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 ('118') 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` = '118' 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 ('118') 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 = 118 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 ('6350', '747', '749', '646', '746', '6356', '6365', '622', '648', '638', '631', '531', '751', '525', '530', '756', '1165', '6358', '256', '628', '568', '644', '6357', '6347', '6344', '6354', '1162', '273', '1160', '271', '528', '755', '753', '1161', '758', '265', '268', '529', '6352', '261', '752', '6359', '527', '6364', '6362', '549', '570', '6361', '6351', '1158', '255', '882', '6360', '257', '264', '6346', '632', '533', '534', '569', '618', '621', '627', '630', '266', '633', '637', '640', '748', '269', '274', '272', '270', '523', '571', '1164', '262', '572', '634', '546', '636', '750', '1157', '629', '647') 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 ('6350', '747', '749', '646', '746', '6356', '6365', '622', '648', '638', '631', '531', '751', '525', '530', '756', '1165', '6358', '256', '628', '568', '644', '6357', '6347', '6344', '6354', '1162', '273', '1160', '271', '528', '755', '753', '1161', '758', '265', '268', '529', '6352', '261', '752', '6359', '527', '6364', '6362', '549', '570', '6361', '6351', '1158', '255', '882', '6360', '257', '264', '6346', '632', '533', '534', '569', '618', '621', '627', '630', '266', '633', '637', '640', '748', '269', '274', '272', '270', '523', '571', '1164', '262', '572', '634', '546', '636', '750', '1157', '629', '647') 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 ('6350', '747', '749', '646', '746', '6356', '6365', '622', '648', '638', '631', '531', '751', '525', '530', '756', '1165', '6358', '256', '628', '568', '644', '6357', '6347', '6344', '6354', '1162', '273', '1160', '271', '528', '755', '753', '1161', '758', '265', '268', '529', '6352', '261', '752', '6359', '527', '6364', '6362', '549', '570', '6361', '6351', '1158', '255', '882', '6360', '257', '264', '6346', '632', '533', '534', '569', '618', '621', '627', '630', '266', '633', '637', '640', '748', '269', '274', '272', '270', '523', '571', '1164', '262', '572', '634', '546', '636', '750', '1157', '629', '647') 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 ('6350', '747', '749', '646', '746', '6356', '6365', '622', '648', '638', '631', '531', '751', '525', '530', '756', '1165', '6358', '256', '628', '568', '644', '6357', '6347', '6344', '6354', '1162', '273', '1160', '271', '528', '755', '753', '1161', '758', '265', '268', '529', '6352', '261', '752', '6359', '527', '6364', '6362', '549', '570', '6361', '6351', '1158', '255', '882', '6360', '257', '264', '6346', '632', '533', '534', '569', '618', '621', '627', '630', '266', '633', '637', '640', '748', '269', '274', '272', '270', '523', '571', '1164', '262', '572', '634', '546', '636', '750', '1157', '629', '647') 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 ('6350', '747', '749', '646', '746', '6356', '6365', '622', '648', '638', '631', '531', '751', '525', '530', '756', '1165', '6358', '256', '628', '568', '644', '6357', '6347', '6344', '6354', '1162', '273', '1160', '271', '528', '755', '753', '1161', '758', '265', '268', '529', '6352', '261', '752', '6359', '527', '6364', '6362', '549', '570', '6361', '6351', '1158', '255', '882', '6360', '257', '264', '6346', '632', '533', '534', '569', '618', '621', '627', '630', '266', '633', '637', '640', '748', '269', '274', '272', '270', '523', '571', '1164', '262', '572', '634', '546', '636', '750', '1157', '629', '647') 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_dfcca2308cb15f8b07777b38a5f74c6f` where `cad_attribute`.`deleted_at` is null and `self_dfcca2308cb15f8b07777b38a5f74c6f`.`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_dfcca2308cb15f8b07777b38a5f74c6f`.`id` and `product_id` in ('6350', '747', '749', '646', '746', '6356', '6365', '622', '648', '638', '631', '531', '751', '525', '530', '756', '1165', '6358', '256', '628', '568', '644', '6357', '6347', '6344', '6354', '1162', '273', '1160', '271', '528', '755', '753', '1161', '758', '265', '268', '529', '6352', '261', '752', '6359', '527', '6364', '6362', '549', '570', '6361', '6351', '1158', '255', '882', '6360', '257', '264', '6346', '632', '533', '534', '569', '618', '621', '627', '630', '266', '633', '637', '640', '748', '269', '274', '272', '270', '523', '571', '1164', '262', '572', '634', '546', '636', '750', '1157', '629', '647') 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 ('6350', '747', '749', '646', '746', '6356', '6365', '622', '648', '638', '631', '531', '751', '525', '530', '756', '1165', '6358', '256', '628', '568', '644', '6357', '6347', '6344', '6354', '1162', '273', '1160', '271', '528', '755', '753', '1161', '758', '265', '268', '529', '6352', '261', '752', '6359', '527', '6364', '6362', '549', '570', '6361', '6351', '1158', '255', '882', '6360', '257', '264', '6346', '632', '533', '534', '569', '618', '621', '627', '630', '266', '633', '637', '640', '748', '269', '274', '272', '270', '523', '571', '1164', '262', '572', '634', '546', '636', '750', '1157', '629', '647')
select * from `cad_product` where `cad_product`.`deleted_at` is null and `id` in ('6350', '747', '749', '646', '746', '6356', '6365', '622', '648', '638', '631', '531', '751', '525', '530', '756', '1165', '6358', '256', '628', '568', '644', '6357', '6347', '6344', '6354', '1162', '273', '1160', '271', '528', '755', '753', '1161', '758', '265', '268', '529', '6352', '261', '752', '6359', '527', '6364', '6362', '549', '570', '6361', '6351', '1158', '255', '882', '6360', '257', '264', '6346', '632', '533', '534', '569', '618', '621', '627', '630', '266', '633', '637', '640', '748', '269', '274', '272', '270', '523', '571', '1164', '262', '572', '634', '546', '636', '750', '1157', '629', '647') order by FIELD(id, 6350,747,749,646,746,6356,6365,622,648,638,631,531,751,525,530,756,1165,6358,256,628,568,644,6357,6347,6344,6354,1162,273,1160,271,528,755,753,1161,758,265,268,529,6352,261,752,6359,527,6364,6362,549,570,6361,6351,1158,255,882,6360,257,264,6346,632,533,534,569,618,621,627,630,266,633,637,640,748,269,274,272,270,523,571,1164,262,572,634,546,636,750,1157,629,647) limit 20 offset 60
select * from `cad_product_image` where `cad_product_image`.`deleted_at` is null and `cad_product_image`.`product_id` in ('618', '621', '627', '630', '266', '633', '637', '640', '748', '269', '274', '272', '270', '523', '571', '1164', '262', '572', '634', '546') 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 ('618', '621', '627', '630', '266', '633', '637', '640', '748', '269', '274', '272', '270', '523', '571', '1164', '262', '572', '634', '546') 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 ('1164', '546', '572', '634', '262', '571', '269', '270', '272', '274', '523', '748', '618', '640', '637', '633', '630', '627', '621', '266')
select * from `cad_store` where `cad_store`.`deleted_at` is null and `cad_store`.`id` in ('113')
select * from `cad_price_table_sku` where `cad_price_table_sku`.`deleted_at` is null and `cad_price_table_sku`.`sku_id` in ('1473', '747', '773', '835', '325', '772', '332', '333', '335', '337', '717', '949', '819', '841', '838', '834', '831', '828', '822', '329')
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 ('618', '621', '627', '630', '266', '633', '637', '640', '748', '269', '274', '272', '270', '523', '571', '1164', '262', '572', '634', '546')
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` = '118' 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` = '117' limit 1
LIMIT
ORDER BY
select * from `cad_category` where `cad_category`.`deleted_at` is null and `cad_category`.`id` = '36' limit 1
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` = '618'
select * from `cad_payment_recipient` where `cad_payment_recipient`.`deleted_at` is null and `cad_payment_recipient`.`store_id` = '113' 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` = '621'
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` = '627'
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` = '630'
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` = '266'
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` = '633'
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` = '637'
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` = '640'
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` = '748'
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` = '269'
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` = '274'
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` = '272'
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` = '270'
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` = '523'
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` = '571'
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` = '1164'
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` = '262'
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` = '572'
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` = '634'
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` = '546'
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'
