1 | UPDATE locality SET weather = '{\"date\":\"2024-04-19\",\"data\":{\"2024-04-19\":{\"01\":{\"temp\":1,\"pressure\":1023,\"humidity\":85,\"icon\":\"04n\",\"wind\":1},\"04\":{\"temp\":1,\"pressure\":1023,\"humidity\":90,\"icon\":\"04n\",\"wind\":1},\"07\":{\"temp\":4,\"pressure\":1022,\"humidity\":80,\"icon\":\"04d\",\"wind\":2},\"10\":{\"temp\":11,\"pressure\":1019,\"humidity\":59,\"icon\":\"03d\",\"wind\":4},\"13\":{\"temp\":14,\"pressure\":1015,\"humidity\":45,\"icon\":\"03d\",\"wind\":5},\"16\":{\"temp\":13,\"pressure\":1013,\"humidity\":53,\"icon\":\"04d\",\"wind\":4},\"19\":{\"temp\":10,\"pressure\":1011,\"humidity\":65,\"icon\":\"04n\",\"wind\":5},\"22\":{\"temp\":7,\"pressure\":1010,\"humidity\":81,\"icon\":\"10n\",\"wind\":5}},\"2024-04-20\":{\"01\":{\"temp\":6,\"pressure\":1008,\"humidity\":87,\"icon\":\"10n\",\"wind\":6},\"04\":{\"temp\":6,\"pressure\":1007,\"humidity\":90,\"icon\":\"04n\",\"wind\":5},\"07\":{\"temp\":5,\"pressure\":1008,\"humidity\":58,\"icon\":\"04d\",\"wind\":6},\"10\":{\"temp\":8,\"pressure\":1007,\"humidity\":45,\"icon\":\"04d\",\"wind\":7},\"13\":{\"temp\":10,\"pressure\":1005,\"humidity\":37,\"icon\":\"04d\",\"wind\":6},\"16\":{\"temp\":9,\"pressure\":1005,\"humidity\":44,\"icon\":\"04d\",\"wind\":5},\"19\":{\"temp\":5,\"pressure\":1005,\"humidity\":64,\"icon\":\"04n\",\"wind\":4},\"22\":{\"temp\":3,\"pressure\":1006,\"humidity\":74,\"icon\":\"04n\",\"wind\":3}},\"2024-04-21\":{\"01\":{\"temp\":1,\"pressure\":1006,\"humidity\":83,\"icon\":\"04n\",\"wind\":2},\"04\":{\"temp\":-1,\"pressure\":1006,\"humidity\":88,\"icon\":\"02n\",\"wind\":2},\"07\":{\"temp\":4,\"pressure\":1006,\"humidity\":71,\"icon\":\"03d\",\"wind\":5},\"10\":{\"temp\":7,\"pressure\":1005,\"humidity\":48,\"icon\":\"10d\",\"wind\":6},\"13\":{\"temp\":8,\"pressure\":1004,\"humidity\":43,\"icon\":\"04d\",\"wind\":6},\"16\":{\"temp\":7,\"pressure\":1004,\"humidity\":50,\"icon\":\"04d\",\"wind\":6},\"19\":{\"temp\":4,\"pressure\":1004,\"humidity\":68,\"icon\":\"04n\",\"wind\":5},\"22\":{\"temp\":3,\"pressure\":1002,\"humidity\":79,\"icon\":\"04n\",\"wind\":5}}}}' WHERE id = 17943 LIMIT 1 |
0 | SELECT * FROM `category` WHERE `id` IN ('96','97','98','99','100','101','102','103','104','106','107','108','110','114','118','120','121','123','126','127','130','131','133','139','142','143','144','148','152','161','164','167') ORDER BY name |