SELECT *, CASE WHEN `sub_cat` IS NULL AND `cat` = "lodging" AND `locality` = "waltham" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `sub_cat` IS NULL AND `cat` = "lodging" AND `locality` = "waltham" AND `logo_file_name` IS NULL THEN 9 WHEN `sub_cat` IS NULL AND `cat` = "lodging" AND `locality` IS NULL AND `logo_file_name` IS NOT NULL THEN 8 WHEN `sub_cat` IS NULL AND `cat` = "lodging" AND `locality` IS NULL AND `logo_file_name` IS NULL THEN 7 WHEN `sub_cat` IS NOT NULL AND `cat` = "lodging" AND `locality` = "waltham" AND `logo_file_name` IS NOT NULL THEN 6 WHEN `sub_cat` IS NOT NULL AND `cat` = "lodging" AND `locality` = "waltham" AND `logo_file_name` IS NULL THEN 5 WHEN `sub_cat` IS NOT NULL AND `cat` = "lodging" AND `locality` IS NULL AND `logo_file_name` IS NOT NULL THEN 4 WHEN `sub_cat` IS NOT NULL AND `cat` = "lodging" AND `locality` IS NULL AND `logo_file_name` IS NULL THEN 3 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_27_slides` WHERE (locality IN ("waltham") OR locality IS NULL) AND (cat = "lodging" OR cat IS NULL) AND name NOT IN ("home-top", "home-bot") AND active = 1 ORDER BY `rank` DESC LIMIT 20
[3] matching rows / [0.00 msec]
Blog ID 27
Blah
Street View data not found for this location.
LODGING
Boston Reservations
(617) 332-419967 Lincoln Woods Rd Waltham MA 02451http://www.bostonreservations.com
Courtyard by Marriott Boston Waltham
(781) 419-0900387 Winter St Waltham MA 02451http://marriott.com/hotels/travel/boswm-courtyard-boston-waltham/