Weddings:

June Wedding on the Terrace

Venue

The Gathering

Size

100 Guests

Highlights

“Social Catering and Events was an absolute DREAM to work with. The food was phenomenal and wasn’t normal, boring wedding food. There are a TON of choices to choose from. We had a ton of weird requests, like South African wine and possibly including our dogs in our wedding, and they worked with us seamlessly on EVERYTHING.” - Chelsey (bride)

Menu

Caprese Skewers with Balsamic Drizzle
Fried Grouper Bites with Spicy Remoulade
BLT Dip 
Summer Salad
Bruschetta Chicken
Southern Style Shrimp & Grits
Jalapeño Corn Mac n’ Cheese
Roasted Veggies 
SoDough Brioche Donuts

Credits

Photographer: Black & Hue Photography


Book Now
Show Stats
Server Time: 12/05/2023 22:54:41
Session Id: 92jc74i8gbfhlgfj68874uq4f1 (Expires: 12/06/2023 00:54:40)
Peak Memory: 9.5183 MB
Markers
 
Time (% of Total)
Memory In
Memory Out
Memory +/-
App
0.2429 (100%)
363.898 kB
9.532 MB
9.177 MB
App.Boot
0.0237 (9.76%)
604.070 kB
5.442 MB
4.852 MB
Required.Providers.Init
0.0022 (0.91%)
605.172 kB
1.246 MB
670.914 kB
Profiler.Init
0.0001 (0.04%)
605.945 kB
650.414 kB
44.469 kB
FileSystem.Init
0.0000 (0%)
651.195 kB
737.875 kB
86.680 kB
Log.Init
0.0001 (0.04%)
738.656 kB
761.930 kB
23.273 kB
Cryptography.Init
0.0000 (0%)
791.906 kB
813.031 kB
21.125 kB
CacheEngine.Init
0.0000 (0%)
813.820 kB
835.844 kB
22.023 kB
Cache.Init
0.0001 (0.04%)
845.438 kB
868.672 kB
23.234 kB
Session.Init
0.0000 (0%)
869.773 kB
891.391 kB
21.617 kB
Cron.Init
0.0000 (0%)
893.789 kB
922.906 kB
29.117 kB
Databases.Init
0.0001 (0.04%)
923.648 kB
961.859 kB
38.211 kB
Databases.Data
0.0001 (0.04%)
924.422 kB
961.125 kB
36.703 kB
Queue.Init
0.0000 (0%)
961.531 kB
1.017 MB
79.758 kB
Registry.Init
0.0000 (0%)
1.055 MB
1.081 MB
27.023 kB
Module.Init
0.0000 (0%)
1.082 MB
1.103 MB
21.422 kB
PostOffice.Init
0.0001 (0.04%)
1.104 MB
1.211 MB
110.500 kB
I18n.Init
0.0000 (0%)
1.212 MB
1.224 MB
11.742 kB
Tools.Init
0.0000 (0%)
1.226 MB
1.245 MB
20.297 kB
Registry.Start
0.0057 (2.35%)
1.240 MB
3.349 MB
2.108 MB
Package.Core.Settings
0.0001 (0.04%)
3.187 MB
3.204 MB
17.445 kB
Package.Render.Settings
0.0000 (0%)
3.205 MB
3.215 MB
10.844 kB
Package.DataManager.Settings
0.0000 (0%)
3.215 MB
3.224 MB
9.125 kB
Package.Menus.Settings
0.0000 (0%)
3.225 MB
3.234 MB
9.117 kB
Package.Administration.Settings
0.0000 (0%)
3.234 MB
3.243 MB
9.125 kB
Package.ImageProcessor.Settings
0.0000 (0%)
3.243 MB
3.252 MB
9.125 kB
Package.FileManager.Settings
0.0000 (0%)
3.253 MB
3.262 MB
9.859 kB
Package.Web.Settings
0.0000 (0%)
3.263 MB
3.271 MB
9.117 kB
Package.Membership.Settings
0.0000 (0%)
3.272 MB
3.281 MB
9.125 kB
Package.Geography.Settings
0.0000 (0%)
3.281 MB
3.290 MB
9.125 kB
Package.Payment.Settings
0.0000 (0%)
3.290 MB
3.300 MB
10.375 kB
Package.Ecommerce.Settings
0.0000 (0%)
3.301 MB
3.310 MB
9.125 kB
Package.HQ.Settings
0.0000 (0%)
3.310 MB
3.321 MB
10.734 kB
Package.HelpDesk.Settings
0.0000 (0%)
3.321 MB
3.330 MB
9.125 kB
Package.FTT.Settings
0.0000 (0%)
3.330 MB
3.339 MB
9.117 kB
Package.SCE.Settings
0.0000 (0%)
3.339 MB
3.348 MB
9.117 kB
Settings.Load
0.0057 (2.35%)
3.383 MB
3.416 MB
33.383 kB
Providers.Init
0.0019 (0.78%)
3.416 MB
4.640 MB
1.224 MB
TemplateEngine.Init
0.0001 (0.04%)
3.417 MB
3.441 MB
25.156 kB
View.Init
0.0001 (0.04%)
3.442 MB
3.539 MB
99.836 kB
Assets.Init
0.0001 (0.04%)
3.540 MB
3.563 MB
24.367 kB
Notification.Init
0.0000 (0%)
3.564 MB
3.585 MB
21.328 kB
DataManager.Init
0.0001 (0.04%)
3.585 MB
3.617 MB
32.633 kB
AuditLog.Init
0.0000 (0%)
3.617 MB
3.638 MB
20.898 kB
Menu.Init
0.0000 (0%)
3.638 MB
3.667 MB
30.188 kB
Admin.Init
0.0001 (0.04%)
3.668 MB
3.760 MB
94.516 kB
Onboard.Init
0.0000 (0%)
3.760 MB
3.783 MB
23.008 kB
ImageProcessor.Init
0.0000 (0%)
3.783 MB
3.804 MB
21.492 kB
Import.Init
0.0000 (0%)
3.805 MB
3.827 MB
22.609 kB
Theme.Init
0.0000 (0%)
3.827 MB
3.852 MB
25.125 kB
FrontEnd.Init
0.0000 (0%)
3.852 MB
3.864 MB
11.961 kB
Pages.Init
0.0000 (0%)
3.864 MB
3.898 MB
35.148 kB
Widget.Init
0.0001 (0.04%)
3.899 MB
3.919 MB
20.930 kB
Membership.Init
0.0001 (0.04%)
3.919 MB
4.016 MB
99.195 kB
Geography.Init
0.0001 (0.04%)
4.017 MB
4.036 MB
19.266 kB
Payment.Init
0.0002 (0.08%)
4.036 MB
4.186 MB
153.281 kB
Taxes.Init
0.0000 (0%)
4.186 MB
4.201 MB
15.102 kB
Shipping.Init
0.0000 (0%)
4.201 MB
4.214 MB
12.953 kB
GiftCards.Init
0.0000 (0%)
4.214 MB
4.228 MB
13.938 kB
Promotions.Init
0.0001 (0.04%)
4.228 MB
4.255 MB
28.047 kB
Marketplaces.Init
0.0000 (0%)
4.256 MB
4.342 MB
88.211 kB
Suppliers.Init
0.0001 (0.04%)
4.342 MB
4.367 MB
25.000 kB
Ecommerce.Init
0.0001 (0.04%)
4.367 MB
4.405 MB
39.016 kB
ShoppingCart.Init
0.0001 (0.04%)
4.406 MB
4.454 MB
49.891 kB
Fulfillment.Init
0.0000 (0%)
4.455 MB
4.556 MB
103.703 kB
HQ.Init
0.0001 (0.04%)
4.556 MB
4.581 MB
25.398 kB
HelpDesk.Init
0.0000 (0%)
4.581 MB
4.602 MB
21.367 kB
CateringEvents.Init
0.0000 (0%)
4.603 MB
4.615 MB
12.313 kB
Venues.Init
0.0000 (0%)
4.615 MB
4.627 MB
12.281 kB
Weddings.Init
0.0000 (0%)
4.627 MB
4.639 MB
12.297 kB
Customapp.Boot
0.0000 (0%)
4.658 MB
4.659 MB
752.000 B
App.OnAppBoot
0.0018 (0.74%)
4.660 MB
4.929 MB
275.953 kB
View.Init
0.0011 (0.45%)
4.674 MB
4.900 MB
231.109 kB
View.Init.SetTheme
0.0000 (0%)
4.787 MB
4.868 MB
83.063 kB
View.Init.SetLayout
0.0001 (0.04%)
4.868 MB
4.898 MB
30.336 kB
App.InitAPIs
0.0009 (0.37%)
4.929 MB
4.930 MB
752.000 B
App.InitRoutes
0.0003 (0.12%)
4.930 MB
4.931 MB
752.000 B
App.InitExtensions
0.0029 (1.19%)
4.932 MB
5.441 MB
521.930 kB
Package.Core
0.0000 (0%)
4.932 MB
4.933 MB
792.000 B
Package.Render
0.0000 (0%)
4.933 MB
4.934 MB
792.000 B
Package.DataManager
0.0000 (0%)
4.935 MB
4.935 MB
800.000 B
Package.Menus
0.0000 (0%)
4.936 MB
4.936 MB
792.000 B
Package.Administration
0.0000 (0%)
4.937 MB
4.938 MB
800.000 B
Package.ImageProcessor
0.0000 (0%)
4.938 MB
4.939 MB
800.000 B
Package.FileManager
0.0000 (0%)
4.939 MB
4.940 MB
800.000 B
Package.Web
0.0000 (0%)
4.940 MB
4.941 MB
792.000 B
Package.Membership
0.0000 (0%)
4.941 MB
4.942 MB
800.000 B
Package.Geography
0.0000 (0%)
4.942 MB
4.943 MB
800.000 B
Package.Payment
0.0000 (0%)
4.943 MB
4.944 MB
792.000 B
Package.Ecommerce
0.0000 (0%)
4.945 MB
4.945 MB
800.000 B
Package.HQ
0.0000 (0%)
4.946 MB
4.946 MB
792.000 B
Package.HelpDesk
0.0000 (0%)
4.947 MB
4.948 MB
800.000 B
Package.FTT
0.0000 (0%)
4.948 MB
4.949 MB
792.000 B
Package.SCE
0.0000 (0%)
4.949 MB
4.952 MB
2.625 kB
Provider.Profiler
0.0000 (0%)
4.952 MB
4.953 MB
800.000 B
Provider.Cryptography
0.0000 (0%)
4.953 MB
4.954 MB
800.000 B
Provider.CacheEngine
0.0000 (0%)
4.954 MB
4.955 MB
800.000 B
Provider.Cache
0.0000 (0%)
4.955 MB
4.956 MB
792.000 B
Provider.Cron
0.0000 (0%)
4.956 MB
4.957 MB
792.000 B
Provider.FileSystem
0.0000 (0%)
4.958 MB
4.958 MB
800.000 B
Provider.Queue
0.0000 (0%)
4.959 MB
4.961 MB
1.891 kB
Provider.Log
0.0000 (0%)
4.961 MB
4.962 MB
792.000 B
Provider.Registry
0.0000 (0%)
4.962 MB
4.963 MB
800.000 B
Provider.Module
0.0000 (0%)
4.963 MB
4.964 MB
792.000 B
Provider.PostOffice
0.0000 (0%)
4.964 MB
4.965 MB
800.000 B
Provider.Session
0.0000 (0%)
4.965 MB
4.966 MB
800.000 B
Provider.I18n
0.0000 (0%)
4.966 MB
4.968 MB
1.820 kB
Provider.Tools
0.0000 (0%)
4.969 MB
4.969 MB
792.000 B
Provider.TemplateEngine
0.0000 (0%)
4.970 MB
4.971 MB
800.000 B
Provider.View
0.0000 (0%)
4.971 MB
4.973 MB
2.625 kB
Provider.Assets
0.0000 (0%)
4.974 MB
4.975 MB
792.000 B
Provider.Notification
0.0000 (0%)
4.975 MB
4.976 MB
800.000 B
Provider.DataManager
0.0000 (0%)
4.976 MB
4.977 MB
800.000 B
Provider.AuditLog
0.0000 (0%)
4.977 MB
4.978 MB
800.000 B
Provider.Menu
0.0001 (0.04%)
4.978 MB
4.985 MB
6.469 kB
Provider.Admin
0.0000 (0%)
4.985 MB
4.986 MB
1.594 kB
Provider.Onboard
0.0000 (0%)
4.987 MB
4.988 MB
800.000 B
Provider.ImageProcessor
0.0000 (0%)
4.988 MB
4.989 MB
800.000 B
Provider.Import
0.0000 (0%)
4.989 MB
4.990 MB
792.000 B
Provider.Theme
0.0000 (0%)
4.990 MB
4.997 MB
6.945 kB
Provider.FrontEnd
0.0000 (0%)
4.997 MB
4.999 MB
1.898 kB
Provider.Pages
0.0000 (0%)
5.000 MB
5.004 MB
4.195 kB
Provider.Widget
0.0000 (0%)
5.004 MB
5.006 MB
1.594 kB
Provider.Membership
0.0014 (0.58%)
5.006 MB
5.008 MB
2.453 kB
Provider.Geography
0.0000 (0%)
5.009 MB
5.009 MB
800.000 B
Provider.Payment
0.0000 (0%)
5.010 MB
5.011 MB
808.000 B
Provider.Taxes
0.0000 (0%)
5.011 MB
5.012 MB
792.000 B
Provider.Shipping
0.0000 (0%)
5.012 MB
5.013 MB
800.000 B
Provider.GiftCards
0.0000 (0%)
5.013 MB
5.019 MB
6.273 kB
Provider.Promotions
0.0000 (0%)
5.020 MB
5.036 MB
16.852 kB
Provider.Marketplaces
0.0000 (0%)
5.036 MB
5.037 MB
800.000 B
Provider.Suppliers
0.0000 (0%)
5.038 MB
5.042 MB
4.148 kB
Provider.Ecommerce
0.0003 (0.12%)
5.042 MB
5.049 MB
7.508 kB
Provider.ShoppingCart
0.0000 (0%)
5.050 MB
5.051 MB
1.641 kB
Provider.Fulfillment
0.0000 (0%)
5.052 MB
5.054 MB
2.281 kB
Provider.HQ
0.0000 (0%)
5.054 MB
5.055 MB
800.000 B
Provider.HelpDesk
0.0000 (0%)
5.055 MB
5.057 MB
1.914 kB
Provider.CateringEvents
0.0000 (0%)
5.058 MB
5.060 MB
2.281 kB
Provider.Venues
0.0000 (0%)
5.060 MB
5.063 MB
3.391 kB
Provider.Weddings
0.0000 (0%)
5.064 MB
5.067 MB
3.031 kB
Customapp.OnAppRun
0.0000 (0%)
5.067 MB
5.068 MB
752.000 B
Module.Controls
0.0001 (0.04%)
5.068 MB
5.180 MB
114.367 kB
Module.Notes
0.0000 (0%)
5.180 MB
5.190 MB
9.844 kB
Module.Taxonomy
0.0000 (0%)
5.190 MB
5.200 MB
9.844 kB
Module.FileManager
0.0000 (0%)
5.200 MB
5.211 MB
10.930 kB
Module.Attachments
0.0000 (0%)
5.211 MB
5.221 MB
9.875 kB
Module.Images
0.0000 (0%)
5.221 MB
5.231 MB
9.859 kB
Module.Manufacturers
0.0000 (0%)
5.231 MB
5.241 MB
10.305 kB
Module.ProductReviews
0.0000 (0%)
5.242 MB
5.252 MB
10.570 kB
Module.ProductWaitlist
0.0000 (0%)
5.252 MB
5.264 MB
12.313 kB
Widget.PageBody
0.0001 (0.04%)
5.265 MB
5.292 MB
27.563 kB
Widget.Billboard
0.0000 (0%)
5.292 MB
5.302 MB
10.500 kB
Widget.Channels
0.0000 (0%)
5.303 MB
5.313 MB
10.492 kB
Widget.ChannelPages
0.0000 (0%)
5.313 MB
5.324 MB
10.508 kB
Widget.Code
0.0000 (0%)
5.324 MB
5.333 MB
9.867 kB
Widget.ContactForm
0.0000 (0%)
5.334 MB
5.344 MB
10.516 kB
Widget.ImageGallery
0.0000 (0%)
5.344 MB
5.355 MB
10.508 kB
Widget.Share
0.0000 (0%)
5.355 MB
5.365 MB
10.492 kB
Widget.Menu
0.0000 (0%)
5.366 MB
5.376 MB
10.492 kB
Widget.Popup
0.0000 (0%)
5.376 MB
5.387 MB
10.492 kB
Widget.RichEdit
0.0000 (0%)
5.387 MB
5.397 MB
10.492 kB
Widget.AccordionRichEdit
0.0000 (0%)
5.398 MB
5.408 MB
10.516 kB
Widget.ProductCarousel
0.0000 (0%)
5.408 MB
5.418 MB
10.508 kB
Widget.SplitScreenRichEdit
0.0000 (0%)
5.419 MB
5.430 MB
11.781 kB
Widget.FullScreenImageGallery
0.0000 (0%)
5.431 MB
5.441 MB
10.531 kB
App.Stack
0.2188 (90.08%)
5.442 MB
9.532 MB
4.090 MB
Router.Matchingroutes
0.0000 (0%)
5.460 MB
5.461 MB
968.000 B
FrontEnd.Call
0.0589 (24.25%)
5.461 MB
7.810 MB
2.349 MB
Pages.FrontEnd
0.0579 (23.84%)
5.544 MB
7.834 MB
2.290 MB
TemplateEngine.Initialize
0.0007 (0.29%)
7.209 MB
7.491 MB
288.914 kB
Render.Theme.Prepare
0.0003 (0.12%)
7.808 MB
7.830 MB
22.016 kB
Render.Blocks
0.0835 (34.38%)
7.888 MB
8.758 MB
891.055 kB
Render.Layout
0.0013 (0.54%)
8.758 MB
8.657 MB
-103.773 kB
Render.Template
0.0681 (28.04%)
8.657 MB
9.470 MB
832.453 kB
Menu.GetMenu.Getentity.Mobile-menu
0.0024 (0.99%)
8.800 MB
8.928 MB
130.859 kB
Menu.GetMenu.Primary-menu
0.0272 (11.2%)
8.929 MB
9.209 MB
286.945 kB
Menu.GetMenu.Getentity.Primary-menu
0.0265 (10.91%)
8.929 MB
9.194 MB
271.164 kB
Menu.Render.Primary-menu
0.0026 (1.07%)
9.209 MB
9.224 MB
14.836 kB
Menu.FindCurrentItem.Primary-menu
0.0020 (0.82%)
9.222 MB
9.225 MB
3.141 kB
Menu.GetMenu.Footer-menu-1
0.0164 (6.75%)
9.218 MB
9.360 MB
146.188 kB
Menu.GetMenu.Getentity.Footer-menu-1
0.0158 (6.5%)
9.218 MB
9.353 MB
137.578 kB
Menu.Render.Footer-menu-1
0.0004 (0.16%)
9.361 MB
9.365 MB
4.477 kB
Menu.FindCurrentItem.Footer-menu-1
0.0000 (0%)
9.366 MB
9.367 MB
1.148 kB
Menu.GetMenu.Footer-menu-2
0.0127 (5.23%)
9.363 MB
9.482 MB
121.922 kB
Menu.GetMenu.Getentity.Footer-menu-2
0.0122 (5.02%)
9.364 MB
9.477 MB
115.734 kB
Menu.Render.Footer-menu-2
0.0003 (0.12%)
9.483 MB
9.486 MB
3.477 kB
Menu.FindCurrentItem.Footer-menu-2
0.0000 (0%)
9.487 MB
9.488 MB
1.148 kB
Render.Hooks
0.0001 (0.04%)
9.484 MB
9.500 MB
16.734 kB
Opcode Cache
Enabled: Yes
Memory: 118.42 MB / 128.00 MB (0.00 B wasted)
Hits: 64305 (95.72%)
Misses: 2874
Scripts: 2782
Cache Engine
Enabled: Yes
Engine: Redis (3.2.10)
Objects: 329
Memory: 30.40 MB
Hits: 6957436440
Misses: 75165945
Database
Queries: 20 (0.0255)

0.0004 (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.0006 (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 = 'weddings/june-wedding-on-the-terrace';
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 = '56';
0.0011 (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.canonical_url AS "CanonicalURL", 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('Wedding/', 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", Wedding.wedding_id AS "WeddingId", Wedding.venue_id AS "Venue", Wedding.is_featured AS "IsFeatured", Wedding.size AS "Size", Wedding.highlights AS "Highlights", Wedding.menu AS "Menu", Wedding.credits AS "Credits" 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 SCE_Weddings Wedding ON Wedding.page_id = Page.page_id LEFT JOIN DM_Statuses Status ON Status.status_id = Page.status_id WHERE Page.page_id = 63 AND Status.is_public = true AND UNIX_TIMESTAMP(Page.status_date) <= 1701834880;
0.0051 (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 = '34') OR Widget.widget_id IN (SELECT widget_id FROM Web_WidgetsEntities WHERE entity_name = 'Wedding') OR WidgetPage.page_id = '63' ) AND ( Widget.widget_id NOT IN (SELECT widget_id FROM Web_WidgetsPages WHERE page_id = '63' 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 = '75';

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 = '5';

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 = '34';

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 = 63 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 = 63 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 = 63 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 = 63 ORDER BY PageURL.is_default DESC;

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


SELECT Page.title AS "Title", DefaultFullURL.path AS "DefaultFullURL" 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 LEFT JOIN DM_Statuses Status ON Status.status_id = Page.status_id WHERE Page.channel_id = 34 AND Page.page_id <> 63 AND Status.is_public = 1 AND UNIX_TIMESTAMP(Page.status_date) <= '1618497676' ORDER BY UNIX_TIMESTAMP(Page.status_date) DESC LIMIT 1;

SELECT Page.title AS "Title", DefaultFullURL.path AS "DefaultFullURL" 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 LEFT JOIN DM_Statuses Status ON Status.status_id = Page.status_id WHERE Page.channel_id = 34 AND Page.page_id <> 63 AND Status.is_public = 1 AND UNIX_TIMESTAMP(Page.status_date) <= 1701834880 AND UNIX_TIMESTAMP(Page.status_date) >= '1618497676' ORDER BY UNIX_TIMESTAMP(Page.status_date) ASC LIMIT 1;
0.0007 (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) <= 1701834880 AND UNIX_TIMESTAMP(Promotion.expires_on) >= 1701834880 AND Promotion.banner_html <> '\'\'' AND Promotion.is_active = true;
0.0020 (6)


SELECT SQL_CALC_FOUND_ROWS 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.canonical_url AS "CanonicalURL", 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('Wedding/', 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", Wedding.wedding_id AS "WeddingId", Wedding.venue_id AS "Venue", Wedding.is_featured AS "IsFeatured", Wedding.size AS "Size", Wedding.highlights AS "Highlights", Wedding.menu AS "Menu", Wedding.credits AS "Credits" 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 SCE_Weddings Wedding ON Wedding.page_id = Page.page_id LEFT JOIN DM_Statuses Status ON Status.status_id = Page.status_id WHERE Page.channel_id = '34' AND Status.is_public = true AND Page.page_id <> 63 ORDER BY Title ASC LIMIT 5;

SELECT FOUND_ROWS() AS `Rows`;
0.0018 (5)


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 = '182';

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 = '5';

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 = '34';

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 = 72 ORDER BY PageURL.is_default DESC;

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


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 = '232';

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 = '5';

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 = '34';

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 = 59 ORDER BY PageURL.is_default DESC;

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


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 = '65';

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 = '5';

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 = '34';

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 = 60 ORDER BY PageURL.is_default DESC;

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


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 = '163';

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 = '5';

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 = '34';

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 = 68 ORDER BY PageURL.is_default DESC;

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


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 = '219';

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 = '5';

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 = '34';

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 = 64 ORDER BY PageURL.is_default DESC;

SELECT Venue.page_id AS "Id", Venue.title AS "Title", Status.Label AS "Status", UNIX_TIMESTAMP(Venue.modified) AS "Modified", UNIX_TIMESTAMP(Venue.created) AS "Created", CONCAT('page/', Venue.page_id) AS "Permalink", DefaultURL.path AS "DefaultURL", DefaultFullURL.path AS "DefaultFullURL" FROM Web_Pages Venue JOIN DM_Statuses Status ON Status.status_id = Venue.status_id LEFT JOIN Web_PagesURLs DefaultURL ON DefaultURL.page_id = Venue.page_id AND DefaultURL.is_default = 1 JOIN DM_URLs DefaultFullURL ON DefaultFullURL.url_id = DefaultURL.url_id WHERE Venue.page_id = '70';
0.0004 (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.0005 (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 (10)


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.0006 (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.0006 (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.0006 (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 (4)


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: /weddings/june-wedding-on-the-terrace
Referer: