SELECT down_table.sikepuri_id AS sikepuri_id, down_table.down_count AS down_count, sikepuri_table.sikepuri_title AS sikepuri_title, sikepuri_table.sikepuri_creater AS sikepuri_creater, sikepuri_table.sikepuri_kind AS sikepuri_kind, sikepuri_table.classdata_id AS classdata_id, sikepuri_table.classdata_name1 AS classdata_name1, sikepuri_table.classdata_count AS classdata_count FROM (SELECT sikepuri_id, COUNT(*) AS down_count FROM sikepuri_downlog GROUP BY sikepuri_id) AS down_table, (SELECT sikepuri.id AS sikepuri_id, sikepuri.title AS sikepuri_title, sikepuri.kind AS sikepuri_kind, sikepuri.creater AS sikepuri_creater, classdata.id AS classdata_id, classdata.name1 AS classdata_name1, COUNT(DISTINCT classdata.id) AS classdata_count FROM sikepuri LEFT JOIN sikepuri_link ON sikepuri.id = sikepuri_link.sikepuri_id LEFT JOIN classdata ON sikepuri_link.classdata_id = classdata.id GROUP BY sikepuri.id) AS sikepuri_table WHERE down_table.sikepuri_id = sikepuri_table.sikepuri_id
