Дмитрий

$query = $this->db->query("SELECT * FROM " . DB_PREFIX . "product WHERE option_id = '1010' or option_id = '10102'")

$query = $this->db->query("SELECT * FROM " . DB_PREFIX . "product WHERE option_id in ('1010', '10102')")

service = Service::select('id', 'name')->with(['users' => function ($query) {
$query->select('users.id', 'lastName', 'firstName')
}, ‘users.schedule’])->where('services.slug', $slug)->first();

select 
  departments.id, 
  departments.department, 
  count(*) as count 
from departments 
join employees on employees.department_id = departments.id 
group by departments.id, departments.name;

select 
  departments.id, 
  departments.department, 
  count(*) as count 
from departments 
left join employees on employees.department_id = departments.id 
group by departments.id, departments.name;

SELECT 
`user_id`, `username`, `first_name`,`last_name`, `title` 
FROM `userdata` 
WHERE `type` = 'supergroup' OR `type` = 'group'

SELECT 
`user_id`, `username`, `first_name`,`last_name`, `title` 
FROM `userdata` 
WHERE `type` IN ('supergroup', 'group');

select not exists( select 1 from test where "2022-01-03 09:00:00" between date_start and date_end);

SELECT materials.id,
       materials.title,
       materials.author,
       materials.description,
       types.name      AS type,
       categories.name AS category
FROM materials
         LEFT JOIN categories
                   ON materials.id_category = categories.id
         LEFT JOIN types
                   ON materials.id_type = types.id
         LEFT JOIN tags_to_materials
                   ON materials.id = tags_to_materials.material_id
         LEFT JOIN tags
                   ON tags.id = tags_to_materials.tag_id
WHERE materials.author LIKE '$str%'
   OR materials.title LIKE '$str%'
   OR categories.name LIKE '$str%'
   OR tags.name LIKE '$str%'

select materials.id,
       materials.title,
       materials.author,
       materials.description,
       types.name      AS type,
       categories.name AS category
FROM materials
         LEFT JOIN categories
                   ON materials.id_category = categories.id
         LEFT JOIN types
                   ON materials.id_type = types.id
         LEFT JOIN tags_to_materials
                   ON materials.id = tags_to_materials.material_id
         LEFT JOIN tags
                   ON tags.id = tags_to_materials.tag_id
where materials.id in (
    SELECT materials.id
    FROM materials
             LEFT JOIN categories
                       ON materials.id_category = categories.id
             LEFT JOIN types
                       ON materials.id_type = types.id
             LEFT JOIN tags_to_materials
                       ON materials.id = tags_to_materials.material_id
             LEFT JOIN tags
                       ON tags.id = tags_to_materials.tag_id
    WHERE materials.author LIKE '$str%'
       OR materials.title LIKE '$str%'
       OR categories.name LIKE '$str%'
       OR tags.name LIKE '$str%' group by materials.id);

SELECT user.*
FROM user
         join
     (
         SELECT name, profession, city
         FROM user
         GROUP BY name, profession, city
         HAVING COUNT(*) > 1
     ) as groupped on 
           groupped.name = user.name and COALESCE(groupped.profession = user.profession, 1) and COALESCE(groupped.city = user.city, 1)
ORDER BY name;

select 
category_contact.contact_id, 
LAST_VALUE(category_contact.category_id) over(order by total_points) as category_id
from category_contact
group by category_contact.contact_id;

select 
category_contact.contact_id, 
substring_index(group_concat(category_contact.category_id order by total_points desc), ',', 1)
from category_contact
group by category_contact.contact_id