select `plans`.*, `company_plan`.`company_id` as `pivot_company_id`, `company_plan`.`plan_id` as `pivot_plan_id`, `company_plan`.`expire_at` as `pivot_expire_at` from `plans` innerjoin `company_plan` on `plans`.`id` = `company_plan`.`plan_id` where `company_plan`.`company_id` =98442
select `categories`.*, `company_categories_keywords`.`company_id` as `pivot_company_id`, `company_categories_keywords`.`category_id` as `pivot_category_id`, `company_categories_keywords`.`keyword_id` as `pivot_keyword_id`, `company_categories_keywords`.`main_category_id` as `pivot_main_category_id` from `categories` innerjoin `company_categories_keywords` on `categories`.`id` = `company_categories_keywords`.`category_id` where `company_categories_keywords`.`company_id` in (98442)
selectdistinct `keywords`.*, `company_categories_keywords`.`company_id` as `pivot_company_id`, `company_categories_keywords`.`keyword_id` as `pivot_keyword_id`, `company_categories_keywords`.`main_category_id` as `pivot_main_category_id`, `company_categories_keywords`.`category_id` as `pivot_category_id` from `keywords` innerjoin `company_categories_keywords` on `keywords`.`id` = `company_categories_keywords`.`keyword_id` where `company_categories_keywords`.`company_id` in (98442)
selectdistinct `categories`.*, `company_categories_keywords`.`company_id` as `pivot_company_id`, `company_categories_keywords`.`category_id` as `pivot_category_id` from `categories` innerjoin `company_categories_keywords` on `categories`.`id` = `company_categories_keywords`.`category_id` where `company_categories_keywords`.`company_id` in (98442)
selectdistinct `categories`.*, `company_categories_keywords`.`keyword_id` as `pivot_keyword_id`, `company_categories_keywords`.`category_id` as `pivot_category_id`, `company_categories_keywords`.`main_category_id` as `pivot_main_category_id` from `categories` innerjoin `company_categories_keywords` on `categories`.`id` = `company_categories_keywords`.`category_id` where `company_categories_keywords`.`keyword_id` in (3642, 3643, 3653, 3654, 3656, 3657, 3658, 3659, 7072, 7073, 8856)
selectdistinct `categories`.*, `company_categories_keywords`.`keyword_id` as `pivot_keyword_id`, `company_categories_keywords`.`main_category_id` as `pivot_main_category_id` from `categories` innerjoin `company_categories_keywords` on `categories`.`id` = `company_categories_keywords`.`main_category_id` where `company_categories_keywords`.`keyword_id` in (3642, 3643, 3653, 3654, 3656, 3657, 3658, 3659, 7072, 7073, 8856)
selectdistinct `keywords`.*, `company_categories_keywords`.`company_id` as `pivot_company_id`, `company_categories_keywords`.`keyword_id` as `pivot_keyword_id`, `company_categories_keywords`.`main_category_id` as `pivot_main_category_id`, `company_categories_keywords`.`category_id` as `pivot_category_id` from `keywords` innerjoin `company_categories_keywords` on `keywords`.`id` = `company_categories_keywords`.`keyword_id` where `company_categories_keywords`.`company_id` in (98442)
select `categories`.*, `company_categories_keywords`.`company_id` as `pivot_company_id`, `company_categories_keywords`.`category_id` as `pivot_category_id`, `company_categories_keywords`.`keyword_id` as `pivot_keyword_id`, `company_categories_keywords`.`main_category_id` as `pivot_main_category_id` from `categories` innerjoin `company_categories_keywords` on `categories`.`id` = `company_categories_keywords`.`category_id` where `company_categories_keywords`.`company_id` in (98442)
select `categories`.`id` from `categories` innerjoin `company_categories_keywords` on `categories`.`id` = `company_categories_keywords`.`category_id` where `company_categories_keywords`.`company_id` =98442
selectcount(*) as aggregate from `companies` leftjoin `company_stars` as `st` on `st`.`company_id` = `companies`.`id` where `companies`.`id` !=98442andexists (select*from `categories` innerjoin `company_categories_keywords` on `categories`.`id` = `company_categories_keywords`.`category_id` where `companies`.`id` = `company_categories_keywords`.`company_id` and `id` in (745, 745, 745, 745, 745, 745, 745, 745, 745, 745, 745)) and `active` =1
select `st`.`star` as `star`, `st`.`number` as `number`, `companies`.*, (selectcount(*) from `media` where `companies`.`id` = `media`.`model_id` and `media`.`model_type` ='App\Models\Company') as `media_count` from `companies` leftjoin `company_stars` as `st` on `st`.`company_id` = `companies`.`id` where `companies`.`id` !=98442andexists (select*from `categories` innerjoin `company_categories_keywords` on `categories`.`id` = `company_categories_keywords`.`category_id` where `companies`.`id` = `company_categories_keywords`.`company_id` and `id` in (745, 745, 745, 745, 745, 745, 745, 745, 745, 745, 745)) and `active` =1orderby `st`.`star` asc, `st`.`number` desc, `st`.`updated_at` desc limit 10offset0
select `categories`.*, `company_categories_keywords`.`company_id` as `pivot_company_id`, `company_categories_keywords`.`category_id` as `pivot_category_id`, `company_categories_keywords`.`keyword_id` as `pivot_keyword_id`, `company_categories_keywords`.`main_category_id` as `pivot_main_category_id` from `categories` innerjoin `company_categories_keywords` on `categories`.`id` = `company_categories_keywords`.`category_id` where `company_categories_keywords`.`company_id` in (111241, 111481, 112340, 115298, 117573, 176900, 197721, 198921, 209212, 215014)
selectdistinct `categories`.*, `company_categories_keywords`.`company_id` as `pivot_company_id`, `company_categories_keywords`.`category_id` as `pivot_category_id` from `categories` innerjoin `company_categories_keywords` on `categories`.`id` = `company_categories_keywords`.`category_id` where `company_categories_keywords`.`company_id` in (111241, 111481, 112340, 115298, 117573, 176900, 197721, 198921, 209212, 215014)