SELECT aiservice, serurl, airank FROM zapple.servicez INNER JOIN zapple.servicedb ON servicez.aicode = servicedb.aicode WHERE servicedb.jcode = 'ijcat' AND servicez.airank != 'yes' ORDER BY servicez.pos<br>
Column 'aiservice' in field list is ambiguous