SELECT *, CASE WHEN `name` LIKE "SALT LAKE CITY%" AND `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "SALT LAKE CITY" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "SALT LAKE CITY" AND `logo_file_name` IS NOT NULL THEN 2 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "SALT LAKE CITY" AND `logo_file_name` IS NULL THEN 1 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` IS NULL AND `logo_file_name` IS NULL THEN 0 END as `rank` FROM `wp_31_slides` WHERE (locality IN ("SALT LAKE CITY") OR locality IS NULL) AND (cat IS NULL) AND name NOT IN ("home-top", "home-bot") AND active = 1 ORDER BY `rank` DESC LIMIT 12 [6] matching rows / [0.00 msec] Blog ID 31 Blah

Salt Lake City

The best things to do in Salt Lake City, top professionals, and exclusive Salt Lake City real estate for sale.

Easily navigate to the best places to visit in Salt Lake City. Explore the best neighborhoods via breathtaking pictures and videos from your desktop. Check out the latest events in Salt Lake City from your mobile device. Plan weekend trips with a few clicks or screen taps.

Ready to start exploring Salt Lake City? EXPLORE NOW

[instagram-feed num=9 cols=3 colsmobile=3 showheader=false showfollow=true type=user user=exploreus.ut]