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

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

delete from whos_online where time_last_click < '1283787753'

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 = '1283788653', last_page_url = '/webshop/index.php?cPath=131' 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 = '131' and language_id = '1'

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

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

select cd.categories_name, c.categories_image from categories c, categories_description cd where c.categories_id = '131' and cd.categories_id = '131' 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 = '131' 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 = '132'