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` =57535
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 (57535)
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 (57535)
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 (57535)
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 (57535)
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 (57535)
select `categories`.`id` from `categories` innerjoin `company_categories_keywords` on `categories`.`id` = `company_categories_keywords`.`category_id` where `company_categories_keywords`.`company_id` =57535
selectcount(*) as aggregate from `companies` leftjoin `company_stars` as `st` on `st`.`company_id` = `companies`.`id` where `companies`.`id` !=57535andexists (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 (451, 451, 451, 1009, 1009, 1009, 1009, 1009, 1009, 1009, 1009, 1009, 1009, 1009, 1009, 1009)) 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` !=57535andexists (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 (451, 451, 451, 1009, 1009, 1009, 1009, 1009, 1009, 1009, 1009, 1009, 1009, 1009, 1009, 1009)) and `active` =1orderby `st`.`star` asc, `st`.`number` desc, `st`.`updated_at` desc limit 10offset410
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 (18015, 18150, 18282, 18345, 18535, 19535, 19578, 20316, 20984, 22106)
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 (18015, 18150, 18282, 18345, 18535, 19535, 19578, 20316, 20984, 22106)