SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20090608' AND '20090612') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 0

SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20090601' AND '20090605') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 0

SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20090525' AND '20090529') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 0

SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20090601' AND '20090605') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 0

SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20090608' AND '20090612') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20090601' AND '20090605') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
3
4
5
6
7
8
9
10
SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20090608' AND '20090612') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20090601' AND '20090605') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
4
5
6
7
8
9
10
SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20090608' AND '20090612') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20090601' AND '20090605') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
7
8
9
10
SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20090601' AND '20090605') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20090601' AND '20090605') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20090601'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20090602'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20090603'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20090604'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20090605'  AND id_misto=(1+0)
ORDER BY poradi


SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20090608' AND '20090612') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20090601' AND '20090605') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
4
5
6
7
8
9
10
SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20090608' AND '20090612') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20090608' AND '20090612') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20090601' AND '20090605') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20090608' AND '20090612') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20090601' AND '20090605') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20090608' AND '20090612') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20090601' AND '20090605') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
2
3
4
5
6
7
8
9
10
SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20090608' AND '20090612') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20090601' AND '20090605') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20090608' AND '20090612') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20090601' AND '20090605') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
10
SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20090608' AND '20090612') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20090615' AND '20090619') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20090615' AND '20090621') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 14

1
2
3
4
5
6
7
8
9
10
11
12
13
14
SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20090615' AND '20090619') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20090615'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20090616'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20090617'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20090618'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20090619'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20090601'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20090602'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20090603'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20090604'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20090605'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20090606'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20090607'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20090608'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20090609'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20090610'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20090611'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20090612'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20090613'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20090614'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20090615'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20090616'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20090617'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20090618'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20090619'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20090620'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20090621'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20090622'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20090623'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20090624'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20090625'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20090626'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20090627'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20090628'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20090629'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20090630'  AND id_misto=(1+0)
ORDER BY poradi


SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20090615' AND '20090619') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20090615'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20090616'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20090617'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20090618'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20090619'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20090615'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20090616'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20090617'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20090618'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20090619'  AND id_misto=(1+0)
ORDER BY poradi


SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20090615' AND '20090619') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20090615' AND '20090619') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20090615' AND '20090619') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20090615' AND '20090619') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20090615' AND '20090619') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20090615' AND '20090619') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20090622' AND '20090626') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20090727' AND '20090731') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20090720' AND '20090724') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20090713' AND '20090717') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20090810' AND '20090814') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20090803' AND '20090807') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20090727' AND '20090731') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20090720' AND '20090724') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
5
6
7
8
9
10
1
2
3
4
5
SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20090713' AND '20090717') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
6
7
8
9
10
SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20090706' AND '20090710') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20090629' AND '20090703') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20090622' AND '20090626') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20090615' AND '20090619') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20090622' AND '20090626') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20090629' AND '20090703') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20090622' AND '20090626') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20090810' AND '20090814') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20090803' AND '20090807') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20090810' AND '20090814') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20090803' AND '20090807') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20090727' AND '20090731') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20090720' AND '20090724') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20090713' AND '20090717') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20090706' AND '20090710') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20090629' AND '20090703') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20090622' AND '20090626') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20090615' AND '20090619') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
8
9
10
10
SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20090803' AND '20090807') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20090727' AND '20090731') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20090803' AND '20090807') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20090803' AND '20090807') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20090810' AND '20090814') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20090810' AND '20090814') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20090810' AND '20090814') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20090803' AND '20090807') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20090810' AND '20090814') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20090803' AND '20090807') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20090824' AND '20090828') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20090831' AND '20090904') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20090831' AND '20090904') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20090824' AND '20090828') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20090907' AND '20090911') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20090907'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20090908'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20090909'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20090910'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20090911'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20090907'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20090908'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20090909'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20090910'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20090911'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20090907'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20090908'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20090909'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20090910'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20090911'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20090907'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20090908'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20090909'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20090910'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20090911'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20090907'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20090908'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20090909'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20090910'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20090911'  AND id_misto=(1+0)
ORDER BY poradi


SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20090831' AND '20090904') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20090907' AND '20090911') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20090907' AND '20090911') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20090907' AND '20090911') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20090907' AND '20090911') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20090907' AND '20090911') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20090907' AND '20090911') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20090831' AND '20090904') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20090831' AND '20090904') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20090831' AND '20090904') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20090831' AND '20090904') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20090901'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20090902'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20090903'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20090904'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20090905'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20090906'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20090907'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20090908'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20090909'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20090910'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20090911'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20090912'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20090913'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20090914'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20090915'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20090916'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20090917'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20090918'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20090919'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20090920'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20090921'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20090922'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20090923'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20090924'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20090925'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20090926'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20090927'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20090928'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20090929'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20090930'  AND id_misto=(1+0)
ORDER BY poradi


SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20090831' AND '20090904') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20090831' AND '20090904') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20090907' AND '20090911') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20090907' AND '20090911') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20090907' AND '20090911') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20090907' AND '20090911') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20090907' AND '20090911') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
1
2
3
4
5
6
7
8
9
10
SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20090831' AND '20090904') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20090831' AND '20090904') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20090831' AND '20090904') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20090907' AND '20090911') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20090907' AND '20090911') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20090907' AND '20090911') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20090907' AND '20090911') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20090907' AND '20090911') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20090907' AND '20090911') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20090914' AND '20090918') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20090914'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20090915'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20090916'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20090917'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20090918'  AND id_misto=(1+0)
ORDER BY poradi


SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20090914' AND '20090918') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20090921' AND '20090925') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20090921'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20090922'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20090923'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20090924'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20090925'  AND id_misto=(1+0)
ORDER BY poradi


SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20090928' AND '20091002') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20090928'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20090929'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20090930'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20091001'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20091002'  AND id_misto=(1+0)
ORDER BY poradi


SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20091005' AND '20091009') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20091005'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20091006'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20091007'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20091008'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20091009'  AND id_misto=(1+0)
ORDER BY poradi


SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20091005' AND '20091009') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20091012' AND '20091016') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20091012' AND '20091016') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20091012'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20091013'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20091014'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20091015'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20091016'  AND id_misto=(1+0)
ORDER BY poradi


SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20091012' AND '20091016') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20091019' AND '20091023') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20091019'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20091020'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20091021'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20091022'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20091023'  AND id_misto=(1+0)
ORDER BY poradi


SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20091026' AND '20091030') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20091026'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20091027'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20091028'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20091029'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20091030'  AND id_misto=(1+0)
ORDER BY poradi


SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20091026' AND '20091030') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20091102' AND '20091106') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20091102'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20091103'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20091104'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20091105'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20091106'  AND id_misto=(1+0)
ORDER BY poradi


SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20091102' AND '20091106') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20091102' AND '20091106') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20091109' AND '20091113') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20091109'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20091110'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20091111'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20091112'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20091113'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20091109'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20091110'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20091111'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20091112'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20091113'  AND id_misto=(1+0)
ORDER BY poradi


SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20091109' AND '20091113') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20091116' AND '20091120') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20091116'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20091117'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20091118'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20091119'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20091120'  AND id_misto=(1+0)
ORDER BY poradi


SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20091109' AND '20091113') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20091123' AND '20091127') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20091123'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20091124'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20091125'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20091126'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20091127'  AND id_misto=(1+0)
ORDER BY poradi


SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20091123' AND '20091127') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20091130' AND '20091204') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20091130'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20091201'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20091202'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20091203'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20091204'  AND id_misto=(1+0)
ORDER BY poradi


SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20091116' AND '20091120') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20091130' AND '20091204') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20091123' AND '20091127') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20091130' AND '20091204') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20091123' AND '20091127') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20091123' AND '20091127') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20091123' AND '20091127') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20091123' AND '20091127') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20091123' AND '20091127') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20091130' AND '20091204') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20091207' AND '20091211') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20091207'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20091208'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20091209'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20091210'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20091211'  AND id_misto=(1+0)
ORDER BY poradi


SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20091214' AND '20091218') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20091214'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20091215'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20091216'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20091217'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20091218'  AND id_misto=(1+0)
ORDER BY poradi


SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20091214' AND '20091218') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20091228' AND '20100101') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20091228'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20091229'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20091230'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20091231'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20100101'  AND id_misto=(1+0)
ORDER BY poradi


SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20091221' AND '20091225') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20091228' AND '20100101') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20091221' AND '20091225') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20100104' AND '20100108') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20100104'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20100105'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20100106'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20100107'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20100108'  AND id_misto=(1+0)
ORDER BY poradi


SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20100111' AND '20100115') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20100111'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20100112'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20100113'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20100114'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20100115'  AND id_misto=(1+0)
ORDER BY poradi


SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20100118' AND '20100122') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20100118'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20100119'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20100120'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20100121'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20100122'  AND id_misto=(1+0)
ORDER BY poradi


SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20100125' AND '20100129') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20100125'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20100126'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20100127'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20100128'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20100129'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20100125'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20100126'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20100127'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20100128'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20100129'  AND id_misto=(1+0)
ORDER BY poradi


SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20100208' AND '20100212') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20100208'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20100209'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20100210'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20100211'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20100212'  AND id_misto=(1+0)
ORDER BY poradi


SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20100215' AND '20100219') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20100215'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20100216'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20100217'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20100218'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20100219'  AND id_misto=(1+0)
ORDER BY poradi


SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20100222' AND '20100226') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20100222'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20100223'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20100224'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20100225'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20100226'  AND id_misto=(1+0)
ORDER BY poradi


SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20100301' AND '20100305') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20100301'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20100302'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20100303'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20100304'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20100305'  AND id_misto=(1+0)
ORDER BY poradi


SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20100308' AND '20100312') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20100308'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20100309'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20100310'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20100311'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20100312'  AND id_misto=(1+0)
ORDER BY poradi


SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20100315' AND '20100319') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20100315'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20100316'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20100317'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20100318'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20100319'  AND id_misto=(1+0)
ORDER BY poradi


SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20100322' AND '20100326') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20100322'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20100323'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20100324'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20100325'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20100326'  AND id_misto=(1+0)
ORDER BY poradi


SELECT 

id,
id_misto,
datum,
chod,
cid,
LEFT(str, 255) as str,
skut,
r0,
r1,
r2,
r3,
r4,
r5,
r6,
r7,
den,
volny,
poradi,
schvaleno,
jidel_max,
DruhChodu

FROM jidlo
WHERE (datum BETWEEN '20100329' AND '20100402') AND id_misto = (1+0)
ORDER BY datum,poradi


pocet zaznamu: 10

1
2
3
4
5
6
7
8
9
10
JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20100329'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20100330'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20100331'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20100401'  AND id_misto=(1+0)
ORDER BY poradi


JidPrep2
--------

SELECT 

jidlo.*,
tchody.chodtxt AS cx

FROM jidlo 
LEFT JOIN tchody ON tchody.chod_id = jidlo.cid
WHERE datum = '20100402'  AND id_misto=(1+0)
ORDER BY poradi


