テキストテキストテキストテキストテキストテキストテキストテキストテキストテキストテキスト

select * from station_master
where `name` = (select name from station_master
where name_romaji = 'chikusenta-/_/footcare/seitai/aromatherapy/yoga/mimitsubo_soshin/shinkyuin/asiitsubo_reflexology/yoga/massage_shiatsu' group by prefecture)
and `prefecture` = (select prefecture from station_master
where name_romaji = 'chikusenta-/_/footcare/seitai/aromatherapy/yoga/mimitsubo_soshin/shinkyuin/asiitsubo_reflexology/yoga/massage_shiatsu' group by prefecture)
File = /virtual/shibataka/public_html/relam-b11design.honehone.org/class_common/area.inc
Line = 1103
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') then station1_distance when station2 IN () then station2_distance when sta...' at line 1 -- select *,case when station1 IN () then station1_distance when station2 IN () then station2_distance when station3 IN () then station3_distance end as distance from dog_shop_table_sy where (station1 IN () or station2 IN () or station3 IN ()) and `onoff` = 1 order by shop_price_plan desc,distance asc limit 0, 20