Error Executing Database Query.
|
Ambiguous column name 'sequence'.
|
|
The error occurred in F:/WWWROOT/2018/PUBLIC/incl/incl.productdetail.cfm: line 294
Called from F:/WWWROOT/2018/PUBLIC/incl/incl.collection.cfm: line 52
Called from F:/WWWROOT/2018/PUBLIC/_owner/main.template.cfm: line 185
Called from F:/WWWROOT/2018/PUBLIC/routes.cfm: line 548
Called from F:/WWWROOT/2018/PUBLIC/incl/incl.productdetail.cfm: line 294
Called from F:/WWWROOT/2018/PUBLIC/incl/incl.collection.cfm: line 52
Called from F:/WWWROOT/2018/PUBLIC/_owner/main.template.cfm: line 185
Called from F:/WWWROOT/2018/PUBLIC/routes.cfm: line 548
|
292 : AND image_active = 1
293 : ) PI
294 : WHERE LRP.lnk_product_id = <cfqueryparam value="#URL.id#">
295 : AND LRP.status = 1 AND P.product_status = 1
296 : ORDER BY sequence
|
|
SQLSTATE |
S0001 |
DATASOURCE |
Bioracer |
VENDORERRORCODE |
209 |
SQL |
SELECT P.*, PI.*, LRP.*, P.product_name_du as productname, S.slug
FROM bioracer_lnk_related_products LRP
INNER JOIN bioracer_products P ON P.product_id = LRP.lnk_related_product_id
inner join bioracer_slugs S ON S.itemid = P.product_id AND S.itemtype = 'product' AND S.lang = (param 1)
outer apply (
select top 1 *
from bioracer_product_images
where lnk_product_id = LRP.lnk_related_product_id
AND image_active = 1
) PI
WHERE LRP.lnk_product_id = (param 2)
AND LRP.status = 1 AND P.product_status = 1
ORDER BY sequence
|
|
Resources:
|
Browser |
CCBot/2.0 (https://commoncrawl.org/faq/) |
Remote Address |
3.239.51.78 |
Referrer |
|
Date/Time |
19-Jan-21 01:41 PM |
|