Main
Welcome to welcomedog.com! PDF Print E-mail
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 )
 


Advanced Search




Lost your Password?
No account yet? Register
Show Cart
 Your Cart is currently empty.

Valid HMTL | Valid CSS

Joomla Templates by Joomlashack

555 queries executed
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 != ''