منخصيصين في كل ما يخص ديكور البيت بداية من
التشطيبات الدخلية وصولا للفرش بأنواعه المختلفة الشامل للستائر والصالونات
والانتريهات والركنات والكراسي والفوتيهات
select*from `rates_tables` where `rates_tables`.`primary_user_id` in (642) andexists (select*from `users` where `rates_tables`.`secondary_user_id` = `users`.`id` and `app_type` like'%b2c%')
select `products`.*, (selectcount(*) from `users` innerjoin `product_user` on `users`.`id` = `product_user`.`user_id` where `products`.`id` = `product_user`.`product_id` and `app_type` like'%b2c%') as `coun_user_count` from `products` where `type` ='2'and `finest_products` isnotnulland `status` ='1'orderby `created_at` desc limit 5
selectexists(select*from `users` innerjoin `product_user` on `users`.`id` = `product_user`.`user_id` where `product_user`.`product_id` in (1174, 1175, 1176, 1177, 1178) and `user_id` isnulland `app_type` like'%b2c%') as `exists`
select `users`.*, `product_user`.`product_id` as `pivot_product_id`, `product_user`.`user_id` as `pivot_user_id`, `product_user`.`created_at` as `pivot_created_at`, `product_user`.`updated_at` as `pivot_updated_at` from `users` innerjoin `product_user` on `users`.`id` = `product_user`.`user_id` where `product_user`.`product_id` in (1174, 1175, 1176, 1177, 1178) and `user_id` isnulland `app_type` like'%b2c%'