For Sales & Advice Call Us on 0121 501 1111

Search

Menu

Loading...

Your search for "striker gravis pro" has 683 results

Filter By

Current Filters

  1. Reporting Status Live Remove This Item
  2. Order In Product No Remove This Item
Clear All

Category

  1. Skateboards71item
  2. Scooters531item
  3. Skates17item
  4. Bikes14item
  5. Longboards4item
  6. Protection32item
  7. Shoes5item
  8. Clothes1 item
  9. Accessories23item
  10. Sports3item
  11. Outdoor2item
  12. Water Sports5item
  13. More26item
  14. Brands667item
  15. Bundles574item
  16. Clearance8item
  17. New Arrivals42item
  18. SkateHut Sale237item
  19. Footwear5item
  20. Black Friday Deals1 item

Bike Frame Size

  1. 21"1 item

Bike Type

  1. BMX3item
  2. BMX1 item

Bike Wheel Size

  1. 20"4item

Clothing Fit

  1. Regular1 item

Sleeve Length

  1. Short Sleeve1 item

Foldable?

  1. No27item

Height Adjustable?

  1. No27item

Helmet Certification

  1. EN1078 Certified9item

Kick Stand?

  1. No2item

Light Brake?

  1. No2item

Light Front?

  1. No2item

Light Rear?

  1. No2item

Material Secondary

  1. Aluminium1 item

Regenerative Breaking?

  1. No2item

Sales Name

  1. Reduction5item
  2. Clearance42item
  3. Exclusion1 item
  4. Price Match53item
  5. Red Tier 132item
  6. Red Tier 228item
  7. B-Stock8item

Scooter Compression Type

  1. IHC33item
  2. HIC2item
  3. SCS17item

Variant Size

  1. Large2item
  2. Extra Small4item
  3. Small4item
  4. Medium3item
  5. Large2item
  6. Extra Large4item
  7. Size - UK 3.5 (EU 36)1 item
  8. Size - UK 4.5 (EU 37.5)1 item
  9. Size - UK 7.5 (EU 41.5)1 item
  10. 21"3item
  11. 22"1 item
  12. 620mm1 item
  13. 670mm1 item
  14. 19.5"2item
  15. 110mm1 item
  16. 170mm12item
  17. 60ft1 item
  18. 51cm1 item
  19. 49cm1 item
  20. Size 101 item
  21. Size 81 item
  22. Size 71 item
  23. Size 41 item
  24. Size 51 item
  25. S/M1 item

Skateboard Type

  1. Stunt2item
  2. Stunt13item

Variant Width

  1. 129mm6item
  2. 139mm6item
  3. 149mm1 item
  4. 4.5"26item
  5. 4.72"7item
  6. 4.8"2item
  7. 5"1 item
  8. 5.25"6item
  9. 5.5"8item
  10. 5.8"1 item
  11. 6"12item
  12. 6.25"1 item
  13. 6.5"3item
  14. 7"2item
  15. 8"1 item
  16. 8.13"1 item
  17. 8.25"1 item

Channel Filters

  1. Allowed602item
  2. Excluded81item

Helmet Size Range

  1. 48 - 52cm1 item
  2. 48 - 54cm7item
  3. 52 - 56cm1 item
  4. 55 - 58cm3item
  5. 56 - 60cm1 item
  6. 59 - 61cm6item

Helmet Impact Type

  1. Single Impact9item

Stock At Supplier

  1. Yes3item
  2. No623item

Cross Sell Type

  1. Colour378item
  2. Size15item
  3. Width2item

In Magento

  1. Yes409item
  2. No293item

Use In Google Feed

  1. Yes675item
  2. No44item

B-Stock

  1. Yes8item
  2. No675item

B-Stock Condition

  1. [Box Damage]4item
  2. [Cosmetic Damage]2item
  3. [Pre-Owned]2item

Own Brand?

  1. Yes4item
  2. No677item

Channels Ready

  1. Yes603item
  2. No80item

Purchaser

  1. Billy30item
  2. Phil12item
  3. Ricky14item
  4. Tony143item
  5. SWAG30item
  6. Brucey9item
  7. Own Brand4item
  8. Ross5item
  9. Rob3item

Country Of Origin

  1. China101item

Google Feed Margin Cat

  1. z159item
  2. z281item
  3. z3176item
  4. other92item

Skateboard Wheel Base

  1. 13"3item
  2. 13.8"3item
  3. 14"9item

Skateboard Deck Shape

  1. Classic Popsicle15item

Skateboard Griptape

  1. Applied15item
  2. Not Included26item

Skateboard Length

  1. 29"3item
  2. 31"3item
  3. 31.2"1 item
  4. 31.5"2item
  5. 31.875"1 item
  6. 32"5item

Skateboard Deck Concave

  1. Medium15item

Skateboard Deck Construction

  1. 7-Ply15item

Order In Active

  1. Yes1 item
  2. No569item

Order In Active Shipping Group

  1. Order in - 5 day leadtime2item

Skateboard Riding Use

  1. Street15item
  2. Park14item

Export

  1. No573item

Has Identifier for GMC

  1. Yes315item
  2. No368item

Export Common

  1. No572item

Supplier Name

  1. 6030 Sports1 item
  2. Centrano229item
  3. Certified Collective 1 item
  4. Core85item
  5. Drone / EXS13item
  6. Form14item
  7. Greenover2item
  8. Ison2item
  9. J&R132item
  10. Keen2item
  11. LG Sports Distribution37item
  12. Madison Distribution8item
  13. New Day Fury4item
  14. Nineteen763item
  15. Onecall45item
  16. Rock Solid9item
  17. Rolling Thunder5item
  18. Seventies2item
  19. Shiner / J&R4item
  20. Shiner16item
  21. Skatehut4item
  22. Sneaker Sheets5item
  23. Stateside34item
  24. TKC14item
  25. Wheels2item
  26. Yvolve1 item
  27. Reydon Sports1 item
  28. Traffic-uk1 item
  29. Kaltik1 item
  30. RI Distribution5item

Best Suited to

  1. Park77item
  2. Street32item
  3. Hybrid44item

Scooter Type

  1. Adult/Commuter Scooter11item
  2. Fliker Scooter1 item
  3. Kids Scooter6item
  4. Light Up Wheel4item
  5. Stunt Scooter99item
  6. Cruiser Scooter4item
  7. Trampoline Scooter8item
  8. Snow Scooter1 item

Skateboard Deck Randomiser

  1. No41item

Board Length

  1. 36"1 item
  2. 37"4item

Is for Gifting?

  1. Yes94item
  2. No589item

Is Gift Tier

  1. High89item

Skateboard Height Range

  1. 3' 7" - 4' 7"3item
  2. 4' 2" - 5' 2"6item
  3. 5' 2" and over13item

Skateboard Shoe Size Range

  1. J 12 - UK 33item
  2. UK 1 - UK 56item
  3. UK 5 - UK 87item
  4. UK 8 - UK 102item
  5. UK 10 - UK 121 item
  6. UK 11 - UK 123item

Scooter Bar Height

  1. Adjustable23item
  2. 500mm1 item
  3. 520mm2item
  4. 533mm12item
  5. 550mm2item
  6. 558mm2item
  7. 560mm10item
  8. 570mm1 item
  9. 575mm3item
  10. 584mm12item
  11. 600mm3item
  12. 609mm6item
  13. 610mm4item
  14. 620mm25item
  15. 635mm9item
  16. 650mm8item
  17. 660mm11item
  18. 670mm4item
  19. 680mm2item
  20. 700mm2item
  21. 710mm5item
  22. 720mm5item
  23. 725mm1 item
  24. 845mm2item
  25. 910mm1 item
  26. 490mm2item

Scooter Height

  1. 680mm1 item
  2. 692mm4item
  3. 700mm1 item
  4. 710mm4item
  5. 742mm2item
  6. 750mm4item
  7. 760mm3item
  8. 770mm2item
  9. 780mm6item
  10. 800mm2item
  11. 805mm2item
  12. 810mm18item
  13. 815mm5item
  14. 820mm2item
  15. 825mm3item
  16. 830mm5item
  17. 840mm4item
  18. 850mm4item
  19. 855mm4item
  20. 865mm7item
  21. 870mm9item
  22. 880mm2item
  23. 890mm5item
  24. 895mm2item
  25. 900mm3item
  26. 910mm1 item
  27. 915mm2item
  28. 920mm2item
  29. 927mm3item
  30. 940mm1 item
  31. 945mm1 item
  32. 960mm2item
  33. 1000mm5item
  34. 1150mm4item

Is Configurable Product

  1. Yes27item
  2. No3item

Product Label Text

  1. Free Grip Tape21item
  2. 30% Off4item
  3. 50% Off3item
  4. 45% Off1 item

Longboard Shape

  1. Cruiser2item

Skill Level

  1. Beginner33item
  2. Intermediate75item
  3. Pro6item

Clothing Style Tops & Shirts

  1. T-Shirt1 item

Product Type Basic

  1. Balance Bikes2item
  2. BMX Completes4item
  3. T-Shirts1 item
  4. Insoles5item
  5. Ice Skates - Hockey2item
  6. Inline Skate Frames1 item
  7. Inline Skates - Rollerblades4item
  8. Inline Skate Wheels2item
  9. Cruisers2item
  10. Longboard Grip Tape1 item
  11. Elbow Pads5item
  12. Helmets10item
  13. Knee Pads10item
  14. Knee Caps1 item
  15. Pad Sets6item
  16. Wrist Guards2item
  17. Roller Derby Skate Boots1 item
  18. Skate Plates5item
  19. Scooter Accessories1 item
  20. Scooter Bearings4item
  21. Scooter Brakes1 item
  22. Scooter Collar Clamps27item
  23. Scooters - Commuter12item
  24. Scooter Compression Kits15item
  25. Scooter Decks109item
  26. Scooters - Fliker1 item
  27. Scooters - Folding5item
  28. Scooter Forks39item
  29. Scooter Grip Tape12item
  30. Scooter Grips76item
  31. Scooter Bars53item
  32. Scooter Headsets3item
  33. Scooter Stands1 item
  34. Scooter Shims & Spacers1 item
  35. Scooters (Snow)1 item
  36. Scooters - Stunt Scooters99item
  37. Scooter Wheels64item
  38. Skateboard Bearings2item
  39. Skateboard - Completes15item
  40. Skateboard Decks26item
  41. Skateboard Grip Tape9item
  42. Skateboard Trucks13item
  43. Basketball Balls2item
  44. Dartboards1 item
  45. Finger Toys13item
  46. Flying Discs1 item
  47. Bodyboards5item
  48. Trampoline Scooters8item

Is Simple Product

  1. Yes642item
  2. No40item

Department

  1. Bikes6item
  2. Clothes/Accessories1 item
  3. Footwear5item
  4. Ice Skates2item
  5. Inline Skates7item
  6. Longboards3item
  7. Protection34item
  8. Roller Derby6item
  9. Scooters535item
  10. Skateboards65item
  11. Sports and Outdoor3item
  12. Toys10item
  13. Water5item

Price

  1. £0.00 - £24.99188item
  2. £25.00 - £49.99144item
  3. £50.00 - £74.9993item
  4. £75.00 - £99.9990item
  5. £100.00 - £124.9927item
  6. £125.00 - £149.9931item
  7. £150.00 - £174.9940item
  8. £175.00 - £199.9928item
  9. £200.00 - £224.998item
  10. £225.00 and above34item

Brand Name

  1. 187 Killer Pads4item
  2. Aerobie1 item
  3. Apex Pro Scooters34item
  4. Bauer2item
  5. Birdhouse1 item
  6. Blazer Pro10item
  7. Blunt Envy45item
  8. Chocolate7item
  9. Collective Bikes1 item
  10. Core85item
  11. Dial 9111 item
  12. Drone13item
  13. Enuff25item
  14. Ethic4item
  15. Flip3item
  16. Girl3item
  17. Gotcha4item
  18. Harsh Protective Gear1 item
  19. Indo3item
  20. Jessup1 item
  21. Kaltik1 item
  22. LMNADE2item
  23. Lucky Scooters12item
  24. Luigino1 item
  25. Meow2item
  26. MGP (Madd Gear Pro)126item
  27. Native17item
  28. North Scooters4item
  29. ODI8item
  30. Passport2item
  31. Polar1 item
  32. Powell Peralta9item
  33. Powerdyne5item
  34. Primitive1 item
  35. Pro-Tec5item
  36. Proto7item
  37. REKD3item
  38. River Wheels2item
  39. Root Industries40item
  40. Sacrifice2item
  41. SEBA1 item
  42. SFR3item
  43. SkateHut2item
  44. Slamm3item
  45. Sneaker Sheets5item
  46. Striker93item
  47. Supremacy6item
  48. Tech Deck9item
  49. The Heart Supply5item
  50. Tilt Scooters41item
  51. Toy Machine1 item
  52. WeThePeople1 item
  53. Wham-O1 item
  54. Y-Volution1 item
  55. Zero4item
  56. Trynyty4item
  57. Harrows1 item
  58. Shaq2item
  59. Tribal2item

Head Size Multi

  1. 48cm8item
  2. 49cm8item
  3. 50cm8item
  4. 50.8cm7item
  5. 51cm8item
  6. 52cm9item
  7. 53cm8item
  8. 54cm8item
  9. 55cm4item
  10. 56cm4item
  11. 57cm4item
  12. 58cm4item
  13. 59cm7item
  14. 60cm7item
  15. 61cm6item

Number Of Wheels

  1. 23item

Product Type

  1. Bikes > Balance Bikes2item
  2. Bikes > BMX Completes4item
  3. Clothes/Accessories > T-Shirts1 item
  4. Footwear > Insoles5item
  5. Ice Skates > Hockey Skates2item
  6. Inline Skates > Frames1 item
  7. Inline Skates > Roller Blades4item
  8. Inline Skates > Wheels2item
  9. Longboards > Cruisers2item
  10. Longboards > Grip Tape1 item
  11. Protection > Elbow Pads5item
  12. Protection > Helmets10item
  13. Protection > Knee Pads10item
  14. Protection > Knee Pads > Knee Caps1 item
  15. Protection > Pad Sets6item
  16. Protection > Wrist Guards2item
  17. Roller Derby > Roller Derby Skates - Boot Only1 item
  18. Roller Skates > Plates5item
  19. Scooters > Accessories1 item
  20. Scooters > Bearings4item
  21. Scooters > Brakes1 item
  22. Scooters > Collar Clamps27item
  23. Scooters > Commuter Completes12item
  24. Scooters > Compression Kits15item
  25. Scooters > Decks109item
  26. Scooters > Folding Completes5item
  27. Scooters > Forks39item
  28. Scooters > Grip Tape12item
  29. Scooters > Grips76item
  30. Scooters > Handle Bars53item
  31. Scooters > Headsets3item
  32. Scooters > Scooter Stands1 item
  33. Scooters > Shims & Spacers1 item
  34. Scooters > Three Wheeled Completes1 item
  35. Scooters > Trampoline Scooters8item
  36. Scooters > Wheels64item
  37. Skateboards > Bearings2item
  38. Skateboards > Completes15item
  39. Skateboards > Decks26item
  40. Skateboards > Grip Tape9item
  41. Skateboards > Trucks13item
  42. Sports and Outdoor > Basketball > Balls2item
  43. Toys > Finger Toys13item
  44. Water > Surfing > Bodyboards5item
  45. Toys > Throwing and Catching > Flying Discs1 item
  46. Scooters > Stunt Completes99item
  47. Scooters > Snow Scooters1 item
  48. Sports and Outdoor > Darts > Dartboards1 item

Sport

  1. Basketball2item
  2. Cycling2item
  3. Darts1 item

Skateboard Age Range

  1. 6 and under1 item
  2. 6 to 101 item
  3. 13 and over13item

Age

  1. 9+ Years4item

Head Size

  1. 45 - 50 cm8item
  2. 50 - 55 cm9item
  3. 55 - 60 cm7item
  4. 60 - 65 cm7item

Age Range

  1. 3 - 6 Years8item
  2. 6 - 12 Years9item
  3. Adults7item

Skateboard Deck Width Range

  1. 8.26" - 8.50"1 item
  2. 7.25" - 7.49"3item
  3. 7.50" - 7.99"8item
  4. 8.00 - 8.124"13item
  5. 8.125" - 8.24"2item
  6. 8.25" - 8.49"10item
  7. 8.50" - 8.79"11item

Grip Length

  1. 129mm2item
  2. 130mm1 item
  3. 135mm9item
  4. 150mm4item
  5. 155mm8item
  6. 160mm7item
  7. 163mm7item
  8. 170mm27item
  9. 173mm4item
  10. 180mm7item

Main Colour

  1. Black238item
  2. Blue56item
  3. Bronze4item
  4. Brown5item
  5. Burgundy1 item
  6. Camo1 item
  7. Clear4item
  8. Gold21item
  9. Green33item
  10. Grey9item
  11. Multi17item
  12. Natural7item
  13. Neochrome35item
  14. Orange14item
  15. Pink14item
  16. Purple17item
  17. Raw34item
  18. Red31item
  19. Silver50item
  20. Teal31item
  21. Turquoise2item
  22. White33item
  23. Yellow7item
  24. Gum3item

Deck Type

  1. Integrated77item

Scooter Bar Compatibility

  1. Fits Oversized Bars Fits Standard Bars29item
  2. Fits Oversized Bars11item
  3. Fits Standard Bars11item

Scooter Bar Type

  1. Aluminium (Standard)15item
  2. Oversized HIC18item
  3. No Slit SCS21item
  4. Standard IHC ICS Threaded8item

Scooter Clamp Type

  1. Collar Clamp20item
  2. Collar Clamp + Shim16item
  3. SCS Compression14item

Scooter Fork Type

  1. Fork For Small Wheels IHC13item
  2. Fork For Small Wheels SCS6item
  3. Fork For 120mm Wheels HIC5item
  4. Fork For 120mm Wheels IHC17item
  5. Fork For 120mm Wheels SCS7item
  6. Fork suitable for 125mm wheels, HIC2item
  7. Fork suitable for 125mm wheels, IHC2item
  8. Fork suitable for 125mm wheels, SCS1 item

Scooter Headset Type

  1. Standard 1-1/81 item
  2. Integrated15item

Scooter Wheel Size

  1. 100mm5item
  2. 110mm55item
  3. 120mm25item
  4. 125mm3item
  5. 140mm1 item
  6. 200mm9item
  7. n/a8item

Skateboard Deck Width

  1. 7.25"3item
  2. 7.75"8item
  3. 8"13item
  4. 8.125"1 item
  5. 8.13"1 item
  6. 8.25"7item
  7. 8.375"2item
  8. 8.4"2item
  9. 8.5"10item
  10. 8.75"1 item

Truck Width

  1. 129mm6item
  2. 139mm6item
  3. 149mm1 item

Shoe Size

  1. Size - UK 1 (EU 33)2item
  2. Size - UK 2 (EU 34)2item
  3. Size - UK 3 (EU 35)3item
  4. Size - UK 3.5 (EU 36)1 item
  5. Size - UK 4 (EU 37)4item
  6. Size - UK 4.5 (EU 37.5)1 item
  7. Size - UK 5 (EU 38)4item
  8. Size - UK 6 (EU 39)4item
  9. Size - UK 7 (EU 41)3item
  10. Size - UK 7.5 (EU 41.5)1 item
  11. Size - UK 8 (EU 42)5item
  12. Size - UK 9 (EU 43)3item
  13. Size - UK 9.5 (EU 43.5)1 item
  14. Size - UK 10 (EU 44)4item
  15. Size - UK 11 (EU 46)4item
  16. Size - UK 12 (EU 47)3item

Pad Size

  1. Youth Small1 item
  2. Youth Medium1 item
  3. Extra Small9item
  4. Small10item
  5. Medium9item
  6. Large14item
  7. Extra Large5item
  8. Junior (up To 8 Years)1 item
  9. One Size Fits Most2item

Skateboard Truck Height

  1. Low - Wheels < 53mm10item
  2. Mid - Wheels 53-56mm3item

Size

  1. Extra Large1 item

Scooter Deck Type

  1. Integrated 100-110mm56item
  2. Integrated 120mm59item
  3. Integrated 125mm5item

Head Size Single

  1. 48cm8item
  2. 52cm1 item
  3. 55cm3item
  4. 56cm1 item
  5. 59cm6item

Skateboard Deck Width Suitability

  1. 7.5"6item
  2. 7.6"6item
  3. 7.75"11item
  4. 7.8"5item
  5. 7.85"5item
  6. 7.88"5item
  7. 7.9"5item
  8. 8"5item
  9. 8.1"5item
  10. 8.12"5item
  11. 8.2"6item
  12. 8.25"7item
  13. 8.3"2item
  14. 8.38"2item
  15. 8.4"2item
  16. 8.5"2item
  17. 8.6"2item
  18. 8.62"2item
  19. 8.68"2item
  20. 8.7"2item
  21. 8.75"2item
  22. 7.875"5item
  23. 8.125"1 item

Skateboard Truck Hanger Width

  1. 129mm6item
  2. 139mm5item
  3. 149mm1 item
  4. 5.5"1 item

Gender

  1. Female5item
  2. Male2item
  3. Unisex10item

Vegan

  1. No680item

Bike Size

  1. Small/Medium2item

Age

  1. 4 to 613item
  2. 6 to 889item
  3. 8 to 1276item
  4. 10 +56item
  5. 5 +3item

Scooter Height

  1. 50cm - 75cm15item
  2. 68cm - 85cm77item
  3. 80cm - 90cm84item
  4. 90cm and over20item
  5. 69cm - 89cm76item

Scooter Brake Type

  1. Flex Fender8item
  2. Stubby3item

Longboard Length

  1. 22.5"2item

Bar Height Range

  1. 500mm - 599mm8item
  2. 600mm - 624mm12item
  3. 650mm - 674mm17item
  4. 675mm - 699mm2item
  5. 700mm and over14item

Bar Width Range

  1. 450mm - 549mm6item
  2. 550mm - 574mm5item
  3. 575mm - 599mm11item
  4. 600mm - 624mm23item
  5. 625mm and over6item

Helmet Type

  1. Skate Helmet8item
  2. Bike Helmet9item

Skate Type Boot

  1. Hard Boot1 item
  2. Soft Boot8item

Skateboard Size

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

Deck Length

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

Scooter Wheel Width

  1. 24mm63item
  2. 26mm1 item

Deck Width

  1. 4"5item
  2. 4.5"62item
  3. 4.72"7item
  4. 4.75"2item
  5. 4.8"10item
  6. 4.9"9item
  7. 5.1"4item
  8. 5.25"10item
  9. 5.5"24item
  10. 5.75"4item
  11. 5.8"1 item
  12. 5.9"1 item
  13. 6"17item
  14. 6.25"1 item
  15. 6.5"5item
  16. 5"2item

Skate Suitability

  1. Indoor5item
  2. Outdoor6item
  3. Indoor/Outdoor8item

Scooter Bar Shape

  1. T - Shape61item
  2. Y - Shape67item

Age Group

  1. Adult30item
  2. Kids7item

Skate Plate Construction

  1. Aluminium5item

Scooter Rider Height Range

  1. 90cm - 125cm18item
  2. 125cm - 150cm95item
  3. 150cm - 170cm81item
  4. 170cm and over21item

Skateboard Wheel Size

  1. 52mm3item
  2. 53mm4item
  3. 54mm8item
  4. 62mm2item

Skate Closure System

  1. Lacing9item
  2. Velcro4item
  3. Buckle4item

Abec Rating

  1. ABEC 718item
  2. ABEC 913item
  3. ABEC 113item
  4. Skate Rated1 item
  5. Unrated6item

Size Adjustable?

  1. No16item

Durometer Rating

  1. 100a12item
  2. 55d4item
  3. 84a1 item
  4. 85a4item
  5. 99a3item

Adjustable Stopper?

  1. Yes5item
  2. No8item

Light-up Wheels?

  1. No13item

Skate Wheel Size

  1. N/A5item
  2. 60mm2item
  3. 80mm3item
  4. 84mm3item

Material Primary

  1. Aluminium37item
  2. Canadian Maple5item
  3. Canvas3item
  4. Cotton1 item
  5. Crmo Steel14item
  6. Hi-Ten Steel1 item
  7. Maple10item
  8. Plastic1 item
  9. Titanium6item

Skate Wheel Width

  1. N/A5item

Builder Part

  1. Yes421item
  2. No14item
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 (160003, 408097, 407506, 407509, 407572, 407575, 408136, 408139, 407578, 408112, 408124, 408115, 408127, 408118, 408130, 408133, 408658, 152972, 152973, 250923, 250924, 101877, 101889, 102169)) ORDER BY FIELD(e.entity_id,160003,408097,407506,407509,407572,407575,408136,408139,407578,408112,408124,408115,408127,408118,408130,408133,408658,152972,152973,250923,250924,101877,101889,102169)

Showing 24 out of 683

Page