1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
| -- 코드를 입력하세요
-- SELECT concat('/home/grep/src/',f.board_id,'/',f.file_id, f.file_name, f.file_ext) as file_path
-- from used_goods_file f
-- join used_goods_board b
-- on f.board_id = b.board_id
-- where b.views=(
-- select max(views)
-- from used_goods_board b1) -- where에 max함수를 쓸 수 없어서 서브쿼리로 우회
-- order by f.file_id desc
select concat('/home/grep/src/', f.board_id, '/', f.file_id, f.file_name, f.file_ext) as file_path
from used_goods_file f
join
(
select board_id, max(views)
from used_goods_board
group by board_id
order by max(views) desc
limit 1
)mv
on mv.board_id=f.board_id
order by f.file_id desc
|
