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 '/23197342' OR pg.path LIKE '%/23197342/%' OR pg.path LIKE '%/23197342' ) 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 = '23197342' GROUP BY _pg.id ORDER BY _pg.sort ASC, _pgl.name ASC, _pg.id ASC
Čarape | Planeta Sport

CARAPE

Pol
Brend
Namena
Status
Veličine
Akcije
Naziv ili šifra proizvoda
135 proizvoda
162,50 RSD
250,00 RSD
162,50 RSD
250,00 RSD
162,50 RSD
250,00 RSD
188,50 RSD
290,00 RSD
188,50 RSD
290,00 RSD
489,50 RSD
890,00 RSD
489,50 RSD
890,00 RSD
578,50 RSD
890,00 RSD
578,50 RSD
890,00 RSD
CARAPE SOCKET 1/1
NOVO
-15 %
Detaljnije
246,50 RSD
290,00 RSD
CARAPE SOCKET 1/1
NOVO
-15 %
Detaljnije
246,50 RSD
290,00 RSD
CARAPE SOCKET 1/1
NOVO
-15 %
Detaljnije
246,50 RSD
290,00 RSD