SELECT (SELECT `alias1865450288`.`competition_Name` 
                            FROM `ys_competition_setup` AS `alias1865450288` 
                            WHERE `alias1865450288`.`competition_ID` = `ys_volunteer_setup`.`competition_ID` 
                            LIMIT 1) 
                            AS `rel.ys_volunteer_setup.competition_ID`, 
 `ys_volunteer_setup`.`competition_ID` AS `ys_volunteer_setup.competition_ID` 
,(SELECT `alias686942982`.`event_Name` 
                            FROM `lk_event` AS `alias686942982` 
                            WHERE `alias686942982`.`event_ID` = `ys_volunteer_setup`.`event_ID` 
                            LIMIT 1) 
                            AS `rel.ys_volunteer_setup.event_ID`, 
 `ys_volunteer_setup`.`event_ID` AS `ys_volunteer_setup.event_ID` 
,(SELECT `alias1656446558`.`position_Name` 
                            FROM `lk_position_in_event` AS `alias1656446558` 
                            WHERE `alias1656446558`.`position_ID` = `ys_volunteer_setup`.`position_ID` 
                            LIMIT 1) 
                            AS `rel.ys_volunteer_setup.position_ID`, 
 `ys_volunteer_setup`.`position_ID` AS `ys_volunteer_setup.position_ID` 
,`ys_volunteer_setup`.`V_time_array` AS `ys_volunteer_setup.V_time_array` 
,`ys_volunteer_setup`.`volunteer_Name` AS `ys_volunteer_setup.volunteer_Name` 
,`ys_volunteer_setup`.`phone_number` AS `ys_volunteer_setup.phone_number` 
,`ys_volunteer_setup`.`position_in_Competition_ID` AS `primary_key` 
 
 FROM `ys_volunteer_setup`
 
 
 
 LIMIT 0,25