SELECT `models`.*, `modelStreams`.`trailerUrl`, IF(`models`.`createdAt` > 1753363968 - 60 * 60 * 24 * 30, 1, 0) AS `isNew`, IF(`modelStreams`.`modelId` IS NOT NULL, 1, 0) AS `isOnline`, `names`.`text` AS `name`, `languages`.`title_ru` AS `language` , `buttSizes`.`title_ru` AS `buttSize` , `bustSizes`.`title_ru` AS `bustSize` , `hairColors`.`title_ru` AS `hairColor` , `eyeColors`.`title_ru` AS `eyeColor` , `pubicHairs`.`title_ru` AS `pubicHair` , `ethnicities`.`title_ru` AS `ethnicity` , `genders`.`title_ru` AS `gender` , `sexualPreferences`.`title_ru` AS `sexualPreference` FROM `models` INNER JOIN `modelTexts` ON `modelTexts`.`modelId` = `models`.`id` AND `modelTexts`.`languageId` = 4 LEFT JOIN `modelStreams` ON `modelStreams`.`modelId` = `models`.`id` INNER JOIN `names` ON `names`.`id` = `models`.`nameId` INNER JOIN `languages` ON `languages`.`id` = `models`.`languageId` INNER JOIN `buttSizes` ON `buttSizes`.`id` = `models`.`buttSizeId` INNER JOIN `bustSizes` ON `bustSizes`.`id` = `models`.`bustSizeId` INNER JOIN `hairColors` ON `hairColors`.`id` = `models`.`hairColorId` INNER JOIN `eyeColors` ON `eyeColors`.`id` = `models`.`eyeColorId` INNER JOIN `pubicHairs` ON `pubicHairs`.`id` = `models`.`pubicHairId` INNER JOIN `ethnicities` ON `ethnicities`.`id` = `models`.`ethnicityId` INNER JOIN `genders` ON `genders`.`id` = `models`.`genderId` INNER JOIN `sexualPreferences` ON `sexualPreferences`.`id` = `models`.`sexualPreferenceId` WHERE `models`.`login` = :login AND `models`.`campaignId` = :campaignId