mysql> insert into pwg_revisions_compatibilities (idx_version, idx_revision) select 78, max(idx_revision) from pwg_revisions_compatibilities join pwg_revisions r on idx_revision=id_revision join pwg_extensions_categories ec on ec.idx_extension=r.idx_extension where idx_version=77 and idx_category in (11,12) group by r.idx_extension;
Query OK, 170 rows affected (0.38 sec)
Records: 170  Duplicates: 0  Warnings: 0

idx_version 77 => 2.7
idx_version 78 => 2.8

idx_category 11 => tools
idx_category 12 => plugins