9SQL

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)))))