9SQL
| Rad 9: | Rad 9: | ||
SEVENTTYPES.NAME LIKE 'KONSERT%' AND ADATES.SEASON_ID = 120 AND | SEVENTTYPES.NAME LIKE 'KONSERT%' AND ADATES.SEASON_ID = 120 AND | ||
| − | SPROJECTS.NAME LIKE '__7%' AND | + | (SPROJECTS.NAME LIKE '__7%') AND |
( SWORKS.COMPOSER_ID IN (SELECT SCOMPOSERS.ID FROM SCOMPOSERS WHERE (((SCOMPOSERS.LASTNAME NOT LIKE '%/%%' OR SCOMPOSERS.LASTNAME IS NULL)))) OR SWORKS.ID IN (SELECT SWORK_COMPOSERS.WORK_ID FROM SWORK_COMPOSERS INNER JOIN SCOMPOSERS ON SWORK_COMPOSERS.COMPOSER_ID=SCOMPOSERS.ID WHERE (((SCOMPOSERS.LASTNAME NOT LIKE '%/%%' OR SCOMPOSERS.LASTNAME IS NULL))))) AND | ( SWORKS.COMPOSER_ID IN (SELECT SCOMPOSERS.ID FROM SCOMPOSERS WHERE (((SCOMPOSERS.LASTNAME NOT LIKE '%/%%' OR SCOMPOSERS.LASTNAME IS NULL)))) OR SWORKS.ID IN (SELECT SWORK_COMPOSERS.WORK_ID FROM SWORK_COMPOSERS INNER JOIN SCOMPOSERS ON SWORK_COMPOSERS.COMPOSER_ID=SCOMPOSERS.ID WHERE (((SCOMPOSERS.LASTNAME NOT LIKE '%/%%' OR SCOMPOSERS.LASTNAME IS NULL))))) AND | ||
( SWORKS.COMPOSER_ID IN (SELECT SCOMPOSERS.ID FROM SCOMPOSERS WHERE (((NOT SCOMPOSERS.DEATHYEAR>'' OR SCOMPOSERS.DEATHYEAR IS NULL)))) OR SWORKS.ID IN (SELECT SWORK_COMPOSERS.WORK_ID FROM SWORK_COMPOSERS INNER JOIN SCOMPOSERS ON SWORK_COMPOSERS.COMPOSER_ID=SCOMPOSERS.ID WHERE (((NOT SCOMPOSERS.DEATHYEAR>'' OR SCOMPOSERS.DEATHYEAR IS NULL))))) | ( SWORKS.COMPOSER_ID IN (SELECT SCOMPOSERS.ID FROM SCOMPOSERS WHERE (((NOT SCOMPOSERS.DEATHYEAR>'' OR SCOMPOSERS.DEATHYEAR IS NULL)))) OR SWORKS.ID IN (SELECT SWORK_COMPOSERS.WORK_ID FROM SWORK_COMPOSERS INNER JOIN SCOMPOSERS ON SWORK_COMPOSERS.COMPOSER_ID=SCOMPOSERS.ID WHERE (((NOT SCOMPOSERS.DEATHYEAR>'' OR SCOMPOSERS.DEATHYEAR IS NULL))))) | ||
Versionen från 3 november 2015 kl. 17.25
A
SEVENTTYPES.NAME LIKE 'KONSERT%' AND ADATES.SEASON_ID = 120 AND (SPROJECTS.NAME LIKE '__0%' OR SPROJECTS.NAME LIKE '__1%' OR SPROJECTS.NAME LIKE '__6%' OR SPROJECTS.NAME LIKE '__9%') AND ( SWORKS.COMPOSER_ID IN (SELECT SCOMPOSERS.ID FROM SCOMPOSERS WHERE (((SCOMPOSERS.LASTNAME NOT LIKE '%/%%' OR SCOMPOSERS.LASTNAME IS NULL)))) OR SWORKS.ID IN (SELECT SWORK_COMPOSERS.WORK_ID FROM SWORK_COMPOSERS INNER JOIN SCOMPOSERS ON SWORK_COMPOSERS.COMPOSER_ID=SCOMPOSERS.ID WHERE (((SCOMPOSERS.LASTNAME NOT LIKE '%/%%' OR SCOMPOSERS.LASTNAME IS NULL))))) AND ( SWORKS.COMPOSER_ID IN (SELECT SCOMPOSERS.ID FROM SCOMPOSERS WHERE (((NOT SCOMPOSERS.DEATHYEAR> OR SCOMPOSERS.DEATHYEAR IS NULL)))) OR SWORKS.ID IN (SELECT SWORK_COMPOSERS.WORK_ID FROM SWORK_COMPOSERS INNER JOIN SCOMPOSERS ON SWORK_COMPOSERS.COMPOSER_ID=SCOMPOSERS.ID WHERE (((NOT SCOMPOSERS.DEATHYEAR> OR SCOMPOSERS.DEATHYEAR IS NULL)))))
B
SEVENTTYPES.NAME LIKE 'KONSERT%' AND ADATES.SEASON_ID = 120 AND (SPROJECTS.NAME LIKE '__7%') AND ( SWORKS.COMPOSER_ID IN (SELECT SCOMPOSERS.ID FROM SCOMPOSERS WHERE (((SCOMPOSERS.LASTNAME NOT LIKE '%/%%' OR SCOMPOSERS.LASTNAME IS NULL)))) OR SWORKS.ID IN (SELECT SWORK_COMPOSERS.WORK_ID FROM SWORK_COMPOSERS INNER JOIN SCOMPOSERS ON SWORK_COMPOSERS.COMPOSER_ID=SCOMPOSERS.ID WHERE (((SCOMPOSERS.LASTNAME NOT LIKE '%/%%' OR SCOMPOSERS.LASTNAME IS NULL))))) AND ( SWORKS.COMPOSER_ID IN (SELECT SCOMPOSERS.ID FROM SCOMPOSERS WHERE (((NOT SCOMPOSERS.DEATHYEAR> OR SCOMPOSERS.DEATHYEAR IS NULL)))) OR SWORKS.ID IN (SELECT SWORK_COMPOSERS.WORK_ID FROM SWORK_COMPOSERS INNER JOIN SCOMPOSERS ON SWORK_COMPOSERS.COMPOSER_ID=SCOMPOSERS.ID WHERE (((NOT SCOMPOSERS.DEATHYEAR> OR SCOMPOSERS.DEATHYEAR IS NULL)))))
