Home Frequently Asked Questions Sunday, 23 November 2008

Main Menu Home Our Online-Shop Testimonials Frequently Asked Questions Contact Us Links Link to Us Online-Shop Baby Birth Announcements Twin Baby Birth Announcements Baby Shower Invitations Baptism and Christening Invitations Birthday Invitations Quinceanera Invitations Graduation Announcements and Invitations Thank you and Note Cards Holidays Throughout the Year List All Products Product Search Advanced Search Username Password Lost your Password? No account yet? Register Submit Your Photos To Submit Your Photos, email them to This e-mail address is being protected from spam bots, you need JavaScript enabled to view it Please note that professional photos require written release from the photographer or photo studio.  No exceptions.       Facts and Questions Filter     Order  Title asc Title desc Hits asc Hits desc Ordering    Display #  5 10 15 20 25 30 50 Item Title Hits Text Examples Anniversary Invitations 53 Text Examples Quinceanera 74 Text Examples First Holy Communion 63 Text Examples Christmas 152 Text Examples Wedding 58 Text Examples Graduation 66 Text Examples Twins 71 Text Examples Thank you / note card 111 Text Examples Shower 78 Text Examples Birthday 85 Text Examples Baptism 133 Text Examples Birth 470   << Start < Prev 1 Next > End >> Results 1 - 12 of 12 FAQ's  ( 12 items ) Here are just a few of our Frequently Asked Questions: [ Back ]   Random Products Traditional Valentine Announcement A $1.15 Traditional Birthday Invitation C $1.85   Your Cart Show Cart Your Cart is currently empty. Product Scroller Classic Baptism / Christening Invitations E Graduation Card D Theme Baby Shower Invitation C Theme Thank You Card C Twin Photo Birth Announcement E Like our site? Tell a Friend! Help us to spread the word to all of your friends! Contact Us 1 (209) 524-1580 Monday ~ Thursday 9 am ~ 5 pm PST Friday ~ 9 - Noon Excluding Holidays       Testimonials “We got the invitations on thursday and they are great thank for doing a wonderful job. We will be ordering thank cards also and will recommend you. ” Lees Summit, Missouri

Home | Our Online-Shop | Testimonials | Frequently Asked Questions | Contact Us | Links | Link to Us

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 ((`name` LIKE '%Table%') AND (`published` > 0))
4
SELECT oldurl, newurl FROM jos_redirection WHERE oldurl = 'Table/Frequently-Asked-Questions/Facts-and-Questions/' ORDER BY rank ASC LIMIT 1
5
UPDATE jos_redirection SET cpt=(cpt+1) WHERE `newurl` = 'index.php?option=com_content&Itemid=36&id=4&lang=en§ionid=3&task=category' AND `oldurl` = 'Table/Frequently-Asked-Questions/Facts-and-Questions/'
6
SELECT template
 FROM jos_templates_menu
 WHERE client_id = 0
 AND ( menuid = 0  OR menuid = 36 )
 ORDER BY menuid DESC
LIMIT 1
7
DELETE FROM jos_session
 WHERE (
 ( time < '1227441471' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1227441471' )
 AND guest = 1
 AND userid = 0
 )
8
SELECT *
 FROM jos_menu
 WHERE id = 36
9
SELECT *
 FROM jos_categories
 WHERE id = '4'
10
SELECT *
 FROM jos_sections
 WHERE id = '3'
11
SELECT c.*, COUNT( b.id ) AS numitems
 FROM jos_categories AS c
 LEFT JOIN jos_content AS b ON b.catid = c.id 
 AND b.state = 1
 AND ( b.publish_up = '0000-00-00 00:00:00' OR b.publish_up <= '2008-11-23 06:12' )
 AND ( b.publish_down = '0000-00-00 00:00:00' OR b.publish_down >= '2008-11-23 06:12' )
 AND b.access <= 0
 WHERE c.section = '3'
 AND c.published = 1
 AND c.access <= 0
 GROUP BY c.id
 HAVING COUNT( b.id ) > 0
 ORDER BY c.ordering
12
SELECT COUNT(a.id) as numitems
 FROM jos_content AS a
 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.catid = 4
 AND a.state = 1
 AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2008-11-23 06:12' )
 AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2008-11-23 06:12' )
 AND a.access <= 0
 AND 0 <= 0
 ORDER BY a.created DESC
13
SELECT a.id, a.title, a.hits, a.created_by, a.created_by_alias, a.created AS created, a.access, u.name AS author, a.state, g.name AS groups
 FROM jos_content AS a
 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.catid = 4
 AND a.state = 1
 AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2008-11-23 06:12' )
 AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2008-11-23 06:12' )
 AND a.access <= 0
 AND 0 <= 0
 ORDER BY a.created DESC
LIMIT 50
14
SELECT `id`,`link` FROM jos_menu where ((`menutype`='mainmenu') AND (`published` > 0) AND (`access` >= '0')) ORDER BY parent, ordering
15
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'
16
SELECT * FROM jos_menu WHERE menutype = 'mainmenu' AND published ='1' AND parent = '0' ORDER BY ordering
17
SELECT id, name, link, parent, type, menutype, access
 FROM jos_menu
 WHERE published = 1
 AND access <= 0
 ORDER BY menutype, parent, ordering
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 = 36 )
 ORDER BY ordering
19
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'mainmenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
20
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_linx&Itemid=39&lang=en'
21
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);
22
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'
23
SELECT `name` FROM `jos_core_acl_aro_groups` WHERE `group_id` =29
24
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

GROUP BY g1.name
ORDER BY g1.lft
25
SELECT `lft`, `rgt` FROM `jos_core_acl_aro_groups` WHERE `name`='Public Backend'
26
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
27
SELECT id FROM jos_menu WHERE link='index.php?option=com_virtuemart' AND published=1 AND access=0
28
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
29
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 != ''
30
SELECT folder, element, published, params
 FROM jos_mambots
 WHERE access <= 0
 AND folder = 'content'
 ORDER BY ordering
31
SELECT params
 FROM jos_mambots
 WHERE element = 'mosemailcloak'
 AND folder = 'content'
32
SELECT COUNT(*) AS numrows
 FROM jos_banner
 WHERE showBanner = 1
33
SELECT *
 FROM jos_banner
 WHERE showBanner = 1
LIMIT 1
34
SELECT DISTINCT product_sku FROM jos_vm_product WHERE product_parent_id='' AND vendor_id='1' AND jos_vm_product.product_publish='Y' ORDER BY product_name DESC
35
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='Item # TVAA'
36
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='129' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
37
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`='129'
38
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='129'
39
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='129' AND (start_date<='1227442372' OR start_date=0) AND (end_date>='1227418560' OR end_date=0) AND product_discount_id=discount_id
40
SELECT vendor_id FROM jos_vm_product WHERE product_id='129'
41
SELECT shopper_group_id,shopper_group_discount FROM jos_vm_shopper_group WHERE vendor_id='1' AND `default`='1'
42
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='129'
43
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='129' 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
44
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='129'
45
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='129' AND shopper_group_id='5'  ORDER BY price_quantity_start
46
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='Item # TBDIC'
47
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='103' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
48
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`='103'
49
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='103'
50
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='103' AND (start_date<='1227442372' OR start_date=0) AND (end_date>='1227418560' OR end_date=0) AND product_discount_id=discount_id
51
SELECT vendor_id FROM jos_vm_product WHERE product_id='103'
52
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='103'
53
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='103' 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
54
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='103'
55
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='103' AND shopper_group_id='5'  ORDER BY price_quantity_start
56
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
57
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='Item # CBIE'
58
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='134' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
59
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`='134'
60
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='Item # GAD'
61
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='86' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
62
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`='86'
63
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='Item # THBSIC'
64
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='62' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
65
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`='62'
66
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='Item # TTYCC'
67
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='111' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
68
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`='111'
69
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='Item # TWAE'
70
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='20' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
71
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`='20'
72
SELECT * FROM jos_equotes 
			WHERE published = 1 
			AND publish_up <= now() 
			AND (publish_down > now() OR publish_down = "0000-00-00 00:00:00")