SET NAMES cp1251
Too many connections


SELECT * FROM lect_url WHERE is_visible=1 ORDER BY date_created DESC LIMIT 0,3 
Too many connections


select distinct year(date_created)+0.01*month(date_created) as ym from lect_url order by ym desc limit 0,6
Too many connections


select count(id) as n_urls, sum(n_visits) as n_visits from lect_url
Too many connections


DROP TABLE IF EXISTS `query_cache`;
Too many connections


CREATE TEMPORARY TABLE `query_cache` (
  `session_id` varchar(32) default '0',
  `url_id` bigint(20) NOT NULL default '0',
  `weight` int(11) NOT NULL default '0',
  `is_required` int(11) NOT NULL default '0',
  KEY `session_id` (`session_id`),
  KEY `url_id` (`url_id`),
  KEY `weight` (`weight`)
) ENGINE=MEMORY DEFAULT CHARSET=cp1251;
Too many connections


SELECT id, deep, start,finish FROM lect_category WHERE id IN(230) and deep>1
Too many connections


SELECT SQL_CALC_FOUND_ROWS DISTINCT
                   u.*
                 , 1 as relev
                 , 0 as is_required
            from lect_url AS u
             WHERE  u.is_visible=1 
            order by u.date_created  desc
            LIMIT 10,10
            
Too many connections


select count(id) as n_comments, url_id from lect_url_comment where url_id IN (0) group by url_id
Too many connections


SELECT * FROM lect_static_menu ORDER BY ordering
Too many connections

Читанка

Всі книги > Оповідання

Нічого не знайдено



Читанка © 2009
Дизайн Fish,
програмування Dobrovolsky