73 items found

per page
SELECT `e`.*, `cat_index`.`position` AS `cat_index_position`, `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`, IF(at_price_desc.value_id > 0, at_price_desc.value, at_price_desc_default.value) AS `price_desc` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_category_product_index_store1` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id=18257 INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0 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 `search_tmp_6037fc192df527_25877330` AS `search_result` ON e.entity_id = search_result.entity_id LEFT JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id AND stock_status_index.website_id = 0 AND stock_status_index.stock_id = 1 LEFT JOIN `catalog_product_entity_decimal` AS `at_price_desc_default` ON (`at_price_desc_default`.`row_id` = `e`.`row_id`) AND (`at_price_desc_default`.`attribute_id` = '887') AND `at_price_desc_default`.`store_id` = 0 LEFT JOIN `catalog_product_entity_decimal` AS `at_price_desc` ON (`at_price_desc`.`row_id` = `e`.`row_id`) AND (`at_price_desc`.`attribute_id` = '887') AND (`at_price_desc`.`store_id` = 1) WHERE (e.created_in '1614211201') ORDER BY `price_index`.`min_price` desc, `price_desc` ASC, `price_index`.`min_price` desc LIMIT 36
  1. Bullet 2.0 Lens

    Lazer Bullet 2.0 Lens

    Out of stock
  2. Urbanize Lens

    Lazer Urbanize Lens

  3. New
    Genesis Aeroshell

    Lazer Genesis Aeroshell

  4. New
    Sphere Aeroshell

    Lazer Sphere Aeroshell

  5. Phoenix+ Padding

    Lazer Phoenix+ Padding

  6. Century/Z1/Blade+ LED Light

    Lazer Century/Z1/Blade+ LED Light

  7. Century Twist Cap

    Lazer Century Twist Cap

  8. Bullet 2.0 Venturi Cap

    Lazer Bullet 2.0 Venturi Cap

  9. Sale
    Revolution & Revolution FF Screws

    Lazer Revolution & Revolution FF Screws

    £24.99 £12.99 (Save 48%)
  10. Impala Peak

    Lazer Impala Peak

  11. Impala Padding

    Lazer Impala Padding

  12. ATS Led

    Lazer ATS Led

  13. Genesis Padding

    Lazer Genesis Padding

  14. New
    Sphere Padding

    Lazer Sphere Padding

  15. Impala Camera Mount

    Lazer Impala Camera Mount

  16. Urbanize Padding

    Lazer Urbanize Padding