Weddings:

Daytime Holiday Wedding

Venue

Capital City Country Club

Size

125

Highlights

"Social Catering made my wedding dreams come true. It was a wonderful experience, and I would hire them and have my wedding at the same location all over again." - Whitney (bride)

Menu

Southern Charm Menu
Garden Salad
Bourbon Pecan Chicken
Mama's Meatloaf
Garlic Red Skin Mashed Potatoes
Homestyle Green Beans
Shortcake Parfait
SoDough Mini Doughnuts

Credits

Photographer: Brittany Morgan
Second Shooter: Melissa Hallaian


Book Now
Show Stats
Server Time: 09/19/2021 13:22:11
Session Id: kb18p72t0f1rq3n30l57c3ja2c (Expires: 09/19/2021 15:22:11)
Peak Memory: 7.8698 MB
Markers
 
Time (% of Total)
Memory In
Memory Out
Memory +/-
App
0.1875 (100%)
363.898 kB
7.863 MB
7.508 MB
App.Boot
0.0408 (21.76%)
604.039 kB
3.754 MB
3.164 MB
Required.Providers.Init
0.0021 (1.12%)
605.141 kB
1.246 MB
670.914 kB
Profiler.Init
0.0001 (0.05%)
605.914 kB
650.383 kB
44.469 kB
FileSystem.Init
0.0000 (0%)
651.164 kB
673.844 kB
22.680 kB
Log.Init
0.0001 (0.05%)
674.625 kB
761.898 kB
87.273 kB
Cryptography.Init
0.0000 (0%)
791.875 kB
813.000 kB
21.125 kB
CacheEngine.Init
0.0000 (0%)
813.789 kB
835.813 kB
22.023 kB
Cache.Init
0.0001 (0.05%)
845.406 kB
868.641 kB
23.234 kB
Session.Init
0.0000 (0%)
869.742 kB
891.359 kB
21.617 kB
Cron.Init
0.0000 (0%)
893.758 kB
922.875 kB
29.117 kB
Databases.Init
0.0001 (0.05%)
923.617 kB
961.828 kB
38.211 kB
Databases.Data
0.0001 (0.05%)
924.391 kB
961.094 kB
36.703 kB
Queue.Init
0.0001 (0.05%)
961.500 kB
1.017 MB
79.758 kB
Registry.Init
0.0001 (0.05%)
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.05%)
1.103 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.0333 (17.76%)
1.240 MB
3.142 MB
1.901 MB
Registry.LoadPackages
0.0001 (0.05%)
1.264 MB
1.279 MB
15.656 kB
Registry.RegisterPackages
0.0023 (1.23%)
1.280 MB
1.641 MB
369.570 kB
Package.Core.Settings
0.0002 (0.11%)
1.280 MB
1.297 MB
17.445 kB
Package.Core.Register
0.0002 (0.11%)
1.298 MB
1.319 MB
21.531 kB
Package.Render.Settings
0.0001 (0.05%)
1.319 MB
1.330 MB
10.844 kB
Package.Render.Register
0.0001 (0.05%)
1.330 MB
1.341 MB
11.094 kB
Package.DataManager.Settings
0.0001 (0.05%)
1.341 MB
1.350 MB
9.125 kB
Package.DataManager.Register
0.0001 (0.05%)
1.351 MB
1.368 MB
18.211 kB
Package.Menus.Settings
0.0001 (0.05%)
1.369 MB
1.378 MB
9.117 kB
Package.Menus.Register
0.0000 (0%)
1.378 MB
1.384 MB
5.992 kB
Package.Administration.Settings
0.0001 (0.05%)
1.384 MB
1.393 MB
9.125 kB
Package.Administration.Register
0.0002 (0.11%)
1.394 MB
1.419 MB
25.789 kB
Package.ImageProcessor.Settings
0.0001 (0.05%)
1.419 MB
1.429 MB
10.375 kB
Package.ImageProcessor.Register
0.0000 (0%)
1.430 MB
1.432 MB
2.383 kB
Package.FileManager.Settings
0.0001 (0.05%)
1.432 MB
1.442 MB
9.859 kB
Package.FileManager.Register
0.0001 (0.05%)
1.442 MB
1.457 MB
14.805 kB
Package.Web.Settings
0.0001 (0.05%)
1.457 MB
1.466 MB
9.117 kB
Package.Web.Register
0.0004 (0.21%)
1.466 MB
1.548 MB
83.148 kB
Package.HQ.Settings
0.0001 (0.05%)
1.548 MB
1.557 MB
9.484 kB
Package.HQ.Register
0.0000 (0%)
1.557 MB
1.561 MB
3.750 kB
Package.FTT.Settings
0.0000 (0%)
1.562 MB
1.570 MB
9.117 kB
Package.FTT.Register
0.0001 (0.05%)
1.571 MB
1.581 MB
10.211 kB
Package.SCE.Settings
0.0000 (0%)
1.581 MB
1.591 MB
10.367 kB
Package.SCE.Register
0.0003 (0.16%)
1.592 MB
1.640 MB
49.867 kB
Registry.LoadHandlers
0.0002 (0.11%)
1.641 MB
1.644 MB
2.891 kB
Registry.RegisterProviders
0.0018 (0.96%)
1.644 MB
2.684 MB
1.039 MB
Provider.Profiler.Register
0.0000 (0%)
1.645 MB
1.653 MB
8.563 kB
Provider.Cryptography.Register
0.0000 (0%)
1.654 MB
1.654 MB
808.000 B
Provider.CacheEngine.Register
0.0000 (0%)
1.655 MB
1.656 MB
808.000 B
Provider.Cache.Register
0.0000 (0%)
1.656 MB
1.657 MB
800.000 B
Provider.Cron.Register
0.0000 (0%)
1.657 MB
1.658 MB
800.000 B
Provider.FileSystem.Register
0.0000 (0%)
1.658 MB
1.659 MB
808.000 B
Provider.Queue.Register
0.0000 (0%)
1.659 MB
1.660 MB
800.000 B
Provider.Log.Register
0.0000 (0%)
1.660 MB
1.661 MB
800.000 B
Provider.Registry.Register
0.0000 (0%)
1.661 MB
1.662 MB
808.000 B
Provider.Module.Register
0.0000 (0%)
1.663 MB
1.663 MB
808.000 B
Provider.PostOffice.Register
0.0000 (0%)
1.664 MB
1.665 MB
808.000 B
Provider.Session.Register
0.0000 (0%)
1.665 MB
1.666 MB
808.000 B
Provider.I18n.Register
0.0000 (0%)
1.666 MB
1.667 MB
800.000 B
Provider.Tools.Register
0.0000 (0%)
1.667 MB
1.668 MB
800.000 B
Provider.TemplateEngine.Register
0.0000 (0%)
1.668 MB
1.687 MB
19.617 kB
Provider.View.Register
0.0000 (0%)
1.688 MB
1.711 MB
23.453 kB
Provider.Assets.Register
0.0001 (0.05%)
1.711 MB
1.798 MB
89.516 kB
Provider.Notification.Register
0.0000 (0%)
1.799 MB
1.818 MB
19.156 kB
Provider.DataManager.Register
0.0000 (0%)
1.818 MB
1.852 MB
34.961 kB
Provider.AuditLog.Register
0.0000 (0%)
1.852 MB
1.877 MB
24.953 kB
Provider.Menu.Register
0.0000 (0%)
1.877 MB
1.922 MB
45.477 kB
Provider.Admin.Register
0.0001 (0.05%)
1.922 MB
2.022 MB
102.188 kB
Provider.Onboard.Register
0.0000 (0%)
2.022 MB
2.046 MB
24.320 kB
Provider.ImageProcessor.Register
0.0000 (0%)
2.046 MB
2.065 MB
19.789 kB
Provider.Import.Register
0.0000 (0%)
2.066 MB
2.161 MB
97.188 kB
Provider.Theme.Register
0.0000 (0%)
2.161 MB
2.189 MB
28.648 kB
Provider.FrontEnd.Register
0.0000 (0%)
2.189 MB
2.199 MB
10.180 kB
Provider.Pages.Register
0.0001 (0.05%)
2.200 MB
2.331 MB
134.375 kB
Provider.Widget.Register
0.0000 (0%)
2.331 MB
2.373 MB
43.117 kB
Provider.HQ.Register
0.0000 (0%)
2.374 MB
2.401 MB
27.813 kB
Provider.CateringEvents.Register
0.0004 (0.21%)
2.401 MB
2.489 MB
89.586 kB
Provider.Venues.Register
0.0004 (0.21%)
2.489 MB
2.591 MB
104.359 kB
Provider.Weddings.Register
0.0003 (0.16%)
2.591 MB
2.683 MB
94.125 kB
Registry.RegisterModules
0.0002 (0.11%)
2.684 MB
2.923 MB
245.117 kB
Module.Controls.Register
0.0001 (0.05%)
2.685 MB
2.732 MB
48.148 kB
Module.Notes.Register
0.0000 (0%)
2.732 MB
2.815 MB
84.875 kB
Module.Taxonomy.Register
0.0000 (0%)
2.815 MB
2.836 MB
21.414 kB
Module.FileManager.Register
0.0000 (0%)
2.837 MB
2.865 MB
29.406 kB
Module.Attachments.Register
0.0000 (0%)
2.866 MB
2.896 MB
31.195 kB
Module.Images.Register
0.0000 (0%)
2.897 MB
2.923 MB
27.141 kB
Registry.RegisterWidgets
0.0004 (0.21%)
2.924 MB
3.141 MB
222.672 kB
Widget.PageBody.Register
0.0001 (0.05%)
2.924 MB
2.961 MB
36.984 kB
Widget.Billboard.Register
0.0000 (0%)
2.961 MB
2.971 MB
10.453 kB
Widget.Channels.Register
0.0000 (0%)
2.972 MB
2.982 MB
10.453 kB
Widget.ChannelPages.Register
0.0000 (0%)
2.982 MB
2.992 MB
10.453 kB
Widget.Code.Register
0.0000 (0%)
2.993 MB
3.002 MB
9.820 kB
Widget.ContactForm.Register
0.0000 (0%)
3.003 MB
3.015 MB
12.984 kB
Widget.ImageGallery.Register
0.0000 (0%)
3.016 MB
3.026 MB
10.453 kB
Widget.Share.Register
0.0000 (0%)
3.026 MB
3.041 MB
14.727 kB
Widget.Menu.Register
0.0000 (0%)
3.041 MB
3.051 MB
10.445 kB
Widget.Popup.Register
0.0000 (0%)
3.052 MB
3.064 MB
12.961 kB
Widget.RichEdit.Register
0.0000 (0%)
3.065 MB
3.075 MB
10.453 kB
Widget.AccordionRichEdit.Register
0.0000 (0%)
3.075 MB
3.085 MB
10.461 kB
Widget.SplitScreenRichEdit.Register
0.0001 (0.05%)
3.086 MB
3.112 MB
26.945 kB
Widget.FullScreenImageGallery.Register
0.0001 (0.05%)
3.112 MB
3.141 MB
29.203 kB
Settings.Load
0.0007 (0.37%)
3.175 MB
3.189 MB
14.445 kB
Providers.Init
0.0006 (0.32%)
3.190 MB
3.297 MB
109.484 kB
TemplateEngine.Init
0.0001 (0.05%)
3.190 MB
3.197 MB
6.336 kB
View.Init
0.0000 (0%)
3.197 MB
3.210 MB
13.164 kB
Assets.Init
0.0000 (0%)
3.210 MB
3.214 MB
4.086 kB
Notification.Init
0.0000 (0%)
3.214 MB
3.217 MB
2.961 kB
DataManager.Init
0.0000 (0%)
3.218 MB
3.222 MB
3.961 kB
AuditLog.Init
0.0000 (0%)
3.222 MB
3.224 MB
2.539 kB
Menu.Init
0.0000 (0%)
3.225 MB
3.235 MB
10.141 kB
Admin.Init
0.0000 (0%)
3.235 MB
3.238 MB
3.023 kB
Onboard.Init
0.0000 (0%)
3.238 MB
3.243 MB
4.266 kB
ImageProcessor.Init
0.0000 (0%)
3.243 MB
3.245 MB
2.500 kB
Import.Init
0.0000 (0%)
3.246 MB
3.248 MB
2.555 kB
Theme.Init
0.0000 (0%)
3.249 MB
3.255 MB
6.680 kB
FrontEnd.Init
0.0000 (0%)
3.255 MB
3.258 MB
2.570 kB
Pages.Init
0.0000 (0%)
3.258 MB
3.273 MB
15.141 kB
Widget.Init
0.0000 (0%)
3.273 MB
3.276 MB
2.523 kB
HQ.Init
0.0000 (0%)
3.276 MB
3.283 MB
6.594 kB
CateringEvents.Init
0.0000 (0%)
3.283 MB
3.286 MB
2.609 kB
Venues.Init
0.0000 (0%)
3.286 MB
3.291 MB
5.055 kB
Weddings.Init
0.0000 (0%)
3.291 MB
3.296 MB
5.070 kB
Customapp.Boot
0.0000 (0%)
3.315 MB
3.316 MB
752.000 B
App.OnAppBoot
0.0013 (0.69%)
3.316 MB
3.557 MB
246.727 kB
View.Init
0.0008 (0.43%)
3.393 MB
3.531 MB
140.859 kB
View.Init.SetTheme
0.0000 (0%)
3.480 MB
3.499 MB
19.063 kB
View.Init.SetLayout
0.0001 (0.05%)
3.499 MB
3.529 MB
30.023 kB
App.InitAPIs
0.0004 (0.21%)
3.558 MB
3.558 MB
752.000 B
App.InitRoutes
0.0001 (0.05%)
3.559 MB
3.563 MB
4.734 kB
App.InitExtensions
0.0004 (0.21%)
3.564 MB
3.754 MB
194.727 kB
Package.Core
0.0000 (0%)
3.564 MB
3.565 MB
792.000 B
Package.Render
0.0000 (0%)
3.566 MB
3.566 MB
792.000 B
Package.DataManager
0.0000 (0%)
3.567 MB
3.567 MB
800.000 B
Package.Menus
0.0000 (0%)
3.568 MB
3.569 MB
792.000 B
Package.Administration
0.0000 (0%)
3.569 MB
3.570 MB
800.000 B
Package.ImageProcessor
0.0000 (0%)
3.570 MB
3.571 MB
800.000 B
Package.FileManager
0.0000 (0%)
3.571 MB
3.572 MB
800.000 B
Package.Web
0.0000 (0%)
3.572 MB
3.573 MB
792.000 B
Package.HQ
0.0000 (0%)
3.573 MB
3.574 MB
792.000 B
Package.FTT
0.0000 (0%)
3.575 MB
3.575 MB
792.000 B
Package.SCE
0.0000 (0%)
3.576 MB
3.576 MB
792.000 B
Provider.Profiler
0.0000 (0%)
3.577 MB
3.578 MB
800.000 B
Provider.Cryptography
0.0000 (0%)
3.578 MB
3.579 MB
800.000 B
Provider.CacheEngine
0.0000 (0%)
3.579 MB
3.580 MB
800.000 B
Provider.Cache
0.0000 (0%)
3.580 MB
3.581 MB
792.000 B
Provider.Cron
0.0000 (0%)
3.581 MB
3.582 MB
792.000 B
Provider.FileSystem
0.0000 (0%)
3.582 MB
3.583 MB
800.000 B
Provider.Queue
0.0000 (0%)
3.583 MB
3.586 MB
2.258 kB
Provider.Log
0.0000 (0%)
3.586 MB
3.587 MB
792.000 B
Provider.Registry
0.0000 (0%)
3.587 MB
3.588 MB
800.000 B
Provider.Module
0.0000 (0%)
3.588 MB
3.589 MB
792.000 B
Provider.PostOffice
0.0000 (0%)
3.589 MB
3.590 MB
800.000 B
Provider.Session
0.0000 (0%)
3.591 MB
3.591 MB
800.000 B
Provider.I18n
0.0000 (0%)
3.592 MB
3.593 MB
1.820 kB
Provider.Tools
0.0000 (0%)
3.594 MB
3.595 MB
792.000 B
Provider.TemplateEngine
0.0000 (0%)
3.595 MB
3.596 MB
800.000 B
Provider.View
0.0000 (0%)
3.596 MB
3.599 MB
2.625 kB
Provider.Assets
0.0000 (0%)
3.599 MB
3.600 MB
792.000 B
Provider.Notification
0.0000 (0%)
3.600 MB
3.601 MB
800.000 B
Provider.DataManager
0.0000 (0%)
3.601 MB
3.602 MB
800.000 B
Provider.AuditLog
0.0000 (0%)
3.602 MB
3.603 MB
800.000 B
Provider.Menu
0.0001 (0.05%)
3.603 MB
3.610 MB
6.469 kB
Provider.Admin
0.0000 (0%)
3.610 MB
3.612 MB
1.594 kB
Provider.Onboard
0.0000 (0%)
3.612 MB
3.613 MB
800.000 B
Provider.ImageProcessor
0.0000 (0%)
3.613 MB
3.614 MB
800.000 B
Provider.Import
0.0000 (0%)
3.614 MB
3.615 MB
792.000 B
Provider.Theme
0.0000 (0%)
3.615 MB
3.621 MB
5.828 kB
Provider.FrontEnd
0.0000 (0%)
3.621 MB
3.622 MB
800.000 B
Provider.Pages
0.0000 (0%)
3.623 MB
3.627 MB
4.195 kB
Provider.Widget
0.0000 (0%)
3.627 MB
3.629 MB
1.594 kB
Provider.HQ
0.0000 (0%)
3.629 MB
3.635 MB
6.281 kB
Provider.CateringEvents
0.0000 (0%)
3.635 MB
3.638 MB
3.023 kB
Provider.Venues
0.0000 (0%)
3.639 MB
3.642 MB
3.391 kB
Provider.Weddings
0.0000 (0%)
3.642 MB
3.645 MB
3.031 kB
Customapp.OnAppRun
0.0000 (0%)
3.646 MB
3.646 MB
752.000 B
Module.Controls
0.0001 (0.05%)
3.647 MB
3.732 MB
87.602 kB
Module.Notes
0.0000 (0%)
3.733 MB
3.733 MB
792.000 B
Module.Taxonomy
0.0000 (0%)
3.734 MB
3.735 MB
792.000 B
Module.FileManager
0.0000 (0%)
3.735 MB
3.736 MB
800.000 B
Module.Attachments
0.0000 (0%)
3.736 MB
3.737 MB
800.000 B
Module.Images
0.0000 (0%)
3.737 MB
3.738 MB
792.000 B
Widget.PageBody
0.0000 (0%)
3.738 MB
3.739 MB
792.000 B
Widget.Billboard
0.0000 (0%)
3.739 MB
3.740 MB
800.000 B
Widget.Channels
0.0000 (0%)
3.741 MB
3.741 MB
792.000 B
Widget.ChannelPages
0.0000 (0%)
3.742 MB
3.742 MB
800.000 B
Widget.Code
0.0000 (0%)
3.743 MB
3.743 MB
792.000 B
Widget.ContactForm
0.0000 (0%)
3.744 MB
3.745 MB
800.000 B
Widget.ImageGallery
0.0000 (0%)
3.745 MB
3.746 MB
800.000 B
Widget.Share
0.0000 (0%)
3.746 MB
3.747 MB
792.000 B
Widget.Menu
0.0000 (0%)
3.747 MB
3.748 MB
792.000 B
Widget.Popup
0.0000 (0%)
3.748 MB
3.749 MB
792.000 B
Widget.RichEdit
0.0000 (0%)
3.749 MB
3.750 MB
792.000 B
Widget.AccordionRichEdit
0.0000 (0%)
3.751 MB
3.751 MB
808.000 B
Widget.SplitScreenRichEdit
0.0000 (0%)
3.752 MB
3.752 MB
808.000 B
Widget.FullScreenImageGallery
0.0000 (0%)
3.753 MB
3.754 MB
808.000 B
App.Stack
0.1463 (78.03%)
3.755 MB
7.863 MB
4.108 MB
Router.Matchingroutes
0.0000 (0%)
3.772 MB
3.773 MB
968.000 B
FrontEnd.Call
0.0660 (35.2%)
3.774 MB
6.351 MB
2.577 MB
Pages.FrontEnd
0.0652 (34.77%)
3.795 MB
6.374 MB
2.579 MB
TemplateEngine.Initialize
0.0011 (0.59%)
5.760 MB
6.050 MB
296.914 kB
Render.Theme.Prepare
0.0003 (0.16%)
6.349 MB
6.371 MB
22.016 kB
Render.Blocks
0.0707 (37.71%)
6.373 MB
7.265 MB
913.789 kB
Render.Layout
0.0004 (0.21%)
7.266 MB
7.322 MB
57.977 kB
Render.Template
0.0076 (4.05%)
7.322 MB
7.823 MB
512.508 kB
Menu.GetMenu.Getentity.Mobile-menu
0.0022 (1.17%)
7.654 MB
7.783 MB
131.484 kB
Menu.FindCurrentItem.Primary-menu
0.0009 (0.48%)
7.813 MB
7.816 MB
3.156 kB
Menu.FindCurrentItem.Footer-menu-1
0.0000 (0%)
7.826 MB
7.827 MB
1.148 kB
Menu.FindCurrentItem.Footer-menu-2
0.0000 (0%)
7.838 MB
7.839 MB
1.148 kB
Render.Hooks
0.0001 (0.05%)
7.836 MB
7.852 MB
16.734 kB
Opcode Cache
Enabled: Yes
Memory: 122.20 MB / 128.00 MB (5.77 MB wasted)
Hits: 102056599 (98.38%)
Misses: 1679636
Scripts: 3059
Cache Engine
Enabled: Yes
Engine: Redis (3.2.10)
Objects: 708
Memory: 14.24 MB
Hits: 5237995782
Misses: 232976304
Database
Queries: 12 (0.0177)

0.0004 (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/daytime-holiday-wedding';
0.0005 (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 = '52';
0.0009 (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('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 = 59 AND Status.is_public = true AND UNIX_TIMESTAMP(Page.status_date) <= 1632072131;
0.0056 (13)


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 = '59' ) AND ( Widget.widget_id NOT IN (SELECT widget_id FROM Web_WidgetsPages WHERE page_id = '59' 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 = '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 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 = 59 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 = 59 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 = 59 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 = 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.0011 (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 <> 59 AND Status.is_public = 1 AND UNIX_TIMESTAMP(Page.status_date) <= '1617284430' 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 <> 59 AND Status.is_public = 1 AND UNIX_TIMESTAMP(Page.status_date) <= 1632072131 AND UNIX_TIMESTAMP(Page.status_date) >= '1617284430' ORDER BY UNIX_TIMESTAMP(Page.status_date) ASC LIMIT 1;
0.0013 (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.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 <> 59 ORDER BY Title ASC LIMIT 5;

SELECT FOUND_ROWS() AS Rows;
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 = '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.0014 (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 = '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 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.0015 (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.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 = '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.0015 (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.0003 (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;
Recent URLs
Request
URL: /weddings/daytime-holiday-wedding
Referer: