SELECT
t1.m_ID,
t3.ScriptName,
t1.m_faction, t1.m_instance_id, t1.m_supercedes, t1.m_title_lang_zhTW, t1.m_title_lang_Mask, t1.m_description_lang_zhTW, t1.m_description_lang_Mask,
t1.m_category, t1.m_points, t1.m_ui_order, t1.m_flags, t1.m_iconID, t1.m_reward_lang_zhTW, t1.m_reward_lang_Mask, t1.m_minimum_criteria, t1.m_shares_criteria,
t2.m_ID, t2.m_achievement_id, t2.m_type, t2.m_asset_id, t2.m_quantity, t2.m_start_event, t2.m_start_asset, t2.m_fail_event, t2.m_fail_asset,
t2.m_description_lang_zhTW,  t2.m_description_lang_Mask, t2.m_flags, t2.m_timer_start_event, t2.m_timer_asset_id, t2.m_timer_time, t2.m_ui_order
FROM `db_achievement_12340` t1 LEFT JOIN `db_achievement_criteria_12340` t2 ON t1.m_ID = t2.m_achievement_id LEFT JOIN creature_template t3
ON t2.m_asset_id  = t3.entry
WHERE t2.m_achievement_id IN (6062, 6065, 6067, 6068, 6069, 6070, 6071, 6072, 6073, 6074, 6075, 6076, 6077, 6078, 6081, 6082, 6084, 6085, 6086, 6089, 6092, 6093, 6094, 6095, 6096, 6097, 6098, 6099, 6100, 6101, 6102, 6105, 6106, 6108, 6109, 6110, 6111, 6112, 6113, 6114, 6115, 6116, 6117, 6118, 6119, 6120, 6121, 6122, 6123, 6124, 6125, 6126, 6127, 6128, 6129, 6130, 6131, 6134, 6135, 6136, 6137, 6138, 6139, 6140, 6141, 6143, 6144, 6145, 6146, 6147, 6148, 6149, 6150, 6151, 6152, 6153, 6154, 6155, 6156, 6157, 6158, 6159, 6160, 6161, 6162, 6163, 6164, 6165, 6166, 6167, 6168, 6169, 6170, 6171, 6172, 6173, 6174, 6175, 6176, 6177, 6178, 6179, 6180, 6181, 6182, 6183, 6184, 6185, 6186, 6187, 6188, 6189, 6190, 6191, 6192, 6193, 6194, 6195, 6196, 6197, 6198, 6199, 6200, 6201, 6202, 6203, 6204, 6205, 6206) AND `ScriptName` IN ('boss_alar','boss_kaelthas','boss_void_reaver','boss_high_astromancer_solarian')
ORDER BY `ScriptName`;