SELECT t1.*
				ANY_VALUE(t4.tag_id) AS tag_id,
				GROUP_CONCAT(t4.tag_word) AS tag_word,
				ANY_VALUE(t4.tag_service) AS tag_service,
				ANY_VALUE(t4.tag_total) AS tag_total,
				ANY_VALUE(t4.tag_soundex) AS tag_soundex,
				ANY_VALUE(t6.attach_token) AS attach_token,
				ANY_VALUE(t6.attach_date_register) AS attach_date_register,
				ANY_VALUE(t6.attach_id) AS attach_id,
				ANY_VALUE(t6.attach_file_ext) AS attach_file_ext,
				ANY_VALUE(t6.attach_file_header) AS attach_file_header,
				ANY_VALUE(t6.attach_img_type) AS attach_img_type,
				ANY_VALUE(t6.attach_img_width) AS attach_img_width,
				ANY_VALUE(t6.attach_img_height) AS attach_img_height,
				ANY_VALUE(t6.attach_file_media) AS attach_file_media,
				ANY_VALUE(t6.attach_show_watermark) AS attach_show_watermark,
				ANY_VALUE(t7.score_average) AS score_average,
				ANY_VALUE(t7.score_count) AS score_count,
				ANY_VALUE(t7.score_date_last) AS score_date_last,
				ANY_VALUE(t8.visit_count) AS visit_count,
				ANY_VALUE(t8.visit_date_last) AS visit_date_last,
				ANY_VALUE(t9.attach_title) AS attach_title
				FROM `x_content` AS t1 LEFT JOIN (`x_tag_relation` AS t3, `x_tag` AS t4)
				ON (t3.relation_kind = 2
					AND t3.relation_id = t1.content_id
					AND t3.tag_id = t4.tag_id
					AND t4.tag_status = 1)

				LEFT JOIN (`x_attach_relation` AS t5, `x_attach` AS t6)
				ON (t5.relation_id = t1.content_id
                    AND t5.relation_kind IN (2)
                    AND t5.attach_id = t6.attach_id
                    AND t6.attach_status = 1 AND t6.attach_file_media  < 3  AND t6.attach_img_type  > 0  AND t5.attach_priority  = 0  AND t6.view_accesslevel_id <= 1 AND t6.attach_date_start <= '2025-08-19 22:45:00' AND (t6.attach_date_finish >= '2025-08-19 22:45:00' OR t6.attach_date_finish = t6.attach_date_start) )

				LEFT JOIN (`x_score_total` AS t7)
				ON (t7.relation_kind = 2
					AND t7.relation_id = t1.content_id)

				LEFT JOIN (`x_visit` AS t8)
				ON (t8.relation_kind = 2
					AND t8.relation_id = t1.content_id)
          LEFT JOIN (`x_attach_title` AS t9)
          ON (t9.attach_id = t6.attach_id AND t9.lang_id = t1.lang_id) 
          WHERE t1.content_id = 105731  AND t1.content_status IN (1, 2)  AND t1.content_date_start <= '2025-08-19 22:30:41' AND (t1.content_date_finish >= '2025-08-19 22:30:41' OR t1.content_date_finish = t1.content_date_start)  GROUP BY t1.content_id ;