For Sales & Advice Call Us on 0121 501 1111

Search

Menu

Loading...

Your search for "triple 8 brainsaver" has 466 results

Filter By

Current Filters

  1. Has Identifier for GMC No Remove This Item
  2. Is for Gifting? No Remove This Item
Clear All

Category

  1. Skateboards150item
  2. Scooters211item
  3. Skates49item
  4. Bikes28item
  5. Longboards26item
  6. Protection5item
  7. Clothes1 item
  8. Sports1 item
  9. Water Sports3item
  10. Brands462item
  11. Bundles332item
  12. Clearance2item
  13. New Arrivals51item
  14. SkateHut Sale90item
  15. Footwear1 item
  16. Black Friday Deals12item

Bike Frame Size

  1. 18.5"1 item
  2. 19.25"2item
  3. 20.5"3item

Bike Type

  1. BMX27item

Bike Wheel Size

  1. 16"1 item
  2. 20"26item

Foldable?

  1. No8item

Height Adjustable?

  1. No8item

Kick Stand?

  1. No1 item

Light Brake?

  1. No1 item

Light Front?

  1. No1 item

Light Rear?

  1. No1 item

Material Secondary

  1. Aluminium1 item

Regenerative Breaking?

  1. No1 item

Sales Name

  1. Reduction1 item
  2. Clearance3item
  3. Price Match1 item
  4. Red Tier 22item
  5. B-Stock2item

Scooter Compression Type

  1. IHC3item

Shoe Size Adjustable

  1. Junior UK 8 - Junior UK 112item
  2. Junior UK 12 - UK 21 item
  3. UK 3 - UK 62item
  4. UK 6 - UK 82item
  5. Junior 12.5 - UK 21 item
  6. UK 2.5 - UK 51 item

Shoe Size Multi

  1. Size - Toddler UK 8 (EU 25.5)2item
  2. Size - Toddler UK 8.5 (EU 26)2item
  3. Size - Toddler UK 9 (EU 26.5)2item
  4. Size - Toddler UK 9.5 (EU 27)2item
  5. Size - Junior UK 10 (EU 27.5)2item
  6. Size - Junior UK 10.5 (EU 28)2item
  7. Size - Junior UK 11 (EU 29)2item
  8. Size - Junior UK 12 (EU 30)1 item
  9. Size - Junior UK 12.5 (EU 31)2item
  10. Size - Junior UK 13 (EU 31.5)2item
  11. Size - Junior UK 13.5 (EU 32)2item
  12. Size - UK 1 (EU 33)2item
  13. Size - UK 1.5 (EU 33.5)2item
  14. Size - UK 2 (EU 34)2item
  15. Size - UK 2.5 (EU 34.5)1 item
  16. Size - UK 3 (EU 35)3item
  17. Size - UK 3.5 (EU 36)3item
  18. Size - UK 4 (EU 37)3item
  19. Size - UK 4.5 (EU 37.5)3item
  20. Size - UK 5 (EU 38)3item
  21. Size - UK 5.5 (EU 38.5)2item
  22. Size - UK 6 (EU 39)4item
  23. Size - UK 6.5 (EU 39.5)2item
  24. Size - UK 7 (EU 41)2item
  25. Size - UK 7.5 (EU 41.5)2item
  26. Size - UK 8 (EU 42)2item

Variant Size

  1. Size - UK 3 (EU 35)1 item
  2. Size - UK 4 (EU 37)1 item
  3. Size - UK 5 (EU 38)1 item
  4. Size - UK 6 (EU 39)1 item
  5. Size - UK 7 (EU 41)1 item
  6. Size - UK 8 (EU 42)1 item
  7. Size - UK 9 (EU 43)1 item
  8. Size - UK 10 (EU 44)1 item
  9. Size - UK 11 (EU 46)1 item
  10. Size - UK 13 (EU 48)1 item
  11. S/M3item
  12. 22.25" x 6.5"1 item
  13. 23.25" x 6.5"1 item
  14. 5.8"1 item
  15. 5.2"1 item

Skateboard Type

  1. Cruiser3item
  2. Longboard8item
  3. Stunt13item

Variant Width

  1. 130mm1 item
  2. 4.3"2item
  3. 4.5"24item
  4. 4.72"6item
  5. 4.8"3item
  6. 5"4item
  7. 5.1"1 item
  8. 5.2"1 item
  9. 5.25"1 item
  10. 5.5"8item
  11. 5.8"1 item
  12. 6"6item
  13. 6.25"1 item
  14. 6.5"3item
  15. 8"5item
  16. 8.06"1 item
  17. 8.13"2item
  18. 8.25"2item
  19. 8.375"2item
  20. 8.38"1 item
  21. 8.4"1 item
  22. 8.5"5item
  23. 8.75"1 item
  24. 8.8"1 item

Channel Filters

  1. Allowed331item
  2. Excluded124item

Stock At Supplier

  1. Yes47item
  2. No416item

Cross Sell Type

  1. Colour147item
  2. Size11item
  3. Width1 item

Reporting Status

  1. Live453item
  2. Discontinued1 item
  3. Pending1 item

In Magento

  1. Yes70item
  2. No402item

Use In Google Feed

  1. Yes452item
  2. No60item

B-Stock

  1. Yes2item
  2. No464item

B-Stock Condition

  1. [Box Damage]2item

Own Brand?

  1. Yes3item
  2. No463item

Channels Ready

  1. Yes428item
  2. No39item

Longboard Wheel Variants

  1. Not Needed4item

Purchaser

  1. Tony10item
  2. Rob12item

Country Of Origin

  1. China76item

Google Feed Margin Cat

  1. z14item
  2. z28item
  3. z39item
  4. other49item

Skateboard Wheel Base

  1. 14"9item
  2. 14.25"2item
  3. 14.38"2item

Skateboard Deck Shape

  1. Classic Popsicle13item

Skateboard Griptape

  1. Applied26item
  2. Not Included95item

Skateboard Length

  1. 31"3item
  2. 31.5"3item
  3. 31.53"1 item
  4. 31.8"1 item
  5. 31.82"1 item
  6. 31.9"2item
  7. 32"6item
  8. 32.2"1 item

Skateboard Deck Concave

  1. Medium13item

Skateboard Deck Construction

  1. 7-Ply13item

Order In Active

  1. Yes4item
  2. No313item

Order In Active Shipping Group

  1. Order in - 5 day leadtime18item

Order In Inactive Shipping Group

  1. Full size longboards1 item

Order In Product

  1. Yes47item
  2. No382item

Skateboard Riding Use

  1. Street13item

Export

  1. No315item

Export Common

  1. No315item

Supplier Name

  1. 6030 Sports1 item
  2. Barts3item
  3. Black Peak Trading1 item
  4. Centrano143item
  5. Core14item
  6. Form43item
  7. Greenover1 item
  8. HLC1 item
  9. Hotline UK1 item
  10. Ison2item
  11. J&R62item
  12. Keen4item
  13. LG Sports Distribution21item
  14. Nineteen766item
  15. Onecall17item
  16. Parklife Innovations Ltd1 item
  17. Rock Solid14item
  18. Rolling Thunder14item
  19. Shiner21item
  20. Skatehut3item
  21. Stateside35item
  22. TKC2item
  23. Upgrade2item
  24. USG19item
  25. Traffic-uk5item
  26. Kaltik6item
  27. OG Distribution1 item
  28. Crocs Europe BV1 item
  29. RI Distribution7item

Best Suited to

  1. Park39item
  2. Street25item
  3. Hybrid31item

Scooter Type

  1. Adult/Commuter Scooter4item
  2. Kids Scooter11item
  3. Stunt Scooter74item
  4. Cruiser Scooter4item

Skateboard Deck Randomiser

  1. No92item

Truck Bolt Length

  1. 7/8"3item
  2. 1"2item

Skateboard Height Range

  1. 4' 2" - 5' 2"1 item
  2. 5' 2" and over28item

Skateboard Shoe Size Range

  1. UK 1 - UK 51 item
  2. UK 5 - UK 85item
  3. UK 8 - UK 102item
  4. UK 10 - UK 128item
  5. UK 11 - UK 1211item
  6. UK 12 and over2item

Scooter Bar Height

  1. Adjustable11item
  2. 500mm3item
  3. 550mm5item
  4. 570mm5item
  5. 584mm6item
  6. 585mm4item
  7. 609mm6item
  8. 620mm12item
  9. 635mm8item
  10. 650mm5item
  11. 660mm4item
  12. 700mm1 item
  13. 490mm2item

Scooter Height

  1. 750mm4item
  2. 760mm2item
  3. 770mm1 item
  4. 780mm2item
  5. 800mm2item
  6. 810mm2item
  7. 815mm9item
  8. 830mm5item
  9. 840mm4item
  10. 850mm3item
  11. 855mm4item
  12. 865mm6item
  13. 870mm7item
  14. 880mm2item
  15. 895mm1 item
  16. 900mm7item
  17. 920mm2item
  18. 940mm1 item
  19. 945mm2item
  20. 950mm4item
  21. 965mm2item
  22. 1000mm9item
  23. 1015mm1 item

Is Configurable Product

  1. Yes2item

Product Label Text

  1. Free Grip Tape69item
  2. 10% Off9item
  3. 40% Off1 item

Longboard Shape

  1. Cruiser4item
  2. Drop Through5item
  3. Pintail4item
  4. Symmetrical3item

Skill Level

  1. Beginner18item
  2. Intermediate61item
  3. Pro12item

Product Type Basic

  1. Bike Repair Kits1 item
  2. BMX Completes27item
  3. T-Shirts1 item
  4. Ramps2item
  5. Ice Hockey - Skates1 item
  6. Inline Skates - Adjustable2item
  7. Inline Skates - Aggressive2item
  8. Inline Skate Frames3item
  9. Inline Skates - Freerides1 item
  10. Inline Skates - Rollerblades16item
  11. Longboard Completes13item
  12. Cruisers3item
  13. Longboard Decks1 item
  14. Longboard Truck Bolts1 item
  15. Longboard Trucks3item
  16. Knee Pads2item
  17. Pad Sets3item
  18. Roller Skates - Adjustable3item
  19. Skate Bearings1 item
  20. Roller Skates11item
  21. Jam Plugs7item
  22. Skate Plates1 item
  23. Skate Tools1 item
  24. Scooter Collar Clamps4item
  25. Scooters - Commuter5item
  26. Scooter Compression Kits8item
  27. Scooter Decks90item
  28. Scooters - Folding2item
  29. Scooter Headsets21item
  30. Scooters - Stunt Scooters75item
  31. Scooters - Three Wheel4item
  32. Skateboard Bearings5item
  33. Skateboard - Completes14item
  34. Skateboard Decks94item
  35. Skateboard Grip Tape9item
  36. Skateboard Truck Bolts7item
  37. Skateboard Trucks3item
  38. Undercarriage Kits1 item
  39. Skateboard Wax1 item
  40. Football Goals1 item
  41. Bikini Bottoms1 item
  42. Bikini Tops1 item
  43. Swim One Pieces1 item
  44. Crocs1 item

Is Simple Product

  1. Yes410item
  2. No59item

Department

  1. Bikes28item
  2. Clothes/Accessories1 item
  3. Footwear1 item
  4. General Hardware2item
  5. Ice Skates1 item
  6. Inline Skates25item
  7. Longboards21item
  8. Protection5item
  9. Roller Derby1 item
  10. Roller Skates22item
  11. Scooters207item
  12. Skateboards133item
  13. Sports and Outdoor1 item
  14. Water3item

Price

  1. £0.00 - £24.9962item
  2. £25.00 - £49.9953item
  3. £50.00 - £74.99108item
  4. £75.00 - £99.9966item
  5. £100.00 - £124.9925item
  6. £125.00 - £149.9917item
  7. £150.00 - £174.9930item
  8. £175.00 - £199.9933item
  9. £200.00 - £224.997item
  10. £225.00 and above65item

Brand Name

  1. Addict Scootering7item
  2. Anti Hero3item
  3. Apex Pro Scooters17item
  4. Barts3item
  5. BazookaGoal1 item
  6. Blunt Envy13item
  7. CCM1 item
  8. Chocolate16item
  9. Chubby Wheels1 item
  10. Core14item
  11. Crocs1 item
  12. District Scooters1 item
  13. DMR2item
  14. Eastern Bikes19item
  15. Element7item
  16. Enjoi2item
  17. Ethic10item
  18. Flip12item
  19. Fracture3item
  20. Girl4item
  21. Haro1 item
  22. Hydroponic6item
  23. Independent1 item
  24. JD Bug3item
  25. K21 item
  26. Kaltik6item
  27. Loaded7item
  28. Lucky Scooters8item
  29. Madrid Longboards1 item
  30. Meow2item
  31. MGP (Madd Gear Pro)29item
  32. Mindless5item
  33. Native9item
  34. North Scooters8item
  35. Ocean Pacific2item
  36. Paris Trucks Co3item
  37. Passport2item
  38. Polar1 item
  39. Powell Peralta9item
  40. Powerdyne1 item
  41. Primitive2item
  42. Proto6item
  43. Rad15item
  44. Radio2item
  45. RAM Longboards5item
  46. Rampage6item
  47. REKD3item
  48. Riedell3item
  49. Rio Roller11item
  50. Roces4item
  51. Rookie2item
  52. Root Industries14item
  53. SEBA4item
  54. SFR5item
  55. Sk8 Mafia1 item
  56. SkateHut3item
  57. Slamm12item
  58. Sour Skateboards4item
  59. Striker28item
  60. Thank You1 item
  61. The Heart Supply6item
  62. Tilt Scooters14item
  63. Tony Hawk Signature Series1 item
  64. Toy Machine2item
  65. Venture2item
  66. Vital4item
  67. WeThePeople3item
  68. Zero22item
  69. Zoo York2item
  70. Unity1 item
  71. Trynyty1 item
  72. FR Skates6item
  73. Luminous Skates3item
  74. Cream3item
  75. Sketti Butta1 item
  76. Longway17item
  77. Opera1 item
  78. Jacuzzi Unlimited1 item
  79. Push1 item
  80. G-Tool1 item
  81. Quantum1 item

Product Type

  1. Bikes > Accessories > Repair Kits1 item
  2. Bikes > BMX Completes27item
  3. Clothes/Accessories > T-Shirts1 item
  4. General Hardware > Ramps2item
  5. Ice Hockey > Ice Hockey Skates1 item
  6. Inline Skates > Adjustable Roller Blades2item
  7. Inline Skates > Aggressive Skates2item
  8. Inline Skates > Frames3item
  9. Inline Skates > Roller Blades16item
  10. Longboards > Completes13item
  11. Longboards > Cruisers3item
  12. Longboards > Decks1 item
  13. Longboards > Truck Bolts1 item
  14. Longboards > Trucks3item
  15. Protection > Knee Pads2item
  16. Protection > Pad Sets3item
  17. Roller Derby > Roller Derby Skates1 item
  18. Roller Skates > Adjustable Skates3item
  19. Roller Skates > Bearings1 item
  20. Roller Skates > Completes11item
  21. Roller Skates > Jam Plugs7item
  22. Roller Skates > Plates1 item
  23. Roller Skates > Tools1 item
  24. Scooters > Collar Clamps4item
  25. Scooters > Commuter Completes5item
  26. Scooters > Compression Kits8item
  27. Scooters > Decks90item
  28. Scooters > Folding Completes2item
  29. Scooters > Headsets21item
  30. Scooters > Three Wheeled Completes4item
  31. Skateboards > Bearings5item
  32. Skateboards > Completes14item
  33. Skateboards > Decks94item
  34. Skateboards > Grip Tape9item
  35. Skateboards > Truck Bolts7item
  36. Skateboards > Trucks3item
  37. Skateboards > Undercarriage Kits1 item
  38. Skateboards > Wax1 item
  39. Sports and Outdoor > Football > Goals1 item
  40. Scooters > Stunt Completes75item
  41. Water > Swimming > Swimwear > One Pieces1 item
  42. Water > Swimming > Swimwear > Bikini Bottoms1 item
  43. Water > Swimming > Swimwear > Bikini Tops1 item
  44. Footwear > Crocs1 item
  45. Inline Skates > Freeride Completes1 item

Sport

  1. Football1 item

Skateboard Age Range

  1. 8 to 131 item
  2. 13 and over29item

Age

  1. 5 - 7 Years1 item
  2. 9+ Years26item

Skateboard Deck Width Range

  1. 8.126" - 8.25"1 item
  2. 8.26" - 8.50"1 item
  3. 7.25" - 7.49"1 item
  4. 7.50" - 7.99"1 item
  5. 8.00 - 8.124"32item
  6. 8.125" - 8.24"6item
  7. 8.25" - 8.49"28item
  8. 8.50" - 8.79"25item
  9. 8.80" - 11"2item

Main Colour

  1. Black153item
  2. Blue42item
  3. Bronze4item
  4. Brown6item
  5. Burgundy1 item
  6. Camo1 item
  7. Clear1 item
  8. Cream1 item
  9. Gold17item
  10. Green20item
  11. Grey7item
  12. Multi12item
  13. Natural10item
  14. Navy4item
  15. Neochrome15item
  16. Orange16item
  17. Pink10item
  18. Purple10item
  19. Raw19item
  20. Red25item
  21. Silver15item
  22. Tan1 item
  23. Teal16item
  24. Turquoise3item
  25. White33item
  26. Yellow7item

Deck Type

  1. Integrated103item

Scooter Bar Compatibility

  1. Fits Oversized Bars Fits Standard Bars8item
  2. Fits Oversized Bars4item

Scooter Bar Type

  1. Aluminium (Standard)3item

Scooter Clamp Type

  1. Collar Clamp4item
  2. SCS Compression8item

Scooter Headset Type

  1. Integrated24item

Scooter Wheel Size

  1. 100mm1 item
  2. 120mm1 item
  3. 200mm5item
  4. n/a4item

Skateboard Deck Width

  1. 7.25"1 item
  2. 7.75"1 item
  3. 8"32item
  4. 8.06"2item
  5. 8.125"4item
  6. 8.13"3item
  7. 8.25"16item
  8. 8.375"9item
  9. 8.38"2item
  10. 8.4"3item
  11. 8.45"1 item
  12. 8.5"24item
  13. 8.75"2item
  14. 8.8"1 item
  15. 8.88"1 item

Shoe Size

  1. Size - Junior UK 13 (EU 31.5)1 item
  2. Size - UK 1 (EU 33)1 item
  3. Size - UK 2 (EU 34)2item
  4. Size - UK 3 (EU 35)8item
  5. Size - UK 3.5 (EU 36)4item
  6. Size - UK 4 (EU 37)12item
  7. Size - UK 5 (EU 38)16item
  8. Size - UK 6 (EU 39)20item
  9. Size - UK 6.5 (EU 39.5)9item
  10. Size - UK 7 (EU 41)25item
  11. Size - UK 7.5 (EU 41.5)1 item
  12. Size - UK 8 (EU 42)32item
  13. Size - UK 8.5 (EU 42.5)1 item
  14. Size - UK 9 (EU 43)17item
  15. Size - UK 9.5 (EU 43.5)12item
  16. Size - UK 10 (EU 44)12item
  17. Size - UK 10.5 (EU 45)1 item
  18. Size - UK 11 (EU 46)11item
  19. Size - UK 12 (EU 47)10item
  20. Size - UK 13 (EU 48)2item
  21. Size - 31 item
  22. Size - 41 item
  23. Size - 61 item
  24. Size - 71 item
  25. Size - 81 item
  26. Size - 91 item
  27. Size - 101 item
  28. Size - 111 item

Pad Size

  1. Extra Extra Small2item
  2. Extra Small3item
  3. Small5item
  4. Medium2item
  5. Large2item
  6. Extra Large1 item

Skateboard Truck Height

  1. Low - Wheels < 53mm1 item
  2. Mid - Wheels 53-56mm1 item
  3. High - Wheels > 56mm2item

Size

  1. Kids M (7-8 Years)1 item
  2. Kids L (9-11 Years)1 item
  3. Womens Size 83item
  4. Womens Size 103item
  5. Womens Size 123item
  6. Womens Size 143item
  7. Womens Size 163item

Scooter Deck Type

  1. Integrated 100-110mm42item
  2. Integrated 120mm47item
  3. Integrated 125mm1 item

Skateboard Deck Width Suitability

  1. 7.9"1 item
  2. 8"1 item
  3. 8.1"1 item
  4. 8.4"1 item
  5. 8.5"1 item
  6. 8.6"1 item
  7. 9"1 item
  8. 9.12"1 item
  9. 9.5"1 item
  10. 9.62"1 item
  11. 9.75"1 item
  12. 10"1 item

Skateboard Truck Hanger Width

  1. 169mm1 item
  2. 5.0"1 item
  3. 5.2"1 item
  4. 5.8"1 item

Gender

  1. Female7item
  2. Male4item
  3. Unisex31item

Skateboard Griptape Deck Width

  1. 9"4item

Vegan

  1. No466item

Bike Size

  1. Small/Medium21item
  2. Medium6item

Bundle Starting Price

  1. £25.00 - £49.993item
  2. £50.00 - £74.998item
  3. £100.00 and above1 item

Age

  1. 6 to 849item
  2. 8 to 1251item
  3. 10 +48item

Scooter Height

  1. 68cm - 85cm31item
  2. 80cm - 90cm51item
  3. 90cm and over23item
  4. 69cm - 89cm49item

Scooter Brake Type

  1. Flex Fender3item

Longboard Length

  1. 28"3item
  2. 32"1 item
  3. 33"4item
  4. 38"3item
  5. 40"1 item
  6. 42"1 item
  7. 44"2item
  8. 39.5"1 item

Bar Height Range

  1. 700mm and over1 item

Skate Type Boot

  1. Hard Boot16item
  2. Soft Boot19item

Skateboard Size

  1. Mini (under 31")1 item
  2. Full Size12item

Deck Length

  1. 19"5item
  2. 19.5"26item
  3. 20"10item
  4. 20.5"7item
  5. 21"11item
  6. 22"17item
  7. 22.5"2item
  8. 23"7item
  9. 19.75"13item
  10. 21.25"3item
  11. 17.5"2item
  12. 19.3"13item
  13. 17"2item
  14. 18.5"9item
  15. 18"7item
  16. 22.2"2item

Deck Width

  1. 4"2item
  2. 4.3"5item
  3. 4.5"39item
  4. 4.7"2item
  5. 4.72"6item
  6. 4.75"2item
  7. 4.8"3item
  8. 5.1"5item
  9. 5.2"1 item
  10. 5.25"6item
  11. 5.5"21item
  12. 5.75"1 item
  13. 5.8"1 item
  14. 5.9"1 item
  15. 6"18item
  16. 6.25"2item
  17. 6.5"3item

Skate Suitability

  1. Indoor2item
  2. Outdoor20item
  3. Indoor/Outdoor15item

Scooter Bar Shape

  1. T - Shape22item
  2. Y - Shape22item

Age Group

  1. Adult45item
  2. Kids11item

Skate Plate Construction

  1. Plastic9item
  2. Aluminium6item

Scooter Rider Height Range

  1. 125cm - 150cm49item
  2. 150cm - 170cm51item
  3. 170cm and over24item

Skateboard Wheel Size

  1. 52mm10item
  2. 53mm3item
  3. 66mm5item
  4. 70mm1 item

Skate Closure System

  1. Lacing31item
  2. Velcro10item
  3. Buckle24item

Abec Rating

  1. ABEC 514item
  2. ABEC 721item
  3. ABEC 96item
  4. ABEC 111 item
  5. Skate Rated2item
  6. Unrated10item

Size Adjustable?

  1. Yes5item
  2. No32item

Durometer Rating

  1. 80a3item
  2. 82a5item
  3. 84a5item
  4. 85a15item
  5. 88a2item
  6. 95a7item
  7. 97a1 item
  8. 98a1 item
  9. 99a6item
  10. N/A3item

Adjustable Stopper?

  1. Yes7item
  2. No10item

Light-up Wheels?

  1. No17item

Skate Wheel Size

  1. N/A1 item
  2. 54mm7item
  3. 58mm3item
  4. 60mm3item
  5. 62mm4item
  6. 64mm2item
  7. 70mm2item
  8. 80mm13item
  9. 84mm5item
  10. 110mm1 item

Material Primary

  1. Aluminium7item
  2. Canvas3item
  3. Cotton1 item
  4. Faux Leather1 item
  5. Leather4item
  6. Maple13item
  7. Mesh1 item
  8. Plastic16item
  9. Synthetic1 item
  10. Vinyl1 item
  11. PU4item
  12. Synthetic Leather5item

Skate Wheel Width

  1. 31mm1 item
  2. 32mm10item
  3. 33mm1 item
  4. 35mm1 item
  5. 36mm1 item
  6. 43mm1 item

Builder Part

  1. Yes210item
  2. No2item
SELECT `e`.*, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, IFNULL(review_summary.reviews_count, 0) AS `reviews_count`, IFNULL(review_summary.rating_summary, 0) AS `rating_summary`, `stock_status_index`.`stock_status` AS `is_salable` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.customer_group_id = 0 AND price_index.website_id = '1' INNER JOIN `catalog_product_website` AS `product_website` ON product_website.product_id = e.entity_id AND product_website.website_id = 1 LEFT JOIN `review_entity_summary` AS `review_summary` ON e.entity_id = review_summary.entity_pk_value AND review_summary.store_id = 1 AND review_summary.entity_type = (SELECT `review_entity`.`entity_id` FROM `review_entity` WHERE (entity_code = 'product')) INNER JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id WHERE (stock_status_index.stock_status = 1) AND (e.entity_id IN (408460, 408472, 407179, 371499, 371502, 371508, 371511, 409047, 407734, 409272, 392260, 407650, 409504, 408073, 409517, 395777, 401863, 392272, 407746, 385880, 409031, 408367, 409283, 410083)) ORDER BY FIELD(e.entity_id,408460,408472,407179,371499,371502,371508,371511,409047,407734,409272,392260,407650,409504,408073,409517,395777,401863,392272,407746,385880,409031,408367,409283,410083)

Showing 24 out of 466

Page