data : select * from rep_core_hashes

data : select cl1.club_name home,cl1.club_id home_id, cl2.club_name visitor, c_id,
          cl2.club_id visitor_id, c.date, c.goal_1, c.goal_2, cl1.club_city home_city, cl2.club_city visitor_city,
                 (SELECT count(id)
          FROM t_comments
         WHERE t_comments.show = 'match' and t_comments.to = c_id) comments
          from t_calendar c left join t_club cl1 on c.home = cl1.club_id 
                 left join t_club cl2 on c.visitor = cl2.club_id  
          where c_id = (select c_id
                from t_calendar c 
                where (home = 1 or visitor = 1) and date<=curdate() and goal_1 is not null
                group by c_id 
                order by date desc limit 0,1)

data : select cl1.club_name home,cl1.club_id home_id, cl2.club_name visitor, c_id,
          cl2.club_id visitor_id, c.date, c.goal_1, c.goal_2, cl1.club_city home_city, cl2.club_city visitor_city,
                 (SELECT count(id)
          FROM t_comments
         WHERE t_comments.show = 'match' and t_comments.to = c_id) comments
          from t_calendar c left join t_club cl1 on c.home = cl1.club_id 
                 left join t_club cl2 on c.visitor = cl2.club_id  
          where c_id = (select c_id
                from t_calendar c 
                where (home = 1 or visitor = 1) and date>=curdate()  and goal_1 is null
                group by c_id 
                order by date limit 0,1)

data : select cl1.club_name home,cl1.club_id home_id, cl2.club_name visitor, c_id,
          cl2.club_id visitor_id, c.date, c.goal_1, c.goal_2, cl1.club_city home_city, cl2.club_city visitor_city,
                 (SELECT count(id)
          FROM t_comments
         WHERE t_comments.show = 'match' and t_comments.to = c_id) comments
          from t_calendar c left join t_club cl1 on c.home = cl1.club_id 
                 left join t_club cl2 on c.visitor = cl2.club_id  
           WHERE date_format(date, '%d.%m') = date_format(sysdate(), '%d.%m') and goal_1 is not null
           --WHERE date_format(date, '%d.%m') = '09.04'
       AND (home = 1 OR visitor = 1)
       order by date

data : INSERT INTO  REP_CORE_HASHES(FILE_PATH) VALUES ( 'modules/common/js/jquery/ui.tabs.js' )

data : SELECT * FROM REP_CORE_HASHES WHERE FILE_PATH='modules/common/js/jquery/ui.tabs.js'

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 amkarfan.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 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!=203 and upproved = 1
 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) and upproved = 1
 group by n.news_id
ORDER BY time DESC
limit 0,10