SELECT SQL_CALC_FOUND_ROWS pd44.* FROM pd44, pd_moption AS mo3059 WHERE (pd44.approved=1) AND (pd44.published=1) AND (pd44.account IN (101163%7C101171%7C1004584%7C1105315,101171,1004584,1105315) ) AND (pd44.housetype=mo3059.ref_id) AND (mo3059.option_id='2901') GROUP BY pd44.crkp_id ORDER BY pd44.pinned DESC , pd44.crkp_id DESC, pinned DESC, crkp_id DESC, pd44.soldout ASC LIMIT 10