Патрик Суейзи, "She's Like the Wind" 2009-09-15 12:22:00
SELECT DISTINCT u.ID as UnitID, u.SortID, uc.Class FROM bn_units u LEFT JOIN bn_units_type uc ON uc.ID = u.ClassID LEFT JOIN bn_architecture a ON u.ID = a.UnitID WHERE a.AssemblyID = 8 AND u.PageID = 30 ORDER BY u.SortID ASC