select * from station_master
where `name` = (select name from station_master
where name_romaji = 'oshiage' group by prefecture)
and `prefecture` = (select prefecture from station_master
where name_romaji = 'oshiage' group by prefecture)
File = /virtual/shibataka/public_html/relam-b11design.honehone.org/class_common/area.inc
Line = 1103

select *,case
when station1 IN (2930,3178,3388,3588) then station1_distance
when station2 IN (2930,3178,3388,3588) then station2_distance
when station3 IN (2930,3178,3388,3588) then station3_distance
end as distance from dog_shop_table_sy
where (station1 IN ('2930','3178','3388','3588') or station2 IN ('2930','3178','3388','3588') or station3 IN ('2930','3178','3388','3588'))
and `onoff` = 1
and case
when station1 IN (2930,3178,3388,3588) then station1_distance < 1000
when station2 IN (2930,3178,3388,3588) then station2_distance < 1000
when station3 IN (2930,3178,3388,3588) then station3_distance < 1000
end
order by shop_price_plan desc,distance asc limit 0, 20
File = /virtual/shibataka/public_html/relam-b11design.honehone.org/class_common/area.inc
Line = 1150