/shop/osaka/seikan/313/therapist/18013/review/?p=2/?p=2
select review.ID
, review.shop_id
, review.user_id
, review.title
, review.body
, review.status
, review.rating
, review.staff
, review.cast_id
, review.reply
, review.email
, review.ranking_flg
, review.ipaddr
, review.ua
, review.created
, review.updated
, cast.cast_name as cast_name
, IF(user.display_name IS NULL, '匿名希望', user.display_name) as user_name
, user.img_path as user_img
from cms_review as review
LEFT JOIN cms_cast as cast ON review.cast_id = cast.ID
JOIN cms_users as user ON review.user_id = user.ID
WHERE review.shop_id = '1313'
AND (review.status = 'publish' OR review.status = 'store_del') AND (review.cast_id = 18013 AND cast.status = 'publish') AND user.deleted = 0
ORDER BY review.created DESC
高杉 京吾の口コミ・2ページ目(Un moment pour toi)-東京/神奈川/愛知/京都/大阪/兵庫/福岡/女性用風俗|Kaikan(カイカン)
高杉 京吾の口コミ・2ページ目(Un moment pour toi)-東京/神奈川/愛知/京都/大阪/兵庫/福岡/女性用風俗