SELECT *
FROM `poll`
INNER JOIN poll_answer ON poll.id = poll_answer.poll_id
INNER JOIN poll_result ON poll_answer.id = poll_result.poll_answer_id
WHERE CURDATE() BETWEEN poll.date_begin AND poll.date_end
AND poll_result.vote_ip ="222"SELECT *
FROM `poll` as b
WHERE NOT EXISTS (SELECT poll.id
FROM `poll`
INNER JOIN poll_answer ON poll.id = poll_answer.poll_id
INNER JOIN poll_result ON poll_answer.id = poll_result.poll_answer_id
WHERE CURDATE() BETWEEN poll.date_begin AND poll.date_end
AND poll_result.vote_ip ="222"
AND b.id = poll.id)select distinct a.id, a.value, (case when a.id_pc is not null then b.value when a.id_monitor is not null then c.value when a.id_printer is not null then d.value else null end) inv_num
from task a left join pc b on (a.id_pc=b.id)
left join monitor c on (a.id_monitor=c.id)
left join printer d on (a.id_printer=d.id)select a.name
from mesta as a join mes_oso as b on (a.id = b.id_mesta)
join osobennosti as c on (b.id_os=c.id)
where c.name_os in ('wi_fi', 'coffee_to_go')
group by a.name
having count(*) = 2select distinct po.product_id,
(case when po.region_id in (1,2,3,4) then order_id else null end) as order_id,
(case when po.region_id in (1,2,3,4) then p.product_name else null end) as product_name,
(case when po.region_id in (1,2,3,4) then po.order_date else null end) as order_date,
region_id
from products_orders po
left join products p
on p.id = po.product_id
where
po.product_id = 100select a.*
from `article` as a
join `articleTag` AS aT ON(aT.articleID = a.id)
join `Tags` as t ON (aT.tagID = t.id)
where t.alias = <условие>Есть ли способ, чтобы не меняя связи сделать поиск не по tagID(в промежуточной таблице) а по alias? Или как-то конвертировать запросом выше из alias в id тега?
"SELECT * FROM `articleTag` AS aT LEFT JOIN `article` AS a ON(aT.articleID = a.id)
WHERE aT.tagID in (select aa.id from `Tags` as aa where aa.alias = <условие>)"SELECT resource.pagetitle, resource.uri, product.id, product.price, img.url AS thumb
FROM `ms2_products` AS product
JOIN `site_content` AS resource ON resource.id = product.id
LEFT JOIN `ms2_product_files` AS img ON img.product_id = product.id
WHERE img.path LIKE "%360x270%" AND img.rank=0
AND <добавить новое условие>
ORDER BY product.id DESC
LIMIT 12