SELECT DINSTINCT... FROM ... JOIN ...ON ... WHERE ... GROUP BY ... HAVING ... ORDER BY ...LIMIT
FROM > ON > JOIN > WHERE > GROUP BY > HAVING > SELECT > DISTINCT > ORDER BY > LIMIT