Contact Us (626) 286-0360 Walk-In Superstore Daily Deal
New Phone Support Hours M-F 8am-5pm PST
Browse by Type or Category
WINTER SALE - 20% OFF (exclusions apply, see details)   Use code: WINTER

M4 Type Red Dot Sight w/ 20mm weaver QD Mount Base for Airsoft

0 -

select r.reviews_id, left(rd.reviews_text, 999999) as reviews_text, r.reviews_rating, r.date_added, r.customers_name from reviews r, reviews_description rd where ( r.products_id='29872' OR ( r.products_id='0' AND r.reviews_rating>3 ) ) and r.reviews_id = rd.reviews_id and rd.languages_id = '1' and r.approved = '1' order by r.reviews_rating desc, r.date_added desc