Changeset 374:9a80851e24f1

Show
Ignore:
Timestamp:
05/18/2009 08:03:11 PM (3 years ago)
Author:
Dmitry Nezhevenko <dion@…>
Branch:
default
Message:

remove unused query

Files:
1 modified

Legend:

Unmodified
Added
Removed
  • sqlconvert/tmp.sql

    r373 r374  
    11DELETE FROM conference_jids where temporary=true; 
    2 DELETE FROM conference_jids where jid in (SELECT jid FROM (select jid, count(jid) as cnt from conference_jids group by conference_id, jid) as tbl where cnt > 1); 
     2// DELETE FROM conference_jids where jid in (SELECT jid FROM (select jid, count(jid) as cnt from conference_jids group by conference_id, jid) as tbl where cnt > 1); 
    33UPDATE conference_jids set jid=LOWER(jid); 
    44