- ()
- ルックス
- 性格
- 趣味
- 感じるポイント
- タバコ
- 得意技
- チャームポイント
- 好みのタイプ
select distinct s.actress_time, a.actress_id, a.actress_name, a.actress_old, a.actress_height, a.actress_bast, a.homepage_ranking,s.syukkin_text, a.actress_waist, a.actress_hip, a.actress_new, a.actress_category, a.actress_s_image1, a.actress_thumb, a.regist_folder, a.actress_folder, a.actress_syuzai,a.actress_image1, r.regist_id, r.regist_type, r.regist_hp_title, r.station_name, r.regist_time, ar.area_name, t.tob_id, t.tob_name, t.tob_search_images from (select sk.*, cast(substr(sk.actress_time,1,2) as unsigned) as actress_time_start, cast(substr(sk.actress_time,7,2) as unsigned) as actress_time_end, substr(sk.actress_time,1,2) as actress_time_chk from syukkin sk ) s left join actress a on s.actress_id = a.actress_id left join registration r on a.regist_id = r.regist_id left join area ar on r.regist_area = ar.area_id left join typeofbusiness t on r.regist_type = t.tob_id where r.domain_id = '8' and r.regist_id ='10348' and r.display_flg = 1 and r.regist_paysite_flg = 1 and a.actress_id = order by a.actress_sort
[TEP STOP]