- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
SELECT * FROM l_table AS bl
LEFT JOIN t_table AS bt
ON (bl.ID = bt.ID)
WHERE DZ IN
(
SELECT LEFT(GROUP_CONCAT(DZ ORDER BY DZ DESC), 19)
FROM l_table GROUP BY UID
)
GROUP BY UID
ORDER BY DZ DESC
;
Комментарии (3) RSS