SELECT models.*, COALESCE(modelOnline.previewUrl, '') AS previewUrl, IF(models.registeredAt > 1718733806, 1, 0) AS isNew, IF(modelOnline.id IS NOT NULL, 1, 0) AS isOnline, languages.title_ja AS language, names.text AS name FROM models INNER JOIN modelOnline ON modelOnline.id = models.id LEFT JOIN languages ON languages.id = models.languageId LEFT JOIN names ON names.id = models.nameId WHERE models.hairColorId = 3 AND (models.isDisabled = 0 OR models.isDisabled = 2) ORDER BY models.memberCount DESC, models.onlineCount DESC, models.id ASC LIMIT 7632, 36