イヤサレは、風俗エステ・メンズエステ情報が満載のサイトです。

お店を探す

エリアから探す

新宿・池袋エリア

上野・神田エリア

東京・銀座エリア

目黒・品川エリア

渋谷・下北エリア

西東京エリア

神奈川エリア

埼玉エリア

千葉エリア

北関東エリア

こだわりから探す

(default) 203 queries took 5 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (555028) ORDER BY `Girl`.`pos` ASC LIMIT 2220
2SELECT `Shop`.`id`, `Shop`.`shopname`, `Shop`.`image_sbanner_pc` FROM `iyasare`.`shops` AS `Shop` LEFT JOIN `iyasare`.`areas` AS `Area` ON (`Shop`.`area_id` = `Area`.`id`) WHERE `Shop`.`view` = '1' AND `Shop`.`delflag` = '0' AND `Shop`.`rank` IN (1, 2) AND NOT (`Shop`.`image_sbanner_pc` = '') ORDER BY RAND() ASC LIMIT 10551
3SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (555029) ORDER BY `Girl`.`pos` ASC LIMIT 2220
4SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (555019) ORDER BY `Girl`.`pos` ASC LIMIT 2220
5SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (555006) ORDER BY `Girl`.`pos` ASC LIMIT 2220
6SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (555016) ORDER BY `Girl`.`pos` ASC LIMIT 2220
7SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (555020) ORDER BY `Girl`.`pos` ASC LIMIT 2220
8SELECT `Area`.`id`, `Area`.`name`, `Area`.`area1` FROM `iyasare`.`areas` AS `Area` WHERE 1 = 1 ORDER BY `Area`.`view` ASC32320
9SELECT `Kodawari`.`id`, `Kodawari`.`name` FROM `iyasare`.`kodawaris` AS `Kodawari` WHERE 1 = 1 ORDER BY `Kodawari`.`view` ASC18180
10SELECT `Shop`.`id`, `Shop`.`rank`, `Shop`.`shopname`, `Shop`.`open24`, `Shop`.`open_hour`, `Shop`.`open_minute`, `Shop`.`close_hour`, `Shop`.`close_minute` FROM `iyasare`.`shops` AS `Shop` LEFT JOIN `iyasare`.`areas` AS `Area` ON (`Shop`.`area_id` = `Area`.`id`) WHERE `Shop`.`view` = '1' AND `Shop`.`delflag` = '0' AND (NOT (`Shop`.`open_hour` IS NULL) AND NOT (`Shop`.`close_hour` IS NULL))1621620
11SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (66024) ORDER BY `Girl`.`pos` ASC LIMIT 2220
12SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (555003) ORDER BY `Girl`.`pos` ASC LIMIT 2220
13SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (555004) ORDER BY `Girl`.`pos` ASC LIMIT 2220
14SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (555006) ORDER BY `Girl`.`pos` ASC LIMIT 2220
15SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (555007) ORDER BY `Girl`.`pos` ASC LIMIT 2220
16SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (555008) ORDER BY `Girl`.`pos` ASC LIMIT 2220
17SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (555009) ORDER BY `Girl`.`pos` ASC LIMIT 2220
18SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (555010) ORDER BY `Girl`.`pos` ASC LIMIT 2220
19SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (555012) ORDER BY `Girl`.`pos` ASC LIMIT 2220
20SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (555013) ORDER BY `Girl`.`pos` ASC LIMIT 2220
21SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (555014) ORDER BY `Girl`.`pos` ASC LIMIT 2220
22SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (555015) ORDER BY `Girl`.`pos` ASC LIMIT 2220
23SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (555016) ORDER BY `Girl`.`pos` ASC LIMIT 2220
24SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (555017) ORDER BY `Girl`.`pos` ASC LIMIT 2220
25SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (555018) ORDER BY `Girl`.`pos` ASC LIMIT 2220
26SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (555019) ORDER BY `Girl`.`pos` ASC LIMIT 2220
27SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (555020) ORDER BY `Girl`.`pos` ASC LIMIT 2220
28SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (555021) ORDER BY `Girl`.`pos` ASC LIMIT 2220
29SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (555022) ORDER BY `Girl`.`pos` ASC LIMIT 2220
30SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (555023) ORDER BY `Girl`.`pos` ASC LIMIT 2220
31SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (555024) ORDER BY `Girl`.`pos` ASC LIMIT 2220
32SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (555025) ORDER BY `Girl`.`pos` ASC LIMIT 2220
33SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (555026) ORDER BY `Girl`.`pos` ASC LIMIT 2220
34SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (555027) ORDER BY `Girl`.`pos` ASC LIMIT 2220
35SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (555028) ORDER BY `Girl`.`pos` ASC LIMIT 2220
36SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (555029) ORDER BY `Girl`.`pos` ASC LIMIT 2220
37SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (555030) ORDER BY `Girl`.`pos` ASC LIMIT 2220
38SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (555031) ORDER BY `Girl`.`pos` ASC LIMIT 2220
39SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (555032) ORDER BY `Girl`.`pos` ASC LIMIT 2220
40SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (555033) ORDER BY `Girl`.`pos` ASC LIMIT 2220
41SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (555034) ORDER BY `Girl`.`pos` ASC LIMIT 2220
42SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660001) ORDER BY `Girl`.`pos` ASC LIMIT 2220
43SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660002) ORDER BY `Girl`.`pos` ASC LIMIT 2220
44SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660003) ORDER BY `Girl`.`pos` ASC LIMIT 2220
45SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660004) ORDER BY `Girl`.`pos` ASC LIMIT 2220
46SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660005) ORDER BY `Girl`.`pos` ASC LIMIT 2220
47SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660006) ORDER BY `Girl`.`pos` ASC LIMIT 2220
48SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660009) ORDER BY `Girl`.`pos` ASC LIMIT 2220
49SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660010) ORDER BY `Girl`.`pos` ASC LIMIT 2220
50SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660011) ORDER BY `Girl`.`pos` ASC LIMIT 2220
51SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660012) ORDER BY `Girl`.`pos` ASC LIMIT 2220
52SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660013) ORDER BY `Girl`.`pos` ASC LIMIT 2220
53SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660014) ORDER BY `Girl`.`pos` ASC LIMIT 2220
54SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660017) ORDER BY `Girl`.`pos` ASC LIMIT 2220
55SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660018) ORDER BY `Girl`.`pos` ASC LIMIT 2220
56SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660019) ORDER BY `Girl`.`pos` ASC LIMIT 2220
57SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660020) ORDER BY `Girl`.`pos` ASC LIMIT 2220
58SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660021) ORDER BY `Girl`.`pos` ASC LIMIT 2220
59SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660025) ORDER BY `Girl`.`pos` ASC LIMIT 2220
60SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660027) ORDER BY `Girl`.`pos` ASC LIMIT 2220
61SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660029) ORDER BY `Girl`.`pos` ASC LIMIT 2220
62SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660031) ORDER BY `Girl`.`pos` ASC LIMIT 2220
63SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660032) ORDER BY `Girl`.`pos` ASC LIMIT 2220
64SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660033) ORDER BY `Girl`.`pos` ASC LIMIT 2220
65SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660034) ORDER BY `Girl`.`pos` ASC LIMIT 2220
66SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660035) ORDER BY `Girl`.`pos` ASC LIMIT 2220
67SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660036) ORDER BY `Girl`.`pos` ASC LIMIT 2220
68SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660037) ORDER BY `Girl`.`pos` ASC LIMIT 2220
69SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660038) ORDER BY `Girl`.`pos` ASC LIMIT 2220
70SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660041) ORDER BY `Girl`.`pos` ASC LIMIT 2220
71SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660042) ORDER BY `Girl`.`pos` ASC LIMIT 2220
72SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660043) ORDER BY `Girl`.`pos` ASC LIMIT 2220
73SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660044) ORDER BY `Girl`.`pos` ASC LIMIT 2220
74SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660045) ORDER BY `Girl`.`pos` ASC LIMIT 2220
75SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660046) ORDER BY `Girl`.`pos` ASC LIMIT 2220
76SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660047) ORDER BY `Girl`.`pos` ASC LIMIT 2220
77SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660048) ORDER BY `Girl`.`pos` ASC LIMIT 2220
78SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660049) ORDER BY `Girl`.`pos` ASC LIMIT 2220
79SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660050) ORDER BY `Girl`.`pos` ASC LIMIT 2220
80SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660051) ORDER BY `Girl`.`pos` ASC LIMIT 2220
81SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660052) ORDER BY `Girl`.`pos` ASC LIMIT 2220
82SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660053) ORDER BY `Girl`.`pos` ASC LIMIT 2220
83SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660056) ORDER BY `Girl`.`pos` ASC LIMIT 2220
84SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660057) ORDER BY `Girl`.`pos` ASC LIMIT 2220
85SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660058) ORDER BY `Girl`.`pos` ASC LIMIT 2220
86SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660059) ORDER BY `Girl`.`pos` ASC LIMIT 2220
87SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660060) ORDER BY `Girl`.`pos` ASC LIMIT 2220
88SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660061) ORDER BY `Girl`.`pos` ASC LIMIT 2220
89SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660062) ORDER BY `Girl`.`pos` ASC LIMIT 2220
90SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660063) ORDER BY `Girl`.`pos` ASC LIMIT 2220
91SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660066) ORDER BY `Girl`.`pos` ASC LIMIT 2220
92SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660068) ORDER BY `Girl`.`pos` ASC LIMIT 2220
93SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660069) ORDER BY `Girl`.`pos` ASC LIMIT 2220
94SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660070) ORDER BY `Girl`.`pos` ASC LIMIT 2220
95SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660071) ORDER BY `Girl`.`pos` ASC LIMIT 2220
96SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660072) ORDER BY `Girl`.`pos` ASC LIMIT 2220
97SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660075) ORDER BY `Girl`.`pos` ASC LIMIT 2220
98SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660076) ORDER BY `Girl`.`pos` ASC LIMIT 2220
99SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660077) ORDER BY `Girl`.`pos` ASC LIMIT 2220
100SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660078) ORDER BY `Girl`.`pos` ASC LIMIT 2220
101SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660079) ORDER BY `Girl`.`pos` ASC LIMIT 2220
102SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660080) ORDER BY `Girl`.`pos` ASC LIMIT 2220
103SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660083) ORDER BY `Girl`.`pos` ASC LIMIT 2220
104SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660084) ORDER BY `Girl`.`pos` ASC LIMIT 2220
105SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660085) ORDER BY `Girl`.`pos` ASC LIMIT 2220
106SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660086) ORDER BY `Girl`.`pos` ASC LIMIT 2220
107SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660087) ORDER BY `Girl`.`pos` ASC LIMIT 2220
108SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660088) ORDER BY `Girl`.`pos` ASC LIMIT 2220
109SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660089) ORDER BY `Girl`.`pos` ASC LIMIT 2220
110SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660090) ORDER BY `Girl`.`pos` ASC LIMIT 2220
111SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660093) ORDER BY `Girl`.`pos` ASC LIMIT 2220
112SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660094) ORDER BY `Girl`.`pos` ASC LIMIT 2220
113SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660095) ORDER BY `Girl`.`pos` ASC LIMIT 2220
114SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660096) ORDER BY `Girl`.`pos` ASC LIMIT 2220
115SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660097) ORDER BY `Girl`.`pos` ASC LIMIT 2220
116SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660098) ORDER BY `Girl`.`pos` ASC LIMIT 2220
117SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660099) ORDER BY `Girl`.`pos` ASC LIMIT 2220
118SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660102) ORDER BY `Girl`.`pos` ASC LIMIT 2220
119SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660103) ORDER BY `Girl`.`pos` ASC LIMIT 2220
120SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660104) ORDER BY `Girl`.`pos` ASC LIMIT 2220
121SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660106) ORDER BY `Girl`.`pos` ASC LIMIT 2220
122SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660107) ORDER BY `Girl`.`pos` ASC LIMIT 2220
123SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660108) ORDER BY `Girl`.`pos` ASC LIMIT 2220
124SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660111) ORDER BY `Girl`.`pos` ASC LIMIT 2220
125SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660112) ORDER BY `Girl`.`pos` ASC LIMIT 2220
126SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660113) ORDER BY `Girl`.`pos` ASC LIMIT 2220
127SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660115) ORDER BY `Girl`.`pos` ASC LIMIT 2220
128SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660116) ORDER BY `Girl`.`pos` ASC LIMIT 2220
129SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660117) ORDER BY `Girl`.`pos` ASC LIMIT 2220
130SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660120) ORDER BY `Girl`.`pos` ASC LIMIT 2220
131SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660121) ORDER BY `Girl`.`pos` ASC LIMIT 2220
132SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660122) ORDER BY `Girl`.`pos` ASC LIMIT 2220
133SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660123) ORDER BY `Girl`.`pos` ASC LIMIT 2220
134SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660124) ORDER BY `Girl`.`pos` ASC LIMIT 2220
135SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660125) ORDER BY `Girl`.`pos` ASC LIMIT 2220
136SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660126) ORDER BY `Girl`.`pos` ASC LIMIT 2220
137SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660128) ORDER BY `Girl`.`pos` ASC LIMIT 2220
138SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660130) ORDER BY `Girl`.`pos` ASC LIMIT 2220
139SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660131) ORDER BY `Girl`.`pos` ASC LIMIT 2220
140SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660132) ORDER BY `Girl`.`pos` ASC LIMIT 2220
141SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660133) ORDER BY `Girl`.`pos` ASC LIMIT 2220
142SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660134) ORDER BY `Girl`.`pos` ASC LIMIT 2220
143SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660135) ORDER BY `Girl`.`pos` ASC LIMIT 2220
144SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660136) ORDER BY `Girl`.`pos` ASC LIMIT 2220
145SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660138) ORDER BY `Girl`.`pos` ASC LIMIT 2220
146SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660139) ORDER BY `Girl`.`pos` ASC LIMIT 2220
147SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660140) ORDER BY `Girl`.`pos` ASC LIMIT 2220
148SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660143) ORDER BY `Girl`.`pos` ASC LIMIT 2220
149SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660144) ORDER BY `Girl`.`pos` ASC LIMIT 2220
150SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660152) ORDER BY `Girl`.`pos` ASC LIMIT 2220
151SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660153) ORDER BY `Girl`.`pos` ASC LIMIT 2220
152SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660156) ORDER BY `Girl`.`pos` ASC LIMIT 2220
153SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660157) ORDER BY `Girl`.`pos` ASC LIMIT 2220
154SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660158) ORDER BY `Girl`.`pos` ASC LIMIT 2220
155SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660164) ORDER BY `Girl`.`pos` ASC LIMIT 2220
156SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660165) ORDER BY `Girl`.`pos` ASC LIMIT 2220
157SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660166) ORDER BY `Girl`.`pos` ASC LIMIT 2220
158SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660175) ORDER BY `Girl`.`pos` ASC LIMIT 2220
159SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660181) ORDER BY `Girl`.`pos` ASC LIMIT 2220
160SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660189) ORDER BY `Girl`.`pos` ASC LIMIT 2220
161SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660194) ORDER BY `Girl`.`pos` ASC LIMIT 2220
162SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660195) ORDER BY `Girl`.`pos` ASC LIMIT 2220
163SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660196) ORDER BY `Girl`.`pos` ASC LIMIT 2220
164SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660204) ORDER BY `Girl`.`pos` ASC LIMIT 2220
165SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660205) ORDER BY `Girl`.`pos` ASC LIMIT 2220
166SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660206) ORDER BY `Girl`.`pos` ASC LIMIT 2220
167SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660207) ORDER BY `Girl`.`pos` ASC LIMIT 2220
168SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660208) ORDER BY `Girl`.`pos` ASC LIMIT 2220
169SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660209) ORDER BY `Girl`.`pos` ASC LIMIT 2220
170SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660217) ORDER BY `Girl`.`pos` ASC LIMIT 2220
171SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660224) ORDER BY `Girl`.`pos` ASC LIMIT 2220
172SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660225) ORDER BY `Girl`.`pos` ASC LIMIT 2220
173SELECT `Girl`.`id`, `Girl`.`shop_id`, `Girl`.`name`, `Girl`.`profile_image` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` IN (66024, 555003, 555004, 555006, 555007, 555008, 555009, 555010, 555012, 555013, 555014, 555015, 555016, 555017, 555018, 555019, 555020, 555021, 555022, 555023, 555024, 555025, 555026, 555027, 555028, 555029, 555030, 555031, 555032, 555033, 555034, 660001, 660002, 660003, 660004, 660005, 660006, 660009, 660010, 660011, 660012, 660013, 660014, 660017, 660018, 660019, 660020, 660021, 660025, 660027, 660029, 660031, 660032, 660033, 660034, 660035, 660036, 660037, 660038, 660041, 660042, 660043, 660044, 660045, 660046, 660047, 660048, 660049, 660050, 660051, 660052, 660053, 660056, 660057, 660058, 660059, 660060, 660061, 660062, 660063, 660066, 660068, 660069, 660070, 660071, 660072, 660075, 660076, 660077, 660078, 660079, 660080, 660083, 660084, 660085, 660086, 660087, 660088, 660089, 660090, 660093, 660094, 660095, 660096, 660097, 660098, 660099, 660102, 660103, 660104, 660106, 660107, 660108, 660111, 660112, 660113, 660115, 660116, 660117, 660120, 660121, 660122, 660123, 660124, 660125, 660126, 660128, 660130, 660131, 660132, 660133, 660134, 660135, 660136, 660138, 660139, 660140, 660143, 660144, 660152, 660153, 660156, 660157, 660158, 660164, 660165, 660166, 660175, 660181, 660189, 660194, 660195, 660196, 660204, 660205, 660206, 660207, 660208, 660209, 660217, 660224, 660225) AND `Girl`.`view` = '1' ORDER BY `Girl`.`pos` ASC4874870
174SELECT `Plan`.`id`, `Plan`.`rank_1` FROM `iyasare`.`plans` AS `Plan` WHERE 1 = 1550
175SELECT `Girl`.`id`, `Girl`.`shop_id`, `Girl`.`name`, `Girl`.`profile_image` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` IN (66024, 555023, 660035, 660048, 660063, 660069, 660078, 660083, 660128, 660181, 660217) AND `Girl`.`view` = '1' ORDER BY `Girl`.`pos` ASC33331
176SELECT `Realtime`.`id`, `Realtime`.`shop_id`, `Realtime`.`body`, `Realtime`.`modified`, `Shop`.`id`, `Shop`.`shopname` FROM `iyasare`.`realtimes` AS `Realtime` LEFT JOIN `iyasare`.`shops` AS `Shop` ON (`Realtime`.`shop_id` = `Shop`.`id`) WHERE `Shop`.`view` = '1' AND `Shop`.`delflag` = '0' AND `Realtime`.`modified` < '2019-09-22 11:20:17' ORDER BY `Realtime`.`modified` DESC LIMIT 5550
177SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (4294967295) ORDER BY `Girl`.`pos` ASC LIMIT 2110
178SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (4294967295) ORDER BY `Girl`.`pos` ASC LIMIT 2110
179SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660224) ORDER BY `Girl`.`pos` ASC LIMIT 2220
180SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660084) ORDER BY `Girl`.`pos` ASC LIMIT 2220
181SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660078) ORDER BY `Girl`.`pos` ASC LIMIT 2220
182SELECT `Shop`.`id`, `Shop`.`shopname`, `Movie`.`youtube`, `Movie`.`youtube_text`, `Movie`.`youtube_modified` FROM `iyasare`.`movies` AS `Movie` LEFT JOIN `iyasare`.`shops` AS `Shop` ON (`Movie`.`shop_id` = `Shop`.`id`) WHERE `Shop`.`view` = '1' AND `Shop`.`delflag` = '0' AND `Movie`.`youtube_status` = 2 ORDER BY rand() ASC LIMIT 5550
183SELECT `Shop`.`id`, `Shop`.`rank`, `Shop`.`shopname`, `Shop`.`tokuwari_title`, `Shop`.`tokuwari_price`, `Shop`.`tokuwari_cond` FROM `iyasare`.`shops` AS `Shop` LEFT JOIN `iyasare`.`areas` AS `Area` ON (`Shop`.`area_id` = `Area`.`id`) WHERE `Shop`.`view` = '1' AND `Shop`.`delflag` = '0' AND `Shop`.`tokuwari` = '1' AND NOT (`Shop`.`tokuwari_title` = '') ORDER BY rand() ASC LIMIT 5551
184SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660120) ORDER BY `Girl`.`pos` ASC LIMIT 2220
185SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660042) ORDER BY `Girl`.`pos` ASC LIMIT 2220
186SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660046) ORDER BY `Girl`.`pos` ASC LIMIT 2220
187SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660027) ORDER BY `Girl`.`pos` ASC LIMIT 2220
188SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (660138) ORDER BY `Girl`.`pos` ASC LIMIT 2220
189SELECT `Blog`.`id`, `Blog`.`shop_id`, `Blog`.`title`, `Blog`.`content`, `Blog`.`view`, `Blog`.`created`, `Blog`.`modified`, `Shop`.`id`, `Shop`.`shopname`, `Shop`.`area_id` FROM `iyasare`.`blogs` AS `Blog` LEFT JOIN `iyasare`.`shops` AS `Shop` ON (`Blog`.`shop_id` = `Shop`.`id`) WHERE `Blog`.`view` = '1' AND `Shop`.`view` = '1' AND `Shop`.`delflag` = '0' ORDER BY `Blog`.`created` DESC LIMIT 5330
190SELECT `Area`.`id`, `Area`.`name` FROM `iyasare`.`areas` AS `Area` WHERE `Area`.`id` = 7110
191SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (555013) ORDER BY `Girl`.`pos` ASC LIMIT 2220
192SELECT `Area`.`id`, `Area`.`name` FROM `iyasare`.`areas` AS `Area` WHERE `Area`.`id` = 11110
193SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (555003) ORDER BY `Girl`.`pos` ASC LIMIT 2220
194SELECT `Area`.`id`, `Area`.`name` FROM `iyasare`.`areas` AS `Area` WHERE `Area`.`id` = 24110
195SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (555007) ORDER BY `Girl`.`pos` ASC LIMIT 2220
196SELECT `Voice`.`id`, `Voice`.`shop_id`, `Voice`.`shopname`, `Voice`.`title`, `Voice`.`content`, `Voice`.`name`, `Voice`.`age`, `Voice`.`station`, `Voice`.`year`, `Voice`.`month`, `Voice`.`visit_count`, `Voice`.`therapist_name`, `Voice`.`point_therapist`, `Voice`.`point_threatment`, `Voice`.`point_reception`, `Voice`.`point_room`, `Voice`.`view`, `Voice`.`created`, `Voice`.`modified`, `Shop`.`id`, `Shop`.`shopname`, `Shop`.`area_id` FROM `iyasare`.`voices` AS `Voice` LEFT JOIN `iyasare`.`shops` AS `Shop` ON (`Voice`.`shop_id` = `Shop`.`id`) WHERE `Voice`.`view` = '1' AND `Shop`.`view` = '1' AND `Shop`.`delflag` = '0' ORDER BY `Voice`.`created` DESC LIMIT 5220
197SELECT `Area`.`id`, `Area`.`name` FROM `iyasare`.`areas` AS `Area` WHERE `Area`.`id` = 25110
198SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (555009) ORDER BY `Girl`.`pos` ASC LIMIT 2220
199SELECT `Area`.`id`, `Area`.`name` FROM `iyasare`.`areas` AS `Area` WHERE `Area`.`id` = 2110
200SELECT `Girl`.`profile_image`, `Girl`.`shop_id` FROM `iyasare`.`girls` AS `Girl` WHERE `Girl`.`shop_id` = (555004) ORDER BY `Girl`.`pos` ASC LIMIT 2220