SELECT L.*, L.LID as ID, L.LID as SITE_ID, 	C.FORMAT_DATE, C.FORMAT_DATETIME, C.FORMAT_NAME, C.WEEK_START, C.CHARSET, C.DIRECTION FROM b_lang L, b_culture C WHERE C.ID=L.CULTURE_ID AND L.ACTIVE='Y' ORDER BY 	LENGTH(L.DIR) DESC, 	L.DOMAIN_LIMITED DESC, 	L.SORT