mysql I need to remember script

SELECT colourid, COUNT(colourid) as noofoccurance FROM vtiger_appendixcolour WHERE colourid != 0 GROUP BY colourid ORDER BY noofoccurance DESC;

This is to find each colourid, how much frequency it has been used. Typically use this to find 'search by popularity;