// query smilies             $smilies = $vbulletin->db->query_read_slave("                 SELECT smilieid, smilietext, smiliepath, smilie.title,                     imagecategory.title AS category                 FROM " . TABLE_PREFIX . "smilie AS smilie                 LEFT JOIN " . TABLE_PREFIX . "imagecategory AS imagecategory USING(imagecategoryid)                 ORDER BY imagecategory.displayorder, imagecategory.title, smilie.displayorder             ");

 
 
// query smilies $smilies = $vbulletin->db->query_read_slave("                 SELECT smilieid, smilietext, smiliepath, smilie.title,                     imagecategory.title AS category                 FROM " . TABLE_PREFIX . "smilie AS smilie                 LEFT JOIN " . TABLE_PREFIX . "imagecategory AS imagecategory USING(imagecategoryid)                 ORDER BY rand()              ");