select SQL_CALC_FOUND_ROWS id from content where statusid=1 and siteid=1 and id in(select contentid from content_properties where typeid=5 and propertyid =238782) order by publisheddate desc limit 0,10;select FOUND_ROWS() as totalcount;array(2) { [0]=> array(10) { [0]=> array(2) { ["id"]=> string(6) "282148" [0]=> string(6) "282148" } [1]=> array(2) { ["id"]=> string(6) "282084" [0]=> string(6) "282084" } [2]=> array(2) { ["id"]=> string(6) "281538" [0]=> string(6) "281538" } [3]=> array(2) { ["id"]=> string(6) "281300" [0]=> string(6) "281300" } [4]=> array(2) { ["id"]=> string(6) "281045" [0]=> string(6) "281045" } [5]=> array(2) { ["id"]=> string(6) "280601" [0]=> string(6) "280601" } [6]=> array(2) { ["id"]=> string(6) "280249" [0]=> string(6) "280249" } [7]=> array(2) { ["id"]=> string(6) "278661" [0]=> string(6) "278661" } [8]=> array(2) { ["id"]=> string(6) "278031" [0]=> string(6) "278031" } [9]=> array(2) { ["id"]=> string(6) "276803" [0]=> string(6) "276803" } } [1]=> array(1) { [0]=> array(2) { ["totalcount"]=> string(2) "98" [0]=> string(2) "98" } } }