Hi I'm wondering if someone could help me with SQLAlchemy and WHERE clauses since I'm having trouble putting a query together.
What I want in my WHERE clause is the below, noting the brackets: WHERE (game_participation.was_a_sub = %s AND game_participation.was_subbed >= %s) OR (game_participation.was_a_sub <= %s AND game_participation.was_a_sub >= %s) AND game_participation.compid = %s AND game_participation.seasonid = %s GROUP BY game_participation.playerid The closest I have got to producing this in SQL Alchemy is this: statement = select([func.count(game_participation.c.idgame_participation),game_participation.c.playerid], or_( (( game_participation.c.was_a_sub == 0) & (game_participation.c.was_subbed >= 60 )) | (( game_participation.c.was_a_sub <= 30) & (game_participation.c.was_a_sub >= 1 )) ) & (and_(game_participation.c.compid == compid)) & (and_(game_participation.c.seasonid == seasonid)), group_by=[game_participation.c.playerid]) ... This in turn produces this in the WHERE clause which is not correct since the four elements in my OR clause area and encased in one bracket () only. I want ( W & X ) or ( Y & Z ) and i'm getting output of (W and X or Y and Z). Full output below: WHERE (game_participation.was_a_sub = %s AND game_participation.was_subbed >= %s OR game_participation.was_a_sub <= %s AND game_participation.was_a_sub >= %s) AND game_participation.compid = %s AND game_participation.seasonid = %s GROUP BY game_participation.playerid Any help would be appreciated. -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.