SELECT t.*, f.dt_fuken , c.dt_city, d.dt_district, pv.view_cnt, stn.station_name FROM m_tenpo t
LEFT JOIN m_fuken f ON t.cd_fuken = f.cd_fuken
LEFT JOIN m_city c ON t.cd_fuken = c.cd_fuken AND t.cd_city = c.cd_city
LEFT JOIN m_district d ON t.cd_fuken = d.cd_fuken AND t.cd_city = d.cd_city AND t.cd_district = d.cd_district
LEFT JOIN station stn ON t.station_cd1 = stn.station_cd
LEFT JOIN (SELECT * FROM jan39_pv WHERE year = '2025' AND month = '08') pv ON t.cd_tenpo = pv.cd_tenpo
WHERE
(
1=1
AND ( t.cd_fuken = '12' AND t.cd_city = '001' AND t.cd_district = '19' )
AND (dt_people LIKE '%4%')
) AND
t.fg_sakujyo='0' AND
t.fg_search_show='0' AND
t.is_close='0' AND
t.dt_lat != 0 AND t.dt_lat IS NOT NULL AND
t.dt_lng != 0 AND t.dt_lng IS NOT NULL AND
(t.fg_service = 2 OR t.fg_service = 3 OR t.fg_service = 4)
ORDER BY view_cnt DESC