SELECT SQL_CALC_FOUND_ROWS pd44.* FROM pd44 WHERE (pd44.approved=1) AND (pd44.published=1) AND (pd44.account IN (101159%7C1003296%7C1003297%7C1003298,1003296,1003297,1003298) ) GROUP BY pd44.crkp_id ORDER BY pinned DESC, crkp_id DESC, pd44.soldout ASC LIMIT 10 OFFSET 60