data : select * from rep_core_hashes

data : select t.*, (w+d+l) g,(w*3+d) p, (bz-bp) br, (last-now) razn from (select c.club_name, c.club_city, c.club_id,
(select count(*) from v_results r1 where r1.team = c.club_id and r1.points=3 and chemp_id=6) w,
(select count(*) from v_results r1 where r1.team = c.club_id and r1.points=1 and chemp_id=6) d,
(select count(*) from v_results r1 where r1.team = c.club_id and r1.points=0 and chemp_id=6) l,
(select sum(g_1) from v_results r1 where r1.team = c.club_id and chemp_id=6) bz,
(select sum(g_2) from v_results r1 where r1.team = c.club_id and chemp_id=6) bp,
(select count(*) from t_calendar where live = 1 and (home = c.club_id or visitor = c.club_id)) live,
(select getPosition (club_id,6,w+d+l-1)) last, (select getPosition (club_id,6,w+d+l)) now
from t_club c left join t_chemp_club on club_id = club where chemp = 6) t
order by p desc, w desc, br desc, bz desc, club_name, club_city

data : INSERT INTO  REP_CORE_HASHES(FILE_PATH) VALUES ( 'src/theme/css/chemptable.class.css' )

data : SELECT * FROM REP_CORE_HASHES WHERE FILE_PATH='src/theme/css/chemptable.class.css'

auth : SELECT MENU_ID, NAME, SHOW_, PARENT_ID, FILE_PATH, N_ORDER, HIDDEN, ENABLED, SUBTITLE, MODULE,  R,  W
    FROM db5729c.rep_core_menu RCM
         LEFT JOIN
         (SELECT MENU_ID m_id, MIN(R) AS R, MIN(CASE
                    WHEN R > 0
                       THEN W
                    ELSE 0
                 END )AS W
		FROM v_user_privs VUP LEFT JOIN t_menu_privs TMP
                 ON TMP.PRIV_ID = VUP.PRIV_ID
           WHERE VUP.USER_ID = 1 AND VUP.SYS_ID=1 AND NOT MENU_ID IS NULL GROUP BY MENU_ID) S
         ON RCM.MENU_ID+'' = S.M_ID+''
    WHERE R > 0 AND ENABLED=1 
ORDER BY N_ORDER, NAME

data : INSERT INTO  REP_CORE_HASHES(FILE_PATH) VALUES ( 'src/content/js/content.js' )

data : SELECT * FROM REP_CORE_HASHES WHERE FILE_PATH='src/content/js/content.js'

data : SELECT u.USER_LOGIN AS autor,
       n.autor autor_id,
       n.text,
       n.header,
       n.news_id,
       n.time,
       count(t.tag) comment_count
  FROM t_news n
       LEFT JOIN t_users u
          ON (n.autor = u.USER_ID)
       LEFT JOIN t_content_tag t
          ON n.news_id = t.id_content
 WHERE news_id = 167
GROUP BY u.USER_LOGIN,
         n.autor,
         n.text,
         n.header,
         n.news_id,
         n.time

data : SELECT TC.parent_id, TC.id,
       TC.text,
       TC.date,
       TU.USER_ID autor_id,
       TU.USER_LOGIN autor
  FROM t_comments TC LEFT JOIN t_users TU
       ON (TC.user_id = TU.USER_ID) where `to` = 167

data : select tag from t_content_tag where id_content = 167

data : SELECT *
  FROM (SELECT count(*) c,
               news_id,
               header,
               time
          FROM t_news n LEFT JOIN t_content_tag c ON n.news_id = c.id_content
         WHERE c.tag IN (SELECT c2.tag
                           FROM t_content_tag c2
                          WHERE c2.id_content = 167)
               AND n.news_id <> 167
        GROUP BY news_id, header, time
        ORDER BY c DESC, time desc
         LIMIT 0, 10) t
ORDER BY time DESC