一覧検索(シリーズ名指定)


serch_type=series

並び替え

オムニバス作品を表示しない 

masterを使用した引数=Select * from (AV_master left outer join dmm_master AS dmm ON AV_master.Dmm_id = dmm.product_id )left outer join duga_master AS duga ON AV_master.Duga_id = duga.product_Id INNER JOIN (SELECT AV_id AS Serch_AVid FROM AVcontact_master where Contct_id = 71 and type = "series" ) Serch_id ON AV_master.AV_id = Serch_AVid GROUP BY AV_master.AV_id ORDER BY AV_id DESC LIMIT 0 ,12
maxnum=3