/var/www/pitstop.ge/public_html/view/pages/store.php on line 1275
');">M-L / 34
/var/www/pitstop.ge/public_html/view/pages/store.php on line 1275
');">S/M
/var/www/pitstop.ge/public_html/view/pages/store.php on line 1275
');">XS/S
/var/www/pitstop.ge/public_html/view/pages/store.php on line 1275
');">S / 48
/var/www/pitstop.ge/public_html/view/pages/store.php on line 1275
');">M/L
/var/www/pitstop.ge/public_html/view/pages/store.php on line 1275
');">S / M
/var/www/pitstop.ge/public_html/view/pages/store.php on line 1275
');">L / 36
/var/www/pitstop.ge/public_html/view/pages/store.php on line 1275
');">XS / 03
/var/www/pitstop.ge/public_html/view/pages/store.php on line 1275
');">L/XL
/var/www/pitstop.ge/public_html/view/pages/store.php on line 1275
');">XXS
/var/www/pitstop.ge/public_html/view/pages/store.php on line 1275
');">XL/2XL
/var/www/pitstop.ge/public_html/view/pages/store.php on line 1275
');">M / 50
/var/www/pitstop.ge/public_html/view/pages/store.php on line 1275
');">L / 44
/var/www/pitstop.ge/public_html/view/pages/store.php on line 1275
');">L / XL
/var/www/pitstop.ge/public_html/view/pages/store.php on line 1275
');">XL / 38
/var/www/pitstop.ge/public_html/view/pages/store.php on line 1275
');">L38
/var/www/pitstop.ge/public_html/view/pages/store.php on line 1275
');">S-M / 04
/var/www/pitstop.ge/public_html/view/pages/store.php on line 1275
');">XS
/var/www/pitstop.ge/public_html/view/pages/store.php on line 1275
');">L / 52
/var/www/pitstop.ge/public_html/view/pages/store.php on line 1275
');">XL / 46
/var/www/pitstop.ge/public_html/view/pages/store.php on line 1275
');">L40
/var/www/pitstop.ge/public_html/view/pages/store.php on line 1275
');">L-2XL / 05
/var/www/pitstop.ge/public_html/view/pages/store.php on line 1275
');">L
/var/www/pitstop.ge/public_html/view/pages/store.php on line 1275
');">S
/var/www/pitstop.ge/public_html/view/pages/store.php on line 1275
');">S-M / 32
/var/www/pitstop.ge/public_html/view/pages/store.php on line 1275
');">XL / 54
/var/www/pitstop.ge/public_html/view/pages/store.php on line 1275
');">XXL / 48
/var/www/pitstop.ge/public_html/view/pages/store.php on line 1275
');">ONE SIZE
/var/www/pitstop.ge/public_html/view/pages/store.php on line 1275
');">XL
/var/www/pitstop.ge/public_html/view/pages/store.php on line 1275
');">M
/var/www/pitstop.ge/public_html/view/pages/store.php on line 1275
');">2XL / 56
/var/www/pitstop.ge/public_html/view/pages/store.php on line 1275
');">2XL
/var/www/pitstop.ge/public_html/view/pages/store.php on line 1275
');">3XL
/var/www/pitstop.ge/public_html/view/pages/store.php on line 1275
');">3XL-6XL / 06
/var/www/pitstop.ge/public_html/view/pages/store.php on line 1275
');">31 mm
/var/www/pitstop.ge/public_html/view/pages/store.php on line 1275
');">32
/var/www/pitstop.ge/public_html/view/pages/store.php on line 1275
');">33
/var/www/pitstop.ge/public_html/view/pages/store.php on line 1275
');">34
/var/www/pitstop.ge/public_html/view/pages/store.php on line 1275
');">35
/var/www/pitstop.ge/public_html/view/pages/store.php on line 1275
');">36
/var/www/pitstop.ge/public_html/view/pages/store.php on line 1275
');">38.5
/var/www/pitstop.ge/public_html/view/pages/store.php on line 1275
');">38
/var/www/pitstop.ge/public_html/view/pages/store.php on line 1275
');">39
/var/www/pitstop.ge/public_html/view/pages/store.php on line 1275
');">40 / S ( LADY )
/var/www/pitstop.ge/public_html/view/pages/store.php on line 1275
');">40.5
/var/www/pitstop.ge/public_html/view/pages/store.php on line 1275
');">40
/var/www/pitstop.ge/public_html/view/pages/store.php on line 1275
');">41
/var/www/pitstop.ge/public_html/view/pages/store.php on line 1275
');">42
/var/www/pitstop.ge/public_html/view/pages/store.php on line 1275
');">42.5
/var/www/pitstop.ge/public_html/view/pages/store.php on line 1275
');">43
/var/www/pitstop.ge/public_html/view/pages/store.php on line 1275
');">43MM
/var/www/pitstop.ge/public_html/view/pages/store.php on line 1275
');">43.5
/var/www/pitstop.ge/public_html/view/pages/store.php on line 1275
');">44
/var/www/pitstop.ge/public_html/view/pages/store.php on line 1275
');">44.5
/var/www/pitstop.ge/public_html/view/pages/store.php on line 1275
');">45.5
/var/www/pitstop.ge/public_html/view/pages/store.php on line 1275
');">45
/var/www/pitstop.ge/public_html/view/pages/store.php on line 1275
');">46 / XL ( LADY )
/var/www/pitstop.ge/public_html/view/pages/store.php on line 1275
');">46
/var/www/pitstop.ge/public_html/view/pages/store.php on line 1275
');">48 / S
/var/www/pitstop.ge/public_html/view/pages/store.php on line 1275
');">48
/var/www/pitstop.ge/public_html/view/pages/store.php on line 1275
');">50
/var/www/pitstop.ge/public_html/view/pages/store.php on line 1275
');">50 / M
/var/www/pitstop.ge/public_html/view/pages/store.php on line 1275
');">52
/var/www/pitstop.ge/public_html/view/pages/store.php on line 1275
');">52 / L
/var/www/pitstop.ge/public_html/view/pages/store.php on line 1275
');">54 / XL
/var/www/pitstop.ge/public_html/view/pages/store.php on line 1275
');">54
/var/www/pitstop.ge/public_html/view/pages/store.php on line 1275
');">56
/var/www/pitstop.ge/public_html/view/pages/store.php on line 1275
');">56 / 2XL
/var/www/pitstop.ge/public_html/view/pages/store.php on line 1275
');">58
/var/www/pitstop.ge/public_html/view/pages/store.php on line 1275
');">58 / 3XL
/var/www/pitstop.ge/public_html/view/pages/store.php on line 1275
');">60 / 4XL
/var/www/pitstop.ge/public_html/view/pages/store.php on line 1275
');">62 / 5XL
სორტირება
SELECT t1.id,t1.groupid,t1.slug,t1.customgift, t1.VAT ,t1.sale,t1.namege,t1.code,t1.brand,min(t1.price) as 'min',max(t1.price) as 'max',(SELECT t5.namege FROM productgroups as t5 WHERE t1.groupid=t5.id) as 'gname',
(SELECT img FROM brands as t3 WHERE t3.id=t1.brand LIMIT 1) as 'bran',
(SELECT slug FROM productgroups as t5 WHERE t5.id=t1.groupid LIMIT 1) as 'groupslug',
(SELECT enddate FROM sale as t4 WHERE t4.code=t1.code ORDER BY id DESC LIMIT 1) as 'enddate',
(SELECT startdate FROM sale as t4 WHERE t4.code=t1.code ORDER BY id DESC LIMIT 1) as 'startdate',
(SELECT AVG(star) FROM reviews as t2 WHERE t1.id=t2.pid LIMIT 1) as 'star',
(SELECT salepercent FROM sale as t10 WHERE t10.code=t1.code ORDER BY id DESC LIMIT 1) as 'slperc',
(SELECT maxval FROM couplimit AS t11 WHERE t11.pid=t1.id LIMIT 1) as 'maxvall',
(SELECT cartsaletype FROM pcategories as t9 WHERE t9.id=t1.category LIMIT 1) as 'cartsaletype'
FROM products as t1
WHERE t1.id>0 AND t1.active=1 AND t1.instock>0 AND t1.brand<>1061 AND t1.price>='8' AND t1.price<='3300' AND FIND_IN_SET(category,'129,27,28,29,30,31,34,36,40,41,43,45,46,47,48,49,55,56,58,59,60,61,62,63,64,65,66,67,68,71,72,73,74,75,94,95,96,98,99,101,102,104,108,117,127,128,150,152,174,193,194') AND !(t1.brand=23 AND t1.category='147') AND !(t1.brand=32 AND t1.category='141') AND t1.brand<>29 GROUP BY t1.groupid ORDER BY t1.id DESC LIMIT 20 OFFSET 100