Hit Camera and Video LTD

select manufacturers_id, manufacturers_name from manufacturers order by manufacturers_name

Resource id #205

select products_id, products_image, products_tax_class_id, products_price from products where products_status = '1' order by products_date_added desc limit 10

Resource id #208

Categories

select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.parent_id = '0' and c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name

Resource id #46

select count(*) as count from categories where parent_id = '24'

Resource id #47

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '24'

Resource id #48

select categories_id from categories where parent_id = '24'

Resource id #49

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '34'

Resource id #50

select categories_id from categories where parent_id = '34'

Resource id #51

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '47'

Resource id #52

select categories_id from categories where parent_id = '47'

Resource id #53

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '46'

Resource id #54

select categories_id from categories where parent_id = '46'

Resource id #55

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '48'

Resource id #56

select categories_id from categories where parent_id = '48'

Resource id #57

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '49'

Resource id #58

select categories_id from categories where parent_id = '49'

Resource id #59

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '114'

Resource id #60

select categories_id from categories where parent_id = '114'

Resource id #61

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '142'

Resource id #62

select categories_id from categories where parent_id = '142'

Resource id #63

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '91'

Resource id #64

select categories_id from categories where parent_id = '91'

Resource id #65

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '92'

Resource id #66

select categories_id from categories where parent_id = '92'

Resource id #67

select count(*) as count from categories where parent_id = '74'

Resource id #68

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '74'

Resource id #69

select categories_id from categories where parent_id = '74'

Resource id #70

select count(*) as count from categories where parent_id = '112'

Resource id #71

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '112'

Resource id #72

select categories_id from categories where parent_id = '112'

Resource id #73

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '86'

Resource id #74

select categories_id from categories where parent_id = '86'

Resource id #75

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '115'

Resource id #76

select categories_id from categories where parent_id = '115'

Resource id #77

select count(*) as count from categories where parent_id = '60'

Resource id #78

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '60'

Resource id #79

select categories_id from categories where parent_id = '60'

Resource id #80

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '61'

Resource id #81

select categories_id from categories where parent_id = '61'

Resource id #82

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '62'

Resource id #83

select categories_id from categories where parent_id = '62'

Resource id #84

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '63'

Resource id #85

select categories_id from categories where parent_id = '63'

Resource id #86

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '64'

Resource id #87

select categories_id from categories where parent_id = '64'

Resource id #88

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '65'

Resource id #89

select categories_id from categories where parent_id = '65'

Resource id #90

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '70'

Resource id #91

select categories_id from categories where parent_id = '70'

Resource id #92

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '71'

Resource id #93

select categories_id from categories where parent_id = '71'

Resource id #94

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '72'

Resource id #95

select categories_id from categories where parent_id = '72'

Resource id #96

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '73'

Resource id #97

select categories_id from categories where parent_id = '73'

Resource id #98

select count(*) as count from categories where parent_id = '99'

Resource id #99

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '99'

Resource id #100

select categories_id from categories where parent_id = '99'

Resource id #101

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '38'

Resource id #102

select categories_id from categories where parent_id = '38'

Resource id #103

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '82'

Resource id #104

select categories_id from categories where parent_id = '82'

Resource id #105

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '83'

Resource id #106

select categories_id from categories where parent_id = '83'

Resource id #107

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '84'

Resource id #108

select categories_id from categories where parent_id = '84'

Resource id #109

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '85'

Resource id #110

select categories_id from categories where parent_id = '85'

Resource id #111

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '88'

Resource id #112

select categories_id from categories where parent_id = '88'

Resource id #113

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '89'

Resource id #114

select categories_id from categories where parent_id = '89'

Resource id #115

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '35'

Resource id #116

select categories_id from categories where parent_id = '35'

Resource id #117

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '93'

Resource id #118

select categories_id from categories where parent_id = '93'

Resource id #119

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '100'

Resource id #120

select categories_id from categories where parent_id = '100'

Resource id #121

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '102'

Resource id #122

select categories_id from categories where parent_id = '102'

Resource id #123

select count(*) as count from categories where parent_id = '131'

Resource id #124

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '131'

Resource id #125

select categories_id from categories where parent_id = '131'

Resource id #126

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '132'

Resource id #127

select categories_id from categories where parent_id = '132'

Resource id #128

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '133'

Resource id #129

select categories_id from categories where parent_id = '133'

Resource id #130

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '134'

Resource id #131

select categories_id from categories where parent_id = '134'

Resource id #132

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '135'

Resource id #133

select categories_id from categories where parent_id = '135'

Resource id #134

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '136'

Resource id #135

select categories_id from categories where parent_id = '136'

Resource id #136

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '138'

Resource id #137

select categories_id from categories where parent_id = '138'

Resource id #138

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '139'

Resource id #139

select categories_id from categories where parent_id = '139'

Resource id #140

select count(*) as count from categories where parent_id = '21'

Resource id #141

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '21'

Resource id #142

select categories_id from categories where parent_id = '21'

Resource id #143

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '40'

Resource id #144

select categories_id from categories where parent_id = '40'

Resource id #145

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '51'

Resource id #146

select categories_id from categories where parent_id = '51'

Resource id #147

select count(*) as count from categories where parent_id = '103'

Resource id #148

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '103'

Resource id #149

select categories_id from categories where parent_id = '103'

Resource id #150

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '104'

Resource id #151

select categories_id from categories where parent_id = '104'

Resource id #152

select count(*) as count from categories where parent_id = '22'

Resource id #153

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '22'

Resource id #154

select categories_id from categories where parent_id = '22'

Resource id #155

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '52'

Resource id #156

select categories_id from categories where parent_id = '52'

Resource id #157

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '53'

Resource id #158

select categories_id from categories where parent_id = '53'

Resource id #159

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '54'

Resource id #160

select categories_id from categories where parent_id = '54'

Resource id #161

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '55'

Resource id #162

select categories_id from categories where parent_id = '55'

Resource id #163

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '56'

Resource id #164

select categories_id from categories where parent_id = '56'

Resource id #165

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '57'

Resource id #166

select categories_id from categories where parent_id = '57'

Resource id #167

select count(*) as count from categories where parent_id = '33'

Resource id #168

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '33'

Resource id #169

select categories_id from categories where parent_id = '33'

Resource id #170

select count(*) as count from categories where parent_id = '143'

Resource id #171

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '143'

Resource id #172

select categories_id from categories where parent_id = '143'

Resource id #173

select count(*) as count from categories where parent_id = '90'

Resource id #174

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '90'

Resource id #175

select categories_id from categories where parent_id = '90'

Resource id #176

select count(*) as count from categories where parent_id = '26'

Resource id #177

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '26'

Resource id #178

select categories_id from categories where parent_id = '26'

Resource id #179

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '94'

Resource id #180

select categories_id from categories where parent_id = '94'

Resource id #181

select count(*) as count from categories where parent_id = '121'

Resource id #182

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '121'

Resource id #183

select categories_id from categories where parent_id = '121'

Resource id #184

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '122'

Resource id #185

select categories_id from categories where parent_id = '122'

Resource id #186

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '123'

Resource id #187

select categories_id from categories where parent_id = '123'

Resource id #188

select count(*) as count from categories where parent_id = '96'

Resource id #189

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '96'

Resource id #190

select categories_id from categories where parent_id = '96'

Resource id #191

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '129'

Resource id #192

select categories_id from categories where parent_id = '129'

Resource id #193

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '124'

Resource id #194

select categories_id from categories where parent_id = '124'

Resource id #195

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '125'

Resource id #196

select categories_id from categories where parent_id = '125'

Resource id #197

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '126'

Resource id #198

select categories_id from categories where parent_id = '126'

Resource id #199

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '127'

Resource id #200

select categories_id from categories where parent_id = '127'

Resource id #201

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '128'

Resource id #202

select categories_id from categories where parent_id = '128'

Resource id #203

Accessories-> (59)
Binoculars
Camera Filters-> (32)
Camera Lenses-> (157)
Digital Camera Accessories-> (37)
Digital Memory Cards-> (18)
Digital P&S Cameras-> (10)
Digital Photo Paper->
Digital SLR Systems-> (10)
Digital Viewers
Film Scanner
Lens to Camera Body Adapter (5)
Photo Printers->
Tripods-> (8)
Used and Collectables-> (23)

Manufacturers

select products_name from products_description where products_id = '908' and language_id = '1'

Resource id #209

select specials_new_products_price from specials where products_id = '908' and status

Resource id #210

What's New?

select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '38') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '74') and tr.tax_class_id = '12' group by tr.tax_priority

Resource id #213

Coolpix S4000 RED
$174.99

Quick Find

Use keywords to find the product you are looking for.
Advanced Search

Information

Shipping & Returns
Privacy Notice
Conditions of Use
Contact Us
Warranty Information
About us

select count(*) as total from products p left join manufacturers m on (p.manufacturers_id = m.manufacturers_id), products_description pd where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '1'

Resource id #218

New Products

select p.products_id, pd.products_name, p.products_image, p.products_price, p.products_tax_class_id, p.products_date_added, m.manufacturers_name from products p left join manufacturers m on (p.manufacturers_id = m.manufacturers_id), products_description pd where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '1' order by p.products_date_added DESC, pd.products_name limit 0, 10

Resource id #219

select specials_new_products_price from specials where products_id = '911' and status

Resource id #220

Resource id #221

select specials_new_products_price from specials where products_id = '910' and status

Resource id #223

Resource id #224

select specials_new_products_price from specials where products_id = '909' and status

Resource id #226

Resource id #227

select specials_new_products_price from specials where products_id = '908' and status

Resource id #229

Resource id #230

select specials_new_products_price from specials where products_id = '907' and status

Resource id #232

Resource id #233

select specials_new_products_price from specials where products_id = '906' and status

Resource id #235

Resource id #236

select specials_new_products_price from specials where products_id = '905' and status

Resource id #238

Resource id #239

select specials_new_products_price from specials where products_id = '904' and status

Resource id #241

Resource id #242

select specials_new_products_price from specials where products_id = '903' and status

Resource id #244

Resource id #245

select specials_new_products_price from specials where products_id = '901' and status

Resource id #247

Resource id #248

	Coolpix S570 BLACK Date Added: Wednesday 07 July, 2010 Manufacturer: Price: $184.99

	Coolpix S570 BLUE Date Added: Wednesday 07 July, 2010 Manufacturer: Price: $184.99

	Coolpix S4000 BLACK Date Added: Wednesday 07 July, 2010 Manufacturer: Price: $174.99

	Coolpix S4000 RED Date Added: Wednesday 07 July, 2010 Manufacturer: Price: $174.99

	Nikon Nikon SU-800 Remote Commander Date Added: Saturday 03 July, 2010 Manufacturer: Nikon Price: $289.00

	Toshiba USB Flash Memory 16GB Date Added: Friday 02 July, 2010 Manufacturer: Toshiba Price: $75.00

	Toshiba USB Flash Memory 8GB Date Added: Friday 02 July, 2010 Manufacturer: Toshiba Price: $35.00

	Toshiba USB Flash Memory 4GB Date Added: Friday 02 July, 2010 Manufacturer: Toshiba Price: $24.00

	Toshiba 4GB SDHC class 10 Date Added: Friday 02 July, 2010 Manufacturer: Toshiba Price: $35.90

	Leica X1 Wrist Carrying Strap Date Added: Wednesday 23 June, 2010 Manufacturer: Price: $99.95

Displaying 1 to 10 (of 359 new products)

Result Pages: 1 2 3 4 5 ... [Next >>]

select distinct p.products_id, pd.products_name from products p, products_description pd where p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '1' order by p.products_ordered desc, pd.products_name limit 10

Resource id #263

select p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image, s.specials_new_products_price from products p, products_description pd, specials s where p.products_status = '1' and p.products_id = s.products_id and pd.products_id = s.products_id and pd.language_id = '1' and s.status = '1' order by s.specials_date_added desc limit 10

Resource id #266

Shopping Cart

select p.products_id, pd.products_name, p.products_model, p.products_image, p.products_price, p.products_weight, p.products_tax_class_id from products p, products_description pd where p.products_id = '908' and pd.products_id = p.products_id and pd.language_id = '1'

Resource id #255

select specials_new_products_price from specials where products_id = '908' and status = '1'

Resource id #256

select products_id, products_price, products_tax_class_id, products_weight from products where products_id = '908'

Resource id #257

Resource id #258

select specials_new_products_price from specials where products_id = '908' and status = '1'

Resource id #259

1 x	Coolpix S4000 RED

$174.99

We are eBayers!

Bestsellers

01.	72mm
02.	AF-S DX Nikkor 18-200mm f/3.5-5.6G ED VR II
03.	Compact AW
04.	Hoya 52mm CPL
05.	SP AF 28-75mm F/2.8 XR Di LD Aspherical (IF)

Reviews

select r.reviews_id, r.reviews_rating, p.products_id, p.products_image, pd.products_name from reviews r, reviews_description rd, products p, products_description pd where p.products_status = '1' and p.products_id = r.products_id and r.reviews_id = rd.reviews_id and rd.languages_id = '1' and p.products_id = pd.products_id and pd.language_id = '1' order by r.reviews_id desc limit 10

Resource id #270

There are currently no product reviews

Languages

Currencies