luna3956

select *
from posts p
left join (
  select post_id
  from actions a
  where
      a.user_id = 8 and
      a.action_type = 1
) a on
    a.post_id = p.id
where
    p.author_id = 8 or
    a.post_id is not null

select 
  p.id,
  (CASE WHEN t1.num = 0 THEN 'no' ELSE 'yes' END) as 'match_res' 
from product p
inner join (
  SELECT product_id, COUNT(product_detail_id) as num
  FROM products_details 
  WHERE 
    product_detail_type_id IN (1, 4, 123)
  group by product_id
) t1 on
  t1.product_id = p.id

`post_id`=73 AND (`meta_key`='_regular_price' OR `meta_key`='_sale_price')

select
      c.cname, o.amt
  from Orders o
  inner join Customers c on
      c.cnum = o.cnum
  where
      amt = (select max(amt) from Orders)

select
    id, count(sex) as cnt
from Tab
where room=2 and sex=2
group by id
having count(sex) <= 6

select id
from Table1
where
    "2019-02-16" between start and final or
    "2019-02-18 " between start and final

select id
from Table1
where
    start <= "2019-02-18 and final >= "2019-02-16"

select
    a.branches_id,
    a.surveys_id,
    b.name as branches_name,
    s.name as surveys_name
from answers a
left join branches b on
    b.id = a.branches_id
left join surveys s on
    s.id = a.surveys_id