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` = 'higiene' 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 ('37') order by `sequence` asc
select * from `cad_category` where `cad_category`.`deleted_at` is null and `cad_category`.`parent_id` in ('38', '39') order by `sequence` asc
select * from `cad_category` where `cad_category`.`deleted_at` is null and `cad_category`.`parent_id` in ('40') 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` = '37' 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 ('37') 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 = 37 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 ('3410', '2241', '2607', '3000', '2237', '2236', '2235', '4929', '2223', '2212', '2611', '2230', '2229', '2228', '2227', '2226', '2225', '2224', '2231', '4924', '4923', '4922', '4921', '4916', '4914', '4898', '4899', '4897', '4925', '4926', '4927', '4928', '4522', '4805', '5809', '3450', '6039', '4806', '4275') 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 ('3410', '2241', '2607', '3000', '2237', '2236', '2235', '4929', '2223', '2212', '2611', '2230', '2229', '2228', '2227', '2226', '2225', '2224', '2231', '4924', '4923', '4922', '4921', '4916', '4914', '4898', '4899', '4897', '4925', '4926', '4927', '4928', '4522', '4805', '5809', '3450', '6039', '4806', '4275') 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 ('3410', '2241', '2607', '3000', '2237', '2236', '2235', '4929', '2223', '2212', '2611', '2230', '2229', '2228', '2227', '2226', '2225', '2224', '2231', '4924', '4923', '4922', '4921', '4916', '4914', '4898', '4899', '4897', '4925', '4926', '4927', '4928', '4522', '4805', '5809', '3450', '6039', '4806', '4275') 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 ('3410', '2241', '2607', '3000', '2237', '2236', '2235', '4929', '2223', '2212', '2611', '2230', '2229', '2228', '2227', '2226', '2225', '2224', '2231', '4924', '4923', '4922', '4921', '4916', '4914', '4898', '4899', '4897', '4925', '4926', '4927', '4928', '4522', '4805', '5809', '3450', '6039', '4806', '4275') 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 ('3410', '2241', '2607', '3000', '2237', '2236', '2235', '4929', '2223', '2212', '2611', '2230', '2229', '2228', '2227', '2226', '2225', '2224', '2231', '4924', '4923', '4922', '4921', '4916', '4914', '4898', '4899', '4897', '4925', '4926', '4927', '4928', '4522', '4805', '5809', '3450', '6039', '4806', '4275') 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_da7a40f6763eda262a90210fe60e719d` where `cad_attribute`.`deleted_at` is null and `self_da7a40f6763eda262a90210fe60e719d`.`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_da7a40f6763eda262a90210fe60e719d`.`id` and `product_id` in ('3410', '2241', '2607', '3000', '2237', '2236', '2235', '4929', '2223', '2212', '2611', '2230', '2229', '2228', '2227', '2226', '2225', '2224', '2231', '4924', '4923', '4922', '4921', '4916', '4914', '4898', '4899', '4897', '4925', '4926', '4927', '4928', '4522', '4805', '5809', '3450', '6039', '4806', '4275') 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 ('3410', '2241', '2607', '3000', '2237', '2236', '2235', '4929', '2223', '2212', '2611', '2230', '2229', '2228', '2227', '2226', '2225', '2224', '2231', '4924', '4923', '4922', '4921', '4916', '4914', '4898', '4899', '4897', '4925', '4926', '4927', '4928', '4522', '4805', '5809', '3450', '6039', '4806', '4275')
select * from `cad_product` where `cad_product`.`deleted_at` is null and `id` in ('3410', '2241', '2607', '3000', '2237', '2236', '2235', '4929', '2223', '2212', '2611', '2230', '2229', '2228', '2227', '2226', '2225', '2224', '2231', '4924', '4923', '4922', '4921', '4916', '4914', '4898', '4899', '4897', '4925', '4926', '4927', '4928', '4522', '4805', '5809', '3450', '6039', '4806', '4275') order by FIELD(id, 3410,2241,2607,3000,2237,2236,2235,4929,2223,2212,2611,2230,2229,2228,2227,2226,2225,2224,2231,4924,4923,4922,4921,4916,4914,4898,4899,4897,4925,4926,4927,4928,4522,4805,5809,3450,6039,4806,4275) limit 20 offset 20
select * from `cad_product_image` where `cad_product_image`.`deleted_at` is null and `cad_product_image`.`product_id` in ('4923', '4922', '4921', '4916', '4914', '4898', '4899', '4897', '4925', '4926', '4927', '4928', '4522', '4805', '5809', '3450', '6039', '4806', '4275') 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 ('4923', '4922', '4921', '4916', '4914', '4898', '4899', '4897', '4925', '4926', '4927', '4928', '4522', '4805', '5809', '3450', '6039', '4806', '4275') 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 ('4275', '4522', '4806', '6039', '5809', '3450', '4805', '4925', '4926', '4927', '4928', '4897', '4898', '4899', '4914', '4916', '4921', '4922', '4923')
select * from `cad_store` where `cad_store`.`deleted_at` is null and `cad_store`.`id` in ('1373', '795', '154', '1919', '1988', '2227', '2155')
select * from `cad_price_table_sku` where `cad_price_table_sku`.`deleted_at` is null and `cad_price_table_sku`.`sku_id` in ('5644', '6176', '6482', '7953', '7707', '4614', '6481', '6622', '6623', '6624', '6625', '6594', '6595', '6596', '6611', '6613', '6618', '6619', '6620')
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 ('4923', '4922', '4921', '4916', '4914', '4898', '4899', '4897', '4925', '4926', '4927', '4928', '4522', '4805', '5809', '3450', '6039', '4806', '4275')
select * from `cad_store` where `cad_store`.`deleted_at` is null and `cad_store`.`id` in ('1988', '154', '1919', '2227', '1373', '2155', '795')
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` = '37' 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` is null limit 1
LIMIT
ORDER BY
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` = '4923'
select * from `cad_payment_recipient` where `cad_payment_recipient`.`deleted_at` is null and `cad_payment_recipient`.`store_id` = '1988' 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` = '4922'
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` = '4921'
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` = '4916'
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` = '4914'
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` = '4898'
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` = '4899'
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` = '4897'
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` = '4925'
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` = '4926'
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` = '4927'
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` = '4928'
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` = '4522'
select * from `cad_payment_recipient` where `cad_payment_recipient`.`deleted_at` is null and `cad_payment_recipient`.`store_id` = '154' 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` = '4805'
select * from `cad_payment_recipient` where `cad_payment_recipient`.`deleted_at` is null and `cad_payment_recipient`.`store_id` = '1919' 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` = '5809'
select * from `cad_payment_recipient` where `cad_payment_recipient`.`deleted_at` is null and `cad_payment_recipient`.`store_id` = '2227' 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` = '3450'
select * from `cad_payment_recipient` where `cad_payment_recipient`.`deleted_at` is null and `cad_payment_recipient`.`store_id` = '1373' 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` = '6039'
select * from `cad_payment_recipient` where `cad_payment_recipient`.`deleted_at` is null and `cad_payment_recipient`.`store_id` = '2155' 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` = '4806'
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` = '4275'
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 * 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'
