SELECT *, CASE WHEN `sub_cat` IS NULL AND `cat` = "" AND `locality` = "CHAPPELL HILL" AND `logo_file_name` IS NOT NULL THEN 6 WHEN `sub_cat` IS NULL AND `cat` = "" AND `locality` = "CHAPPELL HILL" AND `logo_file_name` IS NULL THEN 5 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "CHAPPELL HILL" AND `logo_file_name` IS NOT NULL THEN 4 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "CHAPPELL HILL" 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_37_slides` WHERE (locality IN ("CHAPPELL HILL") OR locality IS NULL) AND (cat IS NULL) AND active = 1 ORDER BY `rank` DESC LIMIT 20 [16] matching rows / [0.00 msec] Blog ID 37 Blah

Chappell Hill

Chappell Hill
Lavender Farm

A delightful day excursion, an aromatic lavender farm
with quaint surroundings and a scenic hillside view.

Annual Bluebonnet Festival

Declared the "Official Bluebonnet Festival of Texas" by the Texas Legislature.