Hit Camera and Video LTD

select manufacturers_id, manufacturers_name from manufacturers order by manufacturers_name

Resource id #193

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

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

Resource id #81

select categories_id from categories where parent_id = '62'

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

Resource id #83

select categories_id from categories where parent_id = '63'

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

Resource id #85

select categories_id from categories where parent_id = '64'

Resource id #86

select count(*) as count 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 = '99'

Resource id #88

select categories_id from categories where parent_id = '99'

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

Resource id #90

select categories_id from categories where parent_id = '38'

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

Resource id #92

select categories_id from categories where parent_id = '82'

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

Resource id #94

select categories_id from categories where parent_id = '83'

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

Resource id #96

select categories_id from categories where parent_id = '84'

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

Resource id #98

select categories_id from categories where parent_id = '85'

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

Resource id #100

select categories_id from categories where parent_id = '88'

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

Resource id #102

select categories_id from categories where parent_id = '89'

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

Resource id #104

select categories_id from categories where parent_id = '35'

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

Resource id #106

select categories_id from categories where parent_id = '93'

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

Resource id #108

select categories_id from categories where parent_id = '100'

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

Resource id #110

select categories_id from categories where parent_id = '102'

Resource id #111

select count(*) as count 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 = '131'

Resource id #113

select categories_id from categories where parent_id = '131'

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

Resource id #115

select categories_id from categories where parent_id = '132'

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

Resource id #117

select categories_id from categories where parent_id = '133'

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

Resource id #119

select categories_id from categories where parent_id = '134'

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

Resource id #121

select categories_id from categories where parent_id = '135'

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

Resource id #123

select categories_id from categories where parent_id = '136'

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

Resource id #125

select categories_id from categories where parent_id = '138'

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

Resource id #127

select categories_id from categories where parent_id = '139'

Resource id #128

select count(*) as count 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 = '21'

Resource id #130

select categories_id from categories where parent_id = '21'

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

Resource id #132

select categories_id from categories where parent_id = '40'

Resource id #133

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

select categories_id from categories where parent_id = '51'

Resource id #135

select count(*) as count 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 = '103'

Resource id #137

select categories_id from categories where parent_id = '103'

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

Resource id #139

select categories_id from categories where parent_id = '104'

Resource id #140

select count(*) as count 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 = '22'

Resource id #142

select categories_id from categories where parent_id = '22'

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

Resource id #144

select categories_id from categories where parent_id = '52'

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

Resource id #146

select categories_id from categories where parent_id = '53'

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

Resource id #148

select categories_id from categories where parent_id = '54'

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

Resource id #150

select categories_id from categories where parent_id = '55'

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

Resource id #152

select categories_id from categories where parent_id = '56'

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

Resource id #154

select categories_id from categories where parent_id = '57'

Resource id #155

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

Resource id #156

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

select categories_id from categories where parent_id = '33'

Resource id #158

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

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

Resource id #160

select categories_id from categories where parent_id = '143'

Resource id #161

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

Resource id #162

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

select categories_id from categories where parent_id = '90'

Resource id #164

select count(*) as count 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 = '26'

Resource id #166

select categories_id from categories where parent_id = '26'

Resource id #167

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

select categories_id from categories where parent_id = '94'

Resource id #169

select count(*) as count 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 = '121'

Resource id #171

select categories_id from categories where parent_id = '121'

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

Resource id #173

select categories_id from categories where parent_id = '122'

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

Resource id #175

select categories_id from categories where parent_id = '123'

Resource id #176

select count(*) as count 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 = '96'

Resource id #178

select categories_id from categories where parent_id = '96'

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

Resource id #180

select categories_id from categories where parent_id = '129'

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

Resource id #182

select categories_id from categories where parent_id = '124'

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

Resource id #184

select categories_id from categories where parent_id = '125'

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

Resource id #186

select categories_id from categories where parent_id = '126'

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

Resource id #188

select categories_id from categories where parent_id = '127'

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

Resource id #190

select categories_id from categories where parent_id = '128'

Resource id #191

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 = '907' and language_id = '1'

Resource id #197

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

Resource id #198

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

Nikon Nikon SU-800 Remote Commander
$289.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

What's New Here?

select p.products_id, pd.products_name, products_date_available as date_expected from products p, products_description pd where to_days(products_date_available) >= to_days(now()) and p.products_id = pd.products_id and pd.language_id = '1' order by date_expected desc limit 10

Resource id #229

Welcome to Hit Camera and Video Ltd. Guest! Would you like to log yourself in? Or would you prefer to create an account?

Registration
Please take time to register to our system. This would greatly help us improve our services by knowing what YOU want. It will also help us to facilitate the speedy processing of your orders. Other benefits would include a newsletter which would notify you with the latest store specials and price drops. So come in and register to get a head start on saving!

New Products For February

select p.products_id, p.products_image, p.products_tax_class_id, if(s.status, s.specials_new_products_price, p.products_price) as products_price from products p left join specials s on p.products_id = s.products_id where products_status = '1' order by p.products_date_added desc limit 9

Resource id #209

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

Resource id #210

Resource id #211

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

Resource id #212

Resource id #213

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

Resource id #214

Resource id #215

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

Resource id #216

Resource id #217

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

Resource id #218

Resource id #219

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

Resource id #220

Resource id #221

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

Resource id #222

Resource id #223

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

Resource id #224

Resource id #225

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

Resource id #226

Resource id #227

Nikon D5100 body only $699.00	AF 10-24mm f/3.5-5.6 Di-II w/ Hood $549.99	AF 18-270mm f/3.5-6.3PZD Di-II w/ Hood $779.99
Coolpix S8100 BLACK $269.00	Nikon Nikon SU-800 Remote Commander $289.00	Toshiba USB Flash Memory 16GB $75.00
Toshiba USB Flash Memory 8GB $35.00	Toshiba USB Flash Memory 4GB $24.00	Toshiba 4GB SDHC class 10 $35.90

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

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

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

There are currently no product reviews

Languages

Currencies