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

Echo1 Full Metal M249 MKII Airsoft AEG with Box Mag.

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='28708' 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

[TEP STOP]