AV女優検索詳細

select dmm_actress_id,dmm_actress_aid,dmm_actress_name,dmm_actress_ruby,dmm_actress_bust,dmm_actress_cup,dmm_actress_waist,dmm_actress_hip,dmm_actress_height,dmm_actress_birthday,dmm_actress_bloodtype,dmm_actress_hobby,dmm_actress_prefectures,dmm_actress_image_url_s,dmm_actress_image_url_l,dmm_actress_list_url_movie,dmm_actress_list_url_monthly,dmm_actress_list_url_merchandise,dmm_actress_update_time,dmm_actress_status,dmm_actress_delete from dmm_actress_info where ((dmm_actress_info.dmm_actress_id = '6094')) and ((dmm_actress_info.dmm_actress_aid = '6245')) and ((dmm_actress_info.dmm_actress_name LIKE '%%')or(dmm_actress_info.dmm_actress_ruby LIKE '%%')) and ((dmm_actress_info.dmm_actress_ruby LIKE '%%')) and ((dmm_actress_info.dmm_actress_bust LIKE '%%')) and ((dmm_actress_info.dmm_actress_cup LIKE '%%')) and ((dmm_actress_info.dmm_actress_waist LIKE '%%')) and ((dmm_actress_info.dmm_actress_hip LIKE '%%')) and ((dmm_actress_info.dmm_actress_height LIKE '%%')) and ((dmm_actress_info.dmm_actress_birthday LIKE '%%')) and ((dmm_actress_info.dmm_actress_status LIKE '%1%')) and ((dmm_actress_info.dmm_actress_delete LIKE '%1%')) order by dmm_actress_id DESC limit 0,1

select count(*) from dmm_actress_info where ((dmm_actress_info.dmm_actress_id = '6094')) and ((dmm_actress_info.dmm_actress_aid = '6245')) and ((dmm_actress_info.dmm_actress_name LIKE '%%')or(dmm_actress_info.dmm_actress_ruby LIKE '%%')) and ((dmm_actress_info.dmm_actress_ruby LIKE '%%')) and ((dmm_actress_info.dmm_actress_bust LIKE '%%')) and ((dmm_actress_info.dmm_actress_cup LIKE '%%')) and ((dmm_actress_info.dmm_actress_waist LIKE '%%')) and ((dmm_actress_info.dmm_actress_hip LIKE '%%')) and ((dmm_actress_info.dmm_actress_height LIKE '%%')) and ((dmm_actress_info.dmm_actress_birthday LIKE '%%')) and ((dmm_actress_info.dmm_actress_status LIKE '%1%')) and ((dmm_actress_info.dmm_actress_delete LIKE '%1%'))

select dmm_item_id,dmm_item_service_code,dmm_item_service_name,dmm_item_floor_code,dmm_item_floor_name,dmm_item_cate_name,dmm_item_content_id,dmm_item_product_id,dmm_item_title,dmm_item_volume,dmm_item_number,dmm_item_review_count,dmm_item_review_average,dmm_item_favorite_count,dmm_item_views_count,dmm_item_url,dmm_item_affiliate_url,dmm_item_image_url_main_list,dmm_item_image_url_main_s,dmm_item_image_url_main_m,dmm_item_tachiyomi_url,dmm_item_tachiyomi_affi_url,dmm_item_images_url_s,dmm_item_images_url_l,dmm_item_movie_url_s,dmm_item_movie_url_m,dmm_item_movie_url_l,dmm_item_movie_url_2l,dmm_item_movie_pc_flag,dmm_item_movie_sp_flag,dmm_item_price,dmm_item_price_list,dmm_item_delivery_price_seri,dmm_item_date,dmm_item_genre,dmm_item_genre_seri,dmm_item_series,dmm_item_series_seri,dmm_item_maker,dmm_item_maker_seri,dmm_item_manufacture,dmm_item_manufacture_seri,dmm_item_actor,dmm_item_actor_seri,dmm_item_actress,dmm_item_actress_seri,dmm_item_director,dmm_item_director_seri,dmm_item_author,dmm_item_author_seri,dmm_item_lavel,dmm_item_lavel_seri,dmm_item_type,dmm_item_type_seri,dmm_item_color,dmm_item_color_seri,dmm_item_size,dmm_item_size_seri,dmm_item_main_text,dmm_item_comments,dmm_item_cdinfo_kind,dmm_item_jancode,dmm_item_maker_product,dmm_item_isbn,dmm_item_stock,dmm_item_directory_id,dmm_item_directory_name,dmm_item_camp_title,dmm_item_camp_date_begin,dmm_item_camp_date_end,dmm_item_update_time,dmm_item_status,dmm_item_delete from dmm_item_info where ((dmm_item_info.dmm_item_id LIKE '%%')) and ((dmm_item_info.dmm_item_content_id LIKE '%%')) and ((dmm_item_info.dmm_item_title LIKE '%%')) and ((dmm_item_info.dmm_item_volume LIKE '%%')) and ((dmm_item_info.dmm_item_number LIKE '%%')) and ((dmm_item_info.dmm_item_review_count LIKE '%%')) and ((dmm_item_info.dmm_item_review_average LIKE '%%')) and ((dmm_item_info.dmm_item_favorite_count LIKE '%%')) and ((dmm_item_info.dmm_item_views_count LIKE '%%')) and ((dmm_item_info.dmm_item_price LIKE '%%')) and ((dmm_item_info.dmm_item_date LIKE '%%')) and ((dmm_item_info.dmm_item_genre LIKE '%%')) and ((dmm_item_info.dmm_item_series LIKE '%%')) and ((dmm_item_info.dmm_item_maker LIKE '%%')) and ((dmm_item_info.dmm_item_manufacture LIKE '%%')) and ((dmm_item_info.dmm_item_actor LIKE '%%')) and ((dmm_item_info.dmm_item_actress LIKE '%南夕貴%')) and ((dmm_item_info.dmm_item_director LIKE '%%')) and ((dmm_item_info.dmm_item_author LIKE '%%')) and ((dmm_item_info.dmm_item_lavel LIKE '%%')) and ((dmm_item_info.dmm_item_status LIKE '%1%')) and ((dmm_item_info.dmm_item_delete LIKE '%1%')) order by dmm_item_review_average DESC limit 0,100

「AV女優を検索する」へ戻る