Pesquisar na Comunidade

Olá, alguém sabe que modificação devo fazer à seguinte query, deforma a que os registos com o room_id 1 e 2 da tabela boom_rooms fiquem sempre no topo? Obrigado. $rooms = $mysqli->query(" SELECT *, ( SELECT Count(boom_users.user_id) FROM boom_users Where boom_users.user_roomid = boom_rooms.room_id AND last_action > '$check_action' AND user_status != 6 ) as room_count FROM boom_rooms WHERE ORDER BY room_count DESC, room_id ASC");

Alguém tem ideia do que pode ser ? Em desenvolvimento funciona normal em produção e homologação com JAR não. Postgres 9.1 em produção e 9.0 em desenvolvimento. Exceção Gerada: org.postgresql.util. PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:381) at wfr.database.DBConnection.execStatement(DBConnection.java:1383) at wfr.com.systems.system_ami.rules.WebrunFunctions.ebfSQLExecuteUpdate(WebrunFunctions.java:12452) at wfr.com.systems.system_ami.rules.PatrimonioInsrerirAlterarDepois.run(PatrimonioInsrerirAlterarDepois.java:61) at wfr.rules.WFRRule.start(WFRRule.java:755) at wfr.rules.WFRRule.call(WFRRule.java:1817) at wfr.rules.WFRRule.call(WFRRule.java:57) at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source) at java.util.concurrent.FutureTask.run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) Tabela select * from pg_locks http://prntscr.com/8jgdif