9SQL
Rad 3: | Rad 3: | ||
SEVENTTYPES.NAME LIKE 'KONSERT%' AND ADATES.SEASON_ID = 120 AND | 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 | (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 (((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))))) | ||
B | B | ||
− | SEVENTTYPES.NAME LIKE ' | + | SEVENTTYPES.NAME LIKE 'K7NSERT%' 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 | (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 | + | ( 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))))) |
− | + |
Versionen från 3 november 2015 kl. 17.53
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 'K7NSERT%' 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)))))