MSSQL Query to MySQL Query

SELECT tbl_use.fld_use_id AS UseID,

( SELECT CAST( endar.fld_endars_id AS VARCHAR(8000) ) + ISNULL(','+ STUFF(( SELECT ',' + CAST( fld_endars_id AS VARCHAR(8000) ) FROM tbl_endars

INNER JOIN tbl_endar_lca AS endar_LCA ON fld_endar_lca_endars_id = fld_endars_id

WHERE endar_LCA.fld_endar_lca_use_id = 1 AND endar_LCA.fld_endar_lca_privilege >= 4

FOR XML PATH( '' ) ), 1, 1, '' ),'') ) AS endarID,

tbl_use.fld_use_ail AS Useail

FROM tbl_endars as endar

LEFT JOIN tbl_use ON endar.fld_endars_owner_id = tbl_use.fld_use_id

WHERE (tbl_use.fld_use_isive='true' AND tbl_use.fld_use_event = 'true' AND tbl_use.fld_use_anch_id IN ( '15430235434543' )) ORDER BY tbl_use.fld_use_anch_id