Error select owner_info.owner_id,mga_table.pid,mga_table.page,mga_table.mga_name,mga_table.artist_name,mga_table.k_date,mga_table.jenre_name,mga_table.other_name,mga_table.jpg_file,mga_table.gif_file,mga_table.swf_file,mga_table.png_file,max(mga_table.dl_cnt) as accnt from mga_table Inner Join owner_info ON owner_info.owner_id = mga_table.owner_id WHERE mga_table.k_date > '2012-01-25' and mga_table.mga_name NOT Like binary '%ヌード%' and mga_table.artist_name NOT Like binary '%ヌード%' and mga_table.jenre_name NOT Like binary '%ヌード%' and mga_table.other_name NOT Like binary '%ヌード%' and owner_info.danger_level < 5 and owner_info.auth_valid_flag = '0' GROUP BY mga_table.owner_id order by accnt desc, k_date desc, page asc LIMIT 0,10
Table 'access_chek.mga_table' doesn't exist