How use SQL_CALC_FOUND_ROWS?

Hello how use SQLCALCFOUND_ROWS in phalcon?

result:

Column 'SQLCALCFOUNDROWS' doesn't belong to any of the selected models (1), when preparing: SELECT SQLCALCFOUNDROWS ROWCOUNT .....

What's a problem with count?

SQL_CALC_FOUND_ROWS is not standard SQL, thus Phalcon ORM doesn't recognize it. Either use COUNT(1), or execute it as raw SQL.

Sometimes we're deeply into some specific RDBMS flavour / SQL dialect... it shoudn't be like that!