WITH item_table AS
(
	SELECT  ITEM_CODE AS ITEM
	       ,ITEM_NAME AS I_NAME
	FROM ITEM
	WHERE STOCK_MANAGEMENT_TYPE = 1 
), color_table AS
(
	SELECT  CL_NAME as C_NAME
	FROM COLOR_TBL
), size_table AS
(
	SELECT  SIZE_NAME as S_NAME
	FROM SIZE_TBL
	LIMIT 10
)
SELECT
    ITEM, I_NAME, C_NAME, S_NAME
FROM
    item_table, color_table, size_table
ORDER BY ITEM, C_NAME desc, S_NAME desc;