Портал ПРОФЕССИОНАЛОВ развития личности
category
articles
categories
current_page
obLevel
__env
app
errors
item
action
specialization
hotServices
hotCourses
banners
pagination
select * from `specializations` where `url` = 'yazyki' limit 1
SELECT *
LIMIT
ORDER BY
select count(*) as aggregate from `articles` inner join `article_specialization` on `articles`.`id` = `article_specialization`.`article_id` where `article_specialization`.`specialization_id` = '10' and `status` = '1'
select `articles`.*, `article_specialization`.`specialization_id` as `pivot_specialization_id`, `article_specialization`.`article_id` as `pivot_article_id` from `articles` inner join `article_specialization` on `articles`.`id` = `article_specialization`.`article_id` where `article_specialization`.`specialization_id` = '10' and `status` = '1' order by `id` desc limit 20 offset 0
select `specializations`.*, `article_specialization`.`article_id` as `pivot_article_id`, `article_specialization`.`specialization_id` as `pivot_specialization_id` from `specializations` inner join `article_specialization` on `specializations`.`id` = `article_specialization`.`specialization_id` where `article_specialization`.`article_id` in ('192', '191', '179', '111', '74', '58')
select * from `trainers` where `trainers`.`id` in ('390', '464', '374', '370')
select * from `specializations` where `active` = '1'
select * from `likes` where `likes`.`target_id` = '192' and `likes`.`target_id` is not null and `module` = 'article' and `target_id` = '192'
select * from `likes` where `likes`.`target_id` = '191' and `likes`.`target_id` is not null and `module` = 'article' and `target_id` = '191'
select * from `likes` where `likes`.`target_id` = '179' and `likes`.`target_id` is not null and `module` = 'article' and `target_id` = '179'
select * from `likes` where `likes`.`target_id` = '111' and `likes`.`target_id` is not null and `module` = 'article' and `target_id` = '111'
select * from `likes` where `likes`.`target_id` = '74' and `likes`.`target_id` is not null and `module` = 'article' and `target_id` = '74'
select * from `likes` where `likes`.`target_id` = '58' and `likes`.`target_id` is not null and `module` = 'article' and `target_id` = '58'
select * from `service_places` where (`end_date` >= '2025-04-05' or `end_date` is null and `start_date` <= '2025-04-05')
select * from `courses` where `status` = '2' and `disabled` = '0' and `hot` = '1' order by RAND() limit 1
ORDER BY RAND()
select * from `services` where `status` = 'hot' and `active` = '1' and ((select count(*) from `service_places` where `service_places`.`service_id` = `services`.`id`) = 0 or 0 = 1) order by `priority` asc, RAND() limit 5
select `trainers`.*, `service_trainer`.`service_id` as `pivot_service_id`, `service_trainer`.`trainer_id` as `pivot_trainer_id` from `trainers` inner join `service_trainer` on `trainers`.`id` = `service_trainer`.`trainer_id` where `service_trainer`.`service_id` in ('877', '258', '878', '834', '581')
select * from `service_places` where `service_places`.`service_id` in ('877', '258', '878', '834', '581') order by `start_date` asc
update `services` set `priority` = '0', `updated_at` = '2025-04-05'
update `services` set `priority` = `priority` + 1, `updated_at` = '2025-04-05' where `id` = '877'
update `services` set `priority` = `priority` + 1, `updated_at` = '2025-04-05' where `id` = '258'
update `services` set `priority` = `priority` + 1, `updated_at` = '2025-04-05' where `id` = '878'
update `services` set `priority` = `priority` + 1, `updated_at` = '2025-04-05' where `id` = '834'
update `services` set `priority` = `priority` + 1, `updated_at` = '2025-04-05' where `id` = '581'
