error_id=1054&error_msg=Unknown column 'sub.name' in 'field list'

<b><PRE>
	SELECT 
	
                `l`.`id` AS `label_id`,
                `l`.`name` AS `label`,
                IF(`thumb_1`<>'',CONCAT('images/products/thumbs/',`v`.`thumb_1`),'') AS `thumb`,
                `s`.`department_id`,
                `s`.`category_id`,
                `s`.`subcategory_id`,
                `sub`.`name`AS`subcategory`,
                `cat`.`name`AS`category`,
                `s`.`style`,
                `s`.`title`,
                `s`.`price_list`,
                `s`.`price_sell`,
                `s`.`ctime`,
                `s`.`qty` AS `inventory`,
		`v`.`color`,
                `s`.`id` AS `style_id`,
		`v`.`id` AS `variant_id`
		
	FROM `style` `s`
	         INNER
	          JOIN `variant` `v`
	            ON (`v`.`style_id`=`s`.`id`  AND `v`.`isactive`=1 AND `v`.`isdefault`=1)
	         INNER
	          JOIN `category` `cat`
	            ON (`s`.`subcategory_id`=`cat`.`id`)
	         INNER
	          JOIN `category` `cat2`
	            ON (`s`.`category_id`=`cat2`.`id`)
	         INNER
	          JOIN `label` `l`
	            ON `s`.`label_id`=`l`.`id`
		 WHERE `s`.`style`='reef'  AND  `s`.`isactive`=1
		    ;</PRE></b>