SQL Query returns error

@PARADISE,

I think your missing some pieces of the query builder...

->from('Pledge as a')
->join('user_data as b', 'a.ruler_id = b.char_id', 'left outer')
->join('Alliance as c', 'a.alliance_id = c.id', 'left outer')
->order_by('a.skill_level', 'DESC')
->get();

You were right! It worked that way!