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 : SELECT u.USER_LOGIN AS autor,
       n.autor autor_id,
       n.text,
       n.header,
       n.news_id,
       n.time,
       count(t.id) comment_count
  FROM t_news n
       LEFT JOIN t_users u
          ON (n.autor = u.USER_ID)
       LEFT JOIN t_comments t
          ON n.news_id = t.`to`
 WHERE main_news = 1
 group by u.USER_LOGIN,
       n.autor, n.text,
       n.header, n.news_id,
       n.time
ORDER BY news_id DESC
 LIMIT 0, 1

data : select news_id from t_news where main_news = 1 and type in (1,2) order by news_id desc limit 0,1

data : 
SELECT n.*, count(c.id) comment_count
  FROM t_news n left join t_comments c on n.news_id = c.`to`
 where type in (1,2) and news_id!=173
 group by n.news_id
ORDER BY time DESC
limit 0,10

data : 
SELECT n.*, count(c.id) comment_count
  FROM t_news n left join t_comments c on n.news_id = c.`to`
 where type in (3) 
 group by n.news_id
ORDER BY time DESC
limit 0,10