|
|||||||||||||||||||||||||||||
|
You have 0 items in your cart. View Cart | Go to Checkout | Turn Debugger OFF |
||||||||||||||||||||||||||||
|
|||||||||||||||||||||||||||||
Website Design By: Webcorp Technologies ![]()
| SQL: SELECT TOP 1 product_ID, product_Name, product_Description FROM tbl_products INNER JOIN tbl_skus ON tbl_products.product_ID = tbl_skus.SKU_ProductID WHERE product_ID = 518 AND product_Archive = False AND product_OnWeb = True AND tbl_skus.SKU_ShowWeb = True AND sku_stock > 0 Records: 1 | ||
| product_ID - adInteger | product_Name - adVarWChar | product_Description - adLongVarWChar |
|---|---|---|
| 518 | Combination Swift | Have the versatility of a floor swift or a table swift with this three set combination that includes the umbrella section, the floor base, and the table base. |
| SQL: SELECT product_MerchantProductID, product_Name, upsell_id, upsell_ProdID, upsell_relProdID FROM tbl_products, tbl_prdtupsell WHERE upsell_relProdID = product_ID AND upsell_ProdID = 518 AND product_Archive = False AND product_OnWeb = True; Records: 2 | ||||
| product_MerchantProductID - adVarWChar | product_Name - adVarWChar | upsell_id - adInteger | upsell_ProdID - adInteger | upsell_relProdID - adInteger |
|---|---|---|---|---|
| StrachFloorSwiftSkeinwinder | Floor Swift / Skeinwinder | 836 | 518 | 508 |
| Strauch-TableSwiftSkeinwinder | Table Swift / Skeinwinder | 837 | 518 | 507 |
| SQL: SELECT Min(SKU_Price) AS minPrice, Max(SKU_Price) AS maxPrice FROM tbl_skus WHERE SKU_ProductID = 518 AND SKU_ShowWeb = True AND SKU_Stock > 0 Records: 1 | |
| minPrice - adDouble | maxPrice - adDouble |
|---|---|
| 193 | 250 |
| SQL: SELECT DISTINCT tbl_prdtoption_rel.optn_rel_OptionType_ID FROM tbl_products INNER JOIN tbl_prdtoption_rel ON tbl_products.product_ID = tbl_prdtoption_rel.optn_rel_Prod_ID WHERE tbl_prdtoption_rel.optn_rel_Prod_ID = 518 AND tbl_products.product_Archive = False; Records: 1 |
| optn_rel_OptionType_ID - adInteger |
|---|
| 2 |
| SQL: SELECT tbl_skuoptions.option_ID, tbl_list_optiontypes.optiontype_Name, tbl_list_optiontypes.optiontype_ID, tbl_skuoptions.option_Sort, tbl_skuoptions.option_Name FROM tbl_skus INNER JOIN ((tbl_list_optiontypes INNER JOIN tbl_skuoptions ON tbl_list_optiontypes.optiontype_ID = tbl_skuoptions.option_Type_ID) INNER JOIN tbl_skuoption_rel ON tbl_skuoptions.option_ID = tbl_skuoption_rel.optn_rel_Option_ID) ON tbl_skus.SKU_ID = tbl_skuoption_rel.optn_rel_SKU_ID WHERE tbl_skus.SKU_ProductID = 518 GROUP BY tbl_skus.SKU_ProductID, tbl_skuoptions.option_ID, tbl_list_optiontypes.optiontype_Name, tbl_list_optiontypes.optiontype_ID, tbl_skuoptions.option_Sort, tbl_skuoptions.option_Name ORDER BY tbl_list_optiontypes.optiontype_Name, tbl_skuoptions.option_Sort, tbl_skuoptions.option_Name; Records: 4 | ||||
| option_ID - adInteger | optiontype_Name - adVarWChar | optiontype_ID - adInteger | option_Sort - adInteger | option_Name - adVarWChar |
|---|---|---|---|---|
| 128 | Color | 2 | 0 | Oak |
| 254 | Color | 2 | 154 | Birch |
| 252 | Color | 2 | 154 | Cherry |
| 253 | Color | 2 | 154 | Walnut |
| SQL: SELECT tbl_list_optiontypes.optiontype_ID, tbl_list_optiontypes.optiontype_Name FROM tbl_skus INNER JOIN ((tbl_list_optiontypes INNER JOIN tbl_skuoptions ON tbl_list_optiontypes.optiontype_ID = tbl_skuoptions.option_Type_ID) INNER JOIN tbl_skuoption_rel ON tbl_skuoptions.option_ID = tbl_skuoption_rel.optn_rel_Option_ID) ON tbl_skus.SKU_ID = tbl_skuoption_rel.optn_rel_SKU_ID WHERE tbl_skus.SKU_ProductID = 518 GROUP BY tbl_list_optiontypes.optiontype_ID, tbl_list_optiontypes.optiontype_Name ORDER BY tbl_list_optiontypes.optiontype_Name; Records: 1 | |
| optiontype_ID - adInteger | optiontype_Name - adVarWChar |
|---|---|
| 2 | Color |