Error Executing Database Query.
|
Table 'bldb150129.amazonsets' doesn't exist
|
|
The error occurred in D:/home/steveransom.com/wwwroot/LegoList.cfm: line 17
|
15 : <CFPARAM name="SC" default="0">
16 :
17 : <CFQUERY datasource="#PartDB#" name="AllCategories">
18 : SELECT DISTINCT Category
19 : From
|
|
SQLSTATE |
42S02 |
DATASOURCE |
MyBrickLink |
VENDORERRORCODE |
1146 |
SQL |
SELECT DISTINCT Category
From
legosets Left Join
amazonsets
On amazonsets.GrabboSetID = legosets.AccessSetID Left Join
trusets
On trusets.GrabboSetID = legosets.AccessSetID
Where
legosets.category IS NOT NULL AND (
(legosets.ShopAtHomeSoldOut = False AND legosets.tempSAHsoldout = FALSE AND legosets.shoplegocomprice > 0.19) Or
(amazonsets.Available = True AND amazonsets.Retired = FALSE AND amazonsets.DisconStreak < 10) Or
(trusets.InvalidPage = False AND trusets.TRUstatus = 'Sold Online + in Stores') )
Order By
Category
|
|
Resources:
|
Browser |
claudebot |
Remote Address |
44.197.251.102 |
Referrer |
|
Date/Time |
18-Mar-24 10:38 PM |
|