Miscellany
public text v1 · immutableSELECT title, xml_id, COUNT(*) as NUM FROM download GROUP BY `download`.`Title`, `download`.`Disc_1_DiscIDSideA` HAVING COUNT( * ) > 1 SORT BY xml_id DESCSELECT title, xml_id, COUNT(*) as NUM FROM download GROUP BY `download`.`Title`, `download`.`Disc_1_DiscIDSideA` HAVING COUNT( * ) > 1 SORT BY xml_id DESC