SELECT * FROM (SELECT * FROM (
					SELECT * FROM (
					SELECT * FROM items_view WHERE thumbnail != ''
					UNION
					SELECT * FROM items_view WHERE thumbnail = ''
				) tmp WHERE id > 0 AND LCASE(category) = 'hardwood' 
				GROUP BY subcollection) tmp WHERE thumbnail != ''

				UNION

				SELECT * FROM (
				SELECT * FROM (
					SELECT * FROM items_view WHERE thumbnail != ''
					UNION
					SELECT * FROM items_view WHERE thumbnail = ''
				) tmp WHERE id > 0 AND LCASE(category) = 'hardwood' 
				GROUP BY subcollection) tmp2 WHERE thumbnail = '') result LIMIT 120 OFFSET 0

• Barrington 
• Belmont 
• Betula 
• Cascade 
• Country Oak 
• Covelo Canyon 
• Domestic Floor 
• Madison 
• Manchester 
• Overland 
• Potomac 
• Providence 
• Safari 
• Traditions 
• Wild West 
• Allure 
• Antique 
• Bay Town 
• Charlestown 
• Newport 
• Portland