Error Executing Database Query.
|
Incorrect syntax near 'kids'.
|
|
The error occurred in H:/DATA/WWWROOT/Twits/PUBLIC/webshop/overview.cfm: line 88
Called from H:/DATA/WWWROOT/Twits/PUBLIC/webshop/routes.cfm: line 30
Called from H:/DATA/WWWROOT/Twits/PUBLIC/_owner/main.template.cfm: line 209
Called from H:/DATA/WWWROOT/Twits/PUBLIC/routes.cfm: line 50
Called from H:/DATA/WWWROOT/Twits/PUBLIC/webshop/overview.cfm: line 88
Called from H:/DATA/WWWROOT/Twits/PUBLIC/webshop/routes.cfm: line 30
Called from H:/DATA/WWWROOT/Twits/PUBLIC/_owner/main.template.cfm: line 209
Called from H:/DATA/WWWROOT/Twits/PUBLIC/routes.cfm: line 50
|
86 : ORDER BY CP.sequence asc, P.createTS desc
87 : </cfif>
88 : <cfelse>
89 : ORDER BY P.createTS desc
90 : </cfif>
|
|
SQLSTATE |
S0001 |
DATASOURCE |
twits |
VENDORERRORCODE |
102 |
SQL |
SELECT P.product_id as pId, P.product_name as product, P.product_artnr as artnr, P.product_permalink as permalink, P.product_price as price,
B.brand_title as brand, B.brand_logo as brandlogo, P.product_promoprice as promoprice, P.product_discount
FROM twits_products P
inner join twits_brands B on (B.brand_id = P.lnk_brand_id)
left outer join twits_cats C on (C.cat_id = CP.lnk_cat_id and C.cat_permalink = snowboard kids)
left outer join twits_cat_products CP on (CP.lnk_product_id = P.product_id)
WHERE P.status > 0
ORDER BY CP.sequence asc, P.createTS desc
|
|
Resources:
|
Browser |
CCBot/2.0 (https://commoncrawl.org/faq/) |
Remote Address |
3.221.159.255 |
Referrer |
|
Date/Time |
25-Jan-21 11:58 PM |
|