select p.id as id, p.heureka_url as heureka_url, pr.heureka_tax as heureka_tax, p.pohoda_sku as pohoda_sku, time_limit, time_limit_start, time_limit_price, time_limit_price_default, time_limit_show, time_limit_action, p.quick_delivery as pquickdelivery, m.quick_delivery as mquickdelivery, p.intro_image as introimage, p.priority as priority, p.parent_id as pid, p.balicek as balicek, p.mfmodel_id as pmid, p.published as published, p.available as available, p.frontpage as frontpage, p.news as news, p.set as pset, p.extrabonus as extrabonus, p.short_description as sdescription, p.variant_name as variant, p.manufacturer_id as mid, p.mfserie_id as sid, p.sku as sku, p.plnoletost, p.pouzecesko, p.name as name, p.description as description, pr.value as price, pr.value*0.0377358490566 as euprice, p.basket_unit_id as buid, p.sale_unit_id as sluid, p.basket_sale_ratio as bsratio, p.image as image, p.catalogue_price as catalogue_price, d.value as discount, d.percent as dpercent, d.bonus as dbonus, t.value as tax, p.note as note, (1-d.value)*ifnull(pr.value_tax, pr.value*(1+t.value)) as realprice, p.max_order_amount as maxOrderAmount, p.action_valid as actionValid, p.gift_id as gift_id, p.action as action, p.free_shipping as freeshipping, p.half_shipping as halfshipping, m.freeshipping as mfreeshipping, p.outlet, p.bazar, p.pgroup as pgroup, m.name as mfname, m.rabat as mrabat, m.discount as mdiscount, m.vip as vip, s.name as sname, p.width as width, p.content as content, p.doses as doses, p.height as height, p.length as length, p.price_group as price_group, m.delivery_days as mdays, ifnull(pr.value_tax, pr.value*(1+t.value)) as pricetax, pr.purchase_tax as purchasetax, pr.purchase_tax*0.0377358490566 as eupurchasetax, ifnull(pr.value_tax, pr.value*(1+t.value))*0.0377358490566 as eupricetax from sh_product p left join (sh_price pr) on (pr.product_id = p.id) left join (sh_discount d) on (d.product_id = p.id) left join (sh_manufacturer m) on (p.manufacturer_id = m.id ) left join (sh_mfserie s) on (p.mfserie_id = s.id ) left join (sh_tax t) on (pr.tax_id = t.id) where p.priority>=0 and d.group_id is null and pr.shopper_group_id is null and pr.currency_id = 1 and p.id = 27452 and p.published = 1 and m.published=1 order by d.value descselect p.id as id, p.heureka_url as heureka_url, pr.heureka_tax as heureka_tax, p.pohoda_sku as pohoda_sku, time_limit, time_limit_start, time_limit_price, time_limit_price_default, time_limit_show, time_limit_action, p.quick_delivery as pquickdelivery, m.quick_delivery as mquickdelivery, p.intro_image as introimage, p.priority as priority, p.parent_id as pid, p.balicek as balicek, p.mfmodel_id as pmid, p.published as published, p.available as available, p.frontpage as frontpage, p.news as news, p.set as pset, p.extrabonus as extrabonus, p.short_description as sdescription, p.variant_name as variant, p.manufacturer_id as mid, p.mfserie_id as sid, p.sku as sku, p.plnoletost, p.pouzecesko, p.name as name, p.description as description, pr.value as price, pr.value*0.0377358490566 as euprice, p.basket_unit_id as buid, p.sale_unit_id as sluid, p.basket_sale_ratio as bsratio, p.image as image, p.catalogue_price as catalogue_price, d.value as discount, d.percent as dpercent, d.bonus as dbonus, t.value as tax, p.note as note, (1-d.value)*ifnull(pr.value_tax, pr.value*(1+t.value)) as realprice, p.max_order_amount as maxOrderAmount, p.action_valid as actionValid, p.gift_id as gift_id, p.action as action, p.free_shipping as freeshipping, p.half_shipping as halfshipping, m.freeshipping as mfreeshipping, p.outlet, p.bazar, p.pgroup as pgroup, m.name as mfname, m.rabat as mrabat, m.discount as mdiscount, m.vip as vip, s.name as sname, p.width as width, p.content as content, p.doses as doses, p.height as height, p.length as length, p.price_group as price_group, m.delivery_days as mdays, ifnull(pr.value_tax, pr.value*(1+t.value)) as pricetax, pr.purchase_tax as purchasetax, pr.purchase_tax*0.0377358490566 as eupurchasetax, ifnull(pr.value_tax, pr.value*(1+t.value))*0.0377358490566 as eupricetax from sh_product p left join (sh_price pr) on (pr.product_id = p.id) left join (sh_discount d) on (d.product_id = p.id) left join (sh_manufacturer m) on (p.manufacturer_id = m.id ) left join (sh_mfserie s) on (p.mfserie_id = s.id ) left join (sh_tax t) on (pr.tax_id = t.id) where p.priority>=0 and d.group_id is null and pr.shopper_group_id is null and pr.currency_id = 1 and p.id = 27452 and p.published = 1 and m.published=1 order by d.value desc Hitec nutrition BS Blade 100% Whey Mass gainer 50g | NAMAKANEJ.cz