SELECT SQL_CALC_FOUND_ROWS pd44.* FROM pd44 WHERE (pd44.approved=1) AND (pd44.published=1) AND (pd44.account IN (100969%7C100968%7C101166%7C1003294%7C1003295%7C1003805,100968,101166,1003294,1003295,1003805) ) GROUP BY pd44.crkp_id ORDER BY pinned DESC, crkp_id DESC, pd44.soldout ASC LIMIT 10