Author Topic: Subqueries and sql_calc_found_rows (Read 1157 times)

krypto · February 08, 2014, 04:18:23 am

Just trying to create a report that displays a bunch of counts, and am hitting a problem with sql_calc_found_rows being added to select subqueries. If I try:

Code: [Select]

SELECT
    (SELECT
            count(ci.id)
        from
            civicrm_value_celebrant_info
            ) As CountOfIds

it becomes:

Code: [Select]

SELECT SQL_CALC_FOUND_ROWS 
    (SELECT SQL_CALC_FOUND_ROWS 
            count(ci.id)
        from
            civicrm_value_celebrant_info
            ) As CountOfIds

which throws an error. Is there a way to stop sql_calc_found_rows getting inserted? Or is there a better sql technique?

krypto · February 19, 2014, 04:41:29 am

FYI I 'fixed' this by stripping everything complex out of the report and just using a basic template as per Case 1 at http://wiki.civicrm.org/confluence/display/CRMDOC/CiviReport+Reference.

CiviCRM Community Forums (archive)

News:

Author Topic: Subqueries and sql_calc_found_rows (Read 1157 times)

krypto

Subqueries and sql_calc_found_rows

krypto

Re: Subqueries and sql_calc_found_rows