SELECT models.*, COALESCE(modelOnline.previewUrl, '') AS previewUrl, IF(models.registeredAt > 1718733790, 1, 0) AS isNew, IF(modelOnline.id IS NOT NULL, 1, 0) AS isOnline, languages.title_tr AS language, names.text AS name, COALESCE(locations.text, '') AS location, buttSizes.title_tr AS buttSize, bustSizes.title_tr AS bustSize, hairColors.title_tr AS hairColor, eyeColors.title_tr AS eyeColor, pubicHairs.title_tr AS pubicHair, ethnicities.title_tr AS ethnicity, genders.title_tr AS gender, sexualPreferences.title_tr AS sexualPreference FROM models LEFT JOIN modelOnline ON modelOnline.id = models.id LEFT JOIN languages ON languages.id = models.languageId LEFT JOIN names ON names.id = models.nameId LEFT JOIN locations ON locations.id = models.locationId LEFT JOIN buttSizes ON buttSizes.id = models.buttSizeId LEFT JOIN bustSizes ON bustSizes.id = models.bustSizeId LEFT JOIN hairColors ON hairColors.id = models.hairColorId LEFT JOIN eyeColors ON eyeColors.id = models.eyeColorId LEFT JOIN pubicHairs ON pubicHairs.id = models.pubicHairId LEFT JOIN ethnicities ON ethnicities.id = models.ethnicityId LEFT JOIN genders ON genders.id = models.genderId LEFT JOIN sexualPreferences ON sexualPreferences.id = models.sexualPreferenceId WHERE models.login = :modelLogin