Hit Camera and Video LTD

select manufacturers_id, manufacturers_name from manufacturers order by manufacturers_name

Resource id #191

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 #194

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 #44

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

Resource id #45

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 #46

select categories_id 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 = '34'

Resource id #48

select categories_id from categories where parent_id = '34'

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

Resource id #50

select categories_id from categories where parent_id = '47'

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

Resource id #52

select categories_id from categories where parent_id = '46'

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

Resource id #54

select categories_id from categories where parent_id = '48'

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

Resource id #56

select categories_id from categories where parent_id = '49'

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

Resource id #58

select categories_id from categories where parent_id = '114'

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

Resource id #60

select categories_id from categories where parent_id = '142'

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

Resource id #62

select categories_id from categories where parent_id = '91'

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

Resource id #64

select categories_id from categories where parent_id = '92'

Resource id #65

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

Resource id #66

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 #67

select categories_id from categories where parent_id = '74'

Resource id #68

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

Resource id #69

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 #70

select categories_id 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 = '86'

Resource id #72

select categories_id from categories where parent_id = '86'

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

Resource id #74

select categories_id from categories where parent_id = '115'

Resource id #75

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

Resource id #76

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 #77

select categories_id 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 = '62'

Resource id #79

select categories_id from categories where parent_id = '62'

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

Resource id #81

select categories_id from categories where parent_id = '63'

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

Resource id #83

select categories_id from categories where parent_id = '64'

Resource id #84

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

Resource id #85

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 #86

select categories_id from categories where parent_id = '99'

Resource id #87

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 #88

select categories_id from categories where parent_id = '38'

Resource id #89

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 #90

select categories_id from categories where parent_id = '82'

Resource id #91

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 #92

select categories_id from categories where parent_id = '83'

Resource id #93

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 #94

select categories_id from categories where parent_id = '84'

Resource id #95

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 #96

select categories_id from categories where parent_id = '85'

Resource id #97

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 #98

select categories_id from categories where parent_id = '88'

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

Resource id #100

select categories_id from categories where parent_id = '89'

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

Resource id #102

select categories_id from categories where parent_id = '35'

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

Resource id #104

select categories_id from categories where parent_id = '93'

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

Resource id #106

select categories_id from categories where parent_id = '100'

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

Resource id #108

select categories_id from categories where parent_id = '102'

Resource id #109

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

Resource id #110

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 #111

select categories_id from categories where parent_id = '131'

Resource id #112

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 #113

select categories_id from categories where parent_id = '132'

Resource id #114

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 #115

select categories_id from categories where parent_id = '133'

Resource id #116

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 #117

select categories_id from categories where parent_id = '134'

Resource id #118

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 #119

select categories_id from categories where parent_id = '135'

Resource id #120

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 #121

select categories_id from categories where parent_id = '136'

Resource id #122

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 #123

select categories_id from categories where parent_id = '138'

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

Resource id #125

select categories_id from categories where parent_id = '139'

Resource id #126

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

Resource id #127

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 #128

select categories_id from categories where parent_id = '21'

Resource id #129

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 #130

select categories_id from categories where parent_id = '40'

Resource id #131

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 #132

select categories_id from categories where parent_id = '51'

Resource id #133

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

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

Resource id #135

select categories_id from categories where parent_id = '103'

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

Resource id #137

select categories_id from categories where parent_id = '104'

Resource id #138

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

Resource id #139

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 #140

select categories_id from categories where parent_id = '22'

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

Resource id #142

select categories_id from categories where parent_id = '52'

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

Resource id #144

select categories_id from categories where parent_id = '53'

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

Resource id #146

select categories_id from categories where parent_id = '54'

Resource id #147

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 #148

select categories_id from categories where parent_id = '55'

Resource id #149

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 #150

select categories_id from categories where parent_id = '56'

Resource id #151

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 #152

select categories_id from categories where parent_id = '57'

Resource id #153

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

Resource id #154

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 #155

select categories_id from categories where parent_id = '33'

Resource id #156

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

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

Resource id #158

select categories_id from categories where parent_id = '143'

Resource id #159

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

Resource id #160

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 #161

select categories_id from categories where parent_id = '90'

Resource id #162

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

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

Resource id #164

select categories_id from categories where parent_id = '26'

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

Resource id #166

select categories_id from categories where parent_id = '94'

Resource id #167

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

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

Resource id #169

select categories_id from categories where parent_id = '121'

Resource id #170

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 #171

select categories_id from categories where parent_id = '122'

Resource id #172

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 #173

select categories_id from categories where parent_id = '123'

Resource id #174

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

Resource id #175

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 #176

select categories_id from categories where parent_id = '96'

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

Resource id #178

select categories_id from categories where parent_id = '129'

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

Resource id #180

select categories_id from categories where parent_id = '124'

Resource id #181

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 #182

select categories_id from categories where parent_id = '125'

Resource id #183

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 #184

select categories_id from categories where parent_id = '126'

Resource id #185

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 #186

select categories_id from categories where parent_id = '127'

Resource id #187

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 #188

select categories_id from categories where parent_id = '128'

Resource id #189

Accessories-> (59)
Binoculars
Camera Filters-> (32)
Camera Lenses-> (128)
Digital Camera Accessories-> (37)
Digital Memory Cards-> (18)
Digital P&S Cameras-> (6)
Digital Photo Paper->
Digital SLR Systems-> (4)
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 = '914' and language_id = '1'

Resource id #195

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

Resource id #196

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 #199

Nikon D5100 body only
$699.00

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 #204

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 #205

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

Resource id #206

Resource id #207

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

Resource id #209

Resource id #210

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

Resource id #212

Resource id #213

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

Resource id #215

Resource id #216

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

Resource id #218

Resource id #219

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

Resource id #221

Resource id #222

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

Resource id #224

Resource id #225

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

Resource id #227

Resource id #228

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

Resource id #230

Resource id #231

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

Resource id #233

Resource id #234

	Nikon D5100 body only Date Added: Friday 23 September, 2011 Manufacturer: Price: $699.00

	AF 10-24mm f/3.5-5.6 Di-II w/ Hood Date Added: Friday 11 March, 2011 Manufacturer: Tamron Price: $549.99

	AF 18-270mm f/3.5-6.3PZD Di-II w/ Hood Date Added: Friday 11 March, 2011 Manufacturer: Tamron Price: $779.99

	Coolpix S8100 BLACK Date Added: Wednesday 07 July, 2010 Manufacturer: Price: $269.00

	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 320 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 #244

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 #247

Shopping Cart

0 items

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

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 #251

There are currently no product reviews

Languages

select languages_id, name, code, image, directory from languages order by sort_order

Resource id #255

Currencies