Wine & Dine

$55.00

Description

Enjoy a four course dinner and wine pairing featuring WINEBOW wines from Argentina and Chile. Dinner highlights the essence of end of summer with bold flavors and colors. 

Choose between a wine + dinner pairing or just the dinner. Hosted at the Capital City Country Club on Thursday, August 25th.

Dinner + Wine includes: 

First course: Smoked Scallop with mango mousse and roasted red pepper ginger sauce. Paired with Finca Wolffer Rose of Malbec (Mendoza, Argentina).

Second course: Charred Cabbage Wedge with rainbow carrots, scallions, jicama dressed with citrus jalapeƱo vinaigrette. Paired with Aruacano Humo Blanco Sauvignon Blanc (Chile).

Third course: Grilled Chimichurri Flank Steak Roulade with charred corn polenta cake and blistered tomato sauce. Paired with Zuccardi Q Uco Red Blend (Mendoza, Argentina).

Fourth course: Lemon curd and blackberry starry night parfait with almond butter cake and toasted meringue. Paired with Santa Julia Tardio Late Harvest Torrontes (Mendoza, Argentina)

Bar services will be available at additional charge at the event. 

A 7.5% sales tax & 22% service charge will applied at check out.

There is a 3.5% surcharge on all credit card transactions. If you would like to avoid this charge, please use a debit card versus a credit card.

Show Stats
Server Time: 10/02/2022 18:21:44
Session Id: lm3p15mscno5rn02e2l01svelh (Expires: 10/02/2022 20:21:44)
Peak Memory: 10.0579 MB
Markers
 
Time (% of Total)
Memory In
Memory Out
Memory +/-
App
0.1952 (100%)
363.898 kB
10.102 MB
9.747 MB
App.Boot
0.0310 (15.88%)
603.797 kB
5.426 MB
4.836 MB
Required.Providers.Init
0.0022 (1.13%)
604.898 kB
1.246 MB
670.914 kB
Profiler.Init
0.0001 (0.05%)
605.672 kB
650.141 kB
44.469 kB
FileSystem.Init
0.0000 (0%)
650.922 kB
737.602 kB
86.680 kB
Log.Init
0.0001 (0.05%)
738.383 kB
761.656 kB
23.273 kB
Cryptography.Init
0.0000 (0%)
791.633 kB
812.758 kB
21.125 kB
CacheEngine.Init
0.0000 (0%)
813.547 kB
835.570 kB
22.023 kB
Cache.Init
0.0001 (0.05%)
845.164 kB
868.398 kB
23.234 kB
Session.Init
0.0000 (0%)
869.500 kB
891.117 kB
21.617 kB
Cron.Init
0.0000 (0%)
893.516 kB
922.633 kB
29.117 kB
Databases.Init
0.0001 (0.05%)
923.375 kB
961.586 kB
38.211 kB
Databases.Data
0.0001 (0.05%)
924.148 kB
960.852 kB
36.703 kB
Queue.Init
0.0000 (0%)
961.258 kB
1.017 MB
79.758 kB
Registry.Init
0.0000 (0%)
1.054 MB
1.081 MB
27.023 kB
Module.Init
0.0000 (0%)
1.082 MB
1.102 MB
21.422 kB
PostOffice.Init
0.0001 (0.05%)
1.103 MB
1.211 MB
110.500 kB
I18n.Init
0.0000 (0%)
1.212 MB
1.223 MB
11.742 kB
Tools.Init
0.0000 (0%)
1.225 MB
1.245 MB
20.297 kB
Registry.Start
0.0057 (2.92%)
1.240 MB
3.337 MB
2.097 MB
Package.Core.Settings
0.0000 (0%)
3.175 MB
3.192 MB
17.445 kB
Package.Render.Settings
0.0000 (0%)
3.192 MB
3.203 MB
10.844 kB
Package.DataManager.Settings
0.0000 (0%)
3.203 MB
3.212 MB
9.125 kB
Package.Menus.Settings
0.0000 (0%)
3.213 MB
3.222 MB
9.117 kB
Package.Administration.Settings
0.0000 (0%)
3.222 MB
3.231 MB
9.125 kB
Package.ImageProcessor.Settings
0.0000 (0%)
3.231 MB
3.240 MB
9.125 kB
Package.FileManager.Settings
0.0000 (0%)
3.240 MB
3.250 MB
9.859 kB
Package.Web.Settings
0.0000 (0%)
3.250 MB
3.259 MB
9.117 kB
Package.Membership.Settings
0.0000 (0%)
3.260 MB
3.269 MB
9.125 kB
Package.Geography.Settings
0.0000 (0%)
3.269 MB
3.278 MB
9.125 kB
Package.Payment.Settings
0.0000 (0%)
3.278 MB
3.288 MB
10.375 kB
Package.Ecommerce.Settings
0.0000 (0%)
3.289 MB
3.298 MB
9.125 kB
Package.HQ.Settings
0.0000 (0%)
3.298 MB
3.308 MB
10.734 kB
Package.HelpDesk.Settings
0.0000 (0%)
3.309 MB
3.318 MB
9.125 kB
Package.FTT.Settings
0.0000 (0%)
3.318 MB
3.327 MB
9.117 kB
Package.SCE.Settings
0.0000 (0%)
3.327 MB
3.336 MB
9.117 kB
Settings.Load
0.0129 (6.61%)
3.371 MB
3.404 MB
33.313 kB
Providers.Init
0.0022 (1.13%)
3.404 MB
4.626 MB
1.222 MB
TemplateEngine.Init
0.0001 (0.05%)
3.405 MB
3.429 MB
25.156 kB
View.Init
0.0001 (0.05%)
3.430 MB
3.527 MB
99.836 kB
Assets.Init
0.0001 (0.05%)
3.527 MB
3.551 MB
24.305 kB
Notification.Init
0.0000 (0%)
3.552 MB
3.572 MB
21.328 kB
DataManager.Init
0.0001 (0.05%)
3.573 MB
3.605 MB
32.633 kB
AuditLog.Init
0.0000 (0%)
3.605 MB
3.625 MB
20.898 kB
Menu.Init
0.0000 (0%)
3.626 MB
3.655 MB
30.188 kB
Admin.Init
0.0001 (0.05%)
3.656 MB
3.748 MB
94.516 kB
Onboard.Init
0.0000 (0%)
3.748 MB
3.771 MB
23.008 kB
ImageProcessor.Init
0.0000 (0%)
3.771 MB
3.792 MB
21.492 kB
Import.Init
0.0000 (0%)
3.792 MB
3.813 MB
21.297 kB
Theme.Init
0.0005 (0.26%)
3.814 MB
3.838 MB
25.125 kB
FrontEnd.Init
0.0000 (0%)
3.838 MB
3.850 MB
11.961 kB
Pages.Init
0.0000 (0%)
3.851 MB
3.885 MB
35.148 kB
Widget.Init
0.0000 (0%)
3.885 MB
3.906 MB
20.930 kB
Membership.Init
0.0000 (0%)
3.906 MB
4.003 MB
99.195 kB
Geography.Init
0.0001 (0.05%)
4.003 MB
4.022 MB
19.266 kB
Payment.Init
0.0002 (0.1%)
4.022 MB
4.172 MB
153.250 kB
Taxes.Init
0.0000 (0%)
4.172 MB
4.187 MB
15.102 kB
Shipping.Init
0.0000 (0%)
4.188 MB
4.200 MB
12.953 kB
GiftCards.Init
0.0000 (0%)
4.201 MB
4.214 MB
13.938 kB
Promotions.Init
0.0001 (0.05%)
4.215 MB
4.242 MB
28.047 kB
Marketplaces.Init
0.0000 (0%)
4.242 MB
4.328 MB
88.211 kB
Suppliers.Init
0.0000 (0%)
4.329 MB
4.353 MB
25.000 kB
Ecommerce.Init
0.0000 (0%)
4.354 MB
4.392 MB
39.016 kB
ShoppingCart.Init
0.0000 (0%)
4.392 MB
4.440 MB
49.578 kB
Fulfillment.Init
0.0000 (0%)
4.441 MB
4.542 MB
103.703 kB
HQ.Init
0.0001 (0.05%)
4.542 MB
4.567 MB
25.398 kB
HelpDesk.Init
0.0000 (0%)
4.568 MB
4.588 MB
21.367 kB
CateringEvents.Init
0.0000 (0%)
4.589 MB
4.601 MB
12.313 kB
Venues.Init
0.0000 (0%)
4.601 MB
4.613 MB
12.281 kB
Weddings.Init
0.0000 (0%)
4.614 MB
4.626 MB
12.297 kB
Customapp.Boot
0.0000 (0%)
4.644 MB
4.645 MB
752.000 B
App.OnAppBoot
0.0017 (0.87%)
4.646 MB
4.916 MB
276.320 kB
View.Init
0.0010 (0.51%)
4.661 MB
4.886 MB
231.109 kB
View.Init.SetTheme
0.0000 (0%)
4.773 MB
4.854 MB
83.063 kB
View.Init.SetLayout
0.0001 (0.05%)
4.855 MB
4.884 MB
30.336 kB
App.InitAPIs
0.0009 (0.46%)
4.916 MB
4.917 MB
752.000 B
App.InitRoutes
0.0003 (0.15%)
4.917 MB
4.918 MB
752.000 B
App.InitExtensions
0.0032 (1.64%)
4.918 MB
5.426 MB
519.695 kB
Package.Core
0.0000 (0%)
4.919 MB
4.920 MB
792.000 B
Package.Render
0.0000 (0%)
4.920 MB
4.921 MB
792.000 B
Package.DataManager
0.0000 (0%)
4.921 MB
4.922 MB
800.000 B
Package.Menus
0.0000 (0%)
4.922 MB
4.923 MB
792.000 B
Package.Administration
0.0000 (0%)
4.923 MB
4.924 MB
800.000 B
Package.ImageProcessor
0.0000 (0%)
4.924 MB
4.925 MB
800.000 B
Package.FileManager
0.0000 (0%)
4.926 MB
4.926 MB
800.000 B
Package.Web
0.0000 (0%)
4.927 MB
4.927 MB
792.000 B
Package.Membership
0.0000 (0%)
4.928 MB
4.929 MB
800.000 B
Package.Geography
0.0000 (0%)
4.929 MB
4.930 MB
800.000 B
Package.Payment
0.0000 (0%)
4.930 MB
4.931 MB
792.000 B
Package.Ecommerce
0.0000 (0%)
4.931 MB
4.932 MB
800.000 B
Package.HQ
0.0000 (0%)
4.932 MB
4.933 MB
792.000 B
Package.HelpDesk
0.0000 (0%)
4.933 MB
4.934 MB
800.000 B
Package.FTT
0.0000 (0%)
4.934 MB
4.935 MB
792.000 B
Package.SCE
0.0000 (0%)
4.936 MB
4.936 MB
792.000 B
Provider.Profiler
0.0000 (0%)
4.937 MB
4.937 MB
800.000 B
Provider.Cryptography
0.0000 (0%)
4.938 MB
4.939 MB
800.000 B
Provider.CacheEngine
0.0000 (0%)
4.939 MB
4.940 MB
800.000 B
Provider.Cache
0.0000 (0%)
4.940 MB
4.941 MB
792.000 B
Provider.Cron
0.0000 (0%)
4.941 MB
4.942 MB
792.000 B
Provider.FileSystem
0.0000 (0%)
4.942 MB
4.943 MB
800.000 B
Provider.Queue
0.0000 (0%)
4.943 MB
4.946 MB
2.258 kB
Provider.Log
0.0000 (0%)
4.946 MB
4.947 MB
792.000 B
Provider.Registry
0.0000 (0%)
4.947 MB
4.948 MB
800.000 B
Provider.Module
0.0000 (0%)
4.948 MB
4.949 MB
792.000 B
Provider.PostOffice
0.0000 (0%)
4.949 MB
4.950 MB
800.000 B
Provider.Session
0.0000 (0%)
4.950 MB
4.951 MB
800.000 B
Provider.I18n
0.0000 (0%)
4.952 MB
4.953 MB
1.820 kB
Provider.Tools
0.0000 (0%)
4.954 MB
4.954 MB
792.000 B
Provider.TemplateEngine
0.0000 (0%)
4.955 MB
4.956 MB
800.000 B
Provider.View
0.0000 (0%)
4.956 MB
4.959 MB
2.625 kB
Provider.Assets
0.0000 (0%)
4.959 MB
4.960 MB
792.000 B
Provider.Notification
0.0000 (0%)
4.960 MB
4.961 MB
800.000 B
Provider.DataManager
0.0000 (0%)
4.961 MB
4.962 MB
800.000 B
Provider.AuditLog
0.0000 (0%)
4.962 MB
4.963 MB
800.000 B
Provider.Menu
0.0001 (0.05%)
4.963 MB
4.970 MB
6.469 kB
Provider.Admin
0.0000 (0%)
4.970 MB
4.972 MB
1.594 kB
Provider.Onboard
0.0000 (0%)
4.972 MB
4.973 MB
800.000 B
Provider.ImageProcessor
0.0000 (0%)
4.973 MB
4.974 MB
800.000 B
Provider.Import
0.0000 (0%)
4.974 MB
4.975 MB
792.000 B
Provider.Theme
0.0000 (0%)
4.975 MB
4.981 MB
5.828 kB
Provider.FrontEnd
0.0000 (0%)
4.981 MB
4.983 MB
1.898 kB
Provider.Pages
0.0000 (0%)
4.984 MB
4.988 MB
4.195 kB
Provider.Widget
0.0000 (0%)
4.988 MB
4.990 MB
1.594 kB
Provider.Membership
0.0019 (0.97%)
4.990 MB
4.992 MB
2.453 kB
Provider.Geography
0.0000 (0%)
4.993 MB
4.993 MB
800.000 B
Provider.Payment
0.0000 (0%)
4.994 MB
4.995 MB
808.000 B
Provider.Taxes
0.0000 (0%)
4.995 MB
4.996 MB
792.000 B
Provider.Shipping
0.0000 (0%)
4.996 MB
4.997 MB
800.000 B
Provider.GiftCards
0.0000 (0%)
4.997 MB
5.003 MB
6.273 kB
Provider.Promotions
0.0000 (0%)
5.004 MB
5.020 MB
16.852 kB
Provider.Marketplaces
0.0000 (0%)
5.020 MB
5.021 MB
800.000 B
Provider.Suppliers
0.0000 (0%)
5.022 MB
5.026 MB
4.516 kB
Provider.Ecommerce
0.0002 (0.1%)
5.026 MB
5.034 MB
7.508 kB
Provider.ShoppingCart
0.0000 (0%)
5.034 MB
5.036 MB
1.641 kB
Provider.Fulfillment
0.0000 (0%)
5.036 MB
5.038 MB
2.281 kB
Provider.HQ
0.0000 (0%)
5.039 MB
5.039 MB
800.000 B
Provider.HelpDesk
0.0000 (0%)
5.040 MB
5.042 MB
1.914 kB
Provider.CateringEvents
0.0000 (0%)
5.042 MB
5.044 MB
2.281 kB
Provider.Venues
0.0000 (0%)
5.045 MB
5.048 MB
3.391 kB
Provider.Weddings
0.0000 (0%)
5.048 MB
5.051 MB
3.031 kB
Customapp.OnAppRun
0.0000 (0%)
5.051 MB
5.052 MB
752.000 B
Module.Controls
0.0001 (0.05%)
5.053 MB
5.164 MB
114.367 kB
Module.Notes
0.0000 (0%)
5.165 MB
5.174 MB
9.844 kB
Module.Taxonomy
0.0000 (0%)
5.175 MB
5.184 MB
9.844 kB
Module.FileManager
0.0000 (0%)
5.185 MB
5.195 MB
10.930 kB
Module.Attachments
0.0000 (0%)
5.196 MB
5.205 MB
9.875 kB
Module.Images
0.0000 (0%)
5.206 MB
5.215 MB
9.859 kB
Module.Manufacturers
0.0000 (0%)
5.216 MB
5.226 MB
10.305 kB
Module.ProductReviews
0.0000 (0%)
5.226 MB
5.236 MB
10.570 kB
Module.ProductWaitlist
0.0000 (0%)
5.237 MB
5.249 MB
12.313 kB
Widget.PageBody
0.0000 (0%)
5.249 MB
5.276 MB
27.563 kB
Widget.Billboard
0.0000 (0%)
5.276 MB
5.287 MB
10.500 kB
Widget.Channels
0.0000 (0%)
5.287 MB
5.297 MB
10.492 kB
Widget.ChannelPages
0.0000 (0%)
5.298 MB
5.308 MB
10.508 kB
Widget.Code
0.0000 (0%)
5.308 MB
5.318 MB
9.867 kB
Widget.ContactForm
0.0000 (0%)
5.318 MB
5.328 MB
10.516 kB
Widget.ImageGallery
0.0000 (0%)
5.329 MB
5.339 MB
10.508 kB
Widget.Share
0.0000 (0%)
5.339 MB
5.350 MB
10.492 kB
Widget.Menu
0.0000 (0%)
5.350 MB
5.360 MB
10.492 kB
Widget.Popup
0.0000 (0%)
5.361 MB
5.371 MB
10.492 kB
Widget.RichEdit
0.0000 (0%)
5.371 MB
5.382 MB
10.492 kB
Widget.AccordionRichEdit
0.0000 (0%)
5.382 MB
5.392 MB
10.516 kB
Widget.ProductCarousel
0.0000 (0%)
5.393 MB
5.403 MB
10.508 kB
Widget.SplitScreenRichEdit
0.0000 (0%)
5.403 MB
5.415 MB
11.781 kB
Widget.FullScreenImageGallery
0.0000 (0%)
5.415 MB
5.425 MB
10.531 kB
App.Stack
0.1638 (83.91%)
5.426 MB
10.102 MB
4.676 MB
Router.Matchingroutes
0.0000 (0%)
5.444 MB
5.445 MB
968.000 B
FrontEnd.Call
0.0882 (45.18%)
5.446 MB
8.321 MB
2.875 MB
TemplateEngine.Initialize
0.0007 (0.36%)
7.959 MB
8.241 MB
288.914 kB
Render.Theme.Prepare
0.0003 (0.15%)
8.319 MB
8.340 MB
22.016 kB
Render.Blocks
0.0011 (0.56%)
8.417 MB
8.458 MB
41.867 kB
Render.Layout
0.0029 (1.49%)
8.458 MB
9.122 MB
679.883 kB
Render.Template
0.0667 (34.17%)
9.122 MB
9.992 MB
890.727 kB
Menu.GetMenu.Getentity.Mobile-menu
0.0026 (1.33%)
9.202 MB
9.338 MB
138.648 kB
Menu.GetMenu.Primary-menu
0.0275 (14.09%)
9.338 MB
9.667 MB
336.977 kB
Menu.GetMenu.Getentity.Primary-menu
0.0268 (13.73%)
9.339 MB
9.650 MB
318.477 kB
Menu.Render.Primary-menu
0.0025 (1.28%)
9.668 MB
9.683 MB
15.836 kB
Menu.FindCurrentItem.Primary-menu
0.0018 (0.92%)
9.681 MB
9.684 MB
3.141 kB
Menu.GetMenu.Footer-menu-1
0.0142 (7.27%)
9.676 MB
9.853 MB
181.563 kB
Menu.GetMenu.Getentity.Footer-menu-1
0.0138 (7.07%)
9.677 MB
9.846 MB
172.953 kB
Menu.Render.Footer-menu-1
0.0003 (0.15%)
9.854 MB
9.858 MB
4.477 kB
Menu.FindCurrentItem.Footer-menu-1
0.0000 (0%)
9.859 MB
9.860 MB
1.148 kB
Menu.GetMenu.Footer-menu-2
0.0144 (7.38%)
9.872 MB
10.016 MB
147.367 kB
Menu.GetMenu.Getentity.Footer-menu-2
0.0139 (7.12%)
9.873 MB
10.009 MB
139.938 kB
Menu.Render.Footer-menu-2
0.0003 (0.15%)
10.016 MB
10.020 MB
3.977 kB
Menu.FindCurrentItem.Footer-menu-2
0.0000 (0%)
10.021 MB
10.022 MB
1.148 kB
Render.Hooks
0.0001 (0.05%)
10.005 MB
10.030 MB
24.734 kB
Opcode Cache
Enabled: Yes
Memory: 127.96 MB / 128.00 MB (0.00 B wasted)
Hits: 212160028 (91.91%)
Misses: 18658236
Scripts: 2960
Cache Engine
Enabled: Yes
Engine: Redis (3.2.10)
Objects: 648
Memory: 11.52 MB
Hits: 2816026075
Misses: 32422071
Database
Queries: 17 (0.0211)

0.0006 (0)


SELECT URL.target_name AS TargetName, URL.path AS Path FROM DM_URLs URL WHERE URL.target_type = 'entity' AND ( URL.target_name = 'MemberHomePage' OR URL.target_name = 'MemberProfilePage' OR URL.target_name = 'MemberSignInPage' OR URL.target_name = 'MemberSignUpPage' OR URL.target_name = 'MemberActivatePage' OR URL.target_name = 'MemberResetPasswordPage' OR URL.target_name = 'MemberForgotPasswordPage');
0.0007 (1)


SELECT URL.url_id AS URLId, URL.path AS Path, URL.target_type AS TargetType, URL.target_name AS TargetName FROM DM_URLs URL WHERE URL.path = 'wine-dine';
0.0007 (1)


SELECT URL.url_id AS "Id", PageURL.page_id AS "PageId", PageURL.path AS "Path", URL.path AS "FullPath", URL.target_type AS "TargetType", URL.target_name AS "TargetName", PageURL.is_default AS "Default", UNIX_TIMESTAMP(PageURL.modified) AS "Modified", URL.modified_by AS "ModifiedBy", UNIX_TIMESTAMP(PageURL.created) AS "Created", URL.created_by AS "CreatedBy", URL.cue_source AS "CueSource", URL.cue_source_id AS "CueSourceId", URL.cue_ver AS "CueVersion" FROM DM_URLs URL JOIN Web_PagesURLs PageURL ON PageURL.url_id = URL.url_id WHERE URL.url_id = '74';
0.0022 (1)


SELECT Page.page_id AS "Id", Page.entity AS "Entity", Page.title AS "Title", Page.subtitle AS "Subtitle", Page.title_tag AS "TitleTag", Page.body_class AS "BodyClass", Page.meta_description AS "MetaDescription", Page.meta_robots AS "MetaRobots", Page.body AS "Body", Page.excerpt AS "Excerpt", Page.search_public_keywords AS "PublicSearchKeywords", Page.javascript AS "JavaScript", Page.stylesheet AS "StyleSheet", Page.exclude_sitemap AS "ExcludeSitemap", Page.exclude_widgets AS "ExcludeWidgets", Page.exclude_search AS "ExcludeSearch", Page.require_ssl AS "RequireSSL", Page.require_signin AS "RequireSignIn", Page.can_cache AS "CanCache", Page.is_system_page AS "IsSystemPage", Page.sort_order AS "SortOrder", Page.image_id AS "Image", Page.author_id AS "Author", Page.status_id AS "Status", UNIX_TIMESTAMP(Page.status_date) AS "StatusDate", Page.channel_id AS "Channel", DefaultLayout.layout_code AS "DefaultLayout", DefaultURL.url_id AS "DefaultURLId", DefaultURL.path AS "DefaultURL", DefaultFullURL.path AS "DefaultFullURL", LOWER(CONCAT('Product/', Page.page_id)) AS "Permalink", UNIX_TIMESTAMP(Page.modified) AS "Modified", Page.modified_by AS "ModifiedBy", UNIX_TIMESTAMP(Page.created) AS "Created", Page.created_by AS "CreatedBy", Page.cue_source AS "CueSource", Page.cue_source_id AS "CueSourceId", Page.cue_ver AS "CueVersion", Product.product_id AS "ProductId", Product.manufacturer_id AS "Manufacturer", Product.sku AS "SKU", Product.part_no AS "PartNo", Product.barcode AS "Barcode", Product.serial_no AS "SerialNo", Product.product_type AS "ProductType", Product.physical_condition AS "Condition", Product.regular_price AS "RegularPrice", Product.sale_price AS "SalePrice", (SELECT MAX(adjusted_cost) FROM Ecom_SuppliersProducts WHERE product_id = Page.page_id AND is_active = 1) AS "MinimumPrice", Product.msrp_price AS "MSRP", Product.map_price AS "MAPPrice", (SELECT IF(quantity = 0, MAX(cost_price), SUM(cost_price * quantity) / SUM(quantity)) FROM Ecom_SuppliersProducts WHERE product_id = Page.page_id AND is_active = 1) AS "Cost", Product.is_taxable AS "Taxable", Product.tax_class_id AS "TaxClass", Product.dimension_width AS "DimensionWidth", Product.dimension_width_unit AS "DimensionWidthUnit", Product.dimension_length AS "DimensionLength", Product.dimension_length_unit AS "DimensionLengthUnit", Product.dimension_height AS "DimensionHeight", Product.dimension_height_unit AS "DimensionHeightUnit", Product.weight AS "Weight", Product.weight_unit AS "WeightUnit", Product.shipping_fee AS "ShippingFee", Product.shipping_value AS "ShippingValue", Product.track_inventory AS "TrackInventory", Product.track_variant_inventory AS "TrackVariantInventory", (SELECT SUM(quantity) FROM Ecom_SuppliersProducts WHERE product_id = Page.page_id AND is_active = 1 GROUP BY product_id) AS "QuantityOnHand", (SELECT SUM(quantity) FROM Ecom_ProductsAllocations WHERE product_id = Page.page_id GROUP BY product_id) AS "QuantityAllocated", (

SELECT SUM(SupplierProduct.quantity) - IF(Allocation.quantity IS NULL, 0, Allocation.quantity) FROM Ecom_SuppliersProducts SupplierProduct LEFT JOIN (

SELECT product_id, SUM(quantity) AS quantity FROM Ecom_ProductsAllocations GROUP BY product_id ) Allocation ON Allocation.product_id = SupplierProduct.product_id WHERE SupplierProduct.product_id = Page.page_id AND SupplierProduct.is_active = 1 GROUP BY SupplierProduct.product_id ) AS "Quantity", Product.location_bin AS "LocationBin", Product.review_count AS "ReviewCount", Product.average_rating AS "AverageRating", Product.allow_backorders AS "AllowBackorders", Product.availability AS "Availability", Product.sales_rank AS "SalesRank", Product.is_new AS "New", Product.is_coming_soon AS "ComingSoon", Product.is_exclusive AS "Exclusive", Product.is_featured AS "Featured", Product.custom_flag_1 AS "CustomFlag1", Product.custom_flag_2 AS "CustomFlag2", Product.custom_flag_3 AS "CustomFlag3", Product.custom_flag_4 AS "CustomFlag4", Product.custom_flag_5 AS "CustomFlag5", Product.custom_field_1 AS "CustomField1", Product.custom_field_2 AS "CustomField2", Product.custom_field_3 AS "CustomField3", Product.custom_field_4 AS "CustomField4", Product.custom_field_5 AS "CustomField5", Product.custom_field_6 AS "CustomField6", Product.custom_field_7 AS "CustomField7", Product.custom_field_8 AS "CustomField8", Product.custom_field_9 AS "CustomField9", Product.custom_field_10 AS "CustomField10", (SELECT COUNT(1) FROM Ecom_ProductsVariants WHERE product_id = Page.page_id AND is_active = 1) AS "VariantCount" FROM Web_Pages Page LEFT JOIN Web_PagesLayouts DefaultLayout ON DefaultLayout.page_id = Page.page_id AND DefaultLayout.is_default = 1 LEFT JOIN Web_PagesURLs DefaultURL ON DefaultURL.page_id = Page.page_id AND DefaultURL.is_default = 1 LEFT JOIN DM_URLs DefaultFullURL ON DefaultFullURL.url_id = DefaultURL.url_id JOIN Ecom_Products Product ON Product.page_id = Page.page_id LEFT JOIN DM_Statuses Status ON Status.status_id = Page.status_id WHERE Page.page_id = 88 AND Status.is_public = true AND UNIX_TIMESTAMP(Page.status_date) <= 1664749304;
0.0059 (10)


SELECT DISTINCT Widget.widget_id AS "Id", Widget.widget_code AS "Code", Widget.admin_title AS "Title", Widget.default_region AS "DefaultRegion", Widget.properties AS "Properties", UNIX_TIMESTAMP(Widget.effective_on) AS "EffectiveOn", UNIX_TIMESTAMP(Widget.expires_on) AS "ExpiresOn", Widget.show_not_signed_in AS "ShowNotSignedIn", Widget.show_signed_in AS "ShowSignedIn", Widget.can_cache AS "CanCache", Widget.is_active AS "Active", UNIX_TIMESTAMP(Widget.modified) AS "Modified", Widget.modified_by AS "ModifiedBy.Id", UNIX_TIMESTAMP(Widget.created) AS "Created", Widget.created_by AS "CreatedBy.Id", Widget.cue_source AS "CueSource", Widget.cue_source_id AS "CueSourceId", Widget.cue_ver AS "CueVersion", WidgetPage.region AS "Region" FROM Web_WidgetsPages WidgetPage JOIN Web_Widgets Widget ON Widget.widget_id = WidgetPage.widget_id WHERE ( Widget.widget_id IN (SELECT widget_id FROM Web_WidgetsChannels WHERE channel_id = '0') OR Widget.widget_id IN (SELECT widget_id FROM Web_WidgetsEntities WHERE entity_name = 'Product') OR WidgetPage.page_id = '88' ) AND ( Widget.widget_id NOT IN (SELECT widget_id FROM Web_WidgetsPages WHERE page_id = '88' AND excluded = 1) ) ORDER BY WidgetPage.sort_order ASC;

SELECT MediaFile.media_file_id AS "Id", MediaFile.media_type AS "MediaType", MediaFile.title AS "Title", MediaFile.version AS "Version", MediaFile.description AS "Description", MediaFile.filename AS "Filename", MediaFile.path AS "Path", MediaFile.target_file AS "File", MediaFile.file_bytes AS "FileBytes", CONCAT(MediaFile.path, MediaFile.target_file) AS "FileURL", MediaFile.hash AS "Hash", MediaFile.mime_type AS "MimeType", MediaFile.show_in_media AS "ShowInMedia", UNIX_TIMESTAMP(MediaFile.status_date) AS "StatusDate", MediaFile.status_id AS "Status", UNIX_TIMESTAMP(MediaFile.modified) AS "Modified", MediaFile.modified_by AS "ModifiedBy", UNIX_TIMESTAMP(MediaFile.created) AS "Created", MediaFile.created_by AS "CreatedBy", MediaFile.cue_source AS "CueSource", MediaFile.cue_source_id AS "CueSourceId", MediaFile.cue_ver AS "CueVersion", ImageFile.alt_text AS "AltText", ImageFile.source_width AS "SourceWidth", ImageFile.source_height AS "SourceHeight", ImageFile.micro_filename AS "MicroFilename", ImageFile.micro_width AS "MicroWidth", ImageFile.micro_height AS "MicroHeight", ImageFile.micro_bytes AS "MicroBytes", CONCAT(MediaFile.path, ImageFile.micro_filename) AS "MicroURL", ImageFile.thumbnail_filename AS "ThumbnailFilename", ImageFile.thumbnail_width AS "ThumbnailWidth", ImageFile.thumbnail_height AS "ThumbnailHeight", ImageFile.thumbnail_bytes AS "ThumbnailBytes", CONCAT(MediaFile.path, ImageFile.thumbnail_filename) AS "ThumbnailURL", ImageFile.small_filename AS "SmallFilename", ImageFile.small_width AS "SmallWidth", ImageFile.small_height AS "SmallHeight", ImageFile.small_bytes AS "SmallBytes", CONCAT(MediaFile.path, ImageFile.small_filename) AS "SmallURL", ImageFile.medium_filename AS "MediumFilename", ImageFile.medium_width AS "MediumWidth", ImageFile.medium_height AS "MediumHeight", ImageFile.medium_bytes AS "MediumBytes", CONCAT(MediaFile.path, ImageFile.medium_filename) AS "MediumURL", ImageFile.large_filename AS "LargeFilename", ImageFile.large_width AS "LargeWidth", ImageFile.large_height AS "LargeHeight", ImageFile.large_bytes AS "LargeBytes", CONCAT(MediaFile.path, ImageFile.large_filename) AS "LargeURL" FROM FM_MediaFiles MediaFile LEFT JOIN FM_ImageFiles ImageFile ON ImageFile.media_file_id = MediaFile.media_file_id WHERE MediaFile.media_file_id = '270';

SELECT Status.status_id AS "Id", Status.entity_name AS "Entity", Status.label AS "Label", Status.is_entity_active AS "EntityIsActive", Status.is_entity_inactive AS "EntityIsInactive", Status.is_default AS "Default", Status.is_public AS "Public", Status.is_active AS "Active", Status.sort_order AS "SortOrder", Status.modified AS "Modified", Status.modified_by AS "ModifiedBy", Status.created AS "Created", Status.created_by AS "CreatedBy", Status.cue_source AS "CueSource", Status.cue_source_id AS "CueSourceId", Status.cue_ver AS "CueVersion" FROM DM_Statuses Status WHERE Status.status_id = '27';

SELECT ChannelLite.page_id AS "Id", ChannelLite.channel_id AS "ChannelId", ChannelLite.title AS "Title", ChannelStatus.is_public AS "Public", ChannelDefaultURL.path AS "DefaultURL", DefaultFullURL.path AS "DefaultFullURL", Channel.page_entity AS "PageEntity", Channel.default_page_layout AS "DefaultPageLayout", Channel.sort_property AS "SortProperty", Channel.pages_per_index AS "PagesPerIndex", Channel.show_full_content AS "ShowFullContent", Channel.words_per_excerpt AS "WordsPerExcerpt", CONCAT_WS('/', MediaFile.path, ImageFile.thumbnail_filename) AS "ImageThumbnailURL", CONCAT_WS('/', MediaFile.path, ImageFile.small_filename) AS "ImageSmallURL", CONCAT_WS('/', MediaFile.path, ImageFile.medium_filename) AS "ImageMediumURL", CONCAT_WS('/', MediaFile.path, ImageFile.large_filename) AS "ImageLargeURL" FROM Web_Pages ChannelLite JOIN DM_Statuses ChannelStatus ON ChannelStatus.status_id = ChannelLite.status_id LEFT JOIN Web_PagesURLs ChannelDefaultURL ON ChannelDefaultURL.page_id = ChannelLite.page_id AND ChannelDefaultURL.is_default = 1 LEFT JOIN DM_URLs DefaultFullURL ON DefaultFullURL.url_id = ChannelDefaultURL.url_id JOIN Web_Channels Channel ON Channel.page_id = ChannelLite.page_id LEFT JOIN FM_MediaFiles MediaFile ON MediaFile.media_file_id = ChannelLite.image_id LEFT JOIN FM_ImageFiles ImageFile ON ImageFile.media_file_id = ChannelLite.image_id WHERE ChannelLite.page_id = '0';

SELECT PageAttachment.page_attachment_id AS "Id", PageAttachment.page_id AS "PageId", PageAttachment.media_file_id AS "MediaFileId", PageAttachment.tag_class AS "TagClass", PageAttachment.sort_order AS "SortOrder", MediaFile.media_type AS "MediaType", MediaFile.title AS "Title", MediaFile.version AS "Version", MediaFile.description AS "Description", MediaFile.filename AS "Filename", MediaFile.path AS "Path", MediaFile.target_file AS "File", MediaFile.file_bytes AS "FileBytes", CONCAT(MediaFile.path, MediaFile.target_file) AS "FileURL", MediaFile.mime_type AS "MimeType", UNIX_TIMESTAMP(MediaFile.status_date) AS "StatusDate", MediaFile.status_id AS "Status", UNIX_TIMESTAMP(PageAttachment.modified) AS "Modified", PageAttachment.modified_by AS "ModifiedBy", UNIX_TIMESTAMP(PageAttachment.created) AS "Created", PageAttachment.created_by AS "CreatedBy", PageAttachment.cue_source AS "CueSource", PageAttachment.cue_source_id AS "CueSourceId", PageAttachment.cue_ver AS "CueVersion" FROM Web_PagesAttachments PageAttachment JOIN FM_MediaFiles MediaFile ON MediaFile.media_file_id = PageAttachment.media_file_id WHERE PageAttachment.page_id = 88;

SELECT PageCategory.page_category_id AS "Id", PageCategory.page_id AS "PageId", PageCategory.taxonomy_id AS "TaxonomyId", Taxonomy.label AS "Label", Taxonomy.description AS "Description", UNIX_TIMESTAMP(PageCategory.modified) AS "Modified", PageCategory.modified_by AS "ModifiedBy", UNIX_TIMESTAMP(PageCategory.created) AS "Created", PageCategory.created_by AS "CreatedBy", PageCategory.cue_source AS "CueSource", PageCategory.cue_source_id AS "CueSourceId", PageCategory.cue_ver AS "CueVersion" FROM Web_PagesCategories PageCategory JOIN DM_Taxonomies Taxonomy ON Taxonomy.taxonomy_id = PageCategory.taxonomy_id WHERE PageCategory.page_id = 88 ORDER BY Taxonomy.label ASC;

SELECT PageImage.page_image_id AS "Id", PageImage.page_id AS "PageId", PageImage.media_file_id AS "MediaFileId", PageImage.tag_id AS "TagId", PageImage.tag_class AS "TagClass", PageImage.sort_order AS "SortOrder", MediaFile.media_type AS "MediaType", MediaFile.title AS "Title", MediaFile.version AS "Version", MediaFile.description AS "Description", MediaFile.filename AS "Filename", MediaFile.path AS "Path", MediaFile.target_file AS "File", MediaFile.file_bytes AS "FileBytes", CONCAT(MediaFile.path, MediaFile.target_file) AS "FileURL", MediaFile.mime_type AS "MimeType", ImageFile.alt_text AS "AltText", ImageFile.source_width AS "SourceWidth", ImageFile.source_height AS "SourceHeight", ImageFile.micro_filename AS "MicroFilename", ImageFile.micro_width AS "MicroWidth", ImageFile.micro_height AS "MicroHeight", ImageFile.micro_bytes AS "MicroBytes", CONCAT(MediaFile.path, ImageFile.micro_filename) AS "MicroURL", ImageFile.thumbnail_filename AS "ThumbnailFilename", ImageFile.thumbnail_width AS "ThumbnailWidth", ImageFile.thumbnail_height AS "ThumbnailHeight", ImageFile.thumbnail_bytes AS "ThumbnailBytes", CONCAT(MediaFile.path, ImageFile.thumbnail_filename) AS "ThumbnailURL", ImageFile.small_filename AS "SmallFilename", ImageFile.small_width AS "SmallWidth", ImageFile.small_height AS "SmallHeight", ImageFile.small_bytes AS "SmallBytes", CONCAT(MediaFile.path, ImageFile.small_filename) AS "SmallURL", ImageFile.medium_filename AS "MediumFilename", ImageFile.medium_width AS "MediumWidth", ImageFile.medium_height AS "MediumHeight", ImageFile.medium_bytes AS "MediumBytes", CONCAT(MediaFile.path, ImageFile.medium_filename) AS "MediumURL", ImageFile.large_filename AS "LargeFilename", ImageFile.large_width AS "LargeWidth", ImageFile.large_height AS "LargeHeight", ImageFile.large_bytes AS "LargeBytes", CONCAT(MediaFile.path, ImageFile.large_filename) AS "LargeURL", UNIX_TIMESTAMP(MediaFile.status_date) AS "StatusDate", MediaFile.status_id AS "Status", UNIX_TIMESTAMP(PageImage.modified) AS "Modified", PageImage.modified_by AS "ModifiedBy", UNIX_TIMESTAMP(PageImage.created) AS "Created", PageImage.created_by AS "CreatedBy", PageImage.cue_source AS "CueSource", PageImage.cue_source_id AS "CueSourceId", PageImage.cue_ver AS "CueVersion" FROM Web_PagesImages PageImage LEFT JOIN FM_MediaFiles MediaFile ON MediaFile.media_file_id = PageImage.media_file_id LEFT JOIN FM_ImageFiles ImageFile ON ImageFile.media_file_id = PageImage.media_file_id WHERE PageImage.page_id = 88 ORDER BY PageImage.sort_order ASC;

SELECT PageTag.page_tag_id AS "Id", PageTag.page_id AS "PageId", PageTag.taxonomy_id AS "TaxonomyId", Taxonomy.label AS "Label", Taxonomy.description AS "Description", UNIX_TIMESTAMP(PageTag.modified) AS "Modified", PageTag.modified_by AS "ModifiedBy", UNIX_TIMESTAMP(PageTag.created) AS "Created", PageTag.created_by AS "CreatedBy", PageTag.cue_source AS "CueSource", PageTag.cue_source_id AS "CueSourceId", PageTag.cue_ver AS "CueVersion" FROM Web_PagesTags PageTag JOIN DM_Taxonomies Taxonomy ON Taxonomy.taxonomy_id = PageTag.taxonomy_id WHERE PageTag.page_id = 88 ORDER BY Taxonomy.label ASC;

SELECT URL.url_id AS "Id", PageURL.page_id AS "PageId", PageURL.path AS "Path", URL.path AS "FullPath", URL.target_type AS "TargetType", URL.target_name AS "TargetName", PageURL.is_default AS "Default", UNIX_TIMESTAMP(PageURL.modified) AS "Modified", URL.modified_by AS "ModifiedBy", UNIX_TIMESTAMP(PageURL.created) AS "Created", URL.created_by AS "CreatedBy", URL.cue_source AS "CueSource", URL.cue_source_id AS "CueSourceId", URL.cue_ver AS "CueVersion" FROM DM_URLs URL JOIN Web_PagesURLs PageURL ON PageURL.url_id = URL.url_id WHERE PageURL.page_id = 88 ORDER BY PageURL.is_default DESC;

SELECT Author.admin_user_id AS "Id", Author.first_name AS "FirstName", Author.last_name AS "LastName", Author.email AS "Email", TRIM(CONCAT(Author.first_name, ' ', Author.last_name, IF(Author.suffix <> '', CONCAT(' ', Author.suffix), ''))) AS "DisplayFirstLast", TRIM(CONCAT(Author.last_name, ', ', Author.first_name, IF(Author.suffix <> '', CONCAT(' ', Author.suffix), ''))) AS "DisplayLastFirst" FROM DM_AdminUsers Author WHERE Author.admin_user_id = '8';

SELECT Author.admin_user_id AS "Id", Author.first_name AS "FirstName", Author.last_name AS "LastName", Author.email AS "Email", TRIM(CONCAT(Author.first_name, ' ', Author.last_name, IF(Author.suffix <> '', CONCAT(' ', Author.suffix), ''))) AS "DisplayFirstLast", TRIM(CONCAT(Author.last_name, ', ', Author.first_name, IF(Author.suffix <> '', CONCAT(' ', Author.suffix), ''))) AS "DisplayLastFirst" FROM DM_AdminUsers Author WHERE Author.admin_user_id = '8';

SELECT Manufacturer.page_id AS "Id", Manufacturer.title AS "Title", Status.Label AS "Status", UNIX_TIMESTAMP(Manufacturer.modified) AS "Modified", UNIX_TIMESTAMP(Manufacturer.created) AS "Created", CONCAT('page/', Manufacturer.page_id) AS "Permalink", DefaultURL.path AS "DefaultURL", DefaultFullURL.path AS "DefaultFullURL" FROM Web_Pages Manufacturer JOIN DM_Statuses Status ON Status.status_id = Manufacturer.status_id LEFT JOIN Web_PagesURLs DefaultURL ON DefaultURL.page_id = Manufacturer.page_id AND DefaultURL.is_default = 1 JOIN DM_URLs DefaultFullURL ON DefaultFullURL.url_id = DefaultURL.url_id WHERE Manufacturer.page_id = '85';

SELECT TaxClass.tax_class_id AS "Id", TaxClass.class_type AS "ClassType", TaxClass.name AS "Name", TaxClass.is_taxable AS "Taxable", TaxClass.is_default AS "Default", TaxClass.is_active AS "Active", UNIX_TIMESTAMP(TaxClass.modified) AS "Modified", TaxClass.modified_by AS "ModifiedBy", UNIX_TIMESTAMP(TaxClass.created) AS "Created", TaxClass.created_by AS "CreatedBy", TaxClass.cue_source AS "CueSource", TaxClass.cue_source_id AS "CueSourceId", TaxClass.cue_ver AS "CueVersion" FROM Ecom_TaxClasses TaxClass WHERE TaxClass.tax_class_id = '7';

SELECT ProductFeature.product_feature_id AS "Id", ProductFeature.product_id AS "ProductId", ProductFeature.feature AS "Feature", ProductFeature.sort_order AS "SortOrder", UNIX_TIMESTAMP(ProductFeature.modified) AS "Modified", ProductFeature.modified_by AS "ModifiedBy", UNIX_TIMESTAMP(ProductFeature.created) AS "Created", ProductFeature.created_by AS "CreatedBy", ProductFeature.cue_source AS "CueSource", ProductFeature.cue_source_id AS "CueSourceId", ProductFeature.cue_ver AS "CueVersion" FROM Ecom_ProductsFeatures ProductFeature WHERE ProductFeature.product_id = 88 ORDER BY ProductFeature.sort_order ASC;

SELECT ProductOption.product_option_id AS "Id", ProductOption.product_id AS "ProductId", ProductOption.product_option_label_id AS "ProductOptionLabelId", ProductOptionLabel.label AS "Label", GROUP_CONCAT(CONCAT(ProductOptionValue.product_option_value_id, '=', ProductOptionValue.value) ORDER BY POLV.sort_order SEPARATOR '|') AS "Values", ProductOption.sort_order AS "SortOrder", UNIX_TIMESTAMP(ProductOption.modified) AS "Modified", ProductOption.modified_by AS "ModifiedBy", UNIX_TIMESTAMP(ProductOption.created) AS "Created", ProductOption.created_by AS "CreatedBy", ProductOption.cue_source AS "CueSource", ProductOption.cue_source_id AS "CueSourceId", ProductOption.cue_ver AS "CueVersion" FROM Ecom_ProductsOptions ProductOption LEFT JOIN Ecom_ProductOptionLabels ProductOptionLabel ON ProductOptionLabel.product_option_label_id = ProductOption.product_option_label_id LEFT JOIN Ecom_ProductsOptionsLabelsValues POLV ON POLV.product_option_label_id = ProductOption.product_option_label_id AND POLV.product_id = ProductOption.product_id LEFT JOIN Ecom_ProductOptionValues ProductOptionValue ON ProductOptionValue.product_option_value_id = POLV.product_option_value_id WHERE ProductOption.product_id = 88 GROUP BY ProductOption.product_option_label_id ORDER BY ProductOption.sort_order ASC, ProductOption.sort_order ASC;

SELECT RelatedProduct.product_related_id AS "Id", RelatedProduct.product_id AS "ProductId", RelatedProduct.related_product_id AS "RelatedProductId", RelPage.title AS "Title", RelProduct.sku AS "SKU", RelatedProduct.sort_order AS "SortOrder", CONCAT(MediaFile.path, ImageFile.thumbnail_filename) AS "ThumbnailURL", UNIX_TIMESTAMP(RelatedProduct.modified) AS "Modified", RelatedProduct.modified_by AS "ModifiedBy", UNIX_TIMESTAMP(RelatedProduct.created) AS "Created", RelatedProduct.created_by AS "CreatedBy", RelatedProduct.cue_source AS "CueSource", RelatedProduct.cue_source_id AS "CueSourceId", RelatedProduct.cue_ver AS "CueVersion" FROM Ecom_ProductsRelated RelatedProduct JOIN Web_Pages RelPage ON RelPage.page_id = RelatedProduct.related_product_id LEFT JOIN FM_MediaFiles MediaFile ON MediaFile.media_file_id = RelPage.image_id LEFT JOIN FM_ImageFiles ImageFile ON ImageFile.media_file_id = RelPage.image_id JOIN Ecom_Products RelProduct ON RelProduct.page_id = RelatedProduct.related_product_id WHERE RelatedProduct.product_id = 88 ORDER BY RelatedProduct.sort_order ASC;

SELECT ProductReview.product_review_id AS "Id", ProductReview.product_id AS "ProductId", Page.title AS "ProductTitle", Product.sku AS "ProductSKU", ProductReview.rating AS "Rating", ProductReview.customer_name AS "CustomerName", ProductReview.customer_email AS "CustomerEmail", ProductReview.subject AS "Subject", ProductReview.body AS "Body", ProductReview.is_active AS "Active", UNIX_TIMESTAMP(ProductReview.modified) AS "Modified", ProductReview.modified_by AS "ModifiedBy", UNIX_TIMESTAMP(ProductReview.created) AS "Created", ProductReview.created_by AS "CreatedBy", ProductReview.cue_source AS "CueSource", ProductReview.cue_source_id AS "CueSourceId", ProductReview.cue_ver AS "CueVersion" FROM Ecom_ProductsReviews ProductReview JOIN Web_Pages Page ON Page.page_id = ProductReview.product_id JOIN Ecom_Products Product ON Product.page_id = ProductReview.product_id WHERE ProductReview.product_id = 88 ORDER BY ProductReview.created DESC;

SELECT ProductSpecification.product_specification_id AS "Id", ProductSpecification.product_id AS "ProductId", ProductSpecification.product_attribute_id AS "ProductAttributeId", ProductSpecification.product_attribute_value_id AS "ProductAttributeValueId", ProductAttribute.label AS "Label", ProductAttributeValue.value AS "Value", ProductSpecification.sort_order AS "SortOrder", UNIX_TIMESTAMP(ProductSpecification.modified) AS "Modified", ProductSpecification.modified_by AS "ModifiedBy", UNIX_TIMESTAMP(ProductSpecification.created) AS "Created", ProductSpecification.created_by AS "CreatedBy", ProductSpecification.cue_source AS "CueSource", ProductSpecification.cue_source_id AS "CueSourceId", ProductSpecification.cue_ver AS "CueVersion" FROM Ecom_ProductsSpecifications ProductSpecification JOIN Ecom_ProductAttributes ProductAttribute ON ProductAttribute.product_attribute_id = ProductSpecification.product_attribute_id JOIN Ecom_ProductAttributesValues ProductAttributeValue ON ProductAttributeValue.product_attribute_value_id = ProductSpecification.product_attribute_value_id WHERE ProductSpecification.product_id = 88 ORDER BY ProductSpecification.sort_order ASC;
0.0019 (3)


SELECT SQL_CALC_FOUND_ROWS ProductVariant.product_variant_id AS "Id", ProductVariant.product_id AS "ProductId", ProductVariant.title AS "Title", ProductVariant.sku AS "SKU", ProductVariant.part_no AS "PartNo", ProductVariant.barcode AS "Barcode", ProductVariant.use_default_pricing AS "UseDefaultPricing", ProductVariant.regular_price_type AS "RegularPriceType", ProductVariant.regular_price_modifier AS "RegularPriceModifier", ProductVariant.regular_price AS "RegularPrice", Product.regular_price AS "ProductRegularPrice", ProductVariant.sale_price_type AS "SalePriceType", ProductVariant.sale_price_modifier AS "SalePriceModifier", ProductVariant.sale_price AS "SalePrice", Product.sale_price AS "ProductSalePrice", ProductVariant.msrp_type AS "MSRPType", ProductVariant.msrp_modifier AS "MSRPModifier", ProductVariant.msrp_price AS "MSRP", Product.msrp_price AS "ProductMSRP", ProductVariant.cost_type AS "CostType", ProductVariant.cost_modifier AS "CostModifier", ProductVariant.cost_price AS "Cost", (SELECT IF(quantity = 0, MAX(cost_price), SUM(cost_price * quantity) / SUM(quantity)) FROM Ecom_SuppliersProducts WHERE product_id = Product.page_id AND is_active = 1) AS "ProductCost", ProductVariant.use_default_shipping AS "UseDefaultShipping", ProductVariant.dimension_width AS "DimensionWidth", ProductVariant.dimension_width_unit AS "DimensionWidthUnit", Product.dimension_width AS "ProductDimensionWidth", Product.dimension_width_unit AS "ProductDimensionWidthUnit", ProductVariant.dimension_length AS "DimensionLength", ProductVariant.dimension_length_unit AS "DimensionLengthUnit", Product.dimension_length AS "ProductDimensionLength", Product.dimension_length_unit AS "ProductDimensionLengthUnit", ProductVariant.dimension_height AS "DimensionHeight", ProductVariant.dimension_height_unit AS "DimensionHeightUnit", Product.dimension_height AS "ProductDimensionHeight", Product.dimension_height_unit AS "ProductDimensionHeightUnit", ProductVariant.weight AS "Weight", ProductVariant.weight_unit AS "WeightUnit", Product.weight AS "ProductWeight", Product.weight_unit AS "ProductWeightUnit", ProductVariant.shipping_fee AS "ShippingFee", ProductVariant.shipping_value AS "ShippingValue", Product.shipping_fee AS "ProductShippingFee", Product.shipping_value AS "ProductShippingValue", Product.track_variant_inventory AS "ProductTrackVariantInventory", (SELECT SUM(quantity) FROM Ecom_SuppliersProducts WHERE product_variant_id = ProductVariant.product_variant_id AND is_active = 1 GROUP BY product_variant_id) AS "QuantityOnHand", (SELECT SUM(quantity) FROM Ecom_ProductsAllocations WHERE product_variant_id = ProductVariant.product_variant_id GROUP BY product_variant_id) AS "QuantityAllocated", (

SELECT SUM(SupplierProduct.quantity) - IF(Allocation.quantity IS NULL, 0, Allocation.quantity) FROM Ecom_SuppliersProducts SupplierProduct LEFT JOIN (

SELECT product_variant_id, SUM(quantity) AS quantity FROM Ecom_ProductsAllocations GROUP BY product_variant_id ) Allocation ON Allocation.product_variant_id = SupplierProduct.product_variant_id WHERE SupplierProduct.product_variant_id = ProductVariant.product_variant_id AND SupplierProduct.is_active = 1 GROUP BY SupplierProduct.product_variant_id ) AS "Quantity", ProductVariant.image_id AS "Image", ProductVariant.sort_order AS "SortOrder", ProductVariant.is_active AS "Active", ProductVariant.settings AS "Settings", UNIX_TIMESTAMP(ProductVariant.modified) AS "Modified", ProductVariant.modified_by AS "ModifiedBy", UNIX_TIMESTAMP(ProductVariant.created) AS "Created", ProductVariant.created_by AS "CreatedBy", ProductVariant.cue_source AS "CueSource", ProductVariant.cue_source_id AS "CueSourceId", ProductVariant.cue_ver AS "CueVersion" FROM Ecom_ProductsVariants ProductVariant JOIN Ecom_Products Product ON Product.page_id = ProductVariant.product_id WHERE ProductVariant.product_id = 88 AND ProductVariant.is_active = true;

SELECT FOUND_ROWS() AS `Rows`;
0.0013 (3)


SELECT MediaFile.media_file_id AS "Id", MediaFile.media_type AS "MediaType", MediaFile.title AS "Title", MediaFile.version AS "Version", MediaFile.description AS "Description", MediaFile.filename AS "Filename", MediaFile.path AS "Path", MediaFile.target_file AS "File", MediaFile.file_bytes AS "FileBytes", CONCAT(MediaFile.path, MediaFile.target_file) AS "FileURL", MediaFile.hash AS "Hash", MediaFile.mime_type AS "MimeType", MediaFile.show_in_media AS "ShowInMedia", UNIX_TIMESTAMP(MediaFile.status_date) AS "StatusDate", MediaFile.status_id AS "Status", UNIX_TIMESTAMP(MediaFile.modified) AS "Modified", MediaFile.modified_by AS "ModifiedBy", UNIX_TIMESTAMP(MediaFile.created) AS "Created", MediaFile.created_by AS "CreatedBy", MediaFile.cue_source AS "CueSource", MediaFile.cue_source_id AS "CueSourceId", MediaFile.cue_ver AS "CueVersion", ImageFile.alt_text AS "AltText", ImageFile.source_width AS "SourceWidth", ImageFile.source_height AS "SourceHeight", ImageFile.micro_filename AS "MicroFilename", ImageFile.micro_width AS "MicroWidth", ImageFile.micro_height AS "MicroHeight", ImageFile.micro_bytes AS "MicroBytes", CONCAT(MediaFile.path, ImageFile.micro_filename) AS "MicroURL", ImageFile.thumbnail_filename AS "ThumbnailFilename", ImageFile.thumbnail_width AS "ThumbnailWidth", ImageFile.thumbnail_height AS "ThumbnailHeight", ImageFile.thumbnail_bytes AS "ThumbnailBytes", CONCAT(MediaFile.path, ImageFile.thumbnail_filename) AS "ThumbnailURL", ImageFile.small_filename AS "SmallFilename", ImageFile.small_width AS "SmallWidth", ImageFile.small_height AS "SmallHeight", ImageFile.small_bytes AS "SmallBytes", CONCAT(MediaFile.path, ImageFile.small_filename) AS "SmallURL", ImageFile.medium_filename AS "MediumFilename", ImageFile.medium_width AS "MediumWidth", ImageFile.medium_height AS "MediumHeight", ImageFile.medium_bytes AS "MediumBytes", CONCAT(MediaFile.path, ImageFile.medium_filename) AS "MediumURL", ImageFile.large_filename AS "LargeFilename", ImageFile.large_width AS "LargeWidth", ImageFile.large_height AS "LargeHeight", ImageFile.large_bytes AS "LargeBytes", CONCAT(MediaFile.path, ImageFile.large_filename) AS "LargeURL" FROM FM_MediaFiles MediaFile LEFT JOIN FM_ImageFiles ImageFile ON ImageFile.media_file_id = MediaFile.media_file_id WHERE MediaFile.media_file_id = '0';

SELECT ProductVariantOption.product_option_id AS "Id", ProductVariantOption.product_id AS "ProductId", ProductVariantOption.product_variant_id AS "ProductVariantId", ProductVariantOption.product_option_label_id AS "ProductOptionLabelId", ProductVariantOption.product_option_value_id AS "ProductOptionValueId", ProductVariantOption.sort_order AS "SortOrder", Label.label AS "Label", Value.value AS "Value", UNIX_TIMESTAMP(ProductVariantOption.modified) AS "Modified", ProductVariantOption.modified_by AS "ModifiedBy", UNIX_TIMESTAMP(ProductVariantOption.created) AS "Created", ProductVariantOption.created_by AS "CreatedBy", ProductVariantOption.cue_source AS "CueSource", ProductVariantOption.cue_source_id AS "CueSourceId", ProductVariantOption.cue_ver AS "CueVersion" FROM Ecom_ProductsVariantsOptions ProductVariantOption JOIN Ecom_ProductOptionLabels Label ON Label.product_option_label_id = ProductVariantOption.product_option_label_id JOIN Ecom_ProductOptionValues Value ON Value.product_option_value_id = ProductVariantOption.product_option_value_id WHERE ProductVariantOption.product_variant_id = 1 ORDER BY ProductVariantOption.sort_order ASC;

SELECT Author.admin_user_id AS "Id", Author.first_name AS "FirstName", Author.last_name AS "LastName", Author.email AS "Email", TRIM(CONCAT(Author.first_name, ' ', Author.last_name, IF(Author.suffix <> '', CONCAT(' ', Author.suffix), ''))) AS "DisplayFirstLast", TRIM(CONCAT(Author.last_name, ', ', Author.first_name, IF(Author.suffix <> '', CONCAT(' ', Author.suffix), ''))) AS "DisplayLastFirst" FROM DM_AdminUsers Author WHERE Author.admin_user_id = '8';

SELECT Author.admin_user_id AS "Id", Author.first_name AS "FirstName", Author.last_name AS "LastName", Author.email AS "Email", TRIM(CONCAT(Author.first_name, ' ', Author.last_name, IF(Author.suffix <> '', CONCAT(' ', Author.suffix), ''))) AS "DisplayFirstLast", TRIM(CONCAT(Author.last_name, ', ', Author.first_name, IF(Author.suffix <> '', CONCAT(' ', Author.suffix), ''))) AS "DisplayLastFirst" FROM DM_AdminUsers Author WHERE Author.admin_user_id = '8';
0.0013 (3)


SELECT MediaFile.media_file_id AS "Id", MediaFile.media_type AS "MediaType", MediaFile.title AS "Title", MediaFile.version AS "Version", MediaFile.description AS "Description", MediaFile.filename AS "Filename", MediaFile.path AS "Path", MediaFile.target_file AS "File", MediaFile.file_bytes AS "FileBytes", CONCAT(MediaFile.path, MediaFile.target_file) AS "FileURL", MediaFile.hash AS "Hash", MediaFile.mime_type AS "MimeType", MediaFile.show_in_media AS "ShowInMedia", UNIX_TIMESTAMP(MediaFile.status_date) AS "StatusDate", MediaFile.status_id AS "Status", UNIX_TIMESTAMP(MediaFile.modified) AS "Modified", MediaFile.modified_by AS "ModifiedBy", UNIX_TIMESTAMP(MediaFile.created) AS "Created", MediaFile.created_by AS "CreatedBy", MediaFile.cue_source AS "CueSource", MediaFile.cue_source_id AS "CueSourceId", MediaFile.cue_ver AS "CueVersion", ImageFile.alt_text AS "AltText", ImageFile.source_width AS "SourceWidth", ImageFile.source_height AS "SourceHeight", ImageFile.micro_filename AS "MicroFilename", ImageFile.micro_width AS "MicroWidth", ImageFile.micro_height AS "MicroHeight", ImageFile.micro_bytes AS "MicroBytes", CONCAT(MediaFile.path, ImageFile.micro_filename) AS "MicroURL", ImageFile.thumbnail_filename AS "ThumbnailFilename", ImageFile.thumbnail_width AS "ThumbnailWidth", ImageFile.thumbnail_height AS "ThumbnailHeight", ImageFile.thumbnail_bytes AS "ThumbnailBytes", CONCAT(MediaFile.path, ImageFile.thumbnail_filename) AS "ThumbnailURL", ImageFile.small_filename AS "SmallFilename", ImageFile.small_width AS "SmallWidth", ImageFile.small_height AS "SmallHeight", ImageFile.small_bytes AS "SmallBytes", CONCAT(MediaFile.path, ImageFile.small_filename) AS "SmallURL", ImageFile.medium_filename AS "MediumFilename", ImageFile.medium_width AS "MediumWidth", ImageFile.medium_height AS "MediumHeight", ImageFile.medium_bytes AS "MediumBytes", CONCAT(MediaFile.path, ImageFile.medium_filename) AS "MediumURL", ImageFile.large_filename AS "LargeFilename", ImageFile.large_width AS "LargeWidth", ImageFile.large_height AS "LargeHeight", ImageFile.large_bytes AS "LargeBytes", CONCAT(MediaFile.path, ImageFile.large_filename) AS "LargeURL" FROM FM_MediaFiles MediaFile LEFT JOIN FM_ImageFiles ImageFile ON ImageFile.media_file_id = MediaFile.media_file_id WHERE MediaFile.media_file_id = '0';

SELECT ProductVariantOption.product_option_id AS "Id", ProductVariantOption.product_id AS "ProductId", ProductVariantOption.product_variant_id AS "ProductVariantId", ProductVariantOption.product_option_label_id AS "ProductOptionLabelId", ProductVariantOption.product_option_value_id AS "ProductOptionValueId", ProductVariantOption.sort_order AS "SortOrder", Label.label AS "Label", Value.value AS "Value", UNIX_TIMESTAMP(ProductVariantOption.modified) AS "Modified", ProductVariantOption.modified_by AS "ModifiedBy", UNIX_TIMESTAMP(ProductVariantOption.created) AS "Created", ProductVariantOption.created_by AS "CreatedBy", ProductVariantOption.cue_source AS "CueSource", ProductVariantOption.cue_source_id AS "CueSourceId", ProductVariantOption.cue_ver AS "CueVersion" FROM Ecom_ProductsVariantsOptions ProductVariantOption JOIN Ecom_ProductOptionLabels Label ON Label.product_option_label_id = ProductVariantOption.product_option_label_id JOIN Ecom_ProductOptionValues Value ON Value.product_option_value_id = ProductVariantOption.product_option_value_id WHERE ProductVariantOption.product_variant_id = 2 ORDER BY ProductVariantOption.sort_order ASC;

SELECT Author.admin_user_id AS "Id", Author.first_name AS "FirstName", Author.last_name AS "LastName", Author.email AS "Email", TRIM(CONCAT(Author.first_name, ' ', Author.last_name, IF(Author.suffix <> '', CONCAT(' ', Author.suffix), ''))) AS "DisplayFirstLast", TRIM(CONCAT(Author.last_name, ', ', Author.first_name, IF(Author.suffix <> '', CONCAT(' ', Author.suffix), ''))) AS "DisplayLastFirst" FROM DM_AdminUsers Author WHERE Author.admin_user_id = '8';

SELECT Author.admin_user_id AS "Id", Author.first_name AS "FirstName", Author.last_name AS "LastName", Author.email AS "Email", TRIM(CONCAT(Author.first_name, ' ', Author.last_name, IF(Author.suffix <> '', CONCAT(' ', Author.suffix), ''))) AS "DisplayFirstLast", TRIM(CONCAT(Author.last_name, ', ', Author.first_name, IF(Author.suffix <> '', CONCAT(' ', Author.suffix), ''))) AS "DisplayLastFirst" FROM DM_AdminUsers Author WHERE Author.admin_user_id = '8';
0.0007 (2)


SELECT c.label AS "Label", d.value AS "Value", SUM(e.quantity) - IF(f.quantity IS NULL, 0, f.quantity) AS "quantity" FROM Ecom_ProductsVariantsOptions a JOIN Ecom_ProductsOptions b ON b.product_id = a.product_id AND b.product_option_label_id = a.product_option_label_id JOIN Ecom_ProductOptionLabels c ON c.product_option_label_id = a.product_option_label_id JOIN Ecom_ProductOptionValues d ON d.product_option_value_id = a.product_option_value_id JOIN Ecom_SuppliersProducts e ON e.product_variant_id = a.product_variant_id AND e.is_active = 1 left join Ecom_ProductsAllocations f ON f.product_variant_id = a.product_variant_id WHERE a.product_id = 88 GROUP BY c.label, d.value ORDER BY b.sort_order ASC;
0.0009 (0)


SELECT Promotion.promotion_id AS "Id", Promotion.promotion_type AS "PromotionType", Promotion.banner_html AS "BannerHTML", Promotion.meta AS "Meta", Promotion.maximum_uses AS "MaximumUses", Promotion.used_count AS "UsedCount" FROM Ecom_Promotions Promotion WHERE UNIX_TIMESTAMP(Promotion.effective_on) <= 1664749304 AND UNIX_TIMESTAMP(Promotion.expires_on) >= 1664749304 AND Promotion.banner_html <> '\'\'' AND Promotion.is_active = true;
0.0007 (0)


SELECT Menu.menu_id AS "Id", Menu.name AS "Name", Menu.title AS "Title", Menu.tag_id AS "TagId", Menu.tag_class AS "TagClass", Menu.icon_class AS "IconClass", Menu.is_auto_events_enabled AS "EnableAutoEvents", Menu.is_admin AS "Admin", Menu.is_visible AS "Visible", Menu.show_children AS "ShowChildren", Menu.is_active AS "Active", UNIX_TIMESTAMP(Menu.modified) AS "Modified", Menu.modified_by AS "ModifiedBy", UNIX_TIMESTAMP(Menu.created) AS "Created", Menu.created_by AS "CreatedBy", Menu.cue_source AS "CueSource", Menu.cue_source_id AS "CueSourceId", Menu.cue_ver AS "CueVersion" FROM Menu_Menus Menu WHERE Menu.tag_id = 'mobile-menu' AND Menu.is_active = 1;
0.0007 (1)


SELECT Menu.menu_id AS "Id", Menu.name AS "Name", Menu.title AS "Title", Menu.tag_id AS "TagId", Menu.tag_class AS "TagClass", Menu.icon_class AS "IconClass", Menu.is_auto_events_enabled AS "EnableAutoEvents", Menu.is_admin AS "Admin", Menu.is_visible AS "Visible", Menu.show_children AS "ShowChildren", Menu.is_active AS "Active", UNIX_TIMESTAMP(Menu.modified) AS "Modified", Menu.modified_by AS "ModifiedBy", UNIX_TIMESTAMP(Menu.created) AS "Created", Menu.created_by AS "CreatedBy", Menu.cue_source AS "CueSource", Menu.cue_source_id AS "CueSourceId", Menu.cue_ver AS "CueVersion" FROM Menu_Menus Menu WHERE Menu.tag_id = 'primary-menu' AND Menu.is_active = 1;
0.0007 (12)


SELECT MenuItem.menu_item_id AS "Id", MenuItem.menu_id AS "MenuId", MenuItem.name AS "Name", MenuItem.item_type AS "ItemType", MenuItem.tag_id AS "TagId", MenuItem.tag_class AS "TagClass", MenuItem.link_to AS "LinkTo", MenuItem.url_id AS "URLId", MenuItem.tag_url AS "TagURL", MenuItem.tag_title AS "TagTitle", MenuItem.tag_target_blank AS "TagTargetBlank", MenuItem.icon_class AS "IconClass", MenuItem.onclick_event AS "OnClickEvent", MenuItem.html AS "HTML", MenuItem.is_visible AS "Visible", MenuItem.show_children AS "ShowChildren", MenuItem.sort_order AS "SortOrder", MenuItem.depth AS "Depth", MenuItem.allowed_roles AS "AllowedRoles", MenuItem.is_active AS "Active", UNIX_TIMESTAMP(MenuItem.modified) AS "Modified", MenuItem.modified_by AS "ModifiedBy.Id", UNIX_TIMESTAMP(MenuItem.created) AS "Created", MenuItem.created_by AS "CreatedBy.Id", MenuItem.cue_source AS "CueSource", MenuItem.cue_source_id AS "CueSourceId", MenuItem.cue_ver AS "CueVersion", URL.path AS "ContentURL" FROM Menu_MenusItems MenuItem LEFT JOIN DM_URLs URL ON URL.url_id = MenuItem.url_id LEFT JOIN DM_AdminUsers ModifiedBy ON ModifiedBy.admin_user_id = MenuItem.modified_by LEFT JOIN DM_AdminUsers CreatedBy ON CreatedBy.admin_user_id = MenuItem.created_by WHERE MenuItem.menu_id = 2 ORDER BY MenuItem.sort_order ASC, MenuItem.sort_order;
0.0007 (1)


SELECT Menu.menu_id AS "Id", Menu.name AS "Name", Menu.title AS "Title", Menu.tag_id AS "TagId", Menu.tag_class AS "TagClass", Menu.icon_class AS "IconClass", Menu.is_auto_events_enabled AS "EnableAutoEvents", Menu.is_admin AS "Admin", Menu.is_visible AS "Visible", Menu.show_children AS "ShowChildren", Menu.is_active AS "Active", UNIX_TIMESTAMP(Menu.modified) AS "Modified", Menu.modified_by AS "ModifiedBy", UNIX_TIMESTAMP(Menu.created) AS "Created", Menu.created_by AS "CreatedBy", Menu.cue_source AS "CueSource", Menu.cue_source_id AS "CueSourceId", Menu.cue_ver AS "CueVersion" FROM Menu_Menus Menu WHERE Menu.tag_id = 'footer-menu-1' AND Menu.is_active = 1;
0.0007 (5)


SELECT MenuItem.menu_item_id AS "Id", MenuItem.menu_id AS "MenuId", MenuItem.name AS "Name", MenuItem.item_type AS "ItemType", MenuItem.tag_id AS "TagId", MenuItem.tag_class AS "TagClass", MenuItem.link_to AS "LinkTo", MenuItem.url_id AS "URLId", MenuItem.tag_url AS "TagURL", MenuItem.tag_title AS "TagTitle", MenuItem.tag_target_blank AS "TagTargetBlank", MenuItem.icon_class AS "IconClass", MenuItem.onclick_event AS "OnClickEvent", MenuItem.html AS "HTML", MenuItem.is_visible AS "Visible", MenuItem.show_children AS "ShowChildren", MenuItem.sort_order AS "SortOrder", MenuItem.depth AS "Depth", MenuItem.allowed_roles AS "AllowedRoles", MenuItem.is_active AS "Active", UNIX_TIMESTAMP(MenuItem.modified) AS "Modified", MenuItem.modified_by AS "ModifiedBy.Id", UNIX_TIMESTAMP(MenuItem.created) AS "Created", MenuItem.created_by AS "CreatedBy.Id", MenuItem.cue_source AS "CueSource", MenuItem.cue_source_id AS "CueSourceId", MenuItem.cue_ver AS "CueVersion", URL.path AS "ContentURL" FROM Menu_MenusItems MenuItem LEFT JOIN DM_URLs URL ON URL.url_id = MenuItem.url_id LEFT JOIN DM_AdminUsers ModifiedBy ON ModifiedBy.admin_user_id = MenuItem.modified_by LEFT JOIN DM_AdminUsers CreatedBy ON CreatedBy.admin_user_id = MenuItem.created_by WHERE MenuItem.menu_id = 3 ORDER BY MenuItem.sort_order ASC, MenuItem.sort_order;
0.0007 (1)


SELECT Menu.menu_id AS "Id", Menu.name AS "Name", Menu.title AS "Title", Menu.tag_id AS "TagId", Menu.tag_class AS "TagClass", Menu.icon_class AS "IconClass", Menu.is_auto_events_enabled AS "EnableAutoEvents", Menu.is_admin AS "Admin", Menu.is_visible AS "Visible", Menu.show_children AS "ShowChildren", Menu.is_active AS "Active", UNIX_TIMESTAMP(Menu.modified) AS "Modified", Menu.modified_by AS "ModifiedBy", UNIX_TIMESTAMP(Menu.created) AS "Created", Menu.created_by AS "CreatedBy", Menu.cue_source AS "CueSource", Menu.cue_source_id AS "CueSourceId", Menu.cue_ver AS "CueVersion" FROM Menu_Menus Menu WHERE Menu.tag_id = 'footer-menu-2' AND Menu.is_active = 1;
0.0007 (5)


SELECT MenuItem.menu_item_id AS "Id", MenuItem.menu_id AS "MenuId", MenuItem.name AS "Name", MenuItem.item_type AS "ItemType", MenuItem.tag_id AS "TagId", MenuItem.tag_class AS "TagClass", MenuItem.link_to AS "LinkTo", MenuItem.url_id AS "URLId", MenuItem.tag_url AS "TagURL", MenuItem.tag_title AS "TagTitle", MenuItem.tag_target_blank AS "TagTargetBlank", MenuItem.icon_class AS "IconClass", MenuItem.onclick_event AS "OnClickEvent", MenuItem.html AS "HTML", MenuItem.is_visible AS "Visible", MenuItem.show_children AS "ShowChildren", MenuItem.sort_order AS "SortOrder", MenuItem.depth AS "Depth", MenuItem.allowed_roles AS "AllowedRoles", MenuItem.is_active AS "Active", UNIX_TIMESTAMP(MenuItem.modified) AS "Modified", MenuItem.modified_by AS "ModifiedBy.Id", UNIX_TIMESTAMP(MenuItem.created) AS "Created", MenuItem.created_by AS "CreatedBy.Id", MenuItem.cue_source AS "CueSource", MenuItem.cue_source_id AS "CueSourceId", MenuItem.cue_ver AS "CueVersion", URL.path AS "ContentURL" FROM Menu_MenusItems MenuItem LEFT JOIN DM_URLs URL ON URL.url_id = MenuItem.url_id LEFT JOIN DM_AdminUsers ModifiedBy ON ModifiedBy.admin_user_id = MenuItem.modified_by LEFT JOIN DM_AdminUsers CreatedBy ON CreatedBy.admin_user_id = MenuItem.created_by WHERE MenuItem.menu_id = 4 ORDER BY MenuItem.sort_order ASC, MenuItem.sort_order;
Recent URLs
Request
URL: /wine-dine
Referer: