一覧検索(メーカー名指定)


serch_type=maker

並び替え

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

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 = 3009 and type = "maker" ) Serch_id ON AV_master.AV_id = Serch_AVid GROUP BY AV_master.AV_id ORDER BY AV_id DESC LIMIT 96 ,12
maxnum=107
list_page=96
1 2 3 4 5