|
|
|
SELECT yourreward.*, item.itemid, item.descrip from `yourreward` left outer join `item` on yourreward.itemcode = item.itemcode WHERE yourreward.`showweb` = 1 ORDER BY `points` DESC
90898
Samsung 46" 6000 Series 1080p LED HDTV 2
Item Code: TVSS000770
17381
LG 1100W 5.1 Channel Home Theatre System
Item Code: HTLG000019
8571
iCan Swivel Plasma/LCD TV Wall Mount w/C
Item Code: TVACLT0036
7500
iCan Swivel Low Profile LED TV Wall Moun
Item Code: TVACLT0041
5000
iCan LCD Swivel Dual Desk Mount 10-24 in
Item Code: TVACLT0056
4565
Toshiba BDX1100 Blu-ray Player (Includes
Item Code: HTBRTO0020
4500
iCan Extremely low profile articulating
Item Code: TVACLT0033
3500
iCan 10''-24'' Dual Swing Arm Desktop Mo
Item Code: TVACLT0053
3000
Samsung ML-1675 Monochrome Laser Printer
Item Code: PRSS000850
2857
Razer DeathAdder 3500dpi 3.5G Infrared S
Item Code: PERZ000126
2500
3.5CH Radio-Controlled helicopter (U2)
Item Code: RCHE000132
2500
Targus HP PB980A 17" Executive Leather C
Item Code: BGLPHP0021
2000
iCan Universal Adjustable Speaker Stands
Item Code: HTACIC0009
1999
Kingston DataTraveler I Gen 3 32GB USB 2
Item Code: SMKT000930
1885
Kingston DataTraveler 101 Gen 2 32GB urD
Item Code: SMKT000970
1750
3.5 Channel Infrared Coaxial Helicopter
Item Code: RCHE000145
1750
iCan Swivel Plasma/LCD wall mounts. Reco
Item Code: TVACLT0021
1500
iCAN 2.1 Multimedia Speaker System w/ VF
Item Code: SPIC000006
1400
iCan 15.6" Nylon Laptop Backpack Black (
Item Code: BGLP001312
1250
iCan 15" Laptop Messenger Bag - Black
Item Code: BGLP001315
1250
UDI U806 Infrared 3CH Micro RC Helicopte
Item Code: RCHE000123
1250
UDI U803 Apache Military Infrared 3CH Mi
Item Code: RCHE000117
1250
iCAN 2.1 Multimedia Speaker System - Pi
Item Code: SPIC000003
1250
iCan SLR camera backpack - black
Item Code: BGDCIC0003
1250
UDI U801 Infrared 3CH Micro RC Helicopte
Item Code: RCHE000111
1000
Dexim Visible Green Charge & Sync for iP
Item Code: BADD000111
1000
Dexim Dual USB Car Charger Kit for iPad,
Item Code: BADD000084
1000
iCAN H-094 10 Ports USB 2.0 Hub with Pow
Item Code: IOIC000064
1000
Remote Control Car 1:10 Polyvinyl Chlori
Item Code: RCGN000028
1000
Remote Control Car 1:10 Polyvinyl Chlori
Item Code: RCGN000019
1000
iCan Auto Focus HD Webcam - White (C-192
Item Code: WCIC000021
1000
Remote Control Car 1:10 Polyvinyl Chlori
Item Code: RCGN000064
1000
Remote Control Car 1:10 Polyvinyl Chlori
Item Code: RCGN000037
1000
Remote Control Car 1:10 Polyvinyl Chlori
Item Code: RCGN000055
1000
Remote Control Car 1:10 Polyvinyl Chlori
Item Code: RCGN000046
900
iCan Black Front HD Webcam - White/Black
Item Code: WCIC000018
900
iCan Changeable Front Shell HD Webcam -
Item Code: WCIC000015
850
Dexim Dual USB Car Charger for iPhone 4s
Item Code: BADD000025
750
Robot USB Hub Ninja (Black)
Item Code: IOGN000018
750
iCan LED Lights HD Webcam - Silver/Black
Item Code: WCIC000012
750
iCan 15" Messenger bag - Black
Item Code: BGLP001327
750
iCan 10" Messenger bag - Black
Item Code: BGLP001330
750
iCAN 15.6" Neoprene Laptop Sleeve (NS-03
Item Code: BGLP001204
750
iCAN iPad case - black
Item Code: BGIC000003
750
Robot USB Hub Tommy (Grey)
Item Code: IOGN000012
750
Dexim Travel Adapter Kit for iPhone 4/4s
Item Code: BADD000040
700
iCAN 13.3" Neoprene Laptop Sleeve (NS-03
Item Code: BGLP001201
650
iCan Wired keyboard and Mouse Combo - bl
Item Code: PEIC000036
650
Targus Universal Stylus for Tablets (Bla
Item Code: PETG000006
650
Targus Universal Stylus for Tablets (whi
Item Code: PETG000009
650
iCan 13"-14" Messenger bag - Black
Item Code: BGLP001309
650
iCan 8-port Smart Card Reader
Item Code: IOIC000019
650
iCAN 15.6" Neoprene Laptop Sleeve (NS-07
Item Code: BGLP001231
650
iCAN 10" Nylon Laptop Bag (NS-075-10-Bla
Item Code: BGLP001285
650
iCAN 6 Outlets Power Bar - 3 ft Cord 187
Item Code: PBIC000019
600
iCan Gamer Mouse Pad (400*300*0.4mm)
Item Code: MAEC000022
600
iCan Simple,Sleek & Slim - 18mm thicknes
Item Code: PEIC000018
600
iCan Simple,Sleek & Slim - 18mm thicknes
Item Code: PEIC000021
550
iCAN 13.3" Neoprene Laptop Sleeve (NS-02
Item Code: BGLP001192
500
Dexim USB Cable Charger for iPhone 4G/3G
Item Code: BADD000015
450
iCan Basic Keyboard Gel Pad (500*92*22mm
Item Code: MAEC000018
400
iCan Wired multimedia Keyboard - black
Item Code: PEIC000039
400
Pottery Bathroom Set (4 pcs) (F18-1-2-3)
Item Code: GIBS000018
400
Pottery Bathroom Set (4 pcs) (F19-1-2-3-
Item Code: GIBS000042
400
Falcon 10oz compressed air duster
Item Code: CNFA000003
400
Nylon Gym Bag (862-1)
Item Code: GINB000091
400
Pottery Bathroom Set (4 pcs) (071042-3)
Item Code: GIBS000059
350
Cartoon Doll Lamp 110V (D89-12)
Item Code: GILA000018
350
Cartoon Doll Lamp 110V (D87-12)
Item Code: GILA000026
350
Pottery Bathroom Set (4 pcs) (F10-1)
Item Code: GIBS000067
350
iCan Ergonomic Wrist Pad (205*242*23mm)
Item Code: MAEC000021
300
Nylon Printing Environmental Bags (Assor
Item Code: GINB000018
250
Pottery Photo Frame (5x7)
Item Code: GIPF000019
250
iCan Recycled Mouse Pad (230*190mm)
Item Code: MAEC000017
250
iCAN 50 Pack CD color sleeve
Item Code: CVIC000176
200
Pottery Bathroom Set (4 pcs) (071012-1)
Item Code: GIBS000034
200
Sport Bottle (L021)
Item Code: GINB000042
200
Quartz metal wall clock (30.8x30.8x4cm)
Item Code: GICL000006
200
Nylon Gym Bag (862-2)
Item Code: GINB000083
200
Sport Bottle (L023)
Item Code: GINB000019
200
Nylon Gym Bag (Black and Red) (862-3)
Item Code: GINB000026
200
iCan 50 Pack CD sleeve - clear
Item Code: CVIC000179
200
Halloa CLEANING WIPES
Item Code: CNDI000016
200
iCAN 100 Pack Slimline Color Paper Envel
Item Code: CVIC000182
150
Clock
Item Code: GICL000018
150
Photo Album Book (3025)
Item Code: GIPB000019
150
iCan Sticker Black&White Series Metal Fo
Item Code: MAEC000130
150
Glass Photo Frame
Item Code: GIPF000026
150
Cotton Storage Box (Assorted color)
Item Code: GISB000026
150
iCan Sticker Black&White Series Metal Fo
Item Code: MAEC000142
150
iCan Sticker Black&White Series Metal Fo
Item Code: MAEC000133
150
Sport Bottle (L022)
Item Code: GINB000034
150
Quartz plastic wall clock (35x35x3.5cm)
Item Code: GICL000003
150
iCAN 100 Pack Slimline Paper Envelope(CD
Item Code: CVIC000173
150
iCan Sticker Black&White Series Metal Fo
Item Code: MAEC000148
150
iCan Sticker Black&White Series Metal Fo
Item Code: MAEC000145
150
Quartz Style glass wall clock
Item Code: GICL000033
100
Nylon Strawberry Environmental Bag
Item Code: GINB000067
100
Pottery Photo Frame (4x6)
Item Code: GIPF000018
100
Nylon Colorful Printing Environmental Ba
Item Code: GINB000075
90
Footshape Multi Purpose Suckers
Item Code: GISH000019
90
Handshape Multi-Purpose Suckers
Item Code: GISH000018
50
Nylon Canada Computers Environmental Bag
Item Code: GIRB000018
|
