Hit Camera and Video LTD

select configuration_key as cfgKey, configuration_value as cfgValue from configuration

select value from sessions where sesskey = 'utht4nk73bes6hr3ip25vh1857' and expiry > '1283788575'

select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies

delete from whos_online where time_last_click < '1283787675'

select count(*) as count from whos_online where session_id = 'utht4nk73bes6hr3ip25vh1857'

update whos_online set customer_id = '0', full_name = 'Guest', ip_address = '38.107.191.106', time_last_click = '1283788575', last_page_url = '/webshop/index.php?cPath=121' where session_id = 'utht4nk73bes6hr3ip25vh1857'

select banners_id, date_scheduled from banners where date_scheduled != ''

select b.banners_id, b.expires_date, b.expires_impressions, sum(bh.banners_shown) as banners_shown from banners b, banners_history bh where b.status = '1' and b.banners_id = bh.banners_id group by b.banners_id

select specials_id from specials where status = '1' and now() >= expires_date and expires_date > 0

select categories_name from categories_description where categories_id = '121' and language_id = '1'

select count(*) as total from products_to_categories where categories_id = '121'

select manufacturers_id, manufacturers_name from manufacturers order by manufacturers_name

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

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

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

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

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

select categories_id from categories where parent_id = '24'

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

select categories_id from categories where parent_id = '34'

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

select categories_id from categories where parent_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 = '46'

select categories_id from categories where parent_id = '46'

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

select categories_id from categories where parent_id = '48'

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

select categories_id from categories where parent_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 = '114'

select categories_id from categories where parent_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 = '142'

select categories_id from categories where parent_id = '142'

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

select categories_id from categories where parent_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 = '92'

select categories_id from categories where parent_id = '92'

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

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

select categories_id from categories where parent_id = '74'

select count(*) as count from categories where parent_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 = '112'

select categories_id from categories where parent_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 = '86'

select categories_id from categories where parent_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 = '115'

select categories_id from categories where parent_id = '115'

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

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

select categories_id from categories where parent_id = '60'

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

select categories_id from categories where parent_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 = '62'

select categories_id from categories where parent_id = '62'

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

select categories_id from categories where parent_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 = '64'

select categories_id from categories where parent_id = '64'

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

select categories_id from categories where parent_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 = '70'

select categories_id from categories where parent_id = '70'

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

select categories_id from categories where parent_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 = '72'

select categories_id from categories where parent_id = '72'

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

select categories_id from categories where parent_id = '73'

select count(*) as count from categories where parent_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'

select categories_id from categories where parent_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 = '38'

select categories_id from categories where parent_id = '38'

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

select categories_id from categories where parent_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 = '83'

select categories_id from categories where parent_id = '83'

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

select categories_id from categories where parent_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 = '85'

select categories_id from categories where parent_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 = '88'

select categories_id from categories where parent_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 = '89'

select categories_id from categories where parent_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 = '35'

select categories_id from categories where parent_id = '35'

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

select categories_id from categories where parent_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 = '100'

select categories_id from categories where parent_id = '100'

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

select categories_id from categories where parent_id = '102'

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

select categories_id from categories where parent_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 = '132'

select categories_id from categories where parent_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 = '133'

select categories_id from categories where parent_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 = '134'

select categories_id from categories where parent_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 = '135'

select categories_id from categories where parent_id = '135'

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

select categories_id from categories where parent_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'

select categories_id from categories where parent_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'

select categories_id from categories where parent_id = '139'

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

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

select categories_id from categories where parent_id = '21'

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

select categories_id from categories where parent_id = '40'

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

select categories_id from categories where parent_id = '51'

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

select categories_id from categories where parent_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 = '104'

select categories_id from categories where parent_id = '104'

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

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

select categories_id from categories where parent_id = '22'

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

select categories_id from categories where parent_id = '52'

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

select categories_id from categories where parent_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 = '54'

select categories_id from categories where parent_id = '54'

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

select categories_id from categories where parent_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 = '56'

select categories_id from categories where parent_id = '56'

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

select categories_id from categories where parent_id = '57'

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

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

select categories_id from categories where parent_id = '33'

select count(*) as count from categories where parent_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 = '143'

select categories_id from categories where parent_id = '143'

select count(*) as count from categories where parent_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 = '90'

select categories_id from categories where parent_id = '90'

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

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

select categories_id from categories where parent_id = '26'

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

select categories_id from categories where parent_id = '94'

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

select categories_id from categories where parent_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 = '122'

select categories_id from categories where parent_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 = '123'

select categories_id from categories where parent_id = '123'

select count(*) as count from categories where parent_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 = '122'

select categories_id from categories where parent_id = '122'

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

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

select categories_id from categories where parent_id = '123'

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

select categories_id from categories where parent_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 = '129'

select categories_id from categories where parent_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 = '124'

select categories_id from categories where parent_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 = '125'

select categories_id from categories where parent_id = '125'

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

select categories_id from categories where parent_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 = '127'

select categories_id from categories where parent_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 = '128'

select categories_id from categories where parent_id = '128'

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

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

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

select distinct m.manufacturers_id as id, m.manufacturers_name as name from products p, products_to_categories p2c, manufacturers m where p.products_status = '1' and p.manufacturers_id = m.manufacturers_id and p.products_id = p2c.products_id and p2c.categories_id = '121' order by m.manufacturers_name

select categories_image from categories where categories_id = '121'

select count(p.products_id) as total from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id left join specials s on p.products_id = s.products_id, products_to_categories p2c where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '121'

select p.products_image, m.manufacturers_name, pd.products_name, p.products_quantity, p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id left join specials s on p.products_id = s.products_id, products_to_categories p2c where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '121' order by pd.products_name limit 0, 15

select distinct p.products_id, pd.products_name from products p, products_description pd, products_to_categories p2c, categories c where p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and '121' in (c.categories_id, c.parent_id) order by p.products_ordered desc, pd.products_name limit 10

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

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'

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

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

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

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

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

select startdate, counter from counter

update counter set counter = '3269973'

select banners_id, banners_title, banners_image, banners_html_text from banners where status = '1' and banners_group = '468x50'

select count(*) as total from sessions where sesskey = 'utht4nk73bes6hr3ip25vh1857'

update sessions set expiry = '1283790015', value = 'cart|O:12:\"shoppingCart\":5:{s:8:\"contents\";a:1:{i:905;a:1:{s:3:\"qty\";i:1;}}s:5:\"total\";d:35;s:6:\"weight\";d:0;s:6:\"cartID\";s:5:\"29611\";s:12:\"content_type\";b:0;}language|s:7:\"english\";languages_id|s:1:\"1\";currency|s:3:\"CAD\";navigation|O:17:\"navigationHistory\":2:{s:4:\"path\";a:3:{i:0;a:4:{s:4:\"page\";s:16:\"products_new.php\";s:4:\"mode\";s:6:\"NONSSL\";s:3:\"get\";a:2:{s:6:\"action\";s:7:\"buy_now\";s:11:\"products_id\";s:3:\"905\";}s:4:\"post\";a:0:{}}i:1;a:4:{s:4:\"page\";s:16:\"product_info.php\";s:4:\"mode\";s:6:\"NONSSL\";s:3:\"get\";a:1:{s:11:\"products_id\";s:3:\"848\";}s:4:\"post\";a:0:{}}i:2;a:4:{s:4:\"page\";s:9:\"index.php\";s:4:\"mode\";s:6:\"NONSSL\";s:3:\"get\";a:1:{s:5:\"cPath\";s:3:\"121\";}s:4:\"post\";a:0:{}}}s:8:\"snapshot\";a:0:{}}' where sesskey = 'utht4nk73bes6hr3ip25vh1857'