Notice: Undefined offset: 8192 in /storage/content/09/172109/jholmster.com/public_html/includes/kiss_error_handler.php on line 179 jQuery/Ajax Advanced Caching System 2.3.3

$49.99

There's Something About Mary
[DVD-TSAB]

There\'s Something About Mary
Regional Code: 2 (Japan, Europe, Middle East, South Africa).
Languages: English, Deutsch.
Subtitles: English, Deutsch, Spanish.
Audio: Dolby Surround 5.1.
Picture Format: 16:9 Wide-Screen.
Length: (approx) 114 minutes.
Other: Interactive Menus, Chapter Selection, Subtitles (more languages).
Reviews (1)

Customers who bought this product also purchased
Blade Runner - Director's Cut
Blade Runner - Director's Cut
Quick Find
 
Use keywords to find the product you are looking for.
Advanced Search
What's New?
Beloved
Beloved
$54.99
Information
Shipping & Returns
Privacy Notice
Conditions of Use
Contact Us
Shopping Cart
0 items
Notifications
NotificationsNotify me of updates to There's Something About Mary
Share Product
Share via E-Mail
Share on Facebook Share on Twitter
Reviews
There's Something About Mary
This has to be one of the funniest movies released for 1999! ..
5 of 5 Stars!
Currencies

Copyright © 2024 jQuery/Ajax Advanced Caching System 2.3.3
Powered by osCommerce

Parse Time: 0.367s

FWR MEDIA
KissER Query Output:
Total Queries: 21
Slowest Query Number 16
Time: 0.0072 Seconds.
Total query Time 0.0409 Seconds.
Number: 1
Time: 0.0039 Seconds.
Query: select configuration_key as cfgKey, configuration_value as cfgValue from configuration
Number: 2
Time: 0.0015 Seconds.
Query: select code, title, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, value from currencies
Number: 3
Time: 0.0014 Seconds.
Query: select languages_id, name, code, image, directory from languages order by sort_order
Number: 4
Time: 0.0019 Seconds.
Query: 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
Number: 5
Time: 0.0017 Seconds.
Query: 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
Number: 6
Time: 0.0016 Seconds.
Query: select products_name from products_description where products_id = '20' and language_id = '1'
Number: 7
Time: 0.002 Seconds.
Query: 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 = '223') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '18') and tr.tax_class_id = '1' group by tr.tax_priority
Number: 8
Time: 0.0013 Seconds.
Query: select products_name from products_description where products_id = '19' and language_id = '1'
Number: 9
Time: 0.0014 Seconds.
Query: select products_name from products_description where products_id = '19' and language_id = '1'
Number: 10
Time: 0.0014 Seconds.
Query: select products_image from products where products_id = '19'
Number: 11
Time: 0.0015 Seconds.
Query: select image from products_images where products_id = '19' order by sort_order
Number: 12
Time: 0.0018 Seconds.
Query: 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' and r.reviews_status = 1 and p.products_id = '19' order by r.reviews_id desc limit 10
Number: 13
Time: 0.0014 Seconds.
Query: select substring(reviews_text, 1, 60) as reviews_text from reviews_description where reviews_id = '1' and languages_id = '1'
Number: 14
Time: 0.0016 Seconds.
Query: select count(*) as total from products p, products_description pd where p.products_status = '1' and p.products_id = '19' and pd.products_id = p.products_id and pd.language_id = '1'
Number: 15
Time: 0.0014 Seconds.
Query: select p.products_id, pd.products_name, pd.products_description, p.products_model, p.products_quantity, p.products_image, pd.products_url, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id from products p, products_description pd where p.products_status = '1' and p.products_id = '19' and pd.products_id = p.products_id and pd.language_id = '1'
Number: 16
Time: 0.0072 Seconds.
Query: update products_description set products_viewed = products_viewed+1 where products_id = '19' and language_id = '1'
Number: 17
Time: 0.0015 Seconds.
Query: select image, htmlcontent from products_images where products_id = '19' order by sort_order
Number: 18
Time: 0.0016 Seconds.
Query: select count(*) as total from products_options popt, products_attributes patrib where patrib.products_id='19' and patrib.options_id = popt.products_options_id and popt.language_id = '1'
Number: 19
Time: 0.0016 Seconds.
Query: select count(*) as count from reviews r, reviews_description rd where r.products_id = '19' and r.reviews_id = rd.reviews_id and rd.languages_id = '1' and reviews_status = 1
Number: 20
Time: 0.0019 Seconds.
Query: select p.products_id, p.products_image from orders_products opa, orders_products opb, orders o, products p where opa.products_id = '19' and opa.orders_id = opb.orders_id and opb.products_id != '19' and opb.products_id = p.products_id and opb.orders_id = o.orders_id and p.products_status = '1' group by p.products_id order by o.date_purchased desc limit 6
Number: 21
Time: 0.0013 Seconds.
Query: select products_name from products_description where products_id = '5' and language_id = '1'
FWR MEDIA
KissER Error Handling:
Unique error code: 8192 Error Count: 1
Error: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead
File: includes/functions/database.php
Line: 19
E_WARNING Error Count: 33
Error: fopen(/tmp/jholmster/configuration_cache.cache): failed to open stream: No such file or directory
File: includes/functions/cache.php
Line: 68
Error: fopen(/tmp/jholmster/configuration_cache_arrays.cache): failed to open stream: No such file or directory
File: includes/functions/cache.php
Line: 68
Error: fopen(/tmp/jholmster/currencies.cache): failed to open stream: No such file or directory
File: includes/functions/cache.php
Line: 68
Error: fopen(/tmp/jholmster/currencies.cache): failed to open stream: No such file or directory
File: includes/functions/cache.php
Line: 28
Error: fopen(/tmp/jholmster/languages.cache): failed to open stream: No such file or directory
File: includes/functions/cache.php
Line: 68
Error: fopen(/tmp/jholmster/languages.cache): failed to open stream: No such file or directory
File: includes/functions/cache.php
Line: 28
Error: constant(): Couldn't find constant PRODPATH_19
File: includes/functions/general.php
Line: 965
Error: array_key_exists() expects parameter 2 to be array, null given
File: includes/application_top.php
Line: 515
Error: fopen(/tmp/jholmster/categories_box-english.cache): failed to open stream: No such file or directory
File: includes/functions/cache.php
Line: 68
Error: constant(): Couldn't find constant SUBCATCOUNT_1
File: includes/functions/general.php
Line: 456
Error: constant(): Couldn't find constant CATCOUNT_1
File: includes/functions/general.php
Line: 422
Error: constant(): Couldn't find constant SUBCATCOUNT_2
File: includes/functions/general.php
Line: 456
Error: constant(): Couldn't find constant CATCOUNT_2
File: includes/functions/general.php
Line: 422
Error: constant(): Couldn't find constant SUBCATCOUNT_3
File: includes/functions/general.php
Line: 456
Error: constant(): Couldn't find constant CATCOUNT_3
File: includes/functions/general.php
Line: 422
Error: constant(): Couldn't find constant SUBCATCOUNT_21
File: includes/functions/general.php
Line: 456
Error: constant(): Couldn't find constant CATCOUNT_21
File: includes/functions/general.php
Line: 422
Error: fopen(/tmp/jholmster/categories_box-english.cache): failed to open stream: No such file or directory
File: includes/functions/cache.php
Line: 28
Error: fopen(/tmp/jholmster/bm_whats_new-english-USD.cache): failed to open stream: No such file or directory
File: includes/functions/cache.php
Line: 68
Error: array_key_exists() expects parameter 2 to be array, null given
File: includes/functions/general.php
Line: 105
Error: fopen(/tmp/jholmster/bm_whats_new-english-USD.cache): failed to open stream: No such file or directory
File: includes/functions/cache.php
Line: 28
Error: fopen(/tmp/jholmster/bm_best_sellers_box-0-1.cache): failed to open stream: No such file or directory
File: includes/functions/cache.php
Line: 68
Error: fopen(/tmp/jholmster/bm_best_sellers_box-0-1.cache): failed to open stream: No such file or directory
File: includes/functions/cache.php
Line: 28
Error: fopen(/tmp/jholmster/reviews_box-english.cache): failed to open stream: No such file or directory
File: includes/functions/cache.php
Line: 68
Error: fopen(/tmp/jholmster/reviews_box-english.cache): failed to open stream: No such file or directory
File: includes/functions/cache.php
Line: 28
Error: fopen(/tmp/jholmster/product_info.php-products_id-19-language-english-currency-USD.page.cache): failed to open stream: No such file or directory
File: includes/functions/cache.php
Line: 68
Error: fopen(/tmp/jholmster/also_purchased-english.cache19): failed to open stream: No such file or directory
File: includes/functions/cache.php
Line: 68
Error: fopen(/tmp/jholmster/also_purchased-english.cache19): failed to open stream: No such file or directory
File: includes/functions/cache.php
Line: 28
Error: fopen(/tmp/jholmster/product_info.php-products_id-19-language-english-currency-USD.page.cache): failed to open stream: No such file or directory
File: includes/functions/cache.php
Line: 28
Error: error_log(/tmp/jholmster/page_parse_time.log): failed to open stream: No such file or directory
File: includes/application_bottom.php
Line: 20