Максим

SELECT DISTINCT events.id, events.name as event_name, events.date_start, events.date_end, events.country_id, events.description, events.day_1, events.day_2, events.month_1, events.month_2, events.year_1, events.year_2, events.is_present, links.links, images.images, countries.countries, countries.country_ids, country_to_cluster.year_start FROM events
    LEFT JOIN (SELECT countries.id, GROUP_CONCAT(countries.id) as country_ids,  event_to_country.country_id as country_id, event_to_country.event_id, GROUP_CONCAT(countries.name) as countries FROM countries LEFT JOIN event_to_country ON countries.id = country_id GROUP BY event_to_country.event_id) as countries ON events.id = countries.event_id
    LEFT JOIN (SELECT event_id, GROUP_CONCAT(link) as links FROM links GROUP BY event_id) AS links ON events.id = links.event_id
    LEFT JOIN (SELECT event_id, GROUP_CONCAT(name) as images FROM images GROUP BY event_id) AS images ON events.id = images.event_id
    LEFT JOIN keywords ON events.id = keywords.event_id
    LEFT JOIN country_to_cluster ON country_to_cluster.country_id = events.country_id AND events.year_1 >= coalesce(country_to_cluster.year_start,events.year_1) AND events.year_1 <= coalesce(country_to_cluster.year_end,events.year_1)
    WHERE (country_to_cluster.cluster_id = :cluster_id) 
    ORDER BY events.year_1 ASC
    LIMIT 30

select product_id
from products_comments
group by product_id
having max(case when comment_id in (1,2) then 1 else 9 end) = 1

select DATE_FORMAT( time_reports.date, '%W'), group_concat(employees.name, ' (', x.total_hours, ' hours)' order by x.total_hours desc SEPARATOR  ', '  LIMIT 3)

SELECT 
  wp_posts.ID, 
    wp_posts.post_title, 
    wc_product_meta_lookup.minPrice, 
    wc_product_meta_lookup.maxPrice 
FROM 
  wp_posts 
  LEFT JOIN (
    SELECT 
      product_id, 
      (min_price * GREATEST(1, coalesce(t2.meta_value*80,1), coalesce(t3.meta_value*80),1)) as minPrice, 
      (max_price * GREATEST(1, coalesce(t2.meta_value*80,1), coalesce(t3.meta_value*80),1)) as maxPrice 
    FROM 
            wp_wc_product_meta_lookup as t1 
            LEFT JOIN wp_postmeta as t2 ON t1.product_id = t2.post_id 
                AND t2.meta_key = 'convert_to_rub' 
                AND t2.meta_value = 1 
            JOIN wp_term_relationships tr ON (t1.product_id = tr.object_id AND tr.term_taxonomy_id IN ( 83, 85 ) )
            LEFT JOIN wp_termmeta as t3 ON tr.term_taxonomy_id = t3.term_id 
                AND t3.meta_key = 'convert_to_rub' 
                AND t3.meta_value = 1 

  ) wc_product_meta_lookup ON (
    wp_posts.ID = wc_product_meta_lookup.product_id
  ) 
WHERE 
  1 = 1 
  AND wp_posts.post_type = 'product' 
  AND wc_product_meta_lookup.minPrice > 0 
--GROUP BY wp_posts.ID 
ORDER BY wp_posts.post_name ASC

select p.*
from prices p,
(select currency_id, max(relevant_from) max_relevant_from
  from price 
  where relevant_from <= NOW()
   group by currency_id) p2
where p.currency_id = p2.currency_id and p.relevant_from = p2.max_relevant_from

select t1.*
from table t1
join (select nomer_zakaza, max(data_obnovleniya) max_DT, min(data_obnovleniya) min_DT
          from table
       group by nomer_zakaza) t2
on (t1.nomer_zakaza = t2.nomer_zakaza and t1.data_obnovleniya in (max_DT, min_DT))
order by t1.nomer_zakaza, t1.data_obnovleniya

select max(Strength) max_St, min(Strength) min_St
from table
, JSON_TABLE(concat('[',JSON_Col,']'),
    '$[*]'
    COLUMNS(
    NESTED PATH '$.Strength[*]' COLUMNS (Strength INT PATH '$') )
   ) as tt