/scripts/detail.php:
<b>query</b>: SELECT name FROM sysobjects WHERE type='U'

<b>query</b>: SELECT * FROM NEWSSERVER

<b>query</b>: SELECT NEWSLANGUAGE.ID, NEWSLANGUAGE.LOCALE FROM NEWSLANGUAGE

<b>query</b>: SELECT KOREKTURA,JAZYKID,PUBLID,KATEGID,HTMLFRAGMENT,DYNAMIC_BR FROM NEWSDB WHERE ID=13705

<b>query</b>: SELECT DETAILPAGE from NEWSDB where ID=13705

<b>query</b>: SELECT * FROM NEWSPAGE WHERE ID=25

<b>query</b>: SELECT * FROM NEWSPAGE WHERE ID=2

<b>query</b>: SELECT * FROM NEWSPAGE WHERE ID=15

<b>query</b>: SELECT * FROM NEWSPAGE WHERE ID=13

<b>query</b>: SELECT LOCALE FROM NEWSLANGUAGE WHERE ID=1

<b>query</b>: SELECT MIME FROM NEWSMIME WHERE ID=1

<b>query</b>: select ID from NEWSPAGE where PARENTID = 13

<b>query</b>: SELECT DISTINCT TYPID FROM NEWSCONN WHERE STRANAID=13 UNION ALL SELECT DISTINCT TYPID FROM NEWSUSEDTYPES WHERE PAGEID=13

<b>query</b>: SELECT * FROM NEWSTYP WHERE ID=3

<b>query</b>: SELECT LOCALE FROM NEWSLANGUAGE WHERE ID=1

<b>query</b>: SELECT MIME FROM NEWSMIME WHERE ID=1

<b>query</b>: select ID from NEWSPAGE where PARENTID = 15

<b>query</b>: SELECT DISTINCT TYPID FROM NEWSCONN WHERE STRANAID=15 UNION ALL SELECT DISTINCT TYPID FROM NEWSUSEDTYPES WHERE PAGEID=15

<b>query</b>: SELECT * FROM NEWSTYP WHERE ID=3

<b>query</b>: SELECT * FROM NEWSTYP WHERE ID=4

<b>query</b>: SELECT LOCALE FROM NEWSLANGUAGE WHERE ID=1

<b>query</b>: SELECT MIME FROM NEWSMIME WHERE ID=1

<b>query</b>: select ID from NEWSPAGE where PARENTID = 2

<b>query</b>: SELECT DISTINCT TYPID FROM NEWSCONN WHERE STRANAID=2 UNION ALL SELECT DISTINCT TYPID FROM NEWSUSEDTYPES WHERE PAGEID=2

<b>query</b>: SELECT * FROM NEWSTYP WHERE ID=4

<b>query</b>: SELECT * FROM NEWSTYP WHERE ID=5

<b>query</b>: SELECT * FROM NEWSTYP WHERE ID=7

<b>query</b>: SELECT * FROM NEWSTYP WHERE ID=11

<b>query</b>: SELECT * FROM NEWSTYP WHERE ID=12

<b>query</b>: SELECT LOCALE FROM NEWSLANGUAGE WHERE ID=1

<b>query</b>: SELECT MIME FROM NEWSMIME WHERE ID=1

<b>query</b>: select ID from NEWSPAGE where PARENTID = 25

<b>query</b>: SELECT DISTINCT TYPID FROM NEWSCONN WHERE STRANAID=25 UNION ALL SELECT DISTINCT TYPID FROM NEWSUSEDTYPES WHERE PAGEID=25

<b>query</b>: SELECT * FROM NEWSTYP WHERE ID=7

<b>query</b>: SELECT * FROM NEWSTYP WHERE ID=11

<b>query</b>: SELECT * FROM NEWSTYP WHERE ID=12

<b>query</b>: SELECT NEWSLANGUAGE.ID, NEWSLANGUAGE.LOCALE FROM NEWSLANGUAGE

<b>query</b>: SELECT KOREKTURA,JAZYKID,PUBLID,KATEGID,HTMLFRAGMENT,DYNAMIC_BR,DATUM AS DATE,NADPIS AS TITLE,TELO AS BODY FROM NEWSDB WHERE ID=13705

<b>query</b>: SELECT NEWSID, LISTID, NAVIGID, OBJECT, LAYOUTID, TYPID FROM NEWSCONN WHERE ID=58

<b>query</b>: select * from NEWSLAYOUT where ID=9

<b>query</b>: select TYP from NEWSPROPOJENI where ID=10

<b>query</b>: select * from NEWSPROPOJENI where ID=10 and TYP=3

<b>query</b>: declare @publicationId int, @pageId int, @areaId int, @groupId int
declare @categoryId int, @languageId int, @columnName varchar(100), @datum datetime

select @publicationId = 0, @pageId = 0, @areaId = 0, @groupId = 0
select @categoryId = 0, @languageId = 0, @columnName = ''
select @datum = getdate()
;




select @publicationId = PUBLID, @categoryId = KATEGID from NEWSDB where ID = @id
;




set rowcount 1
;




select news.ID, news.NADPIS, news.LINKNADPIS, news.POPIS, news.TELO, news.OBRAZEK, news.ALTOBRAZEK, ( convert( varchar(10), news.DATUM, 102 ) + convert( varchar(8), news.DATUM, 8 ) ) DATUM, ( convert( varchar(10), news.CAS, 102 ) + convert( varchar(8), news.CAS, 8 ) ) CAS, ( convert( varchar(10), news.DATUMACT, 102 ) + convert( varchar(8), news.DATUMACT, 8 ) ) as DATUMACT, news.LINKPOPIS, news.PODTEXT, news.LINKPODTEXT, news.KATEGID, news.PUBLID, news.VYDANIID, news.STRANA, news.RUBRIKA, news.JAZYKID, news.AUTOR, news.AUTORID, news.SKUPINAID  into #articles from NEWSDB news

 where ( news.ID != @id ) and ( news.KOREKTURA=1 ) and ( exists (SELECT 1 FROM NEWSKATEG WHERE FULLTEXTSEARCH=1 and ID = news.KATEGID ) ) and ( news.PUBLID = @publicationId ) and ( news.KATEGID = @categoryId ) and (news.HTMLFRAGMENT=1)
order by news.DATUM, news.CAS
;




set rowcount 0
;




select news.*, nvyd.NAZEV as VYDANI, npubl.NAZEV as PUBLIKACE, nkateg.NAZEV as KATEGORIE,
 nskup.NAZEV as SKUPINA,
 na.ID as DOCID, na.NAME, na.DLINK, na.DTYPE, na.DSIZE, ( convert( varchar(10), na.DDATE, 102 ) + convert( varchar(8), na.DDATE, 8 ) ) as DDATE, na.DESCRIPTION 
 from #articles news, NEWSVYDANI nvyd, NEWSPUBL npubl, NEWSKATEG nkateg, NEWSSKUPINA nskup,  NEWSATTACH na 
 where news.VYDANIID *= nvyd.CISLO and news.PUBLID *= npubl.ID and
 news.KATEGID *= nkateg.ID and news.SKUPINAID *= nskup.ID
 and news.ID*=na.NEWSID AND na.DDEFAULT=1

<b>error</b>: Line 26: Incorrect syntax near ')'.

/scripts/detail.php:
<b>query</b>: SELECT name FROM sysobjects WHERE type='U'

<b>query</b>: SELECT * FROM NEWSSERVER

<b>query</b>: SELECT NEWSLANGUAGE.ID, NEWSLANGUAGE.LOCALE FROM NEWSLANGUAGE

<b>query</b>: SELECT KOREKTURA,JAZYKID,PUBLID,KATEGID,HTMLFRAGMENT,DYNAMIC_BR FROM NEWSDB WHERE ID=13705

<b>query</b>: SELECT DETAILPAGE from NEWSDB where ID=13705

<b>query</b>: SELECT * FROM NEWSPAGE WHERE ID=25

<b>query</b>: SELECT * FROM NEWSPAGE WHERE ID=2

<b>query</b>: SELECT * FROM NEWSPAGE WHERE ID=15

<b>query</b>: SELECT * FROM NEWSPAGE WHERE ID=13

<b>query</b>: SELECT LOCALE FROM NEWSLANGUAGE WHERE ID=1

<b>query</b>: SELECT MIME FROM NEWSMIME WHERE ID=1

<b>query</b>: select ID from NEWSPAGE where PARENTID = 13

<b>query</b>: SELECT DISTINCT TYPID FROM NEWSCONN WHERE STRANAID=13 UNION ALL SELECT DISTINCT TYPID FROM NEWSUSEDTYPES WHERE PAGEID=13

<b>query</b>: SELECT * FROM NEWSTYP WHERE ID=3

<b>query</b>: SELECT LOCALE FROM NEWSLANGUAGE WHERE ID=1

<b>query</b>: SELECT MIME FROM NEWSMIME WHERE ID=1

<b>query</b>: select ID from NEWSPAGE where PARENTID = 15

<b>query</b>: SELECT DISTINCT TYPID FROM NEWSCONN WHERE STRANAID=15 UNION ALL SELECT DISTINCT TYPID FROM NEWSUSEDTYPES WHERE PAGEID=15

<b>query</b>: SELECT * FROM NEWSTYP WHERE ID=3

<b>query</b>: SELECT * FROM NEWSTYP WHERE ID=4

<b>query</b>: SELECT LOCALE FROM NEWSLANGUAGE WHERE ID=1

<b>query</b>: SELECT MIME FROM NEWSMIME WHERE ID=1

<b>query</b>: select ID from NEWSPAGE where PARENTID = 2

<b>query</b>: SELECT DISTINCT TYPID FROM NEWSCONN WHERE STRANAID=2 UNION ALL SELECT DISTINCT TYPID FROM NEWSUSEDTYPES WHERE PAGEID=2

<b>query</b>: SELECT * FROM NEWSTYP WHERE ID=4

<b>query</b>: SELECT * FROM NEWSTYP WHERE ID=5

<b>query</b>: SELECT * FROM NEWSTYP WHERE ID=7

<b>query</b>: SELECT * FROM NEWSTYP WHERE ID=11

<b>query</b>: SELECT * FROM NEWSTYP WHERE ID=12

<b>query</b>: SELECT LOCALE FROM NEWSLANGUAGE WHERE ID=1

<b>query</b>: SELECT MIME FROM NEWSMIME WHERE ID=1

<b>query</b>: select ID from NEWSPAGE where PARENTID = 25

<b>query</b>: SELECT DISTINCT TYPID FROM NEWSCONN WHERE STRANAID=25 UNION ALL SELECT DISTINCT TYPID FROM NEWSUSEDTYPES WHERE PAGEID=25

<b>query</b>: SELECT * FROM NEWSTYP WHERE ID=7

<b>query</b>: SELECT * FROM NEWSTYP WHERE ID=11

<b>query</b>: SELECT * FROM NEWSTYP WHERE ID=12

<b>query</b>: SELECT NEWSLANGUAGE.ID, NEWSLANGUAGE.LOCALE FROM NEWSLANGUAGE

<b>query</b>: SELECT KOREKTURA,JAZYKID,PUBLID,KATEGID,HTMLFRAGMENT,DYNAMIC_BR,DATUM AS DATE,NADPIS AS TITLE,TELO AS BODY FROM NEWSDB WHERE ID=13705

<b>query</b>: SELECT NEWSID, LISTID, NAVIGID, OBJECT, LAYOUTID, TYPID FROM NEWSCONN WHERE ID=58

<b>query</b>: select * from NEWSLAYOUT where ID=9

<b>query</b>: select TYP from NEWSPROPOJENI where ID=10

<b>query</b>: select * from NEWSPROPOJENI where ID=10 and TYP=3

<b>query</b>: declare @publicationId int, @pageId int, @areaId int, @groupId int
declare @categoryId int, @languageId int, @columnName varchar(100), @datum datetime

select @publicationId = 0, @pageId = 0, @areaId = 0, @groupId = 0
select @categoryId = 0, @languageId = 0, @columnName = ''
select @datum = getdate()
;




select @publicationId = PUBLID, @categoryId = KATEGID from NEWSDB where ID = @id
;




set rowcount 1
;




select news.ID, news.NADPIS, news.LINKNADPIS, news.POPIS, news.TELO, news.OBRAZEK, news.ALTOBRAZEK, ( convert( varchar(10), news.DATUM, 102 ) + convert( varchar(8), news.DATUM, 8 ) ) DATUM, ( convert( varchar(10), news.CAS, 102 ) + convert( varchar(8), news.CAS, 8 ) ) CAS, ( convert( varchar(10), news.DATUMACT, 102 ) + convert( varchar(8), news.DATUMACT, 8 ) ) as DATUMACT, news.LINKPOPIS, news.PODTEXT, news.LINKPODTEXT, news.KATEGID, news.PUBLID, news.VYDANIID, news.STRANA, news.RUBRIKA, news.JAZYKID, news.AUTOR, news.AUTORID, news.SKUPINAID  into #articles from NEWSDB news

 where ( news.ID != @id ) and ( news.KOREKTURA=1 ) and ( exists (SELECT 1 FROM NEWSKATEG WHERE FULLTEXTSEARCH=1 and ID = news.KATEGID ) ) and ( news.PUBLID = @publicationId ) and ( news.KATEGID = @categoryId ) and (news.HTMLFRAGMENT=1)
order by news.DATUM, news.CAS
;




set rowcount 0
;




select news.*, nvyd.NAZEV as VYDANI, npubl.NAZEV as PUBLIKACE, nkateg.NAZEV as KATEGORIE,
 nskup.NAZEV as SKUPINA,
 na.ID as DOCID, na.NAME, na.DLINK, na.DTYPE, na.DSIZE, ( convert( varchar(10), na.DDATE, 102 ) + convert( varchar(8), na.DDATE, 8 ) ) as DDATE, na.DESCRIPTION 
 from #articles news, NEWSVYDANI nvyd, NEWSPUBL npubl, NEWSKATEG nkateg, NEWSSKUPINA nskup,  NEWSATTACH na 
 where news.VYDANIID *= nvyd.CISLO and news.PUBLID *= npubl.ID and
 news.KATEGID *= nkateg.ID and news.SKUPINAID *= nskup.ID
 and news.ID*=na.NEWSID AND na.DDEFAULT=1

<b>error</b>: Line 26: Incorrect syntax near ')'.

<b>query</b>: SELECT NEWSID, LISTID, NAVIGID, OBJECT, LAYOUTID, TYPID FROM NEWSCONN WHERE ID=60

<b>query</b>: select * from NEWSLAYOUT where ID=24

<b>query</b>: select TYP from NEWSPROPOJENI where ID=9

<b>query</b>: select * from NEWSPROPOJENI where ID=9 and TYP=3

<b>query</b>: declare @publicationId int, @pageId int, @areaId int, @groupId int
declare @categoryId int, @languageId int, @columnName varchar(100), @datum datetime

select @publicationId = 0, @pageId = 0, @areaId = 0, @groupId = 0
select @categoryId = 0, @languageId = 0, @columnName = ''
select @datum = getdate()
;


select @publicationId = PUBLID, @categoryId = KATEGID from NEWSDB where ID = @id
;


select distinct ZPRAVAID as ID, count(*) as KEYWORDS_COUNT into #keywordsTable from NEWSKEYWCONN
 	where ZPRAVAID != @id and KEYWID in
		(select ID from NEWSKEYWORDS where KEYWORD in ( 'Úřední zprávy - trvalé' ) )
	group by ZPRAVAID
;


set rowcount 10
;


select news.ID, news.NADPIS, news.LINKNADPIS, news.POPIS, news.TELO, news.OBRAZEK, news.ALTOBRAZEK, ( convert( varchar(10), news.DATUM, 102 ) + convert( varchar(8), news.DATUM, 8 ) ) DATUM, ( convert( varchar(10), news.CAS, 102 ) + convert( varchar(8), news.CAS, 8 ) ) CAS, ( convert( varchar(10), news.DATUMACT, 102 ) + convert( varchar(8), news.DATUMACT, 8 ) ) as DATUMACT, news.LINKPOPIS, news.PODTEXT, news.LINKPODTEXT, news.KATEGID, news.DETAILPAGE, news.DYNAMIC_BR, news.CESTA, news.PUBLID, news.VYDANIID, news.STRANA, news.RUBRIKA, news.JAZYKID, news.AUTOR, news.AUTORID, news.ISTABLE, news.SKUPINAID  into #articles from NEWSDB news
, #keywordsTable
 where ( news.ID != @id ) and ( news.KOREKTURA=1 ) and ( exists (SELECT 1 FROM NEWSKATEG WHERE FULLTEXTSEARCH=1 and ID = news.KATEGID ) ) and ( news.PUBLID = @publicationId ) and ( news.KATEGID = @categoryId ) and ( news.ID = #keywordsTable.ID ) and (news.HTMLFRAGMENT=0)
order by news.PRIORAUX desc, news.DATUM desc, news.CAS desc
;


set rowcount 0
;


select news.*, nvyd.NAZEV as VYDANI, npubl.NAZEV as PUBLIKACE, nkateg.NAZEV as KATEGORIE,
 nskup.NAZEV as SKUPINA,
 na.ID as DOCID, na.NAME, na.DLINK, na.DTYPE, na.DSIZE, ( convert( varchar(10), na.DDATE, 102 ) + convert( varchar(8), na.DDATE, 8 ) ) as DDATE, na.DESCRIPTION 
 from #articles news, NEWSVYDANI nvyd, NEWSPUBL npubl, NEWSKATEG nkateg, NEWSSKUPINA nskup,  NEWSATTACH na 
 where news.VYDANIID *= nvyd.CISLO and news.PUBLID *= npubl.ID and
 news.KATEGID *= nkateg.ID and news.SKUPINAID *= nskup.ID
 and news.ID*=na.NEWSID AND na.DDEFAULT=1

<b>error</b>: Line 27: Incorrect syntax near ')'.

FOTBAL.CZ - - Football association of Czech Republic - czech, cesky, cech, eech, sport, soccer, fotbal, football, cup, fussball, futsal, statisti, result, league, fixture, champion, qualifi, new, calcio, team, national, club, kopaná
Horní navigační lišta




RSS kanál
[Odkazy na články]
Ikonka serveru
[Ikonka pro vás]

22.3.2007

Fotbal žen: ČR - Švýcarsko



© FOTBAL.CZ - Přepis, šíření, či další zpřístupňování tohoto obsahu či jeho části veřejnosti, a to jakýmkoliv způsobem, je bez předchozího souhlasu FOTBAL.CZ výslovně zakázáno.
nic

WebToDate