16 kamerové sety | kamerak.cz

SELECT game_polozky.*, (SELECT SUM(game_zasoby.pocet_kusu_zasoby) AS hodnota_plus FROM game_zasoby WHERE game_zasoby.obj_kod_polozky_zasoby=game_polozky.obj_kod_polozky AND stav_zasoby='new' AND zasoba_hotovo='A' AND id_druh_zasoby='1') - if( (SELECT SUM(game_zasoby.pocet_kusu_zasoby) AS hodnota_plus FROM game_zasoby WHERE game_zasoby.obj_kod_polozky_zasoby=game_polozky.obj_kod_polozky AND stav_zasoby='new' AND zasoba_hotovo='A' AND id_druh_zasoby='2') IS NULL, 0, (SELECT SUM(game_zasoby.pocet_kusu_zasoby) AS hodnota_plus FROM game_zasoby WHERE game_zasoby.obj_kod_polozky_zasoby=game_polozky.obj_kod_polozky AND stav_zasoby='new' AND zasoba_hotovo='A' AND id_druh_zasoby='2') ) as polozky_skladem, (SELECT COUNT(game_polozky_navstevy.id_game_polozky_navstevy) AS hodnota_navstevy FROM game_polozky_navstevy WHERE game_polozky_navstevy.obj_kod_polozky=game_polozky.obj_kod_polozky AND game_polozky_navstevy.id_eshop='2') as pocet_navstev FROM game_polozky LEFT JOIN game_polozky_strom ON game_polozky_strom.obj_kod_polozky=game_polozky.obj_kod_polozky LEFT JOIN game_strom ON game_strom.id=game_polozky_strom.id_strom LEFT JOIN game_strom_eshop ON game_strom_eshop.id_strom=game_strom.id WHERE game_strom_eshop.id_eshop='2' AND game_strom_eshop.zobrazit='A' AND game_polozky_strom.id_strom='451' AND game_polozky.zobrazit_eshop='A' AND length(game_polozky.obj_kod_polozky)<=8 HAVING (game_polozky.sklad_karta_samostatna != 'A') OR ( (SELECT SUM(game_zasoby.pocet_kusu_zasoby) AS hodnota_plus FROM game_zasoby WHERE game_zasoby.obj_kod_polozky_zasoby=game_polozky.obj_kod_polozky AND stav_zasoby='new' AND zasoba_hotovo='A' AND id_druh_zasoby='1') - if( (SELECT SUM(game_zasoby.pocet_kusu_zasoby) AS hodnota_plus FROM game_zasoby WHERE game_zasoby.obj_kod_polozky_zasoby=game_polozky.obj_kod_polozky AND stav_zasoby='new' AND zasoba_hotovo='A' AND id_druh_zasoby='2') IS NULL, 0, (SELECT SUM(game_zasoby.pocet_kusu_zasoby) AS hodnota_plus FROM game_zasoby WHERE game_zasoby.obj_kod_polozky_zasoby=game_polozky.obj_kod_polozky AND stav_zasoby='new' AND zasoba_hotovo='A' AND id_druh_zasoby='2') ) >= 1 ) ORDER BY game_polozky.obj_kod_polozky