Momentálně 88 různých produktů v sekci Makety .
Ráj na mobil
- Makety
Nejprodávanější zboží kategorie
324 Kč
Aligator R5...
111749
324 Kč
Aligator R5...
111750
324 Kč
Aligator...
112056
433 Kč
Aligator...
116702
40 Kč
p>....< p>
30388
40 Kč
p>....< p>
30435
40 Kč
p>....< p>
30436
40 Kč
p>....< p>
30527
40 Kč
p>....< p>
30528
40 Kč
p>....< p>
30529
40 Kč
p>....< p>
30530
40 Kč
p>....< p>
30531
40 Kč
p>....< p>
30532
40 Kč
p>....< p>
30533
40 Kč
p>....< p>
30534
99 Kč
p>....< p>
32486
99 Kč
p>....< p>
32488
99 Kč
p>....< p>
32489
99 Kč
p>....< p>
32490
99 Kč
p>....< p>
32527
99 Kč
p>....< p>
36111
40 Kč
Nokia...
108711
40 Kč
Maketa Nokia N95 graphite
108712
74 Kč
Maketa Nokia X2 Red
109310
115 Kč
Maketa Nokia E72 Metal Grey
109421
99 Kč
Maketa Nokia E6-00 QWERTZ Black
116594
215 Kč
Karton (boxed) ...
122856
99 Kč
p>....< p>
32020
99 Kč
p>....< p>
32280
99 Kč
p>....< p>
32481
queryseznam: SELECT * FROM telelzbozi WHERE zobrazeno!='0' and (date_upd>'2012-06-04 06:03:18' or pocetskladem>'0') and kategorie2='56' ORDER BY (pocetskladem='0'), pocetskladem DESC, pocet DESC
querypodkategorie: SELECT * FROM kategorie3 where id_kategorie='2' and id_kategorie2='56' order by nazev
querypodkategoriepoc: SELECT * FROM telelzbozi WHERE zobrazeno!='0' and (date_upd>'2012-06-04 06:03:18' or pocetskladem>'0') and kategorie='2' and kategorie2='56'
queryznacky: select
znacka.id as id
,count(telelzbozi.id_znacka) AS pocet, znacka.nazev AS nazev, znacka.urlnazev
from telelzbozi
right join znacka on telelzbozi.id_znacka = znacka.id
where kategorie='2' and kategorie2='56' and znacka.nazev!='' and zobrazeno!='0' and (date_upd>'2012-06-04 06:03:18' or pocetskladem>'0')
group by urlnazev;
|
