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

Resource id #209

select specials_new_products_price from specials where products_id = '906' 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

Toshiba USB Flash Memory 16GB
$75.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 #241

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 September

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

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

Resource id #222

Resource id #223

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

Resource id #224

Resource id #225

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

Resource id #226

Resource id #227

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

Resource id #228

Resource id #229

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

Resource id #230

Resource id #231

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

Resource id #232

Resource id #233

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

Resource id #234

Resource id #235

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

Resource id #236

Resource id #237

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

Resource id #238

Resource id #239

Coolpix S570 BLACK $184.99	Coolpix S570 BLUE $184.99	Coolpix S4000 BLACK $174.99
Coolpix S4000 RED $174.99	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 #255

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

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 = '905' and pd.products_id = p.products_id and pd.language_id = '1'

Resource id #247

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

Resource id #248

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

Resource id #249

Resource id #250

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

Resource id #251

1 x	Toshiba USB Flash Memory 8GB

$35.00

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

There are currently no product reviews

Languages

Currencies