VacationsPromotions.com Home of FunGetAways Contact Us Travel News Travel Links Home Vacation Specials Main Menu Home Contact Us Vacation Packages Hotel Reservations Travel Insurance Travel Information Airport Conditions Weather Information Airport Maps Travel Checklist Currency Converter Airline Seat Maps Airport Codes Flight Tracker World Time Zones FareWatch Security Wait Times Syndicate   Home Welcome To FunGetaways Written by FunGetAways    Saturday, 01 September 2007 Welcome to FunGetAways!!  The travel site designed to provide you all you need to save you money and time in planning that next great trip. As our desire here at FunGetAways is to assist you in every way that we can in making your travel experience the best possible, you will soon be able to book your Air Travel, Hotel Stays, Car Rentals, all at great money saving discounts right here at our site. IMPORTANT: Please be advised that FunGetAways is not associated in any way with Vacation Promotions -  New Port Richey, FL. Inquiries regarding refunds  on purchases made from Vacation Promotions should be directed to  Vacation Promotions 6014 US Hwy 19, Ste 100, New Port Richey, FL 34652 -(800) 684-2058 -  We are also including a great information section to aid you in convenient and safe travel.  In the future we will also be offering Cruise and Travel packages, so you want to bookmark our site as your first stop before you plan your  next trip or vacation.  Make sure you check out our Information Section.  There you will find important informational links  and articles all designed to save you time and money. For you business owners and Charity Fund Raisers - Make sure you check out our Certificates for Cash Saver Vacations, in 20 different fun filled locations, at a price you won't believe. Three Days and Two Nights Hotel Stay in Great Spots like, Las Vegas, Laughlin, Reno, Lake Tahoe, Daytona Beach, Atlantic City, Cancun, Mexico just to mention a few.  Just go to our online store for more information and pricing.  The cost is very inexpensive and provides a great promotional tool to attract and retain customers for your business and charities. We are still adding new services daily so be sure to check back often to see our latest travel offers.  If you don't see what you need right away, email us.  Let us know how we can help you plan your next trip, whether it be traveling through out the US or Abroad.  We are here to meet your needs. The staff at FunGetAways   Be Sure To Check Out FunGetAways Travel Club for more Great Travel Packages     Last Updated ( Wednesday, 07 November 2007 )   Newsflash Product Scroller 500 Mini Vacation Certificates $199.00 Add to Cart 100 Mini Vacation Certificates $43.30 Add to Cart 1000 Mini Vacation Certificates $349.00 Add to Cart Your Cart Show Cart Your Cart is currently empty. Shop Online Vacation Certificates List All Products Product Search Advanced Search Username Password Lost your Password? No account yet? Register Who's Online   © 2010 VacationsPromotions.com Joomla! is Free Software released under the GNU/GPL License.

1
SET sql_mode = 'MYSQL40'
2
SELECT folder, element, published, params
 FROM jos_mambots
 WHERE published >= 1
 AND access <= 0
 AND folder = 'system'
 ORDER BY ordering
3
SELECT id, link
 FROM jos_menu
 WHERE menutype = 'mainmenu'
 AND published = 1
 ORDER BY parent, ordering
LIMIT 1
4
SELECT template
 FROM jos_templates_menu
 WHERE client_id = 0
 AND ( menuid = 0  OR menuid = 1 )
 ORDER BY menuid DESC
LIMIT 1
5
DELETE FROM jos_session
 WHERE (
 ( time < '1268190193' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1268190193' )
 AND guest = 1
 AND userid = 0
 )
6
SELECT *
 FROM jos_menu
 WHERE id = 1
7
SELECT COUNT(a.id)
 FROM jos_content AS a
 INNER JOIN jos_content_frontpage AS f ON f.content_id = a.id
 INNER JOIN jos_categories AS cc ON cc.id = a.catid
 INNER JOIN jos_sections AS s ON s.id = a.sectionid
 LEFT JOIN jos_users AS u ON u.id = a.created_by
 LEFT JOIN jos_groups AS g ON a.access = g.id
 WHERE a.state = 1
 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2010-03-09 20:18' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-03-09 20:18' )
 AND s.published = 1
 AND cc.published = 1
 AND a.access <= 0
 AND s.access <= 0
 AND cc.access <= 0
8
SELECT a.id, a.title, a.title_alias, a.introtext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by,
 a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.ordering, a.metakey, a.metadesc, a.access, a.hits,
 CHAR_LENGTH( a.fulltext ) AS readmore, u.name AS author, u.usertype, s.name AS section, cc.name AS category, g.name AS groups
, s.id AS sec_id, cc.id as cat_id
 FROM jos_content AS a
 INNER JOIN jos_content_frontpage AS f ON f.content_id = a.id
 INNER JOIN jos_categories AS cc ON cc.id = a.catid
 INNER JOIN jos_sections AS s ON s.id = a.sectionid
 LEFT JOIN jos_users AS u ON u.id = a.created_by
 LEFT JOIN jos_groups AS g ON a.access = g.id
 WHERE a.state = 1
 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2010-03-09 20:18' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-03-09 20:18' )
 AND s.published = 1
 AND cc.published = 1
 AND a.access <= 0
 AND s.access <= 0
 AND cc.access <= 0
 ORDER BY  f.ordering
LIMIT 4
9
SELECT folder, element, published, params
 FROM jos_mambots
 WHERE access <= 0
 AND folder = 'content'
 ORDER BY ordering
10
SELECT vendor_id, vendor_min_pov,vendor_name,vendor_store_name,contact_email,vendor_full_image, vendor_freeshipping,
			vendor_address_1, vendor_city, vendor_state, vendor_country, country_2_code, country_3_code,
			vendor_zip, vendor_phone, vendor_store_desc, vendor_currency, vendor_currency_display_style
		FROM (`jos_vm_vendor`, `jos_vm_country`)
		WHERE `vendor_id`=1
		AND (vendor_country=country_2_code OR vendor_country=country_3_code);
11
SELECT jos_vm_shopper_group.shopper_group_id, show_price_including_tax, `default`, shopper_group_discount 
    		FROM `jos_vm_shopper_group` WHERE jos_vm_shopper_group.vendor_id='1' AND `default`='1'
12
SELECT `name` FROM `jos_core_acl_aro_groups` WHERE `group_id` =29
13
SELECT `lft`, `rgt` FROM `jos_core_acl_aro_groups` WHERE `name`='Public Frontend'
14
SELECT g1.group_id, g1.name, COUNT(g2.name) AS level
FROM jos_core_acl_aro_groups AS g1
INNER JOIN jos_core_acl_aro_groups AS g2 ON g1.lft BETWEEN g2.lft AND g2.rgt
WHERE g1.lft BETWEEN 3 AND 12
GROUP BY g1.name
ORDER BY g1.lft
15
SELECT `lft`, `rgt` FROM `jos_core_acl_aro_groups` WHERE `name`='Public Backend'
16
SELECT g1.group_id, g1.name, COUNT(g2.name) AS level
FROM jos_core_acl_aro_groups AS g1
INNER JOIN jos_core_acl_aro_groups AS g2 ON g1.lft BETWEEN g2.lft AND g2.rgt
WHERE g1.lft BETWEEN 13 AND 20
GROUP BY g1.name
ORDER BY g1.lft
17
SELECT a.*
 FROM jos_components AS a
 WHERE ( a.admin_menu_link = 'option=com_syndicate' OR a.admin_menu_link = 'option=com_syndicate&hidemainmenu=1' )
 AND a.option = 'com_syndicate'
18
SELECT id, title, module, position, content, showtitle, params
 FROM jos_modules AS m
 INNER JOIN jos_modules_menu AS mm ON mm.moduleid = m.id
 WHERE m.published = 1
 AND m.access <= 0
 AND m.client_id != 1
 AND ( mm.menuid = 0 OR mm.menuid = 1 )
 ORDER BY ordering
19
SELECT id
 FROM jos_menu
 WHERE link = 'index.php?option=com_search'
 AND published = 1
20
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'topmenu'
 AND published = 1
 AND access <= 0
 AND parent = 0
 ORDER BY ordering
21
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'mainmenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
22
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'information'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
23
SELECT COUNT( id )
 FROM jos_menu 
 WHERE type = 'content_item_link'
 AND published = 1
24
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=17'
25
SELECT id, name, link, parent, type, menutype, access
 FROM jos_menu
 WHERE published = 1
 AND access <= 0
 ORDER BY menutype, parent, ordering
26
SELECT a.id, a.introtext, a.fulltext , a.images, a.attribs, a.title, a.state
 FROM jos_content AS a
 INNER JOIN jos_categories AS cc ON cc.id = a.catid
 INNER JOIN jos_sections AS s ON s.id = a.sectionid
 WHERE a.state = 1
 AND a.access <= 0 AND cc.access <= 0 AND s.access <= 0
 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2010-03-09 20:18' ) 
 AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-03-09 20:18' )
 AND a.catid = 0
 AND cc.published = 1
 AND s.published = 1
 ORDER BY a.ordering
27
SELECT p.product_sku FROM jos_vm_product AS p
 WHERE p.product_publish = 'Y' AND product_parent_id=0 
 ORDER BY RAND() LIMIT 5
28
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='B-500_certs'
29
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='23' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
30
SELECT
                                `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                `jos_vm_category`.`category_flypage`
                        FROM
                                `jos_vm_product`

                        LEFT JOIN `jos_vm_product_category_xref` ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                        LEFT JOIN `jos_vm_category` ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`

                        WHERE `jos_vm_product`.`product_id`='23'
31
SELECT id FROM jos_menu WHERE link='index.php?option=com_virtuemart' AND published=1 AND access=0
32
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='23'
33
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='23' AND (start_date<='1268191093' OR start_date=0) AND (end_date>='1268116560' OR end_date=0) AND product_discount_id=discount_id
34
SELECT vendor_id FROM jos_vm_product WHERE product_id='23'
35
SELECT shopper_group_id,shopper_group_discount FROM jos_vm_shopper_group WHERE vendor_id='1' AND `default`='1'
36
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='23'
37
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='23' AND shopper_group_id='5'  AND (('0' >= price_quantity_start AND '0' <= price_quantity_end)
                                OR (price_quantity_end='0') OR ('0' > price_quantity_end)) ORDER BY price_quantity_end DESC
38
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='23'
39
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='23' AND shopper_group_id='5'  ORDER BY price_quantity_start
40
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='23'
41
SELECT tax_rate FROM jos_vm_vendor, jos_vm_tax_rate WHERE tax_country=vendor_country AND jos_vm_vendor.vendor_id='1' ORDER BY `tax_rate` DESC
42
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='A-100_certs'
43
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='22' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
44
SELECT
                                `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                `jos_vm_category`.`category_flypage`
                        FROM
                                `jos_vm_product`

                        LEFT JOIN `jos_vm_product_category_xref` ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                        LEFT JOIN `jos_vm_category` ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`

                        WHERE `jos_vm_product`.`product_id`='22'
45
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='22'
46
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='22' AND (start_date<='1268191093' OR start_date=0) AND (end_date>='1268116560' OR end_date=0) AND product_discount_id=discount_id
47
SELECT vendor_id FROM jos_vm_product WHERE product_id='22'
48
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='22'
49
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='22' AND shopper_group_id='5'  AND (('0' >= price_quantity_start AND '0' <= price_quantity_end)
                                OR (price_quantity_end='0') OR ('0' > price_quantity_end)) ORDER BY price_quantity_end DESC
50
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='22'
51
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='22' AND shopper_group_id='5'  ORDER BY price_quantity_start
52
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='22'
53
SELECT tax_rate FROM jos_vm_vendor, jos_vm_tax_rate WHERE tax_country=vendor_country AND jos_vm_vendor.vendor_id='1' ORDER BY `tax_rate` DESC
54
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='C-1000_certs'
55
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='24' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
56
SELECT
                                `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                `jos_vm_category`.`category_flypage`
                        FROM
                                `jos_vm_product`

                        LEFT JOIN `jos_vm_product_category_xref` ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                        LEFT JOIN `jos_vm_category` ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`

                        WHERE `jos_vm_product`.`product_id`='24'
57
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='24'
58
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='24' AND (start_date<='1268191093' OR start_date=0) AND (end_date>='1268116560' OR end_date=0) AND product_discount_id=discount_id
59
SELECT vendor_id FROM jos_vm_product WHERE product_id='24'
60
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='24'
61
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='24' AND shopper_group_id='5'  AND (('0' >= price_quantity_start AND '0' <= price_quantity_end)
                                OR (price_quantity_end='0') OR ('0' > price_quantity_end)) ORDER BY price_quantity_end DESC
62
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='24'
63
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='24' AND shopper_group_id='5'  ORDER BY price_quantity_start
64
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='24'
65
SELECT tax_rate FROM jos_vm_vendor, jos_vm_tax_rate WHERE tax_country=vendor_country AND jos_vm_vendor.vendor_id='1' ORDER BY `tax_rate` DESC
66
SELECT category_id, category_description, category_name,category_child_id as cid, category_parent_id as pid,list_order, category_publish
						FROM jos_vm_category, jos_vm_category_xref WHERE jos_vm_category.category_publish='Y' AND jos_vm_category.category_id=jos_vm_category_xref.category_child_id ORDER BY jos_vm_category.list_order ASC, jos_vm_category.category_name ASC
67
SELECT jos_users.id, jos_vm_user_info.user_id from jos_users, jos_vm_user_info 
					WHERE jos_users.id='0' AND jos_users.id=jos_vm_user_info.user_id 
					AND jos_vm_user_info.address_type='BT' AND jos_vm_user_info.first_name != '' 
					AND jos_vm_user_info.last_name != '' AND jos_vm_user_info.city != ''
68
SELECT guest, usertype
 FROM jos_session