需求:
查询用户房间type为2的房间战绩排行榜 根据 主条件killNum做降序, 次条件scoreNum做降序,一个用户只能出现一次取其最高的数据
在同样环境,数据相同的情况下,查询出来的数据不同 纠结了许久
答案数据返回正确 但是我心里摸不着底SQL感觉还需要优化 也喜欢CSDN的大佬们有时间能看一看
有limit 正常:
无limit 不正常:
表结构如下:
用户表:
CREATE TABLE ss_account
(id
int(11) NOT NULL AUTO_INCREMENT,name
varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
PRIMARY KEY (id
) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 125 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
房间id表:
CREATE TABLE ss_room_inc_id
(id
int(11) NOT NULL AUTO_INCREMENT ,type
tinyint(1) NOT NULL ,create_time
int(10) NOT NULL DEFAULT 0 ,
PRIMARY KEY (id
) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2065 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
房间战绩表:
CREATE TABLE ss_game_record
(id
int(11) NOT NULL AUTO_INCREMENT ,account_id
int(11) NOT NULL,room_id
int(11) NOT NULL ,score_num
int(11) NOT NULL,kill_num
int(11) NOT NULL,
PRIMARY KEY (id
) USING BTREE,
) ENGINE = InnoDB AUTO_INCREMENT = 156 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
SET FOREIGN_KEY_CHECKS = 1;
表数据:
INSERT INTO ss_account
VALUES (120, 'Dean');
INSERT INTO ss_account
VALUES (121, '');
INSERT INTO ss_account
VALUES (122, '丑娃儿');
INSERT INTO ss_account
VALUES (123, '一万年');
INSERT INTO ss_account
VALUES (124, '单打独斗');
INSERT INTO ss_game_record
VALUES (2, 120, 1905, 120, 2);
INSERT INTO ss_game_record
VALUES (3, 121, 1906, 80, 1);
INSERT INTO ss_game_record
VALUES (4, 122, 1907, 70, 5);
INSERT INTO ss_game_record
VALUES (5, 122, 1908, 80, 5);
INSERT INTO ss_game_record
VALUES (6, 120, 1909, 100, 0);
INSERT INTO ss_game_record
VALUES (7, 120, 1910, 70, 0);
INSERT INTO ss_game_record
VALUES (8, 120, 1911, 45, 1);
INSERT INTO ss_game_record
VALUES (9, 120, 1912, 195, 1);
INSERT INTO ss_game_record
VALUES (10, 122, 1913, 110, 4);
INSERT INTO ss_game_record
VALUES (11, 120, 1914, 75, 1);
INSERT INTO ss_game_record
VALUES (12, 120, 1915, 105, 0);
INSERT INTO ss_game_record
VALUES (13, 120, 1916, 140, 1);
INSERT INTO ss_game_record
VALUES (14, 120, 1917, 180, 1);
INSERT INTO ss_game_record
VALUES (15, 120, 1918, 495, 0);
INSERT INTO ss_game_record
VALUES (16, 120, 1919, 170, 1);
INSERT INTO ss_game_record
VALUES (17, 120, 1920, 205, 0);
INSERT INTO ss_game_record
VALUES (18, 120, 1921, 435, 0);
INSERT INTO ss_game_record
VALUES (19, 120, 1922, 95, 1);
INSERT INTO ss_game_record
VALUES (20, 120, 1923, 105, 1);
INSERT INTO ss_game_record
VALUES (21, 122, 1924, 230, 0);
INSERT INTO ss_game_record
VALUES (22, 122, 1925, 145, 0);
INSERT INTO ss_game_record
VALUES (23, 122, 1926, 55, 0);
INSERT INTO ss_game_record
VALUES (24, 122, 1927, 325, 0);
INSERT INTO ss_game_record
VALUES (25, 122, 1928, 235, 0);
INSERT INTO ss_game_record
VALUES (26, 122, 1930, 45, 0);
INSERT INTO ss_game_record
VALUES (27, 123, 1929, 70, 0);
INSERT INTO ss_game_record
VALUES (28, 122, 1931, 25, 0);
INSERT INTO ss_game_record
VALUES (29, 122, 1932, 25, 0);
INSERT INTO ss_game_record
VALUES (30, 122, 1933, 35, 0);
INSERT INTO ss_game_record
VALUES (31, 122, 1934, 25, 0);
INSERT INTO ss_game_record
VALUES (32, 122, 1935, 25, 0);
INSERT INTO ss_game_record
VALUES (33, 122, 1936, 55, 0);
INSERT INTO ss_game_record
VALUES (34, 122, 1937, 25, 0);
INSERT INTO ss_game_record
VALUES (35, 122, 1938, 115, 0);
INSERT INTO ss_game_record
VALUES (36, 122, 1939, 135, 0);
INSERT INTO ss_game_record
VALUES (37, 122, 1940, 105, 0);
INSERT INTO ss_game_record
VALUES (38, 122, 1941, 95, 0);
INSERT INTO ss_game_record
VALUES (39, 120, 1942, 380, 0);
INSERT INTO ss_game_record
VALUES (40, 122, 1943, 45, 0);
INSERT INTO ss_game_record
VALUES (41, 120, 1945, 2640, 3);
INSERT INTO ss_game_record
VALUES (42, 122, 1944, 35, 0);
INSERT INTO ss_game_record
VALUES (43, 122, 1946, 25, 0);
INSERT INTO ss_game_record
VALUES (44, 122, 1947, 35, 0);
INSERT INTO ss_game_record
VALUES (45, 122, 1948, 30, 0);
INSERT INTO ss_game_record
VALUES (46, 122, 1950, 45, 0);
INSERT INTO ss_game_record
VALUES (47, 122, 1951, 45, 0);
INSERT INTO ss_game_record
VALUES (48, 122, 1952, 35, 0);
INSERT INTO ss_game_record
VALUES (49, 122, 1954, 35, 0);
INSERT INTO ss_game_record
VALUES (50, 122, 1953, 100, 0);
INSERT INTO ss_game_record
VALUES (51, 122, 1956, 100, 0);
INSERT INTO ss_game_record
VALUES (52, 122, 1957, 25, 0);
INSERT INTO ss_game_record
VALUES (53, 122, 1958, 80, 0);
INSERT INTO ss_game_record
VALUES (54, 122, 1955, 30, 0);
INSERT INTO ss_game_record
VALUES (55, 122, 1959, 85, 0);
INSERT INTO ss_game_record
VALUES (56, 122, 1960, 45, 0);
INSERT INTO ss_game_record
VALUES (57, 122, 1961, 45, 0);
INSERT INTO ss_game_record
VALUES (58, 122, 1962, 30, 0);
INSERT INTO ss_game_record
VALUES (59, 122, 1963, 65, 0);
INSERT INTO ss_game_record
VALUES (60, 122, 1964, 75, 0);
INSERT INTO ss_game_record
VALUES (61, 122, 1967, 25, 0);
INSERT INTO ss_game_record
VALUES (62, 122, 1966, 110, 0);
INSERT INTO ss_game_record
VALUES (63, 122, 1968, 25, 0);
INSERT INTO ss_game_record
VALUES (64, 122, 1969, 55, 0);
INSERT INTO ss_game_record
VALUES (65, 122, 1970, 25, 0);
INSERT INTO ss_game_record
VALUES (66, 122, 1974, 45, 0);
INSERT INTO ss_game_record
VALUES (67, 122, 1973, 80, 0);
INSERT INTO ss_game_record
VALUES (68, 122, 1972, 90, 0);
INSERT INTO ss_game_record
VALUES (69, 122, 1971, 110, 0);
INSERT INTO ss_game_record
VALUES (70, 122, 1975, 25, 0);
INSERT INTO ss_game_record
VALUES (71, 122, 1977, 25, 0);
INSERT INTO ss_game_record
VALUES (72, 122, 1976, 100, 0);
INSERT INTO ss_game_record
VALUES (73, 122, 1978, 35, 0);
INSERT INTO ss_game_record
VALUES (74, 122, 1979, 45, 0);
INSERT INTO ss_game_record
VALUES (75, 122, 1980, 40, 0);
INSERT INTO ss_game_record
VALUES (76, 122, 1983, 25, 0);
INSERT INTO ss_game_record
VALUES (77, 122, 1984, 25, 0);
INSERT INTO ss_game_record
VALUES (78, 122, 1981, 180, 0);
INSERT INTO ss_game_record
VALUES (79, 122, 1985, 25, 0);
INSERT INTO ss_game_record
VALUES (80, 122, 1982, 50, 0);
INSERT INTO ss_game_record
VALUES (81, 122, 1989, 25, 0);
INSERT INTO ss_game_record
VALUES (82, 122, 1986, 85, 0);
INSERT INTO ss_game_record
VALUES (83, 122, 1990, 80, 0);
INSERT INTO ss_game_record
VALUES (84, 122, 1987, 165, 0);
INSERT INTO ss_game_record
VALUES (85, 122, 1988, 45, 0);
INSERT INTO ss_game_record
VALUES (86, 122, 1991, 65, 0);
INSERT INTO ss_game_record
VALUES (87, 122, 1992, 40, 0);
INSERT INTO ss_game_record
VALUES (88, 122, 1993, 80, 0);
INSERT INTO ss_game_record
VALUES (89, 122, 1994, 650, 0);
INSERT INTO ss_game_record
VALUES (90, 122, 1995, 140, 0);
INSERT INTO ss_game_record
VALUES (91, 122, 1997, 190, 0);
INSERT INTO ss_game_record
VALUES (92, 120, 2001, 0, 0);
INSERT INTO ss_game_record
VALUES (93, 122, 1999, 75, 0);
INSERT INTO ss_game_record
VALUES (94, 120, 2002, 585, 0);
INSERT INTO ss_game_record
VALUES (95, 120, 2005, 115, 0);
INSERT INTO ss_game_record
VALUES (96, 122, 2003, 125, 0);
INSERT INTO ss_game_record
VALUES (97, 122, 2004, 55, 0);
INSERT INTO ss_game_record
VALUES (98, 122, 2000, 35, 0);
INSERT INTO ss_game_record
VALUES (99, 122, 2006, 90, 0);
INSERT INTO ss_game_record
VALUES (100, 120, 2008, 880, 2);
INSERT INTO ss_game_record
VALUES (101, 120, 2011, 380, 0);
INSERT INTO ss_game_record
VALUES (102, 122, 2009, 180, 0);
INSERT INTO ss_game_record
VALUES (103, 120, 2012, 730, 1);
INSERT INTO ss_game_record
VALUES (104, 120, 2013, 0, 0);
INSERT INTO ss_game_record
VALUES (105, 122, 2007, 310, 0);
INSERT INTO ss_game_record
VALUES (106, 120, 2014, 635, 0);
INSERT INTO ss_game_record
VALUES (107, 122, 2015, 55, 0);
INSERT INTO ss_game_record
VALUES (108, 122, 2016, 75, 0);
INSERT INTO ss_game_record
VALUES (109, 122, 2017, 240, 0);
INSERT INTO ss_game_record
VALUES (110, 122, 2018, 25, 0);
INSERT INTO ss_game_record
VALUES (111, 122, 2019, 140, 0);
INSERT INTO ss_game_record
VALUES (112, 122, 2020, 35, 0);
INSERT INTO ss_game_record
VALUES (113, 122, 2021, 25, 0);
INSERT INTO ss_game_record
VALUES (114, 122, 2022, 40, 0);
INSERT INTO ss_game_record
VALUES (115, 122, 2023, 25, 0);
INSERT INTO ss_game_record
VALUES (116, 122, 2024, 35, 0);
INSERT INTO ss_game_record
VALUES (117, 122, 2025, 25, 0);
INSERT INTO ss_game_record
VALUES (118, 122, 2026, 60, 0);
INSERT INTO ss_game_record
VALUES (119, 122, 2027, 55, 0);
INSERT INTO ss_game_record
VALUES (120, 122, 2028, 25, 0);
INSERT INTO ss_game_record
VALUES (121, 122, 2029, 25, 0);
INSERT INTO ss_game_record
VALUES (122, 122, 2030, 25, 0);
INSERT INTO ss_game_record
VALUES (123, 122, 2031, 105, 0);
INSERT INTO ss_game_record
VALUES (124, 122, 2032, 50, 0);
INSERT INTO ss_game_record
VALUES (125, 122, 2033, 25, 0);
INSERT INTO ss_game_record
VALUES (126, 122, 2034, 25, 0);
INSERT INTO ss_game_record
VALUES (127, 122, 2035, 25, 0);
INSERT INTO ss_game_record
VALUES (128, 122, 2036, 45, 0);
INSERT INTO ss_game_record
VALUES (129, 122, 2037, 25, 0);
INSERT INTO ss_game_record
VALUES (130, 122, 2038, 425, 0);
INSERT INTO ss_game_record
VALUES (131, 122, 2039, 50, 0);
INSERT INTO ss_game_record
VALUES (132, 122, 2040, 65, 0);
INSERT INTO ss_game_record
VALUES (133, 122, 2041, 195, 0);
INSERT INTO ss_game_record
VALUES (134, 122, 2042, 250, 0);
INSERT INTO ss_game_record
VALUES (135, 122, 2043, 25, 0);
INSERT INTO ss_game_record
VALUES (136, 122, 2044, 100, 0);
INSERT INTO ss_game_record
VALUES (137, 122, 2045, 25, 0);
INSERT INTO ss_game_record
VALUES (138, 122, 2046, 70, 0);
INSERT INTO ss_game_record
VALUES (139, 122, 2047, 30, 0);
INSERT INTO ss_game_record
VALUES (140, 122, 2048, 110, 0);
INSERT INTO ss_game_record
VALUES (141, 122, 2050, 25, 0);
INSERT INTO ss_game_record
VALUES (142, 122, 2049, 330, 0);
INSERT INTO ss_game_record
VALUES (143, 122, 2051, 45, 0);
INSERT INTO ss_game_record
VALUES (144, 122, 2052, 35, 0);
INSERT INTO ss_game_record
VALUES (145, 122, 2053, 25, 0);
INSERT INTO ss_game_record
VALUES (146, 122, 2054, 110, 0);
INSERT INTO ss_game_record
VALUES (147, 122, 2055, 230, 0);
INSERT INTO ss_game_record
VALUES (148, 122, 2056, 105, 0);
INSERT INTO ss_game_record
VALUES (149, 122, 2057, 175, 0);
INSERT INTO ss_game_record
VALUES (150, 122, 2058, 585, 0);
INSERT INTO ss_game_record
VALUES (151, 122, 2059, 60, 0);
INSERT INTO ss_game_record
VALUES (152, 122, 2060, 160, 0);
INSERT INTO ss_game_record
VALUES (153, 122, 2061, 170, 0);
INSERT INTO ss_game_record
VALUES (154, 122, 2062, 255, 0);
INSERT INTO ss_game_record
VALUES (155, 122, 2063, 250, 0);
INSERT INTO ss_room_inc_id
VALUES (1905, 2, 1543304140);
INSERT INTO ss_room_inc_id
VALUES (1906, 2, 1543304154);
INSERT INTO ss_room_inc_id
VALUES (1907, 2, 1543304140);
INSERT INTO ss_room_inc_id
VALUES (1908, 2, 1143304770);
INSERT INTO ss_room_inc_id
VALUES (1909, 1, 1543304770);
INSERT INTO ss_room_inc_id
VALUES (1910, 1, 1543304770);
INSERT INTO ss_room_inc_id
VALUES (1911, 1, 1543304862);
INSERT INTO ss_room_inc_id
VALUES (1912, 2, 1543304862);
INSERT INTO ss_room_inc_id
VALUES (1913, 2, 1543304862);
INSERT INTO ss_room_inc_id
VALUES (1914, 1, 1543305379);
INSERT INTO ss_room_inc_id
VALUES (1915, 1, 1543305379);
INSERT INTO ss_room_inc_id
VALUES (1916, 1, 1543305491);
INSERT INTO ss_room_inc_id
VALUES (1917, 1, 1543305491);
INSERT INTO ss_room_inc_id
VALUES (1918, 1, 1543306739);
INSERT INTO ss_room_inc_id
VALUES (1919, 1, 1543306740);
INSERT INTO ss_room_inc_id
VALUES (1920, 2, 1543306872);
INSERT INTO ss_room_inc_id
VALUES (1921, 2, 1543306930);
INSERT INTO ss_room_inc_id
VALUES (1922, 1, 1543306934);
INSERT INTO ss_room_inc_id
VALUES (1923, 1, 1543306934);
INSERT INTO ss_room_inc_id
VALUES (1924, 1, 1543308579);
INSERT INTO ss_room_inc_id
VALUES (1925, 1, 1543308579);
INSERT INTO ss_room_inc_id
VALUES (1926, 1, 1543309072);
INSERT INTO ss_room_inc_id
VALUES (1927, 1, 1543309072);
INSERT INTO ss_room_inc_id
VALUES (1928, 1, 1543309199);
INSERT INTO ss_room_inc_id
VALUES (1929, 1, 1543309199);
INSERT INTO ss_room_inc_id
VALUES (1930, 1, 1543309277);
INSERT INTO ss_room_inc_id
VALUES (1931, 1, 1543309277);
INSERT INTO ss_room_inc_id
VALUES (1932, 1, 1543309626);
INSERT INTO ss_room_inc_id
VALUES (1933, 1, 1543309626);
INSERT INTO ss_room_inc_id
VALUES (1934, 1, 1543309635);
INSERT INTO ss_room_inc_id
VALUES (1935, 1, 1543309636);
INSERT INTO ss_room_inc_id
VALUES (1936, 1, 1543309685);
INSERT INTO ss_room_inc_id
VALUES (1937, 1, 1543309685);
INSERT INTO ss_room_inc_id
VALUES (1938, 1, 1543309722);
INSERT INTO ss_room_inc_id
VALUES (1939, 1, 1543309722);
INSERT INTO ss_room_inc_id
VALUES (1940, 1, 1543309770);
INSERT INTO ss_room_inc_id
VALUES (1941, 1, 1543309770);
INSERT INTO ss_room_inc_id
VALUES (1942, 2, 1543309797);
INSERT INTO ss_room_inc_id
VALUES (1943, 1, 1543309889);
INSERT INTO ss_room_inc_id
VALUES (1944, 1, 1243309889);
INSERT INTO ss_room_inc_id
VALUES (1945, 2, 1243310030);
INSERT INTO ss_room_inc_id
VALUES (1946, 1, 1543310151);
INSERT INTO ss_room_inc_id
VALUES (1947, 1, 1543310151);
INSERT INTO ss_room_inc_id
VALUES (1948, 1, 1543310160);
INSERT INTO ss_room_inc_id
VALUES (1949, 1, 1543310160);
INSERT INTO ss_room_inc_id
VALUES (1950, 1, 1543310233);
INSERT INTO ss_room_inc_id
VALUES (1951, 1, 1543310233);
INSERT INTO ss_room_inc_id
VALUES (1952, 1, 1543310244);
INSERT INTO ss_room_inc_id
VALUES (1953, 1, 1543310244);
INSERT INTO ss_room_inc_id
VALUES (1954, 1, 1543310255);
INSERT INTO ss_room_inc_id
VALUES (1955, 1, 1543310255);
INSERT INTO ss_room_inc_id
VALUES (1956, 1, 1543310300);
INSERT INTO ss_room_inc_id
VALUES (1957, 1, 1543310300);
INSERT INTO ss_room_inc_id
VALUES (1958, 1, 1543310462);
INSERT INTO ss_room_inc_id
VALUES (1959, 1, 1543310462);
INSERT INTO ss_room_inc_id
VALUES (1960, 1, 1543310487);
INSERT INTO ss_room_inc_id
VALUES (1961, 1, 1543310487);
INSERT INTO ss_room_inc_id
VALUES (1962, 1, 1543310496);
INSERT INTO ss_room_inc_id
VALUES (1963, 1, 1543310496);
INSERT INTO ss_room_inc_id
VALUES (1964, 1, 1543310561);
INSERT INTO ss_room_inc_id
VALUES (1965, 1, 1543310561);
INSERT INTO ss_room_inc_id
VALUES (1966, 1, 1543310902);
INSERT INTO ss_room_inc_id
VALUES (1967, 1, 1543310902);
INSERT INTO ss_room_inc_id
VALUES (1968, 1, 1543310946);
INSERT INTO ss_room_inc_id
VALUES (1969, 1, 1543310946);
INSERT INTO ss_room_inc_id
VALUES (1970, 1, 1543310953);
INSERT INTO ss_room_inc_id
VALUES (1971, 1, 1543310953);
INSERT INTO ss_room_inc_id
VALUES (1972, 1, 1543310961);
INSERT INTO ss_room_inc_id
VALUES (1973, 1, 1543310961);
INSERT INTO ss_room_inc_id
VALUES (1974, 1, 1543310967);
INSERT INTO ss_room_inc_id
VALUES (1975, 1, 1543310991);
INSERT INTO ss_room_inc_id
VALUES (1976, 1, 1543310991);
INSERT INTO ss_room_inc_id
VALUES (1977, 1, 1543311000);
INSERT INTO ss_room_inc_id
VALUES (1978, 1, 1543311000);
INSERT INTO ss_room_inc_id
VALUES (1979, 1, 1543311011);
INSERT INTO ss_room_inc_id
VALUES (1980, 1, 1543311011);
INSERT INTO ss_room_inc_id
VALUES (1981, 1, 1543311012);
INSERT INTO ss_room_inc_id
VALUES (1982, 1, 1543311012);
INSERT INTO ss_room_inc_id
VALUES (1983, 1, 1543311020);
INSERT INTO ss_room_inc_id
VALUES (1984, 1, 1543311020);
INSERT INTO ss_room_inc_id
VALUES (1985, 1, 1543311031);
INSERT INTO ss_room_inc_id
VALUES (1986, 1, 1543311031);
INSERT INTO ss_room_inc_id
VALUES (1987, 1, 1543311034);
INSERT INTO ss_room_inc_id
VALUES (1988, 1, 1543311034);
INSERT INTO ss_room_inc_id
VALUES (1989, 1, 1543311038);
INSERT INTO ss_room_inc_id
VALUES (1990, 1, 1543311038);
INSERT INTO ss_room_inc_id
VALUES (1991, 1, 1543311067);
INSERT INTO ss_room_inc_id
VALUES (1992, 1, 1543311067);
INSERT INTO ss_room_inc_id
VALUES (1993, 1, 1543311091);
INSERT INTO ss_room_inc_id
VALUES (1994, 1, 1543311091);
INSERT INTO ss_room_inc_id
VALUES (1995, 1, 1543311227);
INSERT INTO ss_room_inc_id
VALUES (1996, 1, 1543311227);
INSERT INTO ss_room_inc_id
VALUES (1997, 1, 1543311283);
INSERT INTO ss_room_inc_id
VALUES (1998, 1, 1543311283);
INSERT INTO ss_room_inc_id
VALUES (1999, 1, 1543311339);
INSERT INTO ss_room_inc_id
VALUES (2000, 1, 1543311339);
INSERT INTO ss_room_inc_id
VALUES (2001, 2, 1543311342);
INSERT INTO ss_room_inc_id
VALUES (2002, 2, 1543311400);
INSERT INTO ss_room_inc_id
VALUES (2003, 1, 1543311400);
INSERT INTO ss_room_inc_id
VALUES (2004, 1, 1543311400);
INSERT INTO ss_room_inc_id
VALUES (2005, 2, 1543311416);
INSERT INTO ss_room_inc_id
VALUES (2006, 1, 1543311514);
INSERT INTO ss_room_inc_id
VALUES (2007, 1, 1543311514);
INSERT INTO ss_room_inc_id
VALUES (2008, 2, 1543311526);
INSERT INTO ss_room_inc_id
VALUES (2009, 1, 1543311651);
INSERT INTO ss_room_inc_id
VALUES (2010, 1, 1543311651);
INSERT INTO ss_room_inc_id
VALUES (2011, 2, 1543311661);
INSERT INTO ss_room_inc_id
VALUES (2012, 2, 1543311716);
INSERT INTO ss_room_inc_id
VALUES (2013, 2, 1543311718);
INSERT INTO ss_room_inc_id
VALUES (2014, 2, 1543311787);
INSERT INTO ss_room_inc_id
VALUES (2015, 1, 1543312046);
INSERT INTO ss_room_inc_id
VALUES (2016, 1, 1543312046);
INSERT INTO ss_room_inc_id
VALUES (2017, 1, 1543312119);
INSERT INTO ss_room_inc_id
VALUES (2018, 1, 1543312119);
INSERT INTO ss_room_inc_id
VALUES (2019, 1, 1543312257);
INSERT INTO ss_room_inc_id
VALUES (2020, 1, 1543312257);
INSERT INTO ss_room_inc_id
VALUES (2021, 1, 1543312319);
INSERT INTO ss_room_inc_id
VALUES (2022, 1, 1543312319);
INSERT INTO ss_room_inc_id
VALUES (2023, 1, 1543312498);
INSERT INTO ss_room_inc_id
VALUES (2024, 1, 1543312498);
INSERT INTO ss_room_inc_id
VALUES (2025, 1, 1543312561);
INSERT INTO ss_room_inc_id
VALUES (2026, 1, 1543312561);
INSERT INTO ss_room_inc_id
VALUES (2027, 1, 1543312622);
INSERT INTO ss_room_inc_id
VALUES (2028, 1, 1543312622);
INSERT INTO ss_room_inc_id
VALUES (2029, 1, 1543312761);
INSERT INTO ss_room_inc_id
VALUES (2030, 1, 1543312761);
INSERT INTO ss_room_inc_id
VALUES (2031, 1, 1543312920);
INSERT INTO ss_room_inc_id
VALUES (2032, 1, 1543312920);
INSERT INTO ss_room_inc_id
VALUES (2033, 1, 1543313082);
INSERT INTO ss_room_inc_id
VALUES (2034, 1, 1543313082);
INSERT INTO ss_room_inc_id
VALUES (2035, 1, 1543313189);
INSERT INTO ss_room_inc_id
VALUES (2036, 1, 1543313189);
INSERT INTO ss_room_inc_id
VALUES (2037, 1, 1543313720);
INSERT INTO ss_room_inc_id
VALUES (2038, 1, 1543313720);
INSERT INTO ss_room_inc_id
VALUES (2039, 1, 1543313906);
INSERT INTO ss_room_inc_id
VALUES (2040, 1, 1543313906);
INSERT INTO ss_room_inc_id
VALUES (2041, 1, 1543314357);
INSERT INTO ss_room_inc_id
VALUES (2042, 1, 1543314357);
INSERT INTO ss_room_inc_id
VALUES (2043, 1, 1543314600);
INSERT INTO ss_room_inc_id
VALUES (2044, 1, 1543314600);
INSERT INTO ss_room_inc_id
VALUES (2045, 1, 1543314977);
INSERT INTO ss_room_inc_id
VALUES (2046, 1, 1543314977);
INSERT INTO ss_room_inc_id
VALUES (2047, 1, 1543315498);
INSERT INTO ss_room_inc_id
VALUES (2048, 1, 1543315498);
INSERT INTO ss_room_inc_id
VALUES (2049, 1, 1543315563);
INSERT INTO ss_room_inc_id
VALUES (2050, 1, 1543315563);
INSERT INTO ss_room_inc_id
VALUES (2051, 1, 1543315604);
INSERT INTO ss_room_inc_id
VALUES (2052, 1, 1543315604);
INSERT INTO ss_room_inc_id
VALUES (2053, 1, 1543315678);
INSERT INTO ss_room_inc_id
VALUES (2054, 1, 1543315678);
INSERT INTO ss_room_inc_id
VALUES (2055, 1, 1543316230);
INSERT INTO ss_room_inc_id
VALUES (2056, 1, 1543316230);
INSERT INTO ss_room_inc_id
VALUES (2057, 1, 1543316396);
INSERT INTO ss_room_inc_id
VALUES (2058, 1, 1543316396);
INSERT INTO ss_room_inc_id
VALUES (2059, 1, 1543318165);
INSERT INTO ss_room_inc_id
VALUES (2060, 1, 1543318165);
INSERT INTO ss_room_inc_id
VALUES (2061, 1, 1543318189);
INSERT INTO ss_room_inc_id
VALUES (2062, 1, 1543318189);
INSERT INTO ss_room_inc_id
VALUES (2063, 1, 1543318237);
INSERT INTO ss_room_inc_id
VALUES (2064, 1, 1543318237);