Size: a a a
СК
SELECT i.*, t.name as tags_name
FROM items_tags it
LEFT JOIN items i ON i.id = it.items_id
LEFT JOIN tags t ON t.id = it.tags_id
WHERE it.tags_id IN (
SELECT tags_id
FROM items_tags
WHERE items_id = "${addslashes($id)}"
)
AND i.state = 1
AND t.state = 1
Д
SELECT i.*, t.name as tags_name
FROM items_tags it
LEFT JOIN items i ON i.id = it.items_id
LEFT JOIN tags t ON t.id = it.tags_id
WHERE it.tags_id IN (
SELECT tags_id
FROM items_tags
WHERE items_id = "${addslashes($id)}"
)
AND i.state = 1
AND t.state = 1
ВК
ВК
ВК
СР
SELECT i.*, t.name as tags_name
FROM items_tags it
LEFT JOIN items i ON i.id = it.items_id
LEFT JOIN tags t ON t.id = it.tags_id
WHERE it.tags_id IN (
SELECT tags_id
FROM items_tags
WHERE items_id = "${addslashes($id)}"
)
AND i.state = 1
AND t.state = 1
СК
WHERE EXISTS(
SELECT tags_id
FROM items_tags
WHERE it.tags_id = tags_id AND items_id = "${addslashes($id)}"
)
СР
СР
WHERE EXISTS(
SELECT tags_id
FROM items_tags
WHERE it.tags_id = tags_id AND items_id = "${addslashes($id)}"
)
СК
СК
СР
Д
WHERE EXISTS(
SELECT tags_id
FROM items_tags
WHERE it.tags_id = tags_id AND items_id = "${addslashes($id)}"
)
СК
Д
SELECT i.*, t.name as tags_name
FROM items_tags it
LEFT JOIN items i ON i.id = it.items_id
LEFT JOIN tags t ON t.id = it.tags_id
WHERE it.tags_id IN (
SELECT tags_id
FROM items_tags
WHERE items_id = "${addslashes($id)}"
)
AND i.state = 1
AND t.state = 1Д
SELECT tags_id
FROM items_tags
WHERE items_id = "${addslashes($id)}"
ПервыйД
SELECT i.*, t.name as tags_name
FROM items_tags it
LEFT JOIN items i ON i.id = it.items_id
LEFT JOIN tags t ON t.id = it.tags_id
WHERE it.tags_id IN (.....)
AND i.state = 1
AND t.state = 1СК
SELECT i.*, t.name as tags_name
FROM tags t
WHERE EXISTS (
SELECT tags_id
FROM items_tags
WHERE tags_id = t.id
)
AND t.state = 1
AD
СР