SELECT
    ts.ID as ID_S,
    ts.SIZE as SZ,
    tc.ID as ID_C,
    tc.COLOR as CL
FROM
    TBL_COLOR as tc
CROSS JOIN
    TBL_SIZE as ts
WHERE
    ts.id IN ("1", "3")
ORDER BY
    ID_S DESC, ID_C DESC;