Thanks for posting your db but I could not get your original query to work with the item_colour - but glad you have solved the issue you had with repeating options.
I like your view query too for img_colour_v2
SELECT
<br> `creator_account`.`user_name` AS `user_name`,
<br> `creator_account`.`main_design_folder` AS `mainFolder`,
<br> `creator_subfolder`.`design_sub_folder` AS `subFolder`,
<br> `fit_type`.`fit_category` AS `fitType`,
<br> `item_type`.`category_type` AS `category_type`,
<br> `gender_fit`.`fit_style` AS `fit_style`,
<br> `neck_line_type`.`style_type` AS `style_type`,
<br> `item_colour`.`colour_palette` AS `colour_palette`,
<br> `item_colour`.`colour_code` AS `colour_code`,
<br> `creator_test_imgs`.`img_location` AS `img_location`,
<br> `creator_subfolder`.`creator_accountID` AS `userID`,
<br> `item_colour_variant`.`item_colourID` AS `colourID`,
<br> `gender_fit`.`id` AS `genderID`,
<br> `item_type`.`id` AS `itemTypeID`,
<br> `creator_test_imgs`.`creator_subfolderID` AS `subFolderID`,
<br> `neck_line_type`.`id` AS `neckTypeID`,
<br> `item_colour_variant`.`id` AS `colour_variantID`,
<br> `fit_type`.`id` AS `fitTypeID`
<br>FROM ((((((((`creator_account`
<br> JOIN `creator_subfolder`
<br> ON (`creator_subfolder`.`creator_accountID` = `creator_account`.`id`))
<br> JOIN `item_colour_variant`
<br> ON (`item_colour_variant`.`creator_subfolderID` = `creator_subfolder`.`id`))
<br> JOIN `item_colour`
<br> ON (`item_colour_variant`.`item_colourID` = `item_colour`.`id`))
<br> JOIN `creator_test_imgs`
<br> ON (`creator_test_imgs`.`creator_subfolderID` = `creator_subfolder`.`id`))
<br> JOIN `gender_fit`
<br> ON (`creator_test_imgs`.`gender_fitID` = `gender_fit`.`id`))
<br> JOIN `item_type`
<br> ON (`creator_test_imgs`.`item_typeID` = `item_type`.`id`))
<br> JOIN `neck_line_type`
<br> ON (`creator_test_imgs`.`neck_line_typeID` = `neck_line_type`.`id`))
<br> JOIN `fit_type`
<br> ON (`creator_test_imgs`.`fit_typeID` = `fit_type`.`id`))
<br> `creator_account`.`user_name` AS `user_name`,
<br> `creator_account`.`main_design_folder` AS `mainFolder`,
<br> `creator_subfolder`.`design_sub_folder` AS `subFolder`,
<br> `fit_type`.`fit_category` AS `fitType`,
<br> `item_type`.`category_type` AS `category_type`,
<br> `gender_fit`.`fit_style` AS `fit_style`,
<br> `neck_line_type`.`style_type` AS `style_type`,
<br> `item_colour`.`colour_palette` AS `colour_palette`,
<br> `item_colour`.`colour_code` AS `colour_code`,
<br> `creator_test_imgs`.`img_location` AS `img_location`,
<br> `creator_subfolder`.`creator_accountID` AS `userID`,
<br> `item_colour_variant`.`item_colourID` AS `colourID`,
<br> `gender_fit`.`id` AS `genderID`,
<br> `item_type`.`id` AS `itemTypeID`,
<br> `creator_test_imgs`.`creator_subfolderID` AS `subFolderID`,
<br> `neck_line_type`.`id` AS `neckTypeID`,
<br> `item_colour_variant`.`id` AS `colour_variantID`,
<br> `fit_type`.`id` AS `fitTypeID`
<br>FROM ((((((((`creator_account`
<br> JOIN `creator_subfolder`
<br> ON (`creator_subfolder`.`creator_accountID` = `creator_account`.`id`))
<br> JOIN `item_colour_variant`
<br> ON (`item_colour_variant`.`creator_subfolderID` = `creator_subfolder`.`id`))
<br> JOIN `item_colour`
<br> ON (`item_colour_variant`.`item_colourID` = `item_colour`.`id`))
<br> JOIN `creator_test_imgs`
<br> ON (`creator_test_imgs`.`creator_subfolderID` = `creator_subfolder`.`id`))
<br> JOIN `gender_fit`
<br> ON (`creator_test_imgs`.`gender_fitID` = `gender_fit`.`id`))
<br> JOIN `item_type`
<br> ON (`creator_test_imgs`.`item_typeID` = `item_type`.`id`))
<br> JOIN `neck_line_type`
<br> ON (`creator_test_imgs`.`neck_line_typeID` = `neck_line_type`.`id`))
<br> JOIN `fit_type`
<br> ON (`creator_test_imgs`.`fit_typeID` = `fit_type`.`id`))