Joom!Fish config error: Default language is inactive!
 
Please check configuration, try to use first active language

РККВД - медицинский центр Казани, анализы, лаборатория, косметология, дерматолог

ВЕРСИЯ ДЛЯ СЛАБОВИДЯЩИХ

Авторизация

Авторизация и регистрация необходимы для создания сообщения или новой темы на форуме

Уважаемые посетители!

Если Вы остались довольны качеством, оказанных Вам услуг расскажите об этом всем, а если нет, то расскажите об этом нам!

Администрация РККВД

 

min

Pobeda80_logo_main

tak

vdblogo


 

 


Микологический центр
Лечение грибковых заболеваний кожи и ногтей. Лечение вросшего ногтя
Лазерная деструкция
Удаление бородавок, папиллом, кондилом с последующим гистологическим исследованием

  Государственное автономное учреждение здравоохранения «Республиканский клинический кожно-венерологический диспансер Министерства здравоохранения Республики Татарстан имени профессора А.Г.Ге» (сокращенное наименование - ГАУЗ "РККВД") - единственное государственное специализированное медицинское учреждение республиканского уровня, предоставляющее полный комплекс услуг в области диагностики и лечения кожных заболеваний и инфекций передающихся половым путём. Основной государственный регистрационный номер – 1021602836430. В структуру ГАУЗ «Республиканский клинический кожно-венерологический диспансер Министерства здравоохранения Республики Татарстан имени профессора А.Г.Ге» входят поликлинические и стационарные отделения, кабинеты профилактических медицинских осмотров, лечебно-диагностические кабинеты (платные, анонимные), централизованная серологическая лаборатория, расположенные во всех крупных городах Республики Татарстан (Казань, Бугульма, Зеленодольск, Альметьевск, Лениногорск, Набережные Челны, Нижнекамск и Чистополь).

 Учредителем ГАУЗ «РККВД» является Министерство здравоохранения Республики Татарстан. Органами управления учреждения являются: наблюдательный совет, руководитель – главный врач учреждения, общее собрание (конференции) работников учреждения и другие предусмотренные федеральными законами. Виды медицинской помощи, предоставляемой населению бесплатно в ГАУЗ «Республиканский клинический кожно-венерологический диспансер Министерства здравоохранения Республики Татарстан имени профессора А.Г.Ге» (устанавливаются в соответствии с ежегодно утверждаемой Кабинетом Министров Республики Татарстан Программой государственных гарантий бесплатного оказания гражданам медицинской помощи на территории Республики Татарстан)

kvdmain

  Наши главные преимущества:
  • Лучшие врачи, обладающие огромным опытом работы в своей области;
  • Высокий профессионализм, индивидуальный подход к каждому пациенту и научно-практические основы медицинской деятельности, гарантирующие безопасность здоровья наших пациентов;
  • Гарантии конфиденциальности и анонимности обследования и лечения в РККВД;
  • Современное оборудование зарубежного производства, гарантирующее точность диагностики заболевания и успех его лечения;
  • Государственные гарантии качества лечения наших пациентов, которые не может предоставить ни один частный медицинский центр;
  • Удобное расположение – наши поликлиники готовы принять пациентов в любом районе города;
  • Широкий спектр услуг – от консультаций врача - дерматовенеролога и лечения ИППП до врачебной косметологии;
  • Доступные цены.

 

ИСТОРИЯ ДЕРМАТОВЕНЕРОЛОГИЧЕСКОЙ СЛУЖБЫ

ИНФОРМАЦИЯ О ВИДАХ МЕДИЦИНСКОЙ ПОМОЩИ РККВД

ПОРЯДОК И УСЛОВИЯ ОКАЗАНИЯ МЕДИЦИНСКОЙ ПОМОЩИ

 

Внимание! Поликлиническое отделение №1 по ул.Нариманова,56 закрыто с марта 2019г. Другие наши поликлинические отделения расположены по адресам: ул.Толстого д.4а, ул.Серова д.37, ул.Короленко д.54, ул.Ново-Азинская д.33, ул.Сафиуллина д.32а.

ГРАФИК РАБОТЫ АДМИНИСТРАЦИИ ГАУЗ «РККВД»:
понедельник-пятница с 08:30 до 17:00 ч, перерыв на обед с 12.00 до 12.30.

ГРАФИК РАБОТЫ ПОЛИКЛИНИЧЕСКИХ ОТДЕЛЕНИЙ И СПРАВОЧНОЙ:
понедельник-пятница с 08:00 до 20:00 ч, суббота: с 08:00 до 14:00 ч., воскресенье: выходной.

 Дни и часы приёма граждан руководством ГАУЗ «РККВД» (г.Казань, ул. Толстого, дом 4):

Главный врач Минуллин Искандэр Кагапович по вторникам с 14:00 до 17:00

Заместитель главного врача по медицинской части Бильдюк Евгения Владимировна по вторникам с 14:00 до 17:00

Заместитель главного врача по поликлинической работе Вафина Гузель Гакильевна по вторникам с 14:00 до 17:00

Заместитель главного врача по клинико-экспертной работе Касаткина Светлана Борисовна по вторникам с 14:00 до 17:00

Руководители филиалов поликлинических и стационарных отделений по вторникам с 14:00 до 17:00

Всемирный день безопасности пациентов

 

 

 

Единая справочная 8(843) 210-14-15

 

Решаем вместе
Недовольны работой больницы?

Информация о профиле

Application afterLoad: 0.001 seconds, 0.29 MB
Application afterInitialise: 0.015 seconds, 1.44 MB
Application afterRoute: 0.017 seconds, 2.00 MB
Application afterDispatch: 0.032 seconds, 3.05 MB
Application afterRender: 0.260 seconds, 3.49 MB

Использование памяти

3693104

Зарегистрировано запросов: 79

  1. SELECT *
      FROM jos_jcomments_settings

      WHERE lang = 'ru-RU'
  2. SELECT template
      FROM jos_templates_menu
      WHERE client_id = 0
      AND (menuid = 0 OR menuid = 1)
      ORDER BY menuid DESC
      LIMIT 0, 1
  3. SELECT a.*, u.name AS author, u.usertype, cc.title AS category, s.title AS section, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, g.name AS groups, s.published AS sec_pub, cc.published AS cat_pub, s.access AS sec_access, cc.access AS cat_access 
      FROM jos_content AS a
      LEFT JOIN jos_categories AS cc
      ON cc.id = a.catid
      LEFT JOIN jos_sections AS s
      ON s.id = cc.section
      AND s.scope = "content"
      LEFT JOIN jos_users AS u
      ON u.id = a.created_by
      LEFT JOIN jos_groups AS g
      ON a.access = g.id
      WHERE a.id = 1
      AND (  ( a.created_by = 0 )    OR  ( a.state = 1
      AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-06-10 07:56:57' )
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-06-10 07:56:57' )   )    OR  ( a.state = -1 )  )
  4. SELECT jf_content.reference_field, jf_content.value, jf_content.reference_id, jf_content.original_value

      FROM jos_jf_content AS jf_content

      WHERE jf_content.language_id=2
           
      AND jf_content.published=1
       
      AND jf_content.reference_id IN(1)
       
      AND jf_content.reference_table='content'
  5. SELECT jf_content.reference_field, jf_content.value, jf_content.reference_id, jf_content.original_value

      FROM jos_jf_content AS jf_content

      WHERE jf_content.language_id=2
           
      AND jf_content.published=1
       
      AND jf_content.reference_id IN(1)
       
      AND jf_content.reference_table='users'
  6. UPDATE jos_content
      SET hits = ( hits + 1 )
      WHERE id='1'
  7. SELECT id, title, module, position, content, showtitle, control, params
      FROM jos_modules AS m
      LEFT JOIN jos_modules_menu AS mm
      ON mm.moduleid = m.id
      WHERE m.published = 1
      AND m.access <= 0
      AND m.client_id = 0
      AND ( mm.menuid = 1 OR mm.menuid = 0 )
      ORDER BY position, ordering
  8. SELECT *
      FROM jos_languages
      WHERE active=1
      ORDER BY ordering
  9. SELECT c.id, c.catid
      FROM jos_content AS c
      LEFT JOIN jos_multicity_tags AS t
      ON c.id = t.itemid
      LEFT JOIN jos_sections AS s
      ON s.id = c.sectionid
      WHERE t.tag = 1
      AND c.state = 1
      AND s.alias = 'multicity'
  10. SELECT jf_content.reference_field, jf_content.value, jf_content.reference_id, jf_content.original_value

      FROM jos_jf_content AS jf_content

      WHERE jf_content.language_id=2
           
      AND jf_content.published=1
       
      AND jf_content.reference_id IN(79,80,84,83,87,88,89,90,92,93,94,95,96,97,99,100,107,190,199,201,213,223,240,221,160,245,319,325,340,324,356,377,415,164,420,445,499,508,518,529,530,531,532,533,560,595,611,617,2089,2091,2113,2115)
       
      AND jf_content.reference_table='content'
  11. SELECT *
      FROM jos_multicity_menu
      WHERE (category = 0 OR category IN (SELECT catid
      FROM jos_content
      WHERE id IN (SELECT itemid
      FROM jos_multicity_tags
      WHERE tag = 1)))
      AND parentid = 0
  12. SELECT COUNT(*)
      FROM jos_multicity_menu
      WHERE parentid = 3
      AND published = 1
      AND (connection != '' || category IN (SELECT catid
      FROM jos_content AS c
      LEFT JOIN jos_multicity_tags AS t
      ON t.itemid = c.id
      WHERE t.tag = 1))
  13. SELECT COUNT(*)
      FROM jos_multicity_menu
      WHERE parentid = 4
      AND published = 1
      AND (connection != '' || category IN (SELECT catid
      FROM jos_content AS c
      LEFT JOIN jos_multicity_tags AS t
      ON t.itemid = c.id
      WHERE t.tag = 1))
  14. SELECT COUNT(*)
      FROM jos_multicity_menu
      WHERE parentid = 5
      AND published = 1
      AND (connection != '' || category IN (SELECT catid
      FROM jos_content AS c
      LEFT JOIN jos_multicity_tags AS t
      ON t.itemid = c.id
      WHERE t.tag = 1))
  15. SELECT *
      FROM jos_multicity_menu
      WHERE (category = 0 OR category IN (SELECT catid
      FROM jos_content
      WHERE id IN (SELECT itemid
      FROM jos_multicity_tags
      WHERE tag = 1)))
      AND parentid = 5
  16. SELECT COUNT(*)
      FROM jos_multicity_menu
      WHERE parentid = 6
      AND published = 1
      AND (connection != '' || category IN (SELECT catid
      FROM jos_content AS c
      LEFT JOIN jos_multicity_tags AS t
      ON t.itemid = c.id
      WHERE t.tag = 1))
  17. SELECT COUNT(*)
      FROM jos_multicity_menu
      WHERE parentid = 9
      AND published = 1
      AND (connection != '' || category IN (SELECT catid
      FROM jos_content AS c
      LEFT JOIN jos_multicity_tags AS t
      ON t.itemid = c.id
      WHERE t.tag = 1))
  18. SELECT COUNT(*)
      FROM jos_multicity_menu
      WHERE parentid = 11
      AND published = 1
      AND (connection != '' || category IN (SELECT catid
      FROM jos_content AS c
      LEFT JOIN jos_multicity_tags AS t
      ON t.itemid = c.id
      WHERE t.tag = 1))
  19. SELECT COUNT(*)
      FROM jos_multicity_menu
      WHERE parentid = 12
      AND published = 1
      AND (connection != '' || category IN (SELECT catid
      FROM jos_content AS c
      LEFT JOIN jos_multicity_tags AS t
      ON t.itemid = c.id
      WHERE t.tag = 1))
  20. SELECT COUNT(*)
      FROM jos_multicity_menu
      WHERE parentid = 13
      AND published = 1
      AND (connection != '' || category IN (SELECT catid
      FROM jos_content AS c
      LEFT JOIN jos_multicity_tags AS t
      ON t.itemid = c.id
      WHERE t.tag = 1))
  21. SELECT COUNT(*)
      FROM jos_multicity_menu
      WHERE parentid = 14
      AND published = 1
      AND (connection != '' || category IN (SELECT catid
      FROM jos_content AS c
      LEFT JOIN jos_multicity_tags AS t
      ON t.itemid = c.id
      WHERE t.tag = 1))
  22. SELECT COUNT(*)
      FROM jos_multicity_menu
      WHERE parentid = 15
      AND published = 1
      AND (connection != '' || category IN (SELECT catid
      FROM jos_content AS c
      LEFT JOIN jos_multicity_tags AS t
      ON t.itemid = c.id
      WHERE t.tag = 1))
  23. SELECT COUNT(*)
      FROM jos_multicity_menu
      WHERE parentid = 16
      AND published = 1
      AND (connection != '' || category IN (SELECT catid
      FROM jos_content AS c
      LEFT JOIN jos_multicity_tags AS t
      ON t.itemid = c.id
      WHERE t.tag = 1))
  24. SELECT COUNT(*)
      FROM jos_multicity_menu
      WHERE parentid = 53
      AND published = 1
      AND (connection != '' || category IN (SELECT catid
      FROM jos_content AS c
      LEFT JOIN jos_multicity_tags AS t
      ON t.itemid = c.id
      WHERE t.tag = 1))
  25. SELECT COUNT(*)
      FROM jos_multicity_menu
      WHERE parentid = 59
      AND published = 1
      AND (connection != '' || category IN (SELECT catid
      FROM jos_content AS c
      LEFT JOIN jos_multicity_tags AS t
      ON t.itemid = c.id
      WHERE t.tag = 1))
  26. SELECT COUNT(*)
      FROM jos_multicity_menu
      WHERE parentid = 62
      AND published = 1
      AND (connection != '' || category IN (SELECT catid
      FROM jos_content AS c
      LEFT JOIN jos_multicity_tags AS t
      ON t.itemid = c.id
      WHERE t.tag = 1))
  27. SELECT COUNT(*)
      FROM jos_multicity_menu
      WHERE parentid = 18
      AND published = 1
      AND (connection != '' || category IN (SELECT catid
      FROM jos_content AS c
      LEFT JOIN jos_multicity_tags AS t
      ON t.itemid = c.id
      WHERE t.tag = 1))
  28. SELECT *
      FROM jos_multicity_menu
      WHERE (category = 0 OR category IN (SELECT catid
      FROM jos_content
      WHERE id IN (SELECT itemid
      FROM jos_multicity_tags
      WHERE tag = 1)))
      AND parentid = 18
  29. SELECT COUNT(*)
      FROM jos_multicity_menu
      WHERE parentid = 100
      AND published = 1
      AND (connection != '' || category IN (SELECT catid
      FROM jos_content AS c
      LEFT JOIN jos_multicity_tags AS t
      ON t.itemid = c.id
      WHERE t.tag = 1))
  30. SELECT COUNT(*)
      FROM jos_multicity_menu
      WHERE parentid = 19
      AND published = 1
      AND (connection != '' || category IN (SELECT catid
      FROM jos_content AS c
      LEFT JOIN jos_multicity_tags AS t
      ON t.itemid = c.id
      WHERE t.tag = 1))
  31. SELECT COUNT(*)
      FROM jos_multicity_menu
      WHERE parentid = 20
      AND published = 1
      AND (connection != '' || category IN (SELECT catid
      FROM jos_content AS c
      LEFT JOIN jos_multicity_tags AS t
      ON t.itemid = c.id
      WHERE t.tag = 1))
  32. SELECT COUNT(*)
      FROM jos_multicity_menu
      WHERE parentid = 22
      AND published = 1
      AND (connection != '' || category IN (SELECT catid
      FROM jos_content AS c
      LEFT JOIN jos_multicity_tags AS t
      ON t.itemid = c.id
      WHERE t.tag = 1))
  33. SELECT *
      FROM jos_multicity_menu
      WHERE (category = 0 OR category IN (SELECT catid
      FROM jos_content
      WHERE id IN (SELECT itemid
      FROM jos_multicity_tags
      WHERE tag = 1)))
      AND parentid = 22
  34. SELECT COUNT(*)
      FROM jos_multicity_menu
      WHERE parentid = 95
      AND published = 1
      AND (connection != '' || category IN (SELECT catid
      FROM jos_content AS c
      LEFT JOIN jos_multicity_tags AS t
      ON t.itemid = c.id
      WHERE t.tag = 1))
  35. SELECT COUNT(*)
      FROM jos_multicity_menu
      WHERE parentid = 112
      AND published = 1
      AND (connection != '' || category IN (SELECT catid
      FROM jos_content AS c
      LEFT JOIN jos_multicity_tags AS t
      ON t.itemid = c.id
      WHERE t.tag = 1))
  36. SELECT COUNT(*)
      FROM jos_multicity_menu
      WHERE parentid = 23
      AND published = 1
      AND (connection != '' || category IN (SELECT catid
      FROM jos_content AS c
      LEFT JOIN jos_multicity_tags AS t
      ON t.itemid = c.id
      WHERE t.tag = 1))
  37. SELECT COUNT(*)
      FROM jos_multicity_menu
      WHERE parentid = 25
      AND published = 1
      AND (connection != '' || category IN (SELECT catid
      FROM jos_content AS c
      LEFT JOIN jos_multicity_tags AS t
      ON t.itemid = c.id
      WHERE t.tag = 1))
  38. SELECT COUNT(*)
      FROM jos_multicity_menu
      WHERE parentid = 88
      AND published = 1
      AND (connection != '' || category IN (SELECT catid
      FROM jos_content AS c
      LEFT JOIN jos_multicity_tags AS t
      ON t.itemid = c.id
      WHERE t.tag = 1))
  39. SELECT COUNT(*)
      FROM jos_multicity_menu
      WHERE parentid = 94
      AND published = 1
      AND (connection != '' || category IN (SELECT catid
      FROM jos_content AS c
      LEFT JOIN jos_multicity_tags AS t
      ON t.itemid = c.id
      WHERE t.tag = 1))
  40. SELECT COUNT(*)
      FROM jos_multicity_menu
      WHERE parentid = 92
      AND published = 1
      AND (connection != '' || category IN (SELECT catid
      FROM jos_content AS c
      LEFT JOIN jos_multicity_tags AS t
      ON t.itemid = c.id
      WHERE t.tag = 1))
  41. SELECT COUNT(*)
      FROM jos_multicity_menu
      WHERE parentid = 56
      AND published = 1
      AND (connection != '' || category IN (SELECT catid
      FROM jos_content AS c
      LEFT JOIN jos_multicity_tags AS t
      ON t.itemid = c.id
      WHERE t.tag = 1))
  42. SELECT COUNT(*)
      FROM jos_multicity_menu
      WHERE parentid = 63
      AND published = 1
      AND (connection != '' || category IN (SELECT catid
      FROM jos_content AS c
      LEFT JOIN jos_multicity_tags AS t
      ON t.itemid = c.id
      WHERE t.tag = 1))
  43. SELECT COUNT(*)
      FROM jos_multicity_menu
      WHERE parentid = 64
      AND published = 1
      AND (connection != '' || category IN (SELECT catid
      FROM jos_content AS c
      LEFT JOIN jos_multicity_tags AS t
      ON t.itemid = c.id
      WHERE t.tag = 1))
  44. SELECT COUNT(*)
      FROM jos_multicity_menu
      WHERE parentid = 65
      AND published = 1
      AND (connection != '' || category IN (SELECT catid
      FROM jos_content AS c
      LEFT JOIN jos_multicity_tags AS t
      ON t.itemid = c.id
      WHERE t.tag = 1))
  45. SELECT COUNT(*)
      FROM jos_multicity_menu
      WHERE parentid = 66
      AND published = 1
      AND (connection != '' || category IN (SELECT catid
      FROM jos_content AS c
      LEFT JOIN jos_multicity_tags AS t
      ON t.itemid = c.id
      WHERE t.tag = 1))
  46. SELECT COUNT(*)
      FROM jos_multicity_menu
      WHERE parentid = 67
      AND published = 1
      AND (connection != '' || category IN (SELECT catid
      FROM jos_content AS c
      LEFT JOIN jos_multicity_tags AS t
      ON t.itemid = c.id
      WHERE t.tag = 1))
  47. SELECT COUNT(*)
      FROM jos_multicity_menu
      WHERE parentid = 80
      AND published = 1
      AND (connection != '' || category IN (SELECT catid
      FROM jos_content AS c
      LEFT JOIN jos_multicity_tags AS t
      ON t.itemid = c.id
      WHERE t.tag = 1))
  48. SELECT COUNT(*)
      FROM jos_multicity_menu
      WHERE parentid = 86
      AND published = 1
      AND (connection != '' || category IN (SELECT catid
      FROM jos_content AS c
      LEFT JOIN jos_multicity_tags AS t
      ON t.itemid = c.id
      WHERE t.tag = 1))
  49. SELECT COUNT(*)
      FROM jos_multicity_menu
      WHERE parentid = 26
      AND published = 1
      AND (connection != '' || category IN (SELECT catid
      FROM jos_content AS c
      LEFT JOIN jos_multicity_tags AS t
      ON t.itemid = c.id
      WHERE t.tag = 1))
  50. SELECT *
      FROM jos_multicity_menu
      WHERE (category = 0 OR category IN (SELECT catid
      FROM jos_content
      WHERE id IN (SELECT itemid
      FROM jos_multicity_tags
      WHERE tag = 1)))
      AND parentid = 26
  51. SELECT COUNT(*)
      FROM jos_multicity_menu
      WHERE parentid = 96
      AND published = 1
      AND (connection != '' || category IN (SELECT catid
      FROM jos_content AS c
      LEFT JOIN jos_multicity_tags AS t
      ON t.itemid = c.id
      WHERE t.tag = 1))
  52. SELECT COUNT(*)
      FROM jos_multicity_menu
      WHERE parentid = 73
      AND published = 1
      AND (connection != '' || category IN (SELECT catid
      FROM jos_content AS c
      LEFT JOIN jos_multicity_tags AS t
      ON t.itemid = c.id
      WHERE t.tag = 1))
  53. SELECT COUNT(*)
      FROM jos_multicity_menu
      WHERE parentid = 91
      AND published = 1
      AND (connection != '' || category IN (SELECT catid
      FROM jos_content AS c
      LEFT JOIN jos_multicity_tags AS t
      ON t.itemid = c.id
      WHERE t.tag = 1))
  54. SELECT COUNT(*)
      FROM jos_multicity_menu
      WHERE parentid = 93
      AND published = 1
      AND (connection != '' || category IN (SELECT catid
      FROM jos_content AS c
      LEFT JOIN jos_multicity_tags AS t
      ON t.itemid = c.id
      WHERE t.tag = 1))
  55. SELECT COUNT(*)
      FROM jos_multicity_menu
      WHERE parentid = 68
      AND published = 1
      AND (connection != '' || category IN (SELECT catid
      FROM jos_content AS c
      LEFT JOIN jos_multicity_tags AS t
      ON t.itemid = c.id
      WHERE t.tag = 1))
  56. SELECT COUNT(*)
      FROM jos_multicity_menu
      WHERE parentid = 75
      AND published = 1
      AND (connection != '' || category IN (SELECT catid
      FROM jos_content AS c
      LEFT JOIN jos_multicity_tags AS t
      ON t.itemid = c.id
      WHERE t.tag = 1))
  57. SELECT COUNT(*)
      FROM jos_multicity_menu
      WHERE parentid = 34
      AND published = 1
      AND (connection != '' || category IN (SELECT catid
      FROM jos_content AS c
      LEFT JOIN jos_multicity_tags AS t
      ON t.itemid = c.id
      WHERE t.tag = 1))
  58. SELECT *
      FROM jos_multicity_menu
      WHERE (category = 0 OR category IN (SELECT catid
      FROM jos_content
      WHERE id IN (SELECT itemid
      FROM jos_multicity_tags
      WHERE tag = 1)))
      AND parentid = 34
  59. SELECT COUNT(*)
      FROM jos_multicity_menu
      WHERE parentid = 57
      AND published = 1
      AND (connection != '' || category IN (SELECT catid
      FROM jos_content AS c
      LEFT JOIN jos_multicity_tags AS t
      ON t.itemid = c.id
      WHERE t.tag = 1))
  60. SELECT COUNT(*)
      FROM jos_multicity_menu
      WHERE parentid = 60
      AND published = 1
      AND (connection != '' || category IN (SELECT catid
      FROM jos_content AS c
      LEFT JOIN jos_multicity_tags AS t
      ON t.itemid = c.id
      WHERE t.tag = 1))
  61. SELECT COUNT(*)
      FROM jos_multicity_menu
      WHERE parentid = 35
      AND published = 1
      AND (connection != '' || category IN (SELECT catid
      FROM jos_content AS c
      LEFT JOIN jos_multicity_tags AS t
      ON t.itemid = c.id
      WHERE t.tag = 1))
  62. SELECT COUNT(*)
      FROM jos_multicity_menu
      WHERE parentid = 36
      AND published = 1
      AND (connection != '' || category IN (SELECT catid
      FROM jos_content AS c
      LEFT JOIN jos_multicity_tags AS t
      ON t.itemid = c.id
      WHERE t.tag = 1))
  63. SELECT *
      FROM jos_multicity_menu
      WHERE (category = 0 OR category IN (SELECT catid
      FROM jos_content
      WHERE id IN (SELECT itemid
      FROM jos_multicity_tags
      WHERE tag = 1)))
      AND parentid = 36
  64. SELECT COUNT(*)
      FROM jos_multicity_menu
      WHERE parentid = 46
      AND published = 1
      AND (connection != '' || category IN (SELECT catid
      FROM jos_content AS c
      LEFT JOIN jos_multicity_tags AS t
      ON t.itemid = c.id
      WHERE t.tag = 1))
  65. SELECT COUNT(*)
      FROM jos_multicity_menu
      WHERE parentid = 82
      AND published = 1
      AND (connection != '' || category IN (SELECT catid
      FROM jos_content AS c
      LEFT JOIN jos_multicity_tags AS t
      ON t.itemid = c.id
      WHERE t.tag = 1))
  66. SELECT COUNT(*)
      FROM jos_multicity_menu
      WHERE parentid = 37
      AND published = 1
      AND (connection != '' || category IN (SELECT catid
      FROM jos_content AS c
      LEFT JOIN jos_multicity_tags AS t
      ON t.itemid = c.id
      WHERE t.tag = 1))
  67. SELECT *
      FROM jos_multicity_menu
      WHERE (category = 0 OR category IN (SELECT catid
      FROM jos_content
      WHERE id IN (SELECT itemid
      FROM jos_multicity_tags
      WHERE tag = 1)))
      AND parentid = 37
  68. SELECT COUNT(*)
      FROM jos_multicity_menu
      WHERE parentid = 41
      AND published = 1
      AND (connection != '' || category IN (SELECT catid
      FROM jos_content AS c
      LEFT JOIN jos_multicity_tags AS t
      ON t.itemid = c.id
      WHERE t.tag = 1))
  69. SELECT COUNT(*)
      FROM jos_multicity_menu
      WHERE parentid = 107
      AND published = 1
      AND (connection != '' || category IN (SELECT catid
      FROM jos_content AS c
      LEFT JOIN jos_multicity_tags AS t
      ON t.itemid = c.id
      WHERE t.tag = 1))
  70. SELECT COUNT(*)
      FROM jos_multicity_menu
      WHERE parentid = 108
      AND published = 1
      AND (connection != '' || category IN (SELECT catid
      FROM jos_content AS c
      LEFT JOIN jos_multicity_tags AS t
      ON t.itemid = c.id
      WHERE t.tag = 1))
  71. SELECT COUNT(*)
      FROM jos_multicity_menu
      WHERE parentid = 97
      AND published = 1
      AND (connection != '' || category IN (SELECT catid
      FROM jos_content AS c
      LEFT JOIN jos_multicity_tags AS t
      ON t.itemid = c.id
      WHERE t.tag = 1))
  72. SELECT COUNT(*)
      FROM jos_multicity_menu
      WHERE parentid = 98
      AND published = 1
      AND (connection != '' || category IN (SELECT catid
      FROM jos_content AS c
      LEFT JOIN jos_multicity_tags AS t
      ON t.itemid = c.id
      WHERE t.tag = 1))
  73. SELECT COUNT(*)
      FROM jos_multicity_menu
      WHERE parentid = 99
      AND published = 1
      AND (connection != '' || category IN (SELECT catid
      FROM jos_content AS c
      LEFT JOIN jos_multicity_tags AS t
      ON t.itemid = c.id
      WHERE t.tag = 1))
  74. SELECT COUNT(*)
      FROM jos_multicity_menu
      WHERE parentid = 111
      AND published = 1
      AND (connection != '' || category IN (SELECT catid
      FROM jos_content AS c
      LEFT JOIN jos_multicity_tags AS t
      ON t.itemid = c.id
      WHERE t.tag = 1))
  75. SELECT COUNT(*)
      FROM jos_multicity_menu
      WHERE parentid = 113
      AND published = 1
      AND (connection != '' || category IN (SELECT catid
      FROM jos_content AS c
      LEFT JOIN jos_multicity_tags AS t
      ON t.itemid = c.id
      WHERE t.tag = 1))
  76. SELECT a.*,  CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug
      FROM jos_content AS a
      LEFT JOIN jos_content_frontpage AS f
      ON f.content_id = a.id
      INNER JOIN jos_categories AS cc
      ON cc.id = a.catid
      INNER JOIN jos_sections AS s
      ON s.id = a.sectionid
      WHERE a.state = 1
      AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-06-10 07:56:57' )
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-06-10 07:56:57' )
      AND s.id > 0
      AND a.access <= 0
      AND cc.access <= 0
      AND s.access <= 0
      AND (cc.id=2)
      AND (s.id=1)
      AND f.content_id IS NULL 
      AND s.published = 1
      AND cc.published = 1
      ORDER BY a.created DESC
      LIMIT 0, 2
  77. SELECT jf_content.reference_field, jf_content.value, jf_content.reference_id, jf_content.original_value

      FROM jos_jf_content AS jf_content

      WHERE jf_content.language_id=2
           
      AND jf_content.published=1
       
      AND jf_content.reference_id IN(2293,2292)
       
      AND jf_content.reference_table='content'
  78. SELECT c.id, c.userid, c.comment, c.title, c.name, c.username, c.email, c.date, c.object_id, c.object_group, '' AS avatar, o.title AS object_title, o.link AS object_link, o.access AS object_access, o.userid AS object_owner
      FROM jos_jcomments AS c JOIN jos_jcomments_objects AS o
      ON c.object_id = o.object_id
      AND c.object_group = o.object_group
      AND c.lang = o.lang JOIN jos_content AS cc
      ON cc.id = o.object_id
      LEFT JOIN jos_categories AS ct
      ON ct.id = cc.catid
      WHERE  c.published = 1
      AND c.deleted = 0
      AND o.link <> ''
      AND  o.access <= 0
      AND c.lang = 'ru-RU'
      AND c.object_group = 'com_content'
      AND (cc.publish_up = '0000-00-00 00:00:00' OR cc.publish_up <= '2026-06-10 07:56:57')
      AND (cc.publish_down = '0000-00-00 00:00:00' OR cc.publish_down >= '2026-06-10 07:56:57')
      AND cc.catid IN (2,3)
      ORDER BY c.date DESC
      LIMIT 0, 5
  79. SELECT *
      FROM jos_multicity_cities

Языковые файлы загружены

Диагностика непереведённых строк

Нет

Дизайнер непереведённых строк

Нет