Hit Camera and Video LTD

select configuration_key as cfgKey, configuration_value as cfgValue from configuration

select value from sessions where sesskey = 'd3peqgmg4amet9ig2bhbhem6t1' and expiry > '1283626319'

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

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

delete from whos_online where time_last_click < '1283625419'

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

insert into whos_online (customer_id, full_name, session_id, ip_address, time_entry, time_last_click, last_page_url) values ('0', 'Guest', 'd3peqgmg4amet9ig2bhbhem6t1', '38.107.191.108', '1283626319', '1283626319', '/webshop/advanced_search.php?language=en')

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

select specials_new_products_price from specials where products_id = '909' 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 c.categories_id, cd.categories_name from categories c, categories_description cd where 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 from categories c, categories_description cd where parent_id = '24' 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 from categories c, categories_description cd where parent_id = '34' 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 from categories c, categories_description cd where parent_id = '46' 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 from categories c, categories_description cd where parent_id = '142' 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 from categories c, categories_description cd where parent_id = '48' 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 from categories c, categories_description cd where parent_id = '114' 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 from categories c, categories_description cd where parent_id = '47' 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 from categories c, categories_description cd where parent_id = '49' 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 from categories c, categories_description cd where parent_id = '92' 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 from categories c, categories_description cd where parent_id = '91' 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 from categories c, categories_description cd where parent_id = '74' 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 from categories c, categories_description cd where parent_id = '112' 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 from categories c, categories_description cd where parent_id = '115' 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 from categories c, categories_description cd where parent_id = '86' 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 from categories c, categories_description cd where parent_id = '60' 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 from categories c, categories_description cd where parent_id = '61' 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 from categories c, categories_description cd where parent_id = '70' 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 from categories c, categories_description cd where parent_id = '73' 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 from categories c, categories_description cd where parent_id = '72' 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 from categories c, categories_description cd where parent_id = '71' 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 from categories c, categories_description cd where parent_id = '62' 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 from categories c, categories_description cd where parent_id = '65' 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 from categories c, categories_description cd where parent_id = '63' 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 from categories c, categories_description cd where parent_id = '64' 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 from categories c, categories_description cd where parent_id = '99' 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 from categories c, categories_description cd where parent_id = '35' 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 from categories c, categories_description cd where parent_id = '93' and c.categories_id = cd.categories_id and cd.language_id = '1' order by sort_order, cd.categories_name