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: 05/07/2025 13:51:13
Session Id: o4hdtvac3hog6ir6h5luggoen0 (Expires: 05/07/2025 15:51:13)
Peak Memory: 10.1436 MB
Markers
 
Time (% of Total)
Memory In
Memory Out
Memory +/-
App
0.2928 (100%)
363.898 kB
10.132 MB
9.777 MB
App.Boot
0.0412 (14.07%)
603.695 kB
6.014 MB
5.425 MB
Required.Providers.Init
0.0031 (1.06%)
604.797 kB
1.246 MB
670.922 kB
Profiler.Init
0.0001 (0.03%)
605.570 kB
650.039 kB
44.469 kB
FileSystem.Init
0.0001 (0.03%)
650.820 kB
737.500 kB
86.680 kB
Log.Init
0.0001 (0.03%)
738.281 kB
761.555 kB
23.273 kB
Cryptography.Init
0.0001 (0.03%)
791.531 kB
812.656 kB
21.125 kB
CacheEngine.Init
0.0001 (0.03%)
813.445 kB
835.469 kB
22.023 kB
Cache.Init
0.0001 (0.03%)
845.070 kB
868.305 kB
23.234 kB
Session.Init
0.0001 (0.03%)
869.406 kB
891.023 kB
21.617 kB
Cron.Init
0.0001 (0.03%)
893.422 kB
922.539 kB
29.117 kB
Databases.Init
0.0002 (0.07%)
923.281 kB
961.492 kB
38.211 kB
Databases.Data
0.0002 (0.07%)
924.055 kB
960.758 kB
36.703 kB
Queue.Init
0.0001 (0.03%)
961.164 kB
1.017 MB
79.758 kB
Registry.Init
0.0001 (0.03%)
1.054 MB
1.081 MB
27.023 kB
Module.Init
0.0001 (0.03%)
1.081 MB
1.102 MB
21.422 kB
PostOffice.Init
0.0001 (0.03%)
1.103 MB
1.211 MB
110.500 kB
I18n.Init
0.0001 (0.03%)
1.212 MB
1.223 MB
11.742 kB
Tools.Init
0.0001 (0.03%)
1.225 MB
1.245 MB
20.297 kB
Registry.Start
0.0087 (2.97%)
1.241 MB
3.358 MB
2.117 MB
Package.Core.Settings
0.0000 (0%)
3.204 MB
3.221 MB
17.445 kB
Package.Render.Settings
0.0000 (0%)
3.221 MB
3.232 MB
10.844 kB
Package.DataManager.Settings
0.0000 (0%)
3.232 MB
3.241 MB
9.125 kB
Package.Menus.Settings
0.0000 (0%)
3.242 MB
3.250 MB
9.117 kB
Package.Administration.Settings
0.0000 (0%)
3.251 MB
3.260 MB
9.125 kB
Package.ImageProcessor.Settings
0.0000 (0%)
3.260 MB
3.269 MB
9.125 kB
Package.FileManager.Settings
0.0000 (0%)
3.269 MB
3.279 MB
9.859 kB
Package.Web.Settings
0.0000 (0%)
3.279 MB
3.288 MB
9.117 kB
Package.Membership.Settings
0.0000 (0%)
3.289 MB
3.298 MB
9.125 kB
Package.Geography.Settings
0.0000 (0%)
3.298 MB
3.307 MB
9.125 kB
Package.Payment.Settings
0.0000 (0%)
3.307 MB
3.317 MB
10.375 kB
Package.Ecommerce.Settings
0.0000 (0%)
3.318 MB
3.328 MB
10.961 kB
Package.HQ.Settings
0.0000 (0%)
3.329 MB
3.339 MB
10.734 kB
Package.FTT.Settings
0.0000 (0%)
3.340 MB
3.348 MB
9.117 kB
Package.SCE.Settings
0.0000 (0%)
3.349 MB
3.358 MB
9.117 kB
Settings.Load
0.0095 (3.24%)
3.392 MB
3.425 MB
33.453 kB
Providers.Init
0.0060 (2.05%)
3.426 MB
5.139 MB
1.713 MB
TemplateEngine.Init
0.0002 (0.07%)
3.426 MB
3.451 MB
25.156 kB
View.Init
0.0001 (0.03%)
3.451 MB
3.549 MB
99.836 kB
Assets.Init
0.0001 (0.03%)
3.549 MB
3.573 MB
24.367 kB
Notification.Init
0.0001 (0.03%)
3.573 MB
3.594 MB
21.328 kB
DataManager.Init
0.0001 (0.03%)
3.594 MB
3.626 MB
32.633 kB
AuditLog.Init
0.0001 (0.03%)
3.627 MB
3.647 MB
20.898 kB
Menu.Init
0.0001 (0.03%)
3.647 MB
3.677 MB
30.188 kB
Admin.Init
0.0001 (0.03%)
3.677 MB
3.770 MB
94.516 kB
Onboard.Init
0.0001 (0.03%)
3.770 MB
3.792 MB
23.008 kB
ImageProcessor.Init
0.0001 (0.03%)
3.793 MB
3.814 MB
21.492 kB
Import.Init
0.0001 (0.03%)
3.814 MB
3.836 MB
22.609 kB
Theme.Init
0.0001 (0.03%)
3.836 MB
3.861 MB
25.125 kB
FrontEnd.Init
0.0001 (0.03%)
3.861 MB
3.873 MB
11.961 kB
Pages.Init
0.0001 (0.03%)
3.873 MB
3.913 MB
40.648 kB
Widget.Init
0.0001 (0.03%)
3.913 MB
3.934 MB
20.930 kB
Membership.Init
0.0001 (0.03%)
3.934 MB
4.031 MB
99.195 kB
Geography.Init
0.0001 (0.03%)
4.032 MB
4.050 MB
19.266 kB
Payment.Init
0.0003 (0.1%)
4.051 MB
4.210 MB
163.555 kB
Taxes.Init
0.0001 (0.03%)
4.211 MB
4.226 MB
15.102 kB
Shipping.Init
0.0001 (0.03%)
4.226 MB
4.239 MB
12.953 kB
GiftCards.Init
0.0001 (0.03%)
4.239 MB
4.252 MB
13.938 kB
Promotions.Init
0.0002 (0.07%)
4.253 MB
4.280 MB
28.047 kB
Marketplaces.Init
0.0001 (0.03%)
4.281 MB
4.367 MB
88.211 kB
Suppliers.Init
0.0031 (1.06%)
4.367 MB
4.888 MB
533.219 kB
Ecommerce.Init
0.0001 (0.03%)
4.888 MB
4.926 MB
39.016 kB
ShoppingCart.Init
0.0001 (0.03%)
4.927 MB
5.037 MB
113.211 kB
Fulfillment.Init
0.0001 (0.03%)
5.038 MB
5.071 MB
34.203 kB
HQ.Init
0.0001 (0.03%)
5.071 MB
5.101 MB
30.898 kB
CateringEvents.Init
0.0001 (0.03%)
5.102 MB
5.114 MB
12.313 kB
Venues.Init
0.0001 (0.03%)
5.114 MB
5.126 MB
12.281 kB
Weddings.Init
0.0001 (0.03%)
5.127 MB
5.139 MB
12.297 kB
Customapp.Boot
0.0000 (0%)
5.157 MB
5.158 MB
752.000 B
App.OnAppBoot
0.0027 (0.92%)
5.159 MB
5.428 MB
275.648 kB
View.Init
0.0018 (0.61%)
5.236 MB
5.399 MB
166.805 kB
View.Init.SetTheme
0.0001 (0.03%)
5.349 MB
5.367 MB
19.063 kB
View.Init.SetLayout
0.0001 (0.03%)
5.368 MB
5.397 MB
30.023 kB
App.InitAPIs
0.0021 (0.72%)
5.428 MB
5.429 MB
752.000 B
App.InitRoutes
0.0008 (0.27%)
5.429 MB
5.430 MB
752.000 B
App.InitExtensions
0.0054 (1.84%)
5.430 MB
6.014 MB
597.461 kB
Package.Core
0.0000 (0%)
5.431 MB
5.432 MB
792.000 B
Package.Render
0.0000 (0%)
5.432 MB
5.433 MB
792.000 B
Package.DataManager
0.0000 (0%)
5.433 MB
5.434 MB
800.000 B
Package.Menus
0.0000 (0%)
5.435 MB
5.435 MB
792.000 B
Package.Administration
0.0000 (0%)
5.436 MB
5.436 MB
800.000 B
Package.ImageProcessor
0.0000 (0%)
5.437 MB
5.438 MB
800.000 B
Package.FileManager
0.0000 (0%)
5.438 MB
5.439 MB
800.000 B
Package.Web
0.0000 (0%)
5.439 MB
5.440 MB
792.000 B
Package.Membership
0.0000 (0%)
5.440 MB
5.441 MB
800.000 B
Package.Geography
0.0000 (0%)
5.441 MB
5.442 MB
800.000 B
Package.Payment
0.0000 (0%)
5.442 MB
5.443 MB
792.000 B
Package.Ecommerce
0.0000 (0%)
5.444 MB
5.444 MB
800.000 B
Package.HQ
0.0000 (0%)
5.445 MB
5.445 MB
792.000 B
Package.FTT
0.0000 (0%)
5.446 MB
5.447 MB
792.000 B
Package.SCE
0.0000 (0%)
5.447 MB
5.449 MB
2.625 kB
Provider.Profiler
0.0000 (0%)
5.450 MB
5.451 MB
800.000 B
Provider.Cryptography
0.0000 (0%)
5.451 MB
5.452 MB
800.000 B
Provider.CacheEngine
0.0000 (0%)
5.452 MB
5.453 MB
800.000 B
Provider.Cache
0.0000 (0%)
5.453 MB
5.454 MB
792.000 B
Provider.Cron
0.0000 (0%)
5.454 MB
5.455 MB
792.000 B
Provider.FileSystem
0.0000 (0%)
5.455 MB
5.456 MB
800.000 B
Provider.Queue
0.0000 (0%)
5.457 MB
5.458 MB
1.891 kB
Provider.Log
0.0000 (0%)
5.459 MB
5.459 MB
792.000 B
Provider.Registry
0.0000 (0%)
5.460 MB
5.461 MB
800.000 B
Provider.Module
0.0000 (0%)
5.461 MB
5.462 MB
792.000 B
Provider.PostOffice
0.0000 (0%)
5.462 MB
5.463 MB
800.000 B
Provider.Session
0.0000 (0%)
5.463 MB
5.464 MB
800.000 B
Provider.I18n
0.0000 (0%)
5.464 MB
5.466 MB
1.820 kB
Provider.Tools
0.0000 (0%)
5.466 MB
5.467 MB
792.000 B
Provider.TemplateEngine
0.0000 (0%)
5.468 MB
5.468 MB
800.000 B
Provider.View
0.0000 (0%)
5.469 MB
5.471 MB
2.625 kB
Provider.Assets
0.0000 (0%)
5.472 MB
5.472 MB
792.000 B
Provider.Notification
0.0000 (0%)
5.473 MB
5.473 MB
800.000 B
Provider.DataManager
0.0000 (0%)
5.474 MB
5.475 MB
800.000 B
Provider.AuditLog
0.0000 (0%)
5.475 MB
5.476 MB
800.000 B
Provider.Menu
0.0001 (0.03%)
5.476 MB
5.482 MB
6.469 kB
Provider.Admin
0.0000 (0%)
5.483 MB
5.484 MB
1.594 kB
Provider.Onboard
0.0000 (0%)
5.485 MB
5.485 MB
800.000 B
Provider.ImageProcessor
0.0000 (0%)
5.486 MB
5.487 MB
800.000 B
Provider.Import
0.0000 (0%)
5.487 MB
5.488 MB
792.000 B
Provider.Theme
0.0000 (0%)
5.488 MB
5.495 MB
6.945 kB
Provider.FrontEnd
0.0000 (0%)
5.495 MB
5.497 MB
1.898 kB
Provider.Pages
0.0000 (0%)
5.497 MB
5.501 MB
4.195 kB
Provider.Widget
0.0000 (0%)
5.502 MB
5.503 MB
1.594 kB
Provider.Membership
0.0026 (0.89%)
5.504 MB
5.506 MB
2.453 kB
Provider.Geography
0.0000 (0%)
5.507 MB
5.507 MB
800.000 B
Provider.Payment
0.0000 (0%)
5.508 MB
5.508 MB
808.000 B
Provider.Taxes
0.0000 (0%)
5.509 MB
5.510 MB
792.000 B
Provider.Shipping
0.0000 (0%)
5.510 MB
5.511 MB
800.000 B
Provider.GiftCards
0.0000 (0%)
5.511 MB
5.513 MB
2.273 kB
Provider.Promotions
0.0001 (0.03%)
5.514 MB
5.530 MB
16.852 kB
Provider.Marketplaces
0.0000 (0%)
5.530 MB
5.531 MB
800.000 B
Provider.Suppliers
0.0001 (0.03%)
5.532 MB
5.539 MB
8.148 kB
Provider.Ecommerce
0.0004 (0.14%)
5.540 MB
5.550 MB
10.117 kB
Provider.ShoppingCart
0.0000 (0%)
5.550 MB
5.553 MB
2.758 kB
Provider.Fulfillment
0.0001 (0.03%)
5.553 MB
5.555 MB
2.281 kB
Provider.HQ
0.0000 (0%)
5.556 MB
5.556 MB
800.000 B
Provider.CateringEvents
0.0000 (0%)
5.557 MB
5.559 MB
2.281 kB
Provider.Venues
0.0000 (0%)
5.559 MB
5.563 MB
3.391 kB
Provider.Weddings
0.0000 (0%)
5.563 MB
5.566 MB
3.031 kB
Customapp.OnAppRun
0.0000 (0%)
5.566 MB
5.567 MB
752.000 B
Module.Controls
0.0002 (0.07%)
5.567 MB
5.680 MB
114.727 kB
Module.Notes
0.0000 (0%)
5.680 MB
5.689 MB
9.844 kB
Module.Taxonomy
0.0000 (0%)
5.690 MB
5.699 MB
9.844 kB
Module.FileManager
0.0000 (0%)
5.700 MB
5.711 MB
10.930 kB
Module.Attachments
0.0000 (0%)
5.711 MB
5.721 MB
9.875 kB
Module.Images
0.0000 (0%)
5.721 MB
5.730 MB
9.859 kB
Module.Manufacturers
0.0000 (0%)
5.731 MB
5.741 MB
10.305 kB
Module.ProductReviews
0.0000 (0%)
5.741 MB
5.752 MB
10.570 kB
Module.ProductWaitlist
0.0001 (0.03%)
5.752 MB
5.764 MB
12.313 kB
Widget.PageBody
0.0001 (0.03%)
5.764 MB
5.791 MB
27.563 kB
Widget.Billboard
0.0006 (0.2%)
5.792 MB
5.802 MB
10.500 kB
Widget.Channels
0.0000 (0%)
5.802 MB
5.812 MB
10.492 kB
Widget.ChannelPages
0.0000 (0%)
5.813 MB
5.823 MB
10.508 kB
Widget.Code
0.0000 (0%)
5.823 MB
5.833 MB
9.867 kB
Widget.ContactForm
0.0000 (0%)
5.833 MB
5.844 MB
10.516 kB
Widget.ImageGallery
0.0000 (0%)
5.844 MB
5.854 MB
10.508 kB
Widget.Share
0.0000 (0%)
5.855 MB
5.865 MB
10.492 kB
Widget.Menu
0.0000 (0%)
5.865 MB
5.876 MB
10.492 kB
Widget.Popup
0.0000 (0%)
5.876 MB
5.886 MB
10.492 kB
Widget.RichEdit
0.0000 (0%)
5.886 MB
5.959 MB
74.492 kB
Widget.RichEditBlocks
0.0000 (0%)
5.960 MB
5.970 MB
10.508 kB
Widget.AccordionRichEdit
0.0000 (0%)
5.970 MB
5.981 MB
10.516 kB
Widget.ProductCarousel
0.0000 (0%)
5.981 MB
5.992 MB
11.758 kB
Widget.SplitScreenRichEdit
0.0000 (0%)
5.993 MB
6.003 MB
10.531 kB
Widget.FullScreenImageGallery
0.0000 (0%)
6.003 MB
6.014 MB
10.531 kB
App.Stack
0.2511 (85.76%)
6.015 MB
10.132 MB
4.117 MB
Router.Matchingroutes
0.0000 (0%)
6.032 MB
6.033 MB
968.000 B
FrontEnd.Call
0.0658 (22.47%)
6.034 MB
8.274 MB
2.240 MB
Pages.FrontEnd
0.0638 (21.79%)
6.054 MB
8.298 MB
2.244 MB
TemplateEngine.Initialize
0.0008 (0.27%)
7.915 MB
8.135 MB
225.703 kB
Render.Theme.Prepare
0.0004 (0.14%)
8.272 MB
8.294 MB
22.016 kB
Render.Blocks
0.0942 (32.17%)
8.352 MB
9.244 MB
913.836 kB
Render.Layout
0.0004 (0.14%)
9.245 MB
9.266 MB
22.000 kB
Render.Template
0.0838 (28.62%)
9.267 MB
10.092 MB
845.563 kB
Menu.GetMenu.Getentity.Mobile-menu
0.0034 (1.16%)
9.347 MB
9.475 MB
131.047 kB
Menu.GetMenu.Primary-menu
0.0323 (11.03%)
9.475 MB
9.807 MB
339.438 kB
Menu.GetMenu.Getentity.Primary-menu
0.0311 (10.62%)
9.476 MB
9.790 MB
320.922 kB
Menu.Render.Primary-menu
0.0041 (1.4%)
9.807 MB
9.823 MB
15.836 kB
Menu.FindCurrentItem.Primary-menu
0.0035 (1.2%)
9.821 MB
9.824 MB
3.141 kB
Menu.GetMenu.Footer-menu-1
0.0168 (5.74%)
9.816 MB
9.960 MB
147.313 kB
Menu.GetMenu.Getentity.Footer-menu-1
0.0160 (5.46%)
9.817 MB
9.952 MB
138.703 kB
Menu.Render.Footer-menu-1
0.0004 (0.14%)
9.960 MB
9.964 MB
4.477 kB
Menu.FindCurrentItem.Footer-menu-1
0.0001 (0.03%)
9.965 MB
9.966 MB
1.148 kB
Menu.GetMenu.Footer-menu-2
0.0178 (6.08%)
9.962 MB
10.104 MB
145.234 kB
Menu.GetMenu.Getentity.Footer-menu-2
0.0171 (5.84%)
9.963 MB
10.099 MB
139.047 kB
Menu.Render.Footer-menu-2
0.0003 (0.1%)
10.105 MB
10.108 MB
3.477 kB
Menu.FindCurrentItem.Footer-menu-2
0.0001 (0.03%)
10.109 MB
10.110 MB
1.148 kB
Render.Hooks
0.0001 (0.03%)
10.106 MB
10.122 MB
16.734 kB
Opcode Cache
Enabled: Yes
Memory: 127.72 MB / 128.00 MB (284.24 kB wasted)
Hits: 118427668 (99.29%)
Misses: 838419
Scripts: 3228
Cache Engine
Enabled: Yes
Engine: Redis (7.0.7)
Objects: 1462
Memory: 262.83 MB
Hits: 2924251791
Misses: 75970845
Database
Queries: 20 (0.0359)

0.0008 (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.0010 (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.0011 (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.0016 (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) <= 1746640273;
0.0069 (9)


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", webGetPageHierarchy(Channel.page_id, 'title') AS "FullTitle", 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.0020 (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) <= 1746640273 AND UNIX_TIMESTAMP(Page.status_date) >= '1618497676' ORDER BY UNIX_TIMESTAMP(Page.status_date) ASC LIMIT 1;
0.0012 (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) <= 1746640273 AND UNIX_TIMESTAMP(Promotion.expires_on) >= 1746640273 AND Promotion.banner_html <> '\'\'' AND Promotion.is_active = true;
0.0025 (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.0027 (4)


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", webGetPageHierarchy(Channel.page_id, 'title') AS "FullTitle", 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.0023 (4)


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", webGetPageHierarchy(Channel.page_id, 'title') AS "FullTitle", 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.0023 (4)


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", webGetPageHierarchy(Channel.page_id, 'title') AS "FullTitle", 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.0023 (4)


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", webGetPageHierarchy(Channel.page_id, 'title') AS "FullTitle", 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.0023 (4)


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", webGetPageHierarchy(Channel.page_id, 'title') AS "FullTitle", 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.0008 (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.0009 (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.0014 (12)


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