SELECT `s`.*
FROM `servers` AS `s`
JOIN `server_mods` AS `sm1` ON `sm1`.`server_id` = `s`.`server_id` AND `sm1`.`mod_id` = 9
JOIN `server_mods` AS `sm2` ON `sm2`.`server_id` = `s`.`server_id` AND `sm2`.`mod_id` = 1SELECT *
FROM `servers`
WHERE `server_id` IN (
SELECT `server_id`
FROM `server_mods`
WHERE `mod_id` IN (9, 1)
GROUP BY `server_id`
HAVING COUNT(*) = 2
)SELECT `c`.`id` AS `city_id`, `u`.`id` AS `url_id`, `u`.`url` AS `url`
FROM (
SELECT `id`, `lastCheckTimestamp`
FROM `cities`
ORDER BY `lastCheckTimestamp`
LIMIT 1
) AS `c`
LEFT JOIN `urls` AS `u` ON `u`.`city_id` = `c`.`id`
AND `u`.`lastCheckTimestamp` < `c`.`lastCheckTimestamp`
LIMIT 1> SELECT * FROM `table` WHERE JSON_SEARCH(`items`, 'one', 10, null, '$.*.status') IS NOT NULL
{"2464": {"price": "122.97", "status": "10", "quantity": "1", "articleid": "2464", "warehouseid": "3"}, "2469": {"price": "165.61", "status": "10", "quantity": "1", "articleid": "2469", "warehouseid": "3"}, "2522": {"price": "64.18", "status": "10", "quantity": "1", "articleid": "2522", "warehouseid": "3"}, "2524": {"price": "198.73", "status": "10", "quantity": "1", "articleid": "2524", "warehouseid": "3"}}