SELECT _pg.*, _pgl.id as productGroupLangId, _pgl.productGroupId, _pgl.mid, _pgl.lang, _pgl.name, _pgl.shortDescription, _pgl.description, _pgl.permalink, _pgl.tagovi, _pgl.metaTitle, _pgl.metaDescription, SUBSTRING(SUBSTRING_INDEX(_pg.path, '/', 2), 2) as mainProductGroupId, IFNULL(t.countProducts, 0) as countProducts FROM nb_product_group _pg INNER JOIN nb_product_group_lang _pgl ON _pgl.productGroupId = _pg.id LEFT JOIN ( SELECT pgl.productGroupId, COUNT(pl.productId) as countProducts, pg_help.id FROM nb_product p INNER JOIN nb_product_lang pl ON pl.productId = p.Id AND pl.lang = 'rs' INNER JOIN nb_product_group pg ON pg.id = p.productGroupId INNER JOIN nb_product_group pg_help ON ( pg.path LIKE CONCAT('/', pg_help.id ,'') OR pg.path LIKE CONCAT('%/', pg_help.id ,'/%') OR pg.path LIKE CONCAT('%/', pg_help.id ,'') ) INNER JOIN nb_product_group_lang pgl ON pgl.productGroupId = pg_help.id AND pgl.lang = 'rs' WHERE p.status = 1 AND p.del = -1 and pl.lang = 'rs' AND (p.status = '1' ) AND (p.quantity > 0 ) AND (pg.status = '1' ) AND (pg.del = '-1' ) AND (p.catalogPath != '' AND FIND_IN_SET( '1', p.catalogPath ) ) AND (p.image != '' ) AND (p.price > 0 AND p.price <= 28730.00 ) AND (pg.parentid LIKE '/1' OR pg.path LIKE '%/1/%' OR pg.path LIKE '%/1' ) GROUP BY pg_help.id ) as t ON t.id = _pg.id WHERE _pg.status = 1 AND _pg.del = -1 AND ( _pgl.name != '0' AND _pgl.name != '-' ) AND _pgl.lang = 'rs' AND _pg.parentid = '1' GROUP BY _pg.id ORDER BY _pg.sort ASC, _pgl.name ASC, _pg.id ASC
Katalog proizvoda | Planeta Sport

Katalog

Katalog

Pol
Brend
Namena
Status
Akcije
Naziv ili šifra proizvoda
4656 proizvoda
200,00 RSD
250,00 RSD
200,00 RSD
250,00 RSD
200,00 RSD
250,00 RSD
CARAPE HIGH SOCKET 1/1
NOVO
-10 %
Detaljnije
225,00 RSD
250,00 RSD
232,00 RSD
290,00 RSD
232,00 RSD
290,00 RSD
623,00 RSD
890,00 RSD
623,00 RSD
890,00 RSD
712,00 RSD
890,00 RSD
712,00 RSD
890,00 RSD