CODE (SQL):
скопировать код в буфер обмена
скопировать код в буфер обмена
- SELECT
- g.id,
- g.name,
- g.func9,
- p.func,
- IF(g.func9 = 90, gv.id, p.id) AS id_product
- FROM groups AS g
- LEFT OUTER JOIN products AS p ON g.id = p.id_group
- LEFT OUTER JOIN groups_virt AS gv ON g.id = gv.id_group
- WHERE g.id=2000999999 AND p.func <> 9
- ORDER BY g.name