SELECT product.product_id AS product_id ,min(product_spec.product_spec_id) AS product_spec_id ,min(product_spec.ean) AS ean ,max(product_info.product_name) AS product_name ,max(producer_info.producer_name) AS producer_name ,max(product_info.short_info) AS short_info ,max(product_info.long_info) AS long_info ,max(style_info.style_name) AS druh_zbozi ,min(product_info2.a159) AS obj_cislo ,min(product_info2.a161) AS akcni_cena ,min(fotr.category_id) AS category_id ,max(fotr.shop_id_up) AS fotr_id_up ,max((product_spec.row * (1 + product_spec.dph))) as cena_s_dph ,min((product_spec.row * (1 + product_spec.dph)*(1 - product_spec.sleva / 100))) as cena_se_slevou ,max(product_spec.sleva) as sleva ,min(product_media.media_id) AS media_id ,max(store_central.units) AS units ,min(product_info.language_id) AS language FROM product JOIN product_info ON product_info.product_id = product.product_id AND product_info.language_id = 1 JOIN product_info2 ON product_info2.product_id = product.product_id AND product_info2.language_id = 1 JOIN product_spec ON product_spec.product_id = product.product_id AND product_spec.product_spec_id = ? AND product_spec.row != 0 JOIN style_info ON style_info.style_id = product.style_id AND style_info.language_id = 1 JOIN product_category ON product_category.product_id = product.product_id JOIN product_media ON product_media.product_id = product.product_id JOIN shop_category as kluk ON kluk.category_id = product_category.category_id AND kluk.shop_id = 73 JOIN shop_category as fotr ON fotr.category_id = kluk.shop_id_up AND fotr.shop_id = 73 LEFT JOIN shop_category as dedek ON dedek.category_id = fotr.shop_id_up AND dedek.shop_id = 73 JOIN producer_info ON producer_info.producer_id = product.producer_id JOIN store_central ON store_central.product_spec_id = product_spec.product_spec_id LEFT JOIN product_notshow_2 ON product_notshow_2.product_spec_id = product_spec.product_spec_id WHERE product.product_id = ? GROUP BY product.product_id


542699416
352649674


object(stdClass)#7 (18) {
  ["product_id"]=>
  int(352649674)
  ["product_spec_id"]=>
  int(542699416)
  ["ean"]=>
  string(13) "8592772099402"
  ["product_name"]=>
  string(52) "Ski Gog. 952 DAO, neon yellow, amber2, silver mirror"
  ["producer_name"]=>
  string(8) "blizzard"
  ["short_info"]=>
  string(152) "Target group: junior/lady
Frame: Neon yellow
Lens color: amber
Coating color: silver flash
Strap color: black/white
UV protection: 100%
Lens vent:"
  ["long_info"]=>
  string(875) "

Target group: junior/lady

Frame: Neon yellow

Lens color: amber

Coating color: silver flash

Strap color: black/white

UV protection: 100%

Lens vent: no

Helmet FIT: yes

2nd lens: no

Packing: color box , soft pouch

" ["druh_zbozi"]=> string(18) "lyžařské brýle" ["obj_cislo"]=> string(6) "952130" ["akcni_cena"]=> string(1) "1" ["category_id"]=> int(336647754) ["fotr_id_up"]=> int(418756846) ["cena_s_dph"]=> string(17) "599.0000000000005" ["cena_se_slevou"]=> string(37) "539.000000000000629916527545910000000" ["sleva"]=> string(15) "10.016694490818" ["media_id"]=> int(765411259) ["units"]=> int(192) ["language"]=> int(1) }