SELECT * FROM `questions`, `groups` WHERE `questions`.gid=`groups`.gid AND `questions`.sid=27 AND `questions`.language='en' AND `groups`.language='en' ORDER BY groups.group_order, title