Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- /*
- items - предметы, у которых есть rub - айди рубрики
- rubric - рубрика, у которой есть id и name
- Получаем рубрики, где есть предметы
- */
- SELECT rubric.name, rubric.id, COUNT(items.id) AS COUNT
- FROM (items
- INNER JOIN rubric ON books.rub = rubric.id)
- GROUP BY id
- HAVING COUNT(items.id) > 0;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement