Home Baby Birth Announcements Classic Birth Announcements Classic Birth Announcements A 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.       Info: Your browser does not accept cookies. If you want to put products into your cart and purchase them you need to enable cookies. Info: To add this product into your cart you have to select a product variant on the details page. Baby Birth Announcements Classic Birth Announcements Classic Birth Announcements A Classic Birth Announcements A Price: $1.34  Birth announcment slim card with bow.   Our Slim cards measure a whopping 9.25 inches tall and a slim 4.25 inches wide.  Features your baby's birth information and a cute little clip art bow, rattle or rocking horse.  Colors inclulde, pink, blue, green, lavender, black or red border and bow.   Font Examples:   Text Examples: CLICK HERE FOR SOME TEXT EXAMPLES Font Choice: AmazoneAntiqueBernhardBickleyCaligulaCantenaoCaslonChaucerComicEnglishFreehandGaramondGrailHarringtonHogarthLucidiaMonotypeNuptialOttumAntiqueStarbabeTiranti Font for Name if different: NoneAmazoneAntiqueBernhardBickleyCaligulaCantenaoCaslonChaucerComicEnglishFreehandGaramondGrailHarringtonHogarthLucidiaMonotypeNuptialOttumAntiqueStarbabeTiranti Border Color: Pastel Pink Pastel Blue Dark Blue Red Pastel Green Dark Green Lavender Black Color Printing of Text: None yes  ( + $0.28 ) Ribbon Assembly: None yes  ( + $0.28 ) Opening Line: Baby's Name: Birth / Adoption Date: Birth Time: Birth Weight: Birth Length: Closing Line: Parent's Name: Quantity:   You may also be interested in this/these product(s): Photo Birth Announcements B $2.40 Add to Cart Sibling Photo Birth Announcements A $2.40 Add to Cart Photo Baby Shower Invitation B $2.40 Add to Cart Insert Card B $0.42 Add to Cart   Random Products Baptism / Christening Invitations A $2.40 Photo Birth Announcements E $2.40   Your Cart Show Cart Your Cart is currently empty. Product Scroller Photo Vellum Valentine Card Style A Response Card C Insert Card C Classic Birthday Invitation A Photo Birth Announcements A 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 received the invitations in the mail yesterday and we are very pleased. They look great and thank you for sending them so quick.” Haddam, Connecticut

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 '%Add item to your cart%') AND (`published` > 0))
4
SELECT oldurl, newurl FROM jos_redirection WHERE oldurl = 'Add-item-to-your-cart/index.php' ORDER BY rank ASC LIMIT 1
5
UPDATE jos_redirection SET cpt=(cpt+1) WHERE `newurl` = '' AND `oldurl` = 'Add-item-to-your-cart/index.php'
6
SELECT template
 FROM jos_templates_menu
 WHERE client_id = 0
 AND ( menuid = 0  OR menuid = 26 )
 ORDER BY menuid DESC
LIMIT 1
7
DELETE FROM jos_session
 WHERE (
 ( time < '1227440720' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1227440720' )
 AND guest = 1
 AND userid = 0
 )
8
SELECT *
 FROM jos_menu
 WHERE id = 26
9
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);
10
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'
11
SELECT `name` FROM `jos_core_acl_aro_groups` WHERE `group_id` =29
12
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
13
SELECT `lft`, `rgt` FROM `jos_core_acl_aro_groups` WHERE `name`='Public Backend'
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 13 AND 20
GROUP BY g1.name
ORDER BY g1.lft
15
SELECT * FROM jos_vm_function WHERE LOWER(function_name)='cartadd'
16
SELECT module_perms FROM jos_vm_module where module_name='shop'
17
SELECT jos_vm_module.module_name,jos_vm_function.function_class FROM jos_vm_module,jos_vm_function WHERE jos_vm_module.module_id=jos_vm_function.module_id AND jos_vm_function.function_method='add' AND jos_vm_function.function_class='ps_cart'
18
SELECT id FROM jos_menu WHERE link='index.php?option=com_virtuemart' AND published=1 AND access=0
19
SELECT product_id FROM jos_vm_product WHERE product_parent_id = '11'
20
SELECT product_id, attribute, custom_attribute FROM jos_vm_product WHERE product_id='11'
21
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`='11'
22
SELECT affiliate_id,rate,company,user_email FROM `jos_vm_affiliate`, `jos_vm_user_info` WHERE jos_vm_affiliate.user_id = jos_vm_user_info.user_info_id AND jos_vm_user_info.user_id = '0'
23
SELECT visit_id FROM jos_vm_visit WHERE visit_id = '20e6rrtufmtfqm2mdk6ncbaa13'
24
INSERT INTO jos_vm_visit (visit_id, affiliate_id,pages,entry_page,exit_page,sdate,edate) VALUES ('20e6rrtufmtfqm2mdk6ncbaa13','','1','shop.product_details','shop.product_details','1227441620','1227441620')
25
SELECT * FROM `jos_vm_product` WHERE `product_id`=11 AND `product_publish`='Y'
26
SELECT COUNT(file_id) AS images FROM jos_vm_product_files WHERE file_product_id=11 AND file_is_image=1
27
SELECT product_sku, related_products FROM jos_vm_product,jos_vm_product_relations WHERE jos_vm_product_relations.product_id='11' AND product_publish='Y' AND FIND_IN_SET(jos_vm_product.product_id, REPLACE(related_products, '|', ',' )) LIMIT 0, 4
28
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='Item # PAB'
29
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='2' 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`='2'
31
SELECT `id`,`link` FROM jos_menu where ((`menutype`='mainmenu') AND (`published` > 0) AND (`access` >= '0')) ORDER BY parent, ordering
32
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='2'
33
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='2' AND (start_date<='1227441620' OR start_date=0) AND (end_date>='1227418560' OR end_date=0) AND product_discount_id=discount_id
34
SELECT vendor_id FROM jos_vm_product WHERE product_id='2'
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='2'
37
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='2' 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='2'
39
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='2' AND shopper_group_id='5'  ORDER BY price_quantity_start
40
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='Item # SBA'
41
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='8' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
42
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`='8'
43
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='8'
44
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='8' AND (start_date<='1227441620' OR start_date=0) AND (end_date>='1227418560' OR end_date=0) AND product_discount_id=discount_id
45
SELECT vendor_id FROM jos_vm_product WHERE product_id='8'
46
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='8'
47
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='8' 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
48
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='8'
49
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='8' AND shopper_group_id='5'  ORDER BY price_quantity_start
50
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='Item # PBSIB'
51
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='66' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
52
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`='66'
53
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='66'
54
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='66' AND (start_date<='1227441620' OR start_date=0) AND (end_date>='1227418560' OR end_date=0) AND product_discount_id=discount_id
55
SELECT vendor_id FROM jos_vm_product WHERE product_id='66'
56
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='66'
57
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='66' 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
58
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='66'
59
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='66' AND shopper_group_id='5'  ORDER BY price_quantity_start
60
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='Item # ISCB'
61
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='79' 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`='79'
63
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='79'
64
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='79' AND (start_date<='1227441620' OR start_date=0) AND (end_date>='1227418560' OR end_date=0) AND product_discount_id=discount_id
65
SELECT vendor_id FROM jos_vm_product WHERE product_id='79'
66
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='79'
67
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='79' 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
68
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='79'
69
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='79' AND shopper_group_id='5'  ORDER BY price_quantity_start
70
SELECT category_id FROM jos_vm_product_category_xref WHERE product_id = '11' LIMIT 0,1
71
SELECT category_id, category_name,category_parent_id FROM jos_vm_category, jos_vm_category_xref WHERE jos_vm_category_xref.category_child_id='28' AND jos_vm_category.category_id='28'
72
SELECT category_id, category_name,category_parent_id FROM jos_vm_category, jos_vm_category_xref WHERE jos_vm_category_xref.category_child_id='24' AND jos_vm_category.category_id='24'
73
SELECT category_child_id FROM jos_vm_category_xref WHERE category_parent_id='28'
74
SELECT manufacturer_id FROM jos_vm_product_mf_xref WHERE product_id='11'
75
SELECT mf_name,jos_vm_manufacturer.manufacturer_id FROM jos_vm_product_mf_xref,jos_vm_manufacturer WHERE product_id='11' AND jos_vm_manufacturer.manufacturer_id=jos_vm_product_mf_xref.manufacturer_id
76
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='11'
77
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='11' AND (start_date<='1227441620' OR start_date=0) AND (end_date>='1227418560' OR end_date=0) AND product_discount_id=discount_id
78
SELECT vendor_id FROM jos_vm_product WHERE product_id='11'
79
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='11'
80
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='11' 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
81
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='11'
82
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='11' AND shopper_group_id='5'  ORDER BY price_quantity_start
83
SELECT attribute_value FROM jos_vm_product_attribute WHERE `product_id` = '11' AND attribute_name='download'
84
SELECT DISTINCT file_id, file_mimetype, file_title, file_name FROM `jos_vm_product_files` WHERE file_product_id = '11' AND file_published = '1' AND file_is_image = '0'
85
SELECT product_id as num_rows FROM jos_vm_product WHERE product_parent_id='11'
86
SELECT product_available_date,product_availability,product_in_stock  FROM jos_vm_product WHERE product_id='11'
87
SELECT product_id,product_name FROM jos_vm_product WHERE product_parent_id='11' AND product_publish='Y'
88
SELECT product_parent_id FROM jos_vm_product WHERE product_id='11'
89
SELECT product_id,product_name FROM jos_vm_product WHERE product_parent_id='0' AND product_parent_id<>0 AND product_publish='Y'
90
SELECT product_id, attribute FROM jos_vm_product WHERE product_id='11'
91
SELECT product_id, custom_attribute from jos_vm_product WHERE product_id='11'
92
SELECT jos_vm_vendor.vendor_name FROM jos_vm_product, jos_vm_vendor WHERE jos_vm_product.product_id='11' AND jos_vm_vendor.vendor_id=jos_vm_product.vendor_id
93
SELECT * FROM jos_vm_product_product_type_xref WHERE product_id='11'
94
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'
95
SELECT * FROM jos_menu WHERE menutype = 'mainmenu' AND published ='1' AND parent = '0' ORDER BY ordering
96
SELECT id, name, link, parent, type, menutype, access
 FROM jos_menu
 WHERE published = 1
 AND access <= 0
 ORDER BY menutype, parent, ordering
97
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 = 26 )
 ORDER BY ordering
98
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'mainmenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
99
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_linx&Itemid=39&lang=en'
100
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
101
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 != ''
102
SELECT folder, element, published, params
 FROM jos_mambots
 WHERE access <= 0
 AND folder = 'content'
 ORDER BY ordering
103
SELECT params
 FROM jos_mambots
 WHERE element = 'mosemailcloak'
 AND folder = 'content'
104
SELECT COUNT(*) AS numrows
 FROM jos_banner
 WHERE showBanner = 1
105
SELECT *
 FROM jos_banner
 WHERE showBanner = 1
LIMIT 1
106
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
107
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='Item # BIA'
108
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='108' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
109
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`='108'
110
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='108'
111
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='108' AND (start_date<='1227441621' OR start_date=0) AND (end_date>='1227418560' OR end_date=0) AND product_discount_id=discount_id
112
SELECT vendor_id FROM jos_vm_product WHERE product_id='108'
113
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='108'
114
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='108' 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
115
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='108'
116
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='108' AND shopper_group_id='5'  ORDER BY price_quantity_start
117
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='Item # PAE'
118
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='5' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
119
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`='5'
120
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='5'
121
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='5' AND (start_date<='1227441621' OR start_date=0) AND (end_date>='1227418560' OR end_date=0) AND product_discount_id=discount_id
122
SELECT vendor_id FROM jos_vm_product WHERE product_id='5'
123
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='5'
124
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='5' 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
125
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='5'
126
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='5' AND shopper_group_id='5'  ORDER BY price_quantity_start
127
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
128
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='PVCA'
129
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='127' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
130
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`='127'
131
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='Item # RSPCC'
132
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='83' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
133
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`='83'
134
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='Item # ISCC'
135
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='80' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
136
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`='80'
137
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='Item #CBDIA'
138
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='104' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
139
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`='104'
140
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='Item # PAA'
141
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='1' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
142
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`='1'
143
SELECT * FROM jos_equotes 
			WHERE published = 1 
			AND publish_up <= now() 
			AND (publish_down > now() OR publish_down = "0000-00-00 00:00:00")