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 =285871) order by publisheddate desc limit 0,10;select FOUND_ROWS() as totalcount;array(2) {
[0]=>
array(10) {
[0]=>
array(2) {
["id"]=>
string(6) "344819"
[0]=>
string(6) "344819"
}
[1]=>
array(2) {
["id"]=>
string(6) "344810"
[0]=>
string(6) "344810"
}
[2]=>
array(2) {
["id"]=>
string(6) "344172"
[0]=>
string(6) "344172"
}
[3]=>
array(2) {
["id"]=>
string(6) "337256"
[0]=>
string(6) "337256"
}
[4]=>
array(2) {
["id"]=>
string(6) "330229"
[0]=>
string(6) "330229"
}
[5]=>
array(2) {
["id"]=>
string(6) "328593"
[0]=>
string(6) "328593"
}
[6]=>
array(2) {
["id"]=>
string(6) "328529"
[0]=>
string(6) "328529"
}
[7]=>
array(2) {
["id"]=>
string(6) "328507"
[0]=>
string(6) "328507"
}
[8]=>
array(2) {
["id"]=>
string(6) "328508"
[0]=>
string(6) "328508"
}
[9]=>
array(2) {
["id"]=>
string(6) "328264"
[0]=>
string(6) "328264"
}
}
[1]=>
array(1) {
[0]=>
array(2) {
["totalcount"]=>
string(2) "63"
[0]=>
string(2) "63"
}
}
}