SQL query fail

I have this SQL

{up sql=customtables_table_uc | select=sum(es_uc1),sum(es_uc2),sum(es_uc3),sum(es_uc4),sum(es_uc5),sum(es_uc6),sum(es_uc7),sum(es_uc8),sum(es_uc9),sum(es_uc10),sum(es_uc11),sum(es_uc12),sum(es_uc13),sum(es_uc14),sum(es_uc15),sum(es_uc16),sum(es_uc17),sum(es_uc18),sum(es_uc19),sum(es_uc20),sum(es_uc21),sum(es_uc22),sum(es_uc23),sum(es_uc24),sum(es_uc25),sum(es_uc26),sum(es_uc27),sum(es_uc28),sum(es_uc29),sum(es_uc30),sum(es_uc31),sum(es_uc32),sum(es_uc33),sum(es_uc34),sum(es_uc35),sum(es_uc36),sum(es_uc37),sum(es_uc38),sum(es_uc39) | debug}{/up sql}

which generate
SELECT sum(es_uc1),sum(es_uc2),sum(es_uc3),sum(es_uc4),sum(es_uc5),sum(es_uc6),sum(es_uc7),sum(es_uc8),sum(es_uc9),sum(es_uc10),sum(es_uc11),sum(es_uc12),sum(es_uc13),sum(es_uc14),sum(es_uc15),sum(es_uc16),sum(es_uc17),sum(es_uc18),sum(es_uc19),sum(es_uc20),sum(es_uc21),sum(es_uc22),sum(es_uc23),sum(es_uc24),sum(es_uc25),sum(es_uc26),sum(es_uc27),sum(es_uc28),sum(es_uc29),sum(es_uc30),sum(es_uc31),sum(es_uc32),sum(es_uc33),sum(es_uc34),sum(es_uc35),sum(es_uc36),sum(es_uc37),sum(es_uc38),sum(es_uc39) FROM #__customtables_table_uc

but I get an error like
[up-92-1 sql] es_uc2 : unknown column in query

for every field in the table (even the ones I've not put in the SQL command)

and at the end a

count(): Argument #1 ($value) must be of type Countable|array, null given

Thank you

I'll look into this issue and get back to you

Good morning,

Replace the file in /plugins/content/up/actions/sql/sql.php with the one in the attached zip

It fixes an error that doesn't quite fit your case. Keep me informed

Ok the error

count(): Argument #1 ($value) must be of type Countable|array, null given

is no more present

Remain the strange error that says
up-m654b6126119b0 sql] es_uc10 : unknown column in query

for every column in the table, but only with more than one sum:
{up sql=customtables_table_uc | select=sum(es_uc1),sum(es_uc2)}{/up sql}

With simgle sums
{up sql=customtables_table_uc | select=sum(es_uc1)}{/up sql}
{up sql=customtables_table_uc | select=sum(es_uc2)}{/up sql}

it works

It's normal.
The action is intended to return ONE single total used by another action

You can get trickier by adding a template option and the titles :

Ops. Sorry. Thank you.