SELECT SQL_CALC_FOUND_ROWS pd44.* FROM pd44 LEFT JOIN pd_bts ON (pd44.transport_bts=pd_bts.ref_id) WHERE (pd44.approved=1) AND (pd44.published=1) AND (pd44.account IN (100615%7C101162%7C101258%7C1003751,101162,101258,1003751) ) AND ((pd_bts.ref_id IS NOT NULL) ) GROUP BY pd44.crkp_id, pd44.transport_bts ORDER BY pd44.pinned DESC , pd44.crkp_id DESC, pinned DESC, crkp_id DESC, pd44.soldout ASC LIMIT 10