SELECT
    TS.ID AS ID_S,
    TS.SIZE AS SZ,
    TC.ID AS ID_C,
    TC.COLOR AS CL
    
FROM TBL_SIZE AS TS
    CROSS JOIN TBL_COLOR AS TC

WHERE TS.ID IN(1,3)

ORDER BY
    TS.ID DESC,
    TS.SIZE DESC;