ERROR
An exception occurred while executing 'SELECT count(w0_.WORKSHOP_ID) AS SCLR_0, w1_.ID AS ID_1, p2_.ID AS ID_2, p2_.NAME AS NAME_3 FROM WORKSHOP_SHOPS w0_ INNER JOIN USERS u3_ ON w0_.USER_ID = u3_.ID INNER JOIN SHOPS s4_ ON w0_.SHOP_ID = s4_.ID INNER JOIN TOWNS t5_ ON s4_.TOWN_ID = t5_.ID INNER JOIN PROVINCES p2_ ON t5_.PROVINCE_ID = p2_.ID INNER JOIN WORKSHOP_MENUS w1_ ON w0_.WORKSHOP_ID = w1_.ID WHERE w1_.ACTIVE = 1 AND s4_.ACTIVE = 1 AND w0_.WORKSHOP_DATE >= ? AND (w0_.MAX_PLACES - w0_.TAKEN_PLACES) <> 0 AND w0_.STATE_ID NOT IN (242, 243) GROUP BY p2_.ID, p2_.NAME, w1_.ID, SCLR_0' with params ["03\/10\/23"]:
ORA-00904: "SCLR_0": invalid identifier
03-10-2023 01:40:54
Ir a inicio