SELECT DISTINCT `product_name`,`jos_vm_category`.`products_per_row`,`jos_vm_category`.`category_browsepage`,`jos_vm_category`.`category_flypage`,`jos_vm_category`.`category_id`,
`jos_vm_product`.`product_id`,`product_full_image`,`product_thumb_image`,`product_s_desc`,`product_parent_id`,`product_publish`,`product_in_stock`,`product_sku`, `product_url`,
`product_weight`,`product_weight_uom`,`product_length`,`product_width`,`product_height`,`product_lwh_uom`,`product_in_stock`,`product_available_date`,`product_availability`,`jos_vm_product`.`mdate`, `jos_vm_product`.`cdate`, cat_parent.list_order AS list_order_0, `jos_vm_category`.list_order AS list_order_1 FROM (`jos_vm_product`, `jos_vm_category`, `jos_vm_product_category_xref`,`jos_vm_shopper_group`) LEFT JOIN `jos_vm_product_price` ON `jos_vm_product`.`product_id` = `jos_vm_product_price`.`product_id`
LEFT JOIN `jos_vm_category_xref` ON `jos_vm_category_xref`.`category_child_id` = `jos_vm_category`.`category_id`
LEFT JOIN `jos_vm_category` cat_parent ON cat_parent.`category_id` = `jos_vm_category_xref`.`category_parent_id` WHERE `jos_vm_product_category_xref`.`product_id`=`jos_vm_product`.`product_id`
AND `jos_vm_product_category_xref`.`category_id`=`jos_vm_category`.`category_id`
AND `jos_vm_product_category_xref`.`category_id` IN('79')
AND ((`jos_vm_product`.`product_id`=`jos_vm_product_price`.`product_id` AND `jos_vm_shopper_group`.`shopper_group_id`=`jos_vm_product_price`.`shopper_group_id`) OR `jos_vm_product_price`.`product_id` IS NULL)
AND `jos_vm_shopper_group`.`default` = 1
AND `product_parent_id`=0
AND `product_publish`='Y'
AND `jos_vm_category`.`category_publish`='Y'
GROUP BY `jos_vm_product`.`product_sku`
ORDER BY list_order_0 ASC, list_order_1 ASC, `jos_vm_product_category_xref`.`product_list` LIMIT 0, 2000
Kód produktu:
Regom005
Popis produktu
Typy P12 2x7 040, P14 217 5250, P14 287 5100, P15 217 xxx, P16 217 xxx, P24 217 xxx, P26 217 xxx, P51 217 xxx(0), P52 2x7 xxx(0), P54 217 540, P57 217 xxx(0),P58 217 5x0(0)
