how order by weigh in drupal sql statement

i have the following drupal sql. Wondering how would i order the following be weight

SELECT node.nid FROM node node LEFT JOIN content_type_videoclip videoclip ON node.vid = videoclip.vid WHERE node.type in ('videoclip')

I can work out how drupal manages the weight