select SQL_CALC_FOUND_ROWS id from content where statusid=1 and siteid=1 and content.tempid!=9 and id in(select contentid from content_properties where typeid=5 and propertyid =217459) order by publisheddate desc limit 0,10;select FOUND_ROWS() as totalcount;array(2) {
[0]=>
array(10) {
[0]=>
array(2) {
["id"]=>
string(6) "282943"
[0]=>
string(6) "282943"
}
[1]=>
array(2) {
["id"]=>
string(6) "280286"
[0]=>
string(6) "280286"
}
[2]=>
array(2) {
["id"]=>
string(6) "280262"
[0]=>
string(6) "280262"
}
[3]=>
array(2) {
["id"]=>
string(6) "275186"
[0]=>
string(6) "275186"
}
[4]=>
array(2) {
["id"]=>
string(6) "275008"
[0]=>
string(6) "275008"
}
[5]=>
array(2) {
["id"]=>
string(6) "272311"
[0]=>
string(6) "272311"
}
[6]=>
array(2) {
["id"]=>
string(6) "266551"
[0]=>
string(6) "266551"
}
[7]=>
array(2) {
["id"]=>
string(6) "264039"
[0]=>
string(6) "264039"
}
[8]=>
array(2) {
["id"]=>
string(6) "259144"
[0]=>
string(6) "259144"
}
[9]=>
array(2) {
["id"]=>
string(6) "258324"
[0]=>
string(6) "258324"
}
}
[1]=>
array(1) {
[0]=>
array(2) {
["totalcount"]=>
string(2) "44"
[0]=>
string(2) "44"
}
}
}