Weddings:

Rainy Fall Wedding

Venue

The Space at Feather Oaks

Size

120 Guests

Highlights

"Social Catering made our wedding day exceptional!!! The team went above and beyond to make sure all the small details were taken care of down to food signs for my s’mores station. We wanted our guests to feel at home and couldn’t have done it without Social Catering’s delicious food and warm service team! Booking was easy, planning was a dream, and the day of exceeded all our expectations." Kristen (bride)

Menu

Cocktail Hour
Shrimp & Pimento Cheese Grit Shooters
Fried Grouper Bites
Caramelized Pear, Bacon, and Roquefort Crostini with Candied Walnuts
BLT Dip

Dinner Stations
Taco Bar with Ancho Chicken & Pork Carnitas
Pork Tenderloin Roulade with Cornbread Stuffing Craving Station
Boursin Herb Mashed Potatoes with Pan Gravy
Holiday Brussels Salad

For Dessert
SoDough Baking Co Cake & Brioche Donuts
S'mores Bar

Credits

Photography: Kylene and Ryan Studios


Book Now
Show Stats
Server Time: 02/06/2023 10:49:00
Session Id: 3b19uh5ar3viu1rl63dumjb1hv (Expires: 02/06/2023 12:49:00)
Peak Memory: 16.8526 MB
Markers
 
Time (% of Total)
Memory In
Memory Out
Memory +/-
App
0.3002 (100%)
363.898 kB
16.841 MB
16.486 MB
App.Boot
0.0703 (23.42%)
604.047 kB
12.023 MB
11.433 MB
Required.Providers.Init
0.0049 (1.63%)
605.148 kB
1.246 MB
670.914 kB
Profiler.Init
0.0001 (0.03%)
605.922 kB
650.391 kB
44.469 kB
FileSystem.Init
0.0000 (0%)
651.172 kB
737.852 kB
86.680 kB
Log.Init
0.0001 (0.03%)
738.633 kB
761.906 kB
23.273 kB
Cryptography.Init
0.0000 (0%)
791.883 kB
813.008 kB
21.125 kB
CacheEngine.Init
0.0000 (0%)
813.797 kB
835.820 kB
22.023 kB
Cache.Init
0.0001 (0.03%)
845.414 kB
868.648 kB
23.234 kB
Session.Init
0.0000 (0%)
869.750 kB
891.367 kB
21.617 kB
Cron.Init
0.0000 (0%)
893.766 kB
922.883 kB
29.117 kB
Databases.Init
0.0001 (0.03%)
923.625 kB
961.836 kB
38.211 kB
Databases.Data
0.0001 (0.03%)
924.398 kB
961.102 kB
36.703 kB
Queue.Init
0.0000 (0%)
961.508 kB
1.017 MB
79.758 kB
Registry.Init
0.0001 (0.03%)
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.03%)
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.0142 (4.73%)
1.240 MB
3.337 MB
2.097 MB
Package.Core.Settings
0.0001 (0.03%)
3.175 MB
3.192 MB
17.445 kB
Package.Render.Settings
0.0000 (0%)
3.193 MB
3.203 MB
10.844 kB
Package.DataManager.Settings
0.0000 (0%)
3.204 MB
3.213 MB
9.125 kB
Package.Menus.Settings
0.0000 (0%)
3.213 MB
3.222 MB
9.117 kB
Package.Administration.Settings
0.0000 (0%)
3.222 MB
3.231 MB
9.125 kB
Package.ImageProcessor.Settings
0.0000 (0%)
3.231 MB
3.240 MB
9.125 kB
Package.FileManager.Settings
0.0000 (0%)
3.241 MB
3.250 MB
9.859 kB
Package.Web.Settings
0.0000 (0%)
3.251 MB
3.260 MB
9.117 kB
Package.Membership.Settings
0.0000 (0%)
3.260 MB
3.269 MB
9.125 kB
Package.Geography.Settings
0.0000 (0%)
3.269 MB
3.278 MB
9.125 kB
Package.Payment.Settings
0.0000 (0%)
3.279 MB
3.289 MB
10.375 kB
Package.Ecommerce.Settings
0.0000 (0%)
3.289 MB
3.298 MB
9.125 kB
Package.HQ.Settings
0.0000 (0%)
3.298 MB
3.309 MB
10.734 kB
Package.HelpDesk.Settings
0.0000 (0%)
3.309 MB
3.318 MB
9.125 kB
Package.FTT.Settings
0.0000 (0%)
3.318 MB
3.327 MB
9.117 kB
Package.SCE.Settings
0.0000 (0%)
3.328 MB
3.337 MB
9.117 kB
Settings.Load
0.0096 (3.2%)
3.371 MB
3.404 MB
33.375 kB
Providers.Init
0.0267 (8.89%)
3.404 MB
10.849 MB
7.444 MB
TemplateEngine.Init
0.0001 (0.03%)
3.405 MB
3.430 MB
25.156 kB
View.Init
0.0001 (0.03%)
3.430 MB
3.527 MB
99.836 kB
Assets.Init
0.0001 (0.03%)
3.528 MB
3.552 MB
24.305 kB
Notification.Init
0.0000 (0%)
3.552 MB
3.573 MB
21.328 kB
DataManager.Init
0.0001 (0.03%)
3.573 MB
3.605 MB
32.633 kB
AuditLog.Init
0.0000 (0%)
3.605 MB
3.626 MB
20.898 kB
Menu.Init
0.0000 (0%)
3.626 MB
3.656 MB
30.188 kB
Admin.Init
0.0001 (0.03%)
3.656 MB
3.748 MB
94.516 kB
Onboard.Init
0.0000 (0%)
3.749 MB
3.771 MB
23.008 kB
ImageProcessor.Init
0.0000 (0%)
3.771 MB
3.792 MB
21.492 kB
Import.Init
0.0000 (0%)
3.793 MB
3.814 MB
21.297 kB
Theme.Init
0.0005 (0.17%)
3.814 MB
3.838 MB
25.125 kB
FrontEnd.Init
0.0000 (0%)
3.839 MB
3.850 MB
11.961 kB
Pages.Init
0.0000 (0%)
3.851 MB
3.885 MB
35.148 kB
Widget.Init
0.0000 (0%)
3.886 MB
3.906 MB
20.930 kB
Membership.Init
0.0017 (0.57%)
3.906 MB
4.498 MB
605.883 kB
Geography.Init
0.0009 (0.3%)
4.498 MB
4.678 MB
183.797 kB
Payment.Init
0.0035 (1.17%)
4.678 MB
5.716 MB
1.038 MB
Taxes.Init
0.0009 (0.3%)
5.716 MB
5.830 MB
116.688 kB
Shipping.Init
0.0006 (0.2%)
5.831 MB
5.968 MB
140.586 kB
GiftCards.Init
0.0005 (0.17%)
5.968 MB
6.091 MB
125.594 kB
Promotions.Init
0.0020 (0.67%)
6.091 MB
6.557 MB
476.625 kB
Marketplaces.Init
0.0009 (0.3%)
6.557 MB
6.818 MB
267.328 kB
Suppliers.Init
0.0018 (0.6%)
6.819 MB
7.395 MB
590.711 kB
Ecommerce.Init
0.0069 (2.3%)
7.396 MB
9.287 MB
1.891 MB
ShoppingCart.Init
0.0023 (0.77%)
9.288 MB
9.947 MB
675.008 kB
Fulfillment.Init
0.0012 (0.4%)
9.947 MB
10.310 MB
371.422 kB
HQ.Init
0.0001 (0.03%)
10.310 MB
10.335 MB
25.398 kB
HelpDesk.Init
0.0010 (0.33%)
10.335 MB
10.573 MB
243.898 kB
CateringEvents.Init
0.0003 (0.1%)
10.574 MB
10.658 MB
86.352 kB
Venues.Init
0.0004 (0.13%)
10.659 MB
10.758 MB
102.102 kB
Weddings.Init
0.0003 (0.1%)
10.759 MB
10.848 MB
91.875 kB
Customapp.Boot
0.0000 (0%)
10.867 MB
10.868 MB
752.000 B
App.OnAppBoot
0.0018 (0.6%)
10.869 MB
11.138 MB
276.008 kB
View.Init
0.0011 (0.37%)
10.883 MB
11.046 MB
166.797 kB
View.Init.SetTheme
0.0000 (0%)
10.996 MB
11.015 MB
19.063 kB
View.Init.SetLayout
0.0001 (0.03%)
11.015 MB
11.044 MB
30.023 kB
App.InitAPIs
0.0009 (0.3%)
11.138 MB
11.139 MB
752.000 B
App.InitRoutes
0.0003 (0.1%)
11.139 MB
11.140 MB
752.000 B
App.InitExtensions
0.0055 (1.83%)
11.141 MB
12.023 MB
903.367 kB
Package.Core
0.0000 (0%)
11.141 MB
11.142 MB
792.000 B
Package.Render
0.0000 (0%)
11.142 MB
11.143 MB
792.000 B
Package.DataManager
0.0000 (0%)
11.144 MB
11.144 MB
800.000 B
Package.Menus
0.0000 (0%)
11.145 MB
11.145 MB
792.000 B
Package.Administration
0.0000 (0%)
11.146 MB
11.147 MB
800.000 B
Package.ImageProcessor
0.0000 (0%)
11.147 MB
11.148 MB
800.000 B
Package.FileManager
0.0000 (0%)
11.148 MB
11.149 MB
800.000 B
Package.Web
0.0000 (0%)
11.149 MB
11.150 MB
792.000 B
Package.Membership
0.0000 (0%)
11.150 MB
11.151 MB
800.000 B
Package.Geography
0.0000 (0%)
11.151 MB
11.152 MB
800.000 B
Package.Payment
0.0000 (0%)
11.153 MB
11.153 MB
792.000 B
Package.Ecommerce
0.0000 (0%)
11.154 MB
11.154 MB
800.000 B
Package.HQ
0.0000 (0%)
11.155 MB
11.156 MB
792.000 B
Package.HelpDesk
0.0000 (0%)
11.156 MB
11.157 MB
800.000 B
Package.FTT
0.0000 (0%)
11.157 MB
11.158 MB
792.000 B
Package.SCE
0.0000 (0%)
11.158 MB
11.159 MB
792.000 B
Provider.Profiler
0.0000 (0%)
11.159 MB
11.160 MB
800.000 B
Provider.Cryptography
0.0000 (0%)
11.160 MB
11.161 MB
800.000 B
Provider.CacheEngine
0.0000 (0%)
11.161 MB
11.162 MB
800.000 B
Provider.Cache
0.0000 (0%)
11.163 MB
11.163 MB
792.000 B
Provider.Cron
0.0000 (0%)
11.164 MB
11.164 MB
792.000 B
Provider.FileSystem
0.0000 (0%)
11.165 MB
11.166 MB
800.000 B
Provider.Queue
0.0000 (0%)
11.166 MB
11.168 MB
2.258 kB
Provider.Log
0.0000 (0%)
11.168 MB
11.169 MB
792.000 B
Provider.Registry
0.0000 (0%)
11.170 MB
11.170 MB
800.000 B
Provider.Module
0.0000 (0%)
11.171 MB
11.171 MB
792.000 B
Provider.PostOffice
0.0000 (0%)
11.172 MB
11.173 MB
800.000 B
Provider.Session
0.0000 (0%)
11.173 MB
11.174 MB
800.000 B
Provider.I18n
0.0000 (0%)
11.174 MB
11.176 MB
1.820 kB
Provider.Tools
0.0000 (0%)
11.176 MB
11.177 MB
792.000 B
Provider.TemplateEngine
0.0000 (0%)
11.177 MB
11.178 MB
800.000 B
Provider.View
0.0000 (0%)
11.178 MB
11.181 MB
2.625 kB
Provider.Assets
0.0000 (0%)
11.181 MB
11.182 MB
792.000 B
Provider.Notification
0.0000 (0%)
11.182 MB
11.183 MB
800.000 B
Provider.DataManager
0.0000 (0%)
11.184 MB
11.184 MB
800.000 B
Provider.AuditLog
0.0000 (0%)
11.185 MB
11.186 MB
800.000 B
Provider.Menu
0.0001 (0.03%)
11.186 MB
11.192 MB
6.469 kB
Provider.Admin
0.0000 (0%)
11.193 MB
11.194 MB
1.594 kB
Provider.Onboard
0.0000 (0%)
11.194 MB
11.195 MB
800.000 B
Provider.ImageProcessor
0.0000 (0%)
11.196 MB
11.196 MB
800.000 B
Provider.Import
0.0000 (0%)
11.197 MB
11.197 MB
792.000 B
Provider.Theme
0.0000 (0%)
11.198 MB
11.203 MB
5.828 kB
Provider.FrontEnd
0.0000 (0%)
11.204 MB
11.206 MB
1.898 kB
Provider.Pages
0.0000 (0%)
11.206 MB
11.210 MB
4.195 kB
Provider.Widget
0.0000 (0%)
11.211 MB
11.212 MB
1.594 kB
Provider.Membership
0.0024 (0.8%)
11.212 MB
11.215 MB
2.453 kB
Provider.Geography
0.0000 (0%)
11.215 MB
11.216 MB
800.000 B
Provider.Payment
0.0000 (0%)
11.216 MB
11.217 MB
808.000 B
Provider.Taxes
0.0000 (0%)
11.217 MB
11.218 MB
792.000 B
Provider.Shipping
0.0000 (0%)
11.219 MB
11.219 MB
800.000 B
Provider.GiftCards
0.0000 (0%)
11.220 MB
11.226 MB
6.273 kB
Provider.Promotions
0.0001 (0.03%)
11.226 MB
11.243 MB
16.852 kB
Provider.Marketplaces
0.0000 (0%)
11.243 MB
11.244 MB
800.000 B
Provider.Suppliers
0.0000 (0%)
11.244 MB
11.249 MB
4.516 kB
Provider.Ecommerce
0.0004 (0.13%)
11.249 MB
11.256 MB
7.508 kB
Provider.ShoppingCart
0.0000 (0%)
11.257 MB
11.258 MB
1.641 kB
Provider.Fulfillment
0.0000 (0%)
11.259 MB
11.261 MB
2.281 kB
Provider.HQ
0.0000 (0%)
11.261 MB
11.262 MB
800.000 B
Provider.HelpDesk
0.0000 (0%)
11.262 MB
11.264 MB
1.914 kB
Provider.CateringEvents
0.0000 (0%)
11.264 MB
11.267 MB
2.281 kB
Provider.Venues
0.0000 (0%)
11.267 MB
11.270 MB
3.391 kB
Provider.Weddings
0.0000 (0%)
11.271 MB
11.274 MB
3.031 kB
Customapp.OnAppRun
0.0000 (0%)
11.274 MB
11.275 MB
752.000 B
Module.Controls
0.0001 (0.03%)
11.275 MB
11.324 MB
50.367 kB
Module.Notes
0.0000 (0%)
11.325 MB
11.334 MB
9.844 kB
Module.Taxonomy
0.0000 (0%)
11.335 MB
11.344 MB
9.844 kB
Module.FileManager
0.0000 (0%)
11.345 MB
11.355 MB
10.930 kB
Module.Attachments
0.0000 (0%)
11.356 MB
11.365 MB
9.875 kB
Module.Images
0.0000 (0%)
11.366 MB
11.375 MB
9.859 kB
Module.Manufacturers
0.0004 (0.13%)
11.376 MB
11.521 MB
149.281 kB
Module.ProductReviews
0.0004 (0.13%)
11.522 MB
11.623 MB
104.109 kB
Module.ProductWaitlist
0.0004 (0.13%)
11.624 MB
11.732 MB
110.391 kB
Widget.PageBody
0.0001 (0.03%)
11.732 MB
11.759 MB
27.563 kB
Widget.Billboard
0.0000 (0%)
11.759 MB
11.769 MB
10.500 kB
Widget.Channels
0.0000 (0%)
11.770 MB
11.780 MB
10.492 kB
Widget.ChannelPages
0.0000 (0%)
11.780 MB
11.791 MB
10.508 kB
Widget.Code
0.0000 (0%)
11.791 MB
11.801 MB
9.867 kB
Widget.ContactForm
0.0000 (0%)
11.801 MB
11.811 MB
10.516 kB
Widget.ImageGallery
0.0000 (0%)
11.812 MB
11.822 MB
10.508 kB
Widget.Share
0.0000 (0%)
11.822 MB
11.833 MB
10.492 kB
Widget.Menu
0.0000 (0%)
11.833 MB
11.843 MB
10.492 kB
Widget.Popup
0.0000 (0%)
11.844 MB
11.854 MB
10.492 kB
Widget.RichEdit
0.0000 (0%)
11.854 MB
11.864 MB
10.492 kB
Widget.AccordionRichEdit
0.0000 (0%)
11.865 MB
11.875 MB
10.516 kB
Widget.ProductCarousel
0.0003 (0.1%)
11.875 MB
11.966 MB
92.359 kB
Widget.SplitScreenRichEdit
0.0001 (0.03%)
11.966 MB
11.994 MB
28.266 kB
Widget.FullScreenImageGallery
0.0001 (0.03%)
11.994 MB
12.022 MB
29.273 kB
App.Stack
0.2295 (76.45%)
12.023 MB
16.841 MB
4.817 MB
Router.Matchingroutes
0.0000 (0%)
12.041 MB
12.042 MB
968.000 B
FrontEnd.Call
0.0692 (23.05%)
12.043 MB
14.532 MB
2.490 MB
Pages.FrontEnd
0.0675 (22.49%)
12.063 MB
14.556 MB
2.493 MB
TemplateEngine.Initialize
0.0009 (0.3%)
13.999 MB
14.288 MB
295.250 kB
Render.Theme.Prepare
0.0003 (0.1%)
14.531 MB
14.552 MB
22.016 kB
Render.Blocks
0.0791 (26.35%)
14.611 MB
15.533 MB
944.773 kB
Render.Layout
0.0004 (0.13%)
15.534 MB
15.590 MB
57.945 kB
Render.Template
0.0749 (24.95%)
15.590 MB
16.797 MB
1.207 MB
Menu.GetMenu.Getentity.Mobile-menu
0.0032 (1.07%)
15.987 MB
16.115 MB
130.859 kB
Menu.GetMenu.Primary-menu
0.0260 (8.66%)
16.115 MB
16.420 MB
312.102 kB
Menu.GetMenu.Getentity.Primary-menu
0.0251 (8.36%)
16.116 MB
16.404 MB
294.805 kB
Menu.Render.Primary-menu
0.0037 (1.23%)
16.420 MB
16.506 MB
87.289 kB
Menu.FindCurrentItem.Primary-menu
0.0027 (0.9%)
16.504 MB
16.507 MB
3.141 kB
Menu.GetMenu.Footer-menu-1
0.0173 (5.76%)
16.499 MB
16.663 MB
168.469 kB
Menu.GetMenu.Getentity.Footer-menu-1
0.0167 (5.56%)
16.499 MB
16.656 MB
159.859 kB
Menu.Render.Footer-menu-1
0.0004 (0.13%)
16.664 MB
16.668 MB
4.477 kB
Menu.FindCurrentItem.Footer-menu-1
0.0000 (0%)
16.669 MB
16.670 MB
1.148 kB
Menu.GetMenu.Footer-menu-2
0.0151 (5.03%)
16.666 MB
16.809 MB
146.742 kB
Menu.GetMenu.Getentity.Footer-menu-2
0.0145 (4.83%)
16.667 MB
16.803 MB
139.313 kB
Menu.Render.Footer-menu-2
0.0003 (0.1%)
16.810 MB
16.813 MB
3.977 kB
Menu.FindCurrentItem.Footer-menu-2
0.0000 (0%)
16.814 MB
16.815 MB
1.148 kB
Render.Hooks
0.0001 (0.03%)
16.811 MB
16.831 MB
20.734 kB
Opcode Cache
Enabled: Yes
Memory: 124.42 MB / 128.00 MB (3.58 MB wasted)
Hits: 285933308 (92.15%)
Misses: 24357174
Scripts: 3062
Cache Engine
Enabled: Yes
Engine: Redis (3.2.10)
Objects: 714
Memory: 14.53 MB
Hits: 4234340837
Misses: 46371688
Database
Queries: 20 (0.0288)

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.0008 (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/rainy-fall-wedding';
0.0008 (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 = '62';
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.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 = 68 AND Status.is_public = true AND UNIX_TIMESTAMP(Page.status_date) <= 1675698540;
0.0042 (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 = '68' ) AND ( Widget.widget_id NOT IN (SELECT widget_id FROM Web_WidgetsPages WHERE page_id = '68' 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 = '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 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 = 68 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 = 68 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 = 68 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 = 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.0016 (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 <> 68 AND Status.is_public = 1 AND UNIX_TIMESTAMP(Page.status_date) <= '1620339035' 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 <> 68 AND Status.is_public = 1 AND UNIX_TIMESTAMP(Page.status_date) <= 1675698540 AND UNIX_TIMESTAMP(Page.status_date) >= '1620339035' ORDER BY UNIX_TIMESTAMP(Page.status_date) ASC LIMIT 1;
0.0010 (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) <= 1675698540 AND UNIX_TIMESTAMP(Promotion.expires_on) >= 1675698540 AND Promotion.banner_html <> '\'\'' AND Promotion.is_active = true;
0.0023 (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 <> 68 ORDER BY Title ASC LIMIT 5;

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


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


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

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

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

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

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


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


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.0008 (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.0011 (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.0008 (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.0008 (5)


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