SQLSTATE |
HY000 |
DATASOURCE |
parkcityicumulus |
VENDORERRORCODE |
156 |
SQL |
SELECT a.class_id,d.sku_id,B.CLASS_SESSION_ID, A.CLASS_NAME, C.RESOURCE_NAME, DATEADD(HOUR, -7,B.START_DATETIME) as START_DATETIME, DATEADD(HOUR, -7,B.END_DATETIME) as END_DATETIME, A.IS_ACTIVE, ISNULL(b.CUSTOMER_COUNT,0) AS CUSTOMER_COUNT, A.MAX_CAPACITY
FROM TB_CLASSES A
inner join TB_ID_LINK e on a.STYLE_ID = e.ICUMULUS_ID
LEFT JOIN TB_CLASS_SESSION B ON(A.CLASS_ID=B.CLASS_ID)
LEFT JOIN TB_CLASS_RESOURCE C ON(C.CLASS_RESOURCE_ID=B.CLASS_RESOURCE_ID)
left join tb_skus d on (d.style_id=e.ICUMULUS_ID)
WHERE A.STYLE_ID = and a.IS_ACTIVE='Y' and e.COLUMN_NAME = 'STYLE_ID' and B.START_DATETIME >= getdate()
order by START_DATETIME asc
|
|