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 > '1283786114'

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

delete from whos_online where time_last_click < '1283785214'

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.109', time_last_click = '1283786114', last_page_url = '/webshop/index.php?cPath=60' 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 = '60' and language_id = '1'

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

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

select cd.categories_name, c.categories_image from categories c, categories_description cd where c.categories_id = '60' and cd.categories_id = '60' and cd.language_id = '1'

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 = '60' 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 = '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 = '61'

select categories_id from categories where parent_id = '61'

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

select categories_id from categories where parent_id = '62'

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

select categories_id from categories where parent_id = '65'

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

select categories_id from categories where parent_id = '63'

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

select categories_id from categories where parent_id = '64'

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

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