Нашли или выдавили из себя код, который нельзя назвать нормальным, на который без улыбки не взглянешь? Не торопитесь его удалять или рефакторить, — запостите его на говнокод.ру, посмеёмся вместе!
−867.6
SELECT SQL_CALC_FOUND_ROWS *,cached_login as login,cached_name as uname,comment_count as ccount FROM posts p WHERE exists (select * from tags tg, tegi_zapisi tx where tg.alt_title like 'post' and tg.id_tag=tx.id_tag and tx.id_post=p.id_post) and exists (select * from tags tg, tegi_zapisi tx where tg.alt_title like 'opentomsk' and tg.id_tag=tx.id_tag and tx.id_post=p.id_post) and hide<>1 ORDER BY p.date desc, p.time desc LIMIT 210,10
выбираем все посты с определёнными тегами или без них
удивляемся, почему тормозит пропорционально количеству тегов
guest,
08 Августа 2009
−853.2
какой нафиг код((((
больше года пишут и поддерживают проект
а как оказалось, в бд на 36 таблиц нет ни одного фореинг кея!
уебаны ((((((((((
guest,
05 Августа 2009
−844
SELECT
'X' `TYPEOF`
,161 AS `ID`
,pa.ARTICUL
,p.PRODUCT_NAME
,p.PRODUCT_INSTRUCTION
,p.PRODUCT_WEIGHT
,p.PRODUCT_VOLUME
,p.PRODUCT_RATING
,pm.MEASURE
,b.BRAND_NAME
,cs.COLL_NAME COLLECTION
,m.MAN_NAME MANUFACTORER
,pst.QUANTITY
,p.TIMESTAMP_X AS LAST_MODIFY
,pts.PRODUCT_NOTE
,pts.PRODUCT_DESCRIPTION
,pts.PRODUCT_IMAGE
,pts.PRODUCT_GALLERY
,pts.PRODUCT_ACTIVE
,pts.PRODUCT_ACTIVE_FROM
,pts.PRODUCT_ACTIVE_TO
,pts.PRODUCT_NEW
,pts.PRODUCT_LEADER
,pts.USER_ID
,pts.SITE_ID
,'X' CATEGORIES
,'X' FEATURES
,'X' RANGE_APPLICATION
,'X' RANGE_PRESCRIPTION
,'X' PRODUCT_PRICE
,'X' PRICE_CURRENCY
,'X' PRODUCT_PRICE_GROUP
,'X' IMAGES
FROM `e_products` `p`
LEFT JOIN `e_product_to_site` `pts` ON ((`pts`.`PRODUCT_ID`=161))
LEFT JOIN `e_product_articuls` `pa` ON ((`pa`.`PRODUCT_ID`=161))
LEFT JOIN `e_product_stock` `pst` ON ((`pst`.`PRODUCT_ID`=161))
LEFT JOIN `e_product_to_brand` `ptb` ON ((`ptb`.`BRAND_ID`=161))
LEFT JOIN `e_product_to_collection` `pcl` ON ((`pcl`.`PRODUCT_ID` = 161))
LEFT JOIN `e_product_measure` `pm` ON ((`p`.`PRODUCT_MEASURE` = `pm`.`ID`))
LEFT JOIN `e_brands` `b` ON ((`ptb`.`BRAND_ID`=`b`.`ID`))
LEFT JOIN `e_manufactorers` `m` ON ((`b`.`MAN_ID`=`m`.`ID`))
LEFT JOIN `e_collections` `cs` ON ((`cs`.`ID`=`pcl`.`COLLECTION_ID`))
LEFT JOIN `e_product_prices` `pp` ON ((`pp`.`PRODUCT_ID`=`p`.`ID`))
WHERE `p`.`ID` IN (161) AND `pts`.`SITE_ID` LIKE 's0'
UNION
SELECT 'categories',`p`.`ID` AS `ID`
,'X','X','X','X','X','X','X','X','X','X','X','X'
,'X','X','X','X','X','X','X','X','X','X','X'
,`ptc`.`CATEGORY_ID`
,'X','X','X','X','X','X','X'
FROM `e_product_to_category` `ptc`
LEFT JOIN `e_products` `p` ON ((`p`.`ID`=`ptc`.`PRODUCT_ID`))
LEFT JOIN `e_product_categories` `pc` ON ((`pc`.`ID`=`ptc`.`CATEGORY_ID`))
LEFT JOIN `e_catalogs` `c` ON ((`c`.`ID`=`pc`.`CATALOG_ID`))
WHERE `ptc`.`PRODUCT_ID` IN (161)
AND `c`.`SITE_ID` LIKE 's0'
UNION
SELECT 'features',`p`.`ID` AS `ID`
,'X','X','X','X','X','X','X','X','X','X','X','X'
,'X','X','X','X','X','X','X','X','X','X','X'
,'X'
,FEATURE_ID
,'X','X','X','X','X','X'
FROM `e_product_catalog` `pc`
LEFT JOIN `e_products` `p` ON `p`.`ID`=`pc`.`PRODUCT_ID`
LEFT JOIN `e_product_to_category` `ptc` ON ((`ptc`.`PRODUCT_ID`=`pc`.`PRODUCT_ID`))
LEFT JOIN `e_catalogs` `c` ON ((`c`.`ID`=`ptc`.`CATEGORY_ID`))
WHERE `pc`.`PRODUCT_ID` IN (161) AND `c`.`SITE_ID` LIKE 's0'
UNION
SELECT 'rangeapp',`p`.`ID` AS `ID`
,'X','X','X','X','X','X','X','X','X','X','X','X'
,'X','X','X','X','X','X','X','X','X','X','X'
,'X','X'
,`RANGE_APP_ID`
,'X' ,'X','X','X','X'
FROM `e_product_range_app` `pra`
LEFT JOIN `e_products` `p` ON `p`.`ID`=`pra`.`PRODUCT_ID`
WHERE `PRODUCT_ID` IN (161)
UNION
SELECT 'rangepre',`p`.`ID` AS `ID`
,'X','X','X','X','X','X','X','X','X','X','X','X'
,'X','X','X','X','X','X','X','X','X','X','X'
,'X','X','X'
,`RANGE_PRE_ID`,'X','X','X','X'
FROM `e_product_range_pre` `prp`
LEFT JOIN `e_products` `p` ON `p`.`ID`=`prp`.`PRODUCT_ID`
WHERE `PRODUCT_ID` IN (161)
UNION
SELECT 'prices',`p`.`ID` AS `ID`
,'X','X','X','X','X','X','X','X','X','X','X','X'
guest,
28 Июля 2009
−131.5
SELECT [Worker_list].[Id] ,
[Worker_list.Post_adress] ,
[Worker_list.Ident_fiscal] ,
[Worker_list.VacationDay] ,
[Worker_list].[Name_worker] ,
[Worker_list].[Name] ,
[Worker_list].[Firstname] ,
[Worker_list].[Middlenamme] ,
[Worker_list].[Табельний номер] ,
[Worker_list].[workfrom] AS workfromtable,
(SELECT MIN([time_list].[begin_date])
FROM [time_list]
WHERE [time_list].[worker]=[worker_list].[id]
) AS accountfrom,
IIF
(
ISNULL([workfromtable]),[accountfrom],[workfromtable]
) AS workfrom ,
[Worker_list].[startstockdate] AS startstockdatetable,
IIF
(
ISNULL([startstockdatetable]),[accountfrom],[startstockdatetable]
) AS startstockdate ,
[Worker_list].[startaccrualday] AS startaccrualdaytable,
[Worker_list].[startusedday] AS startuseddaytable ,
IIF
(
ISNULL([startaccrualdaytable]),0,[startaccrualdaytable]
) AS Startaccrualday,
IIF
(
ISNULL([startuseddaytable]),0,[startuseddaytable]
) AS startusedday,
(SELECT MIN([calendar_all].[Дата])
FROM calendar_all
) AS Todayis ,
SUM(DATEDIFF("d",[Chas]![Date Begin],DATEADD("d",1,[Chas]![Date end]))) AS UsedDayAfterTable,
IIF
(
ISNULL([useddayaftertable]),0,[useddayaftertable]
) AS UsedDayAfter,
(SELECT SUM (DATEDIFF("d",Chas.[Date Begin], DATEADD("d",1,Chas.[Date End])))
FROM Worker_list AS Worker_list_1
INNER JOIN (Reason_list
INNER JOIN Chas
ON Reason_list.Id = Chas.Reason)
ON Worker_list_1.Id = Chas.Worker
WHERE Reason_list.List =0
AND Worker_list.Id =Worker_List_1.Id
AND chas.[date end] <=
(SELECT MIN([calendar_all].[Дата])
FROM calendar_all
)
) AS timelossafterbeforetable,
(SELECT SUM (DATEDIFF("d",Chas.[Date Begin], DATEADD("d",1,
(SELECT MIN([calendar_all].[Дата])
FROM calendar_all
))))
FROM Worker_list AS Worker_list_1
INNER JOIN (Reason_list
INNER JOIN Chas
ON Reason_list.Id = Chas.Reason)
ON Worker_list_1.Id = Chas.Worker
WHERE Reason_list.List =0
AND Worker_list.Id =Worker_List_1.Id
AND chas.[date begin] <
(SELECT MIN([calendar_all].[Дата])
FROM calendar_all
)
AND chas.[date end] >
(SELECT MIN([calendar_all].[Дата])
FROM calendar_all
)
) AS timelossaftertable,
IIF
(
ISNULL([timelossafterbeforetable]),0,[timelossafterbeforetable]
) AS timelossafterbefore,
IIF
(
ISNULL([timelossaftertable]),0,[timelossaftertable]
) AS timelossafter,
DATEDIFF("d",[startstockdate],[todayis])-[timelossafterbefore]-[timelossafter] AS workoffafter ,
INT([workoffafter] /365*
IIF
(
ISNULL([Worker_list].[VacationDay]),GetVacationDayCount(),[Worker_list].[VacationDay]
)
) AS accrualdayafter,
DATEDIFF("d",[workfrom],[todayis]) AS workoffall ,
[Startaccrualday] -[startusedday]+[accrualdayafter] AS accrualdayall ,
[accrualdayafter] +[startaccrualday] AS accrualday ,
[startusedday] +[useddayafter]-StateHoliDay AS usedday ,
[accrualday] -[usedday] AS unusedday ,
DATEADD("d",INT([usedday]/
IIF
(
ISNULL([Worker_list].[VacationDay]),GetVacationDayCount(),[Worker_list].[VacationDay]
)
*365)+[timelossafterbefore]+[timelossafter],[workfrom]) AS Usedto,Запрос количества оставшихся отпусков в кадровой программе
guest,
14 Июля 2009
−859
49512select * from dual
guest,
13 Июля 2009
−861.8
select
....
if(n.Pinned=1,concat(n.Name,' <img src=/images/icons/897634.gif>'),n.Name) as Name
from
news n
left outer join ....
.....
where
....Как вам html-верстка в sql запросах?
guest,
23 Июня 2009
−128.7
if(mysql_query('DROP TABLE table_name'))
echo "таблица существовала ;(";
Проверка таблицы на существование.
Взято самизнаетеоткуда
ЗЫ SQL+PHP
guest,
11 Июня 2009
−857.4
select *
from INV_CARD
where to_char (dt_reg, 'MM') < TO_CHAR(SYSDATE, 'MM')
AND (DT_OUT IS NULL OR to_char (dt_OUT, 'MM') = TO_CHAR(SYSDATE, 'MM'))
AND ID_FA_TYPE NOT IN (SELECT ID_FA_TYPE FROM FA_TYPE WHERE CODE = '17')
AND ID_FA_STATUS IN (SELECT ID_FA_STATUS FROM FA.V_FA_STATUS WHERE IS_ACCOUNTING = 1)
AND STATUS = 1
AND GLN.ACC_OPER.GET_ACC1_ACC2(ID_AMORT_ACC) LIKE '01%'
(PL/SQL)
очень понравилось сравнение дат, ну и использование констант тоже зачет
guest,
04 Июня 2009
−852.5
--
--Ada SPEC file
--Universe
--
-- Description:
--
--
--
--
--
--
--
package Universe is
type UniversalObject is tagged record
id:integer;
end record;
type Position is record
x:integer;
y:integer;
end record;
type VisibleObject is new UniversalObject with record
mass: integer;
Name:String (0..60);
Speed: float; --скорость:)
OrbitalPosition: Position;
end record;
type Ship Is new VisibleObject with record
Size:integer;
end record;
type Asteroid is new VisibleObject WITH NULL RECORD;
procedure USELECT (Object: in UniversalObject'Class); --Новая инструкция выбора:)
end Universe;
Тут не смешно, но мне кажется, стоит оптимизировать.
И еще: Добавьте языков в список. Не все ковнокодеры - вебмастера.
guest,
03 Июня 2009
−866.4
"select crash.Фамилия from crash where Нарушение=(select select bill.Нарушение from bill where Штраф=(select max(Штраф) from bill));";
guest,
03 Июня 2009
Follow us!