Bad handshake
select category.cid, site_category.site_id, site_category.ctitle from category inner join site_category on (category.cid=site_category.cid) where (site_category.cshow=1) and (category.cshow=1) and ((site_category.site_id=9) or (site_category.site_id=1)) order by site_category.site_id desc, site_category.c_order