• Home
• Product Catalog
• Upcoming Events
• FAQ
• Contact Us

OOPS. Your Flash player is missing or outdated.Click here to update your player so you can see this content.

 

Debug: A Cookie had to be set to keep the session (there was none - does your Browser keep the Cookie?) although a Session already has been started! If you see this message on each page load, your browser doesn't accept Cookies from this site.

Debug: calculating tax based on vendor address

BICHON

$15.00
Add to Cart

SHAR-PEI

$55.00
Add to Cart

PITBULL ALL BROWN

$55.00
Add to Cart

POMERANIAN

$55.00
Add to Cart

ROT

$30.00
Add to Cart

GERMAN SHEPARD

$55.00
Add to Cart

POODLE WHITE

$55.00
Add to Cart

PUG

$35.00
Add to Cart

PEKINGESE

$60.00
Add to Cart

BEAGLE

$35.00
Add to Cart

YELLOW LAB

$30.00
Add to Cart

WESTIE

$55.00
Add to Cart

SHITZU

$35.00
Add to Cart

GOLDEN RETRIVER

$55.00
Add to Cart

HUSKY

$55.00
Add to Cart

BOSTON TERRIER

$15.00
Add to Cart

TIGER CAT

$45.00
Add to Cart

SHITZU MALE

$55.00
Add to Cart

JACK RUSSELL

$55.00
Add to Cart

BICHON

$35.00
Add to Cart

NEW FOUNDLAND

$55.00
Add to Cart

SHITZU

$35.00
Add to Cart

SCHAUZER

$25.00
Add to Cart

SCOTTIE

$35.00
Add to Cart

FRENCH BULLDOG

$55.00
Add to Cart

SPRINGER SPANIEL

$55.00
Add to Cart

CHIHUAHUA SHORT HAIR

$55.00
Add to Cart

YORKY

$35.00
Add to Cart

GERMAN SHEPARD

$25.00
Add to Cart

CAT6

$45.00
Add to Cart

SCHAUZER

$55.00
Add to Cart

PUG

$25.00
Add to Cart

PUG FAWN

$55.00
Add to Cart

MOUNTAIN BERNESE

$55.00
Add to Cart

POMERIAN BLACK

$55.00
Add to Cart

CORGI PEMBROOKE

$55.00
Add to Cart

Boxer (Ears)

$55.00
Add to Cart

YORKY

$35.00
Add to Cart

YORKY

$35.00
Add to Cart

BECHON

$35.00
Add to Cart

SCOTTIE TERRIER

$55.00
Add to Cart

ALL BLACK

$45.00
Add to Cart

BEAGLE

$35.00
Add to Cart

BULLDOG

$60.00
Add to Cart

Boxer

$55.00
Add to Cart

Main

Welcome to welcomedog.com! Saturday, 12 June 2004 Welcomedog.com has a great selection of ceramic resin products for use indoors or even outdoors. Our collection of products do not melt or fade. Check out our collection of dogs, cats, door stoppers, planters, and much more! Last Updated ( Sunday, 11 February 2007 )

Polls

What is your favorite product?
Welcome Dogs Cats Door Stoppers Planters Bookends Playful Puppies

Search the Website

Product Search Advanced Search

Username Password

Lost your Password?

No account yet? Register

Show Cart

Your Cart is currently empty.

1
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);
2
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'
3
SELECT `name` FROM `jos_core_acl_aro_groups` WHERE `group_id` =29
4
SELECT `lft`, `rgt` FROM `jos_core_acl_aro_groups` WHERE `name`='Public Frontend'
5
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
6
SELECT `lft`, `rgt` FROM `jos_core_acl_aro_groups` WHERE `name`='Public Backend'
7
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
8
SELECT p.product_sku FROM jos_vm_product AS p
 WHERE p.product_publish = 'Y' AND product_parent_id=0 
 ORDER BY RAND() LIMIT 45
9
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='C'
10
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
11
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'
12
SELECT id FROM jos_menu WHERE link='index.php?option=com_virtuemart' AND published=1 AND access=0
13
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='111'
14
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='111' AND (start_date<='1329966508' OR start_date=0) AND (end_date>='1329892560' OR end_date=0) AND product_discount_id=discount_id
15
SELECT vendor_id FROM jos_vm_product WHERE product_id='111'
16
SELECT shopper_group_id,shopper_group_discount FROM jos_vm_shopper_group WHERE vendor_id='1' AND `default`='1'
17
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='111'
18
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='111' 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
19
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='111'
20
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='111' AND shopper_group_id='5'  ORDER BY price_quantity_start
21
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='111'
22
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
23
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='JF4Y057-1'
24
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='48' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
25
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`='48'
26
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='48'
27
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='48' AND (start_date<='1329966508' OR start_date=0) AND (end_date>='1329892560' OR end_date=0) AND product_discount_id=discount_id
28
SELECT vendor_id FROM jos_vm_product WHERE product_id='48'
29
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='48'
30
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='48' 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
31
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='48'
32
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='48' AND shopper_group_id='5'  ORDER BY price_quantity_start
33
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='48'
34
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
35
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='Y4111607E'
36
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='39' 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`='39'
38
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='39'
39
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='39' AND (start_date<='1329966508' OR start_date=0) AND (end_date>='1329892560' OR end_date=0) AND product_discount_id=discount_id
40
SELECT vendor_id FROM jos_vm_product WHERE product_id='39'
41
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='39'
42
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='39' 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
43
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='39'
44
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='39' AND shopper_group_id='5'  ORDER BY price_quantity_start
45
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='39'
46
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
47
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='JF4Y018-3'
48
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='42' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
49
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`='42'
50
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='42'
51
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='42' AND (start_date<='1329966508' OR start_date=0) AND (end_date>='1329892560' OR end_date=0) AND product_discount_id=discount_id
52
SELECT vendor_id FROM jos_vm_product WHERE product_id='42'
53
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='42'
54
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='42' 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
55
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='42'
56
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='42' AND shopper_group_id='5'  ORDER BY price_quantity_start
57
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='42'
58
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
59
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='BOOKEND7'
60
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
61
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'
62
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='103'
63
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='103' AND (start_date<='1329966508' OR start_date=0) AND (end_date>='1329892560' OR end_date=0) AND product_discount_id=discount_id
64
SELECT vendor_id FROM jos_vm_product WHERE product_id='103'
65
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='103'
66
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
67
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='103'
68
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
69
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='103'
70
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
71
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='JF1G1620A'
72
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='28' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
73
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`='28'
74
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='28'
75
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='28' AND (start_date<='1329966508' OR start_date=0) AND (end_date>='1329892560' OR end_date=0) AND product_discount_id=discount_id
76
SELECT vendor_id FROM jos_vm_product WHERE product_id='28'
77
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='28'
78
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='28' 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
79
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='28'
80
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='28' AND shopper_group_id='5'  ORDER BY price_quantity_start
81
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='28'
82
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
83
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='JF4Y017-3'
84
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='55' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
85
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`='55'
86
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='55'
87
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='55' AND (start_date<='1329966508' OR start_date=0) AND (end_date>='1329892560' OR end_date=0) AND product_discount_id=discount_id
88
SELECT vendor_id FROM jos_vm_product WHERE product_id='55'
89
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='55'
90
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='55' 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
91
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='55'
92
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='55' AND shopper_group_id='5'  ORDER BY price_quantity_start
93
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='55'
94
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
95
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='STANDING'
96
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='64' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
97
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`='64'
98
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='64'
99
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='64' AND (start_date<='1329966508' OR start_date=0) AND (end_date>='1329892560' OR end_date=0) AND product_discount_id=discount_id
100
SELECT vendor_id FROM jos_vm_product WHERE product_id='64'
101
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='64'
102
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='64' 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
103
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='64'
104
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='64' AND shopper_group_id='5'  ORDER BY price_quantity_start
105
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='64'
106
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
107
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='TS6A107-1'
108
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='37' 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`='37'
110
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='37'
111
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='37' AND (start_date<='1329966508' OR start_date=0) AND (end_date>='1329892560' OR end_date=0) AND product_discount_id=discount_id
112
SELECT vendor_id FROM jos_vm_product WHERE product_id='37'
113
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='37'
114
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='37' 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='37'
116
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='37' AND shopper_group_id='5'  ORDER BY price_quantity_start
117
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='37'
118
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
119
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='STAND'
120
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='106' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
121
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`='106'
122
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='106'
123
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='106' AND (start_date<='1329966508' OR start_date=0) AND (end_date>='1329892560' OR end_date=0) AND product_discount_id=discount_id
124
SELECT vendor_id FROM jos_vm_product WHERE product_id='106'
125
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='106'
126
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='106' 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
127
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='106'
128
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='106' AND shopper_group_id='5'  ORDER BY price_quantity_start
129
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='106'
130
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
131
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='5 PLANTER'
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` FROM jos_vm_product WHERE product_id='83'
135
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='83' AND (start_date<='1329966508' OR start_date=0) AND (end_date>='1329892560' OR end_date=0) AND product_discount_id=discount_id
136
SELECT vendor_id FROM jos_vm_product WHERE product_id='83'
137
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='83'
138
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='83' 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
139
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='83'
140
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='83' AND shopper_group_id='5'  ORDER BY price_quantity_start
141
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='83'
142
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
143
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='JF2111635E'
144
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='54' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
145
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`='54'
146
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='54'
147
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='54' AND (start_date<='1329966508' OR start_date=0) AND (end_date>='1329892560' OR end_date=0) AND product_discount_id=discount_id
148
SELECT vendor_id FROM jos_vm_product WHERE product_id='54'
149
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='54'
150
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='54' 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
151
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='54'
152
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='54' AND shopper_group_id='5'  ORDER BY price_quantity_start
153
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='54'
154
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
155
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='4STANDING'
156
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
157
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'
158
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='86'
159
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='86' AND (start_date<='1329966508' OR start_date=0) AND (end_date>='1329892560' OR end_date=0) AND product_discount_id=discount_id
160
SELECT vendor_id FROM jos_vm_product WHERE product_id='86'
161
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='86'
162
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='86' 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
163
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='86'
164
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='86' AND shopper_group_id='5'  ORDER BY price_quantity_start
165
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='86'
166
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
167
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='JF2111611D'
168
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='29' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
169
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`='29'
170
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='29'
171
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='29' AND (start_date<='1329966508' OR start_date=0) AND (end_date>='1329892560' OR end_date=0) AND product_discount_id=discount_id
172
SELECT vendor_id FROM jos_vm_product WHERE product_id='29'
173
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='29'
174
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='29' 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
175
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='29'
176
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='29' AND shopper_group_id='5'  ORDER BY price_quantity_start
177
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='29'
178
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
179
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='Y5111602-1'
180
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='31' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
181
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`='31'
182
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='31'
183
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='31' AND (start_date<='1329966508' OR start_date=0) AND (end_date>='1329892560' OR end_date=0) AND product_discount_id=discount_id
184
SELECT vendor_id FROM jos_vm_product WHERE product_id='31'
185
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='31'
186
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='31' 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
187
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='31'
188
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='31' AND shopper_group_id='5'  ORDER BY price_quantity_start
189
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='31'
190
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
191
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='D'
192
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='113' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
193
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`='113'
194
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='113'
195
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='113' AND (start_date<='1329966508' OR start_date=0) AND (end_date>='1329892560' OR end_date=0) AND product_discount_id=discount_id
196
SELECT vendor_id FROM jos_vm_product WHERE product_id='113'
197
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='113'
198
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='113' 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
199
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='113'
200
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='113' AND shopper_group_id='5'  ORDER BY price_quantity_start
201
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='113'
202
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
203
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='JF3211202K'
204
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='95' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
205
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`='95'
206
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='95'
207
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='95' AND (start_date<='1329966508' OR start_date=0) AND (end_date>='1329892560' OR end_date=0) AND product_discount_id=discount_id
208
SELECT vendor_id FROM jos_vm_product WHERE product_id='95'
209
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='95'
210
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='95' 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
211
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='95'
212
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='95' AND shopper_group_id='5'  ORDER BY price_quantity_start
213
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='95'
214
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
215
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='Y7111604'
216
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='130' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
217
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`='130'
218
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='130'
219
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='130' AND (start_date<='1329966508' OR start_date=0) AND (end_date>='1329892560' OR end_date=0) AND product_discount_id=discount_id
220
SELECT vendor_id FROM jos_vm_product WHERE product_id='130'
221
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='130'
222
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='130' 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
223
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='130'
224
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='130' AND shopper_group_id='5'  ORDER BY price_quantity_start
225
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='130'
226
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
227
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='JF4Y022'
228
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='32' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
229
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`='32'
230
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='32'
231
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='32' AND (start_date<='1329966508' OR start_date=0) AND (end_date>='1329892560' OR end_date=0) AND product_discount_id=discount_id
232
SELECT vendor_id FROM jos_vm_product WHERE product_id='32'
233
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='32'
234
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='32' 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
235
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='32'
236
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='32' AND shopper_group_id='5'  ORDER BY price_quantity_start
237
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='32'
238
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
239
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='1 PLEASE'
240
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='69' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
241
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`='69'
242
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='69'
243
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='69' AND (start_date<='1329966508' OR start_date=0) AND (end_date>='1329892560' OR end_date=0) AND product_discount_id=discount_id
244
SELECT vendor_id FROM jos_vm_product WHERE product_id='69'
245
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='69'
246
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='69' 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
247
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='69'
248
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='69' AND shopper_group_id='5'  ORDER BY price_quantity_start
249
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='69'
250
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
251
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='TS6A107-2'
252
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='35' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
253
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`='35'
254
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='35'
255
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='35' AND (start_date<='1329966508' OR start_date=0) AND (end_date>='1329892560' OR end_date=0) AND product_discount_id=discount_id
256
SELECT vendor_id FROM jos_vm_product WHERE product_id='35'
257
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='35'
258
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='35' 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
259
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='35'
260
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='35' AND shopper_group_id='5'  ORDER BY price_quantity_start
261
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='35'
262
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
263
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='4SITTING'
264
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='84' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
265
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`='84'
266
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='84'
267
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='84' AND (start_date<='1329966508' OR start_date=0) AND (end_date>='1329892560' OR end_date=0) AND product_discount_id=discount_id
268
SELECT vendor_id FROM jos_vm_product WHERE product_id='84'
269
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='84'
270
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='84' 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
271
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='84'
272
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='84' AND shopper_group_id='5'  ORDER BY price_quantity_start
273
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='84'
274
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
275
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='SCHAUZER'
276
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='119' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
277
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`='119'
278
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='119'
279
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='119' AND (start_date<='1329966508' OR start_date=0) AND (end_date>='1329892560' OR end_date=0) AND product_discount_id=discount_id
280
SELECT vendor_id FROM jos_vm_product WHERE product_id='119'
281
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='119'
282
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='119' 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
283
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='119'
284
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='119' AND shopper_group_id='5'  ORDER BY price_quantity_start
285
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='119'
286
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
287
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='SITTING7'
288
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='143' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
289
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`='143'
290
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='143'
291
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='143' AND (start_date<='1329966508' OR start_date=0) AND (end_date>='1329892560' OR end_date=0) AND product_discount_id=discount_id
292
SELECT vendor_id FROM jos_vm_product WHERE product_id='143'
293
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='143'
294
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='143' 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
295
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='143'
296
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='143' AND shopper_group_id='5'  ORDER BY price_quantity_start
297
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='143'
298
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
299
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='Y10111601'
300
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='142' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
301
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`='142'
302
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='142'
303
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='142' AND (start_date<='1329966508' OR start_date=0) AND (end_date>='1329892560' OR end_date=0) AND product_discount_id=discount_id
304
SELECT vendor_id FROM jos_vm_product WHERE product_id='142'
305
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='142'
306
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='142' 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
307
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='142'
308
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='142' AND shopper_group_id='5'  ORDER BY price_quantity_start
309
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='142'
310
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
311
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='Y51116043'
312
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='51' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
313
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`='51'
314
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='51'
315
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='51' AND (start_date<='1329966508' OR start_date=0) AND (end_date>='1329892560' OR end_date=0) AND product_discount_id=discount_id
316
SELECT vendor_id FROM jos_vm_product WHERE product_id='51'
317
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='51'
318
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='51' 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
319
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='51'
320
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='51' AND shopper_group_id='5'  ORDER BY price_quantity_start
321
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='51'
322
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
323
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='JF4Y018-2'
324
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='18' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
325
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`='18'
326
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='18'
327
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='18' AND (start_date<='1329966508' OR start_date=0) AND (end_date>='1329892560' OR end_date=0) AND product_discount_id=discount_id
328
SELECT vendor_id FROM jos_vm_product WHERE product_id='18'
329
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='18'
330
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='18' 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
331
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='18'
332
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='18' AND shopper_group_id='5'  ORDER BY price_quantity_start
333
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='18'
334
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
335
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='SCRATCHING5'
336
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='125' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
337
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`='125'
338
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='125'
339
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='125' AND (start_date<='1329966508' OR start_date=0) AND (end_date>='1329892560' OR end_date=0) AND product_discount_id=discount_id
340
SELECT vendor_id FROM jos_vm_product WHERE product_id='125'
341
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='125'
342
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='125' 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
343
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='125'
344
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='125' AND shopper_group_id='5'  ORDER BY price_quantity_start
345
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='125'
346
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
347
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='GERMAN SHEPARD'
348
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='118' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
349
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`='118'
350
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='118'
351
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='118' AND (start_date<='1329966508' OR start_date=0) AND (end_date>='1329892560' OR end_date=0) AND product_discount_id=discount_id
352
SELECT vendor_id FROM jos_vm_product WHERE product_id='118'
353
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='118'
354
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='118' 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
355
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='118'
356
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='118' AND shopper_group_id='5'  ORDER BY price_quantity_start
357
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='118'
358
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
359
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='Y5211201B'
360
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='135' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
361
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`='135'
362
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='135'
363
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='135' AND (start_date<='1329966508' OR start_date=0) AND (end_date>='1329892560' OR end_date=0) AND product_discount_id=discount_id
364
SELECT vendor_id FROM jos_vm_product WHERE product_id='135'
365
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='135'
366
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='135' 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
367
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='135'
368
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='135' AND shopper_group_id='5'  ORDER BY price_quantity_start
369
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='135'
370
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
371
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='JF2111624D'
372
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='46' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
373
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`='46'
374
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='46'
375
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='46' AND (start_date<='1329966508' OR start_date=0) AND (end_date>='1329892560' OR end_date=0) AND product_discount_id=discount_id
376
SELECT vendor_id FROM jos_vm_product WHERE product_id='46'
377
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='46'
378
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='46' 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
379
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='46'
380
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='46' AND shopper_group_id='5'  ORDER BY price_quantity_start
381
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='46'
382
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
383
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='PUG'
384
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='120' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
385
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`='120'
386
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='120'
387
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='120' AND (start_date<='1329966508' OR start_date=0) AND (end_date>='1329892560' OR end_date=0) AND product_discount_id=discount_id
388
SELECT vendor_id FROM jos_vm_product WHERE product_id='120'
389
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='120'
390
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='120' 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
391
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='120'
392
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='120' AND shopper_group_id='5'  ORDER BY price_quantity_start
393
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='120'
394
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
395
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='JF3111615K'
396
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='61' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
397
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`='61'
398
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='61'
399
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='61' AND (start_date<='1329966508' OR start_date=0) AND (end_date>='1329892560' OR end_date=0) AND product_discount_id=discount_id
400
SELECT vendor_id FROM jos_vm_product WHERE product_id='61'
401
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='61'
402
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='61' 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
403
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='61'
404
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='61' AND shopper_group_id='5'  ORDER BY price_quantity_start
405
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='61'
406
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
407
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='Y4111606-2'
408
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='58' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
409
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`='58'
410
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='58'
411
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='58' AND (start_date<='1329966508' OR start_date=0) AND (end_date>='1329892560' OR end_date=0) AND product_discount_id=discount_id
412
SELECT vendor_id FROM jos_vm_product WHERE product_id='58'
413
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='58'
414
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='58' 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
415
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='58'
416
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='58' AND shopper_group_id='5'  ORDER BY price_quantity_start
417
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='58'
418
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
419
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='JF4Y018-3E'
420
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='132' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
421
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`='132'
422
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='132'
423
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='132' AND (start_date<='1329966508' OR start_date=0) AND (end_date>='1329892560' OR end_date=0) AND product_discount_id=discount_id
424
SELECT vendor_id FROM jos_vm_product WHERE product_id='132'
425
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='132'
426
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='132' 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
427
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='132'
428
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='132' AND shopper_group_id='5'  ORDER BY price_quantity_start
429
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='132'
430
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
431
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='Y5111604-4A'
432
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='140' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
433
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`='140'
434
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='140'
435
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='140' AND (start_date<='1329966508' OR start_date=0) AND (end_date>='1329892560' OR end_date=0) AND product_discount_id=discount_id
436
SELECT vendor_id FROM jos_vm_product WHERE product_id='140'
437
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='140'
438
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='140' 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
439
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='140'
440
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='140' AND shopper_group_id='5'  ORDER BY price_quantity_start
441
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='140'
442
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
443
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='Y611167'
444
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='11' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
445
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'
446
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='11'
447
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='11' AND (start_date<='1329966509' OR start_date=0) AND (end_date>='1329892560' OR end_date=0) AND product_discount_id=discount_id
448
SELECT vendor_id FROM jos_vm_product WHERE product_id='11'
449
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='11'
450
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
451
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='11'
452
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
453
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='11'
454
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
455
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='STANDING5'
456
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='126' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
457
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`='126'
458
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='126'
459
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='126' AND (start_date<='1329966509' OR start_date=0) AND (end_date>='1329892560' OR end_date=0) AND product_discount_id=discount_id
460
SELECT vendor_id FROM jos_vm_product WHERE product_id='126'
461
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='126'
462
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='126' 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
463
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='126'
464
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='126' AND shopper_group_id='5'  ORDER BY price_quantity_start
465
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='126'
466
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
467
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='SITIING'
468
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='123' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
469
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`='123'
470
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='123'
471
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='123' AND (start_date<='1329966509' OR start_date=0) AND (end_date>='1329892560' OR end_date=0) AND product_discount_id=discount_id
472
SELECT vendor_id FROM jos_vm_product WHERE product_id='123'
473
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='123'
474
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='123' 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
475
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='123'
476
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='123' AND shopper_group_id='5'  ORDER BY price_quantity_start
477
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='123'
478
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
479
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='1 BEGGING'
480
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='67' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
481
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`='67'
482
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='67'
483
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='67' AND (start_date<='1329966509' OR start_date=0) AND (end_date>='1329892560' OR end_date=0) AND product_discount_id=discount_id
484
SELECT vendor_id FROM jos_vm_product WHERE product_id='67'
485
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='67'
486
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='67' 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
487
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='67'
488
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='67' AND shopper_group_id='5'  ORDER BY price_quantity_start
489
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='67'
490
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
491
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='Y5111604-5'
492
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='47' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
493
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`='47'
494
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='47'
495
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='47' AND (start_date<='1329966509' OR start_date=0) AND (end_date>='1329892560' OR end_date=0) AND product_discount_id=discount_id
496
SELECT vendor_id FROM jos_vm_product WHERE product_id='47'
497
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='47'
498
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='47' 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
499
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='47'
500
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='47' AND shopper_group_id='5'  ORDER BY price_quantity_start
501
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='47'
502
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
503
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='JF3211201K'
504
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='97' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
505
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`='97'
506
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='97'
507
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='97' AND (start_date<='1329966509' OR start_date=0) AND (end_date>='1329892560' OR end_date=0) AND product_discount_id=discount_id
508
SELECT vendor_id FROM jos_vm_product WHERE product_id='97'
509
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='97'
510
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='97' 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
511
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='97'
512
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='97' AND shopper_group_id='5'  ORDER BY price_quantity_start
513
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='97'
514
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
515
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='BEAGLE SITTING'
516
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
517
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'
518
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='104'
519
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='104' AND (start_date<='1329966509' OR start_date=0) AND (end_date>='1329892560' OR end_date=0) AND product_discount_id=discount_id
520
SELECT vendor_id FROM jos_vm_product WHERE product_id='104'
521
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='104'
522
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='104' 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
523
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='104'
524
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='104' AND shopper_group_id='5'  ORDER BY price_quantity_start
525
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='104'
526
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
527
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='JF3111616K'
528
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='16' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
529
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`='16'
530
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='16'
531
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='16' AND (start_date<='1329966509' OR start_date=0) AND (end_date>='1329892560' OR end_date=0) AND product_discount_id=discount_id
532
SELECT vendor_id FROM jos_vm_product WHERE product_id='16'
533
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='16'
534
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='16' 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
535
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='16'
536
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='16' AND shopper_group_id='5'  ORDER BY price_quantity_start
537
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='16'
538
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
539
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='J2111606'
540
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='12' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
541
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`='12'
542
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='12'
543
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='12' AND (start_date<='1329966509' OR start_date=0) AND (end_date>='1329892560' OR end_date=0) AND product_discount_id=discount_id
544
SELECT vendor_id FROM jos_vm_product WHERE product_id='12'
545
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='12'
546
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='12' 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
547
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='12'
548
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='12' AND shopper_group_id='5'  ORDER BY price_quantity_start
549
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='12'
550
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
551
SELECT p.id, p.title
 FROM jos_polls AS p
 INNER JOIN jos_poll_menu AS pm ON  pm.pollid = p.id
 WHERE ( pm.menuid = 29 OR pm.menuid = 0 )
 AND p.published = 1
552
SELECT id
 FROM jos_menu
 WHERE type = 'components'
 AND published = 1
 AND link = 'index.php?option=com_poll'
553
SELECT id, text
 FROM jos_poll_data
 WHERE pollid = 14
 AND text != ''
 ORDER BY id
554
SELECT id
 FROM jos_menu
 WHERE link = 'index.php?option=com_search'
 AND published = 1
555
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 != ''