SELECT DISTINCT software.url_sw, nazev_sw AS nazev, tip,
kratky_popis, datum_sw, oznaceni,upresneni, cena AS cena_aplikace,
smscount, msisdn, code,
software.url_sekce AS sw_url_sekce, nazev_sekce AS sw_nazev_sekce,
stazeni_celkem AS celkem, (stazeni_po + stazeni_ut + stazeni_st + stazeni_ct + stazeni_pa + stazeni_so + stazeni_ne) AS tyden,
TO_DAYS(current_date) - TO_DAYS(datum_verze) AS pocetdnu,
IF((TO_DAYS(current_date) - TO_DAYS(datum_verze) < 15), (IF(datum_verze=datum_sw,'novinka','update')), NULL ) AS aktualni, klic_slova, status, hlasujicich, prumer,
MAX(datum_verze) AS datum, MAX(velikost) AS velikost
FROM sekce AS sekce, software AS software, verze AS verze
LEFT JOIN hodnoceni_cache ON hodnoceni_cache.url_sw = verze.url_sw
LEFT JOIN mobil_software ms ON (ms.url_sw = software.url_sw)
WHERE software.url_sw = verze.url_sw
AND verze.aktualnost = 't'
AND sekce.url_sekce = software.url_sekce
AND sekce.url_sekce LIKE 'mobil%'
AND datum_sw <= '2012-01-29'
AND (status = 'a' OR status='s')
AND software.url_sekce = 'mobil/tapety/lide'
AND ( software.url_sekce LIKE 'mobil%')
GROUP BY software.url_sw, nazev, tip, kratky_popis, datum_sw,
oznaceni, software.url_sekce, nazev_sekce,celkem, tyden,
pocetdnu, aktualni, klic_slova, status
ORDER BY prumer desc,hlasujicich desc
LIMIT 0, 20
Unknown column 'software.url_sw' in 'on clause'
SELECT id AS mobil_id , CONCAT(vyrobce, ' ', nazev) AS mobil_nazev
FROM mobil_telefony
ORDER BY mobil_nazev
