query.m

    NSString *mainQuery = [NSString stringWithFormat:@"%@ %@ %@ %@ %@", @"(select \
                `px_scrum_dates`.`dateId`, `startDate`, `endDate`, `classTypeName`, `typeToken`, `placeName`, `placeCity` ,concat(concat(date_format(`startDate`, '%y%m%d'), '-'), `typeToken`) as `courseCode`, `trainerId`, `px_scrum_date_contents`.`dateTitle` \
                from \
                `px_scrum_dates`, \
                `px_scrum_class_types`, \
                `px_scrum_places`, \
                `px_scrum_place_contents`, \
                `px_scrum_trainerdate`, \
                `px_scrum_date_contents` \
                where \
                `classTypeId` = `typeId` \
                and `px_scrum_dates`.`placeId` = `px_scrum_places`.`placeId` \
                and `px_scrum_places`.`placeId` = `px_scrum_place_contents`.`placeId` \
                and `placeContentLanguage` = 'de' \
                and `px_scrum_date_contents`.`dateId` = `px_scrum_dates`.`dateId`\
                and `px_scrum_date_contents`.`dateContentLanguage` = 'de'\
                and `px_scrum_dates`.`dateId` = `px_scrum_trainerdate`.`dateId` \
                and ((`px_scrum_dates`.`typeId` <> 2 and `px_scrum_dates`.`typeId` <> 3) or (`px_scrum_trainerdate`.`trainerId` = 9 or `px_scrum_trainerdate`.`trainerId` = 10))\n",
    (showAllDatesButton.state == NSOnState ? @"" : [whereClause stringByAppendingString:@"\n"]),
                @") \
                union all \
                (select \
                 `px_scrum_dates`.`dateId`, `startDate`, `endDate`, `classTypeName`, `typeToken`, `placeName`, `placeCity` ,concat(concat(date_format(`startDate`, '%y%m%d'), '-'), `typeToken`) as `courseCode`, `trainerId`, `px_scrum_date_contents`.`dateTitle` \
                 from \
                 `px_scrum_dates`, \
                 `px_scrum_class_types`, \
                 `px_scrum_places`, \
                 `px_scrum_place_contents`, \
                 `px_scrum_trainerdate`, \
                 `px_scrum_date_contents` \
                 where \
                 `classTypeId` = `typeId` \
                 and `px_scrum_dates`.`placeId` = `px_scrum_places`.`placeId` \
                 and `px_scrum_places`.`placeId` = `px_scrum_place_contents`.`placeId` \
                 and `placeContentLanguage` = 'de' \
                 and `px_scrum_date_contents`.`dateId` = `px_scrum_dates`.`dateId`\
                 and `px_scrum_date_contents`.`dateContentLanguage` = 'de'\
                 and `px_scrum_dates`.`dateId` = `px_scrum_trainerdate`.`dateId` \
                 and `px_scrum_dates`.`dateId` not in (select `px_scrum_trainerdate`.`dateId` \
                                                       from `px_scrum_dates`, `px_scrum_trainerdate` \
                                                       where `px_scrum_dates`.`dateId` = `px_scrum_trainerdate`.`dateId` \
                 and ((`px_scrum_dates`.`typeId` <> 2 and `px_scrum_dates`.`typeId` <> 3) or (`px_scrum_trainerdate`.`trainerId` = 9 or `px_scrum_trainerdate`.`trainerId` = 10)))\n",
    (showAllDatesButton.state == NSOnState ? @"" : [whereClause stringByAppendingString:@"\n"]),
                 @") \
                order by `startDate` asc;"];
    
    NSLog(@"%@", mainQuery);
    
    _jsonSQL = [[[SQLConnection alloc] init] postSQLQuery:mainQuery];