Advertisement
Guest User

Untitled

a guest
Apr 23rd, 2014
44
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.39 KB | None | 0 0
  1. cursor.execute(
  2. "SELECT * FROM {jobs} WHERE {jobs}.status = 'open' AND NOT EXISTS ("
  3. "SELECT job_id FROM {jobmeta} WHERE {jobmeta}.job_id = {jobs}.id AND {jobmeta}.meta_key = 'pj_locked_by' AND {jobmeta}.meta_value IN ("
  4. "SELECT ID FROM {jobs} WHERE {jobs}.status != 'closed'"
  5. ")) ORDER BY {jobs}.ID ASC LIMIT 1;".format( jobs=config.DB_TABLE_JOBS, jobmeta=config.DB_TABLE_JOBMETA )
  6. );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement