J.A.T. template series was designed 2006 by 4bp.de: www.4bp.de, www.oltrogge.ws

PLEASE REGISTER BEFORE PLACING ORDER, USING YAHOO EMAIL IS NOT RECOMMENDED






Lost Password?

~PRODUCTS~

 
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.

Question & Answer (0) Ladies Corner (7) GIRL (453) BOY (242) BOY N GIRL 7T to 15T (29) Toys (9) OTHER ACCESSORIES (70) Small Stuffs... (11) SUPER BARGAIN (125) Baby & Kids Shoes (50) 5 ITEMS for RM40 (70) 3 ITEMS for RM50 (142) 3 ITEMS For RM70 (66) 3 ITEMS for RM90 (48) 4 ITEMS for RM50 (84)

List All Products


Advanced Search
Show Cart
 Your Cart is currently empty.

~~Latest products~~ PLS REGISTER TO VIEW PRICE

Debug: calculating tax based on shipping address

Girl Dress
Girl Dress
RM29.90
Ralph Lauren Bodysuit
Ralph Lauren Bodysuit
RM15.00
Kitty Purple Shirt
Kitty Purple Shirt
RM15.00
Tuxedo 4pc Set
Tuxedo 4pc Set
RM49.90
Boy Long Sleeve
Boy Long Sleeve
RM18.00
Boy Pants
Boy Pants
RM19.90
Boy T (Green)
Boy T (Green)
RM15.00
Boy T
Boy T
RM15.00
Boy Long T
Boy Long T
RM18.00
Boy Long leeve T
Boy Long leeve T
RM18.00
Boy Long Sleeve T
Boy Long Sleeve T
RM18.00
Boy T
Boy T
RM18.00
Girl Long Sleeve T
Girl Long Sleeve T
RM18.00
Long Sleeve T
Long Sleeve T
RM18.00
Boy T
Boy T
RM15.00
2pc Set
2pc Set
RM25.00
Red Legging
Red Legging
RM13.90
Panda T
Panda T
RM12.00
Girl Dress
Girl Dress
RM35.00
Hello Kitty Dress Top
Hello Kitty Dress Top
RM15.00
Legging
Legging
RM13.90
Dress
Dress
RM29.90
Dress
Dress
RM29.90
WonderKids Bodysuit
WonderKids Bodysuit
RM10.00
Carter's Pink Romper
Carter's Pink Romper
RM19.90
Daddys Girl Romper
Daddys Girl Romper
RM19.90
Property of Mum T
Property of Mum T
RM15.00
Kimbaloo Pants
Kimbaloo Pants
RM10.00
Carter's Flower Dress
Carter's Flower Dress
RM25.00
Carter's Flower Dress
Carter's Flower Dress
RM25.00
J.A.T. template series was designed 2006 by 4bp.de: www.4bp.de, www.oltrogge.ws
339 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 id FROM jos_menu WHERE link='index.php?option=com_virtuemart' AND published=1 AND access=0
9 SELECT category_id, category_description, category_name,category_child_id as cid, category_parent_id as pid,list_order, category_publish FROM jos_vm_category, jos_vm_category_xref WHERE jos_vm_category.category_publish='Y' AND jos_vm_category.category_id=jos_vm_category_xref.category_child_id ORDER BY jos_vm_category.list_order ASC, jos_vm_category.category_name ASC
10 SELECT count(jos_vm_product.product_id) as num_rows from jos_vm_product,jos_vm_product_category_xref, jos_vm_category WHERE jos_vm_product_category_xref.category_id='81' AND jos_vm_category.category_id=jos_vm_product_category_xref.category_id AND jos_vm_product.product_id=jos_vm_product_category_xref.product_id AND product_publish='Y' AND product_in_stock > 0
11 SELECT category_child_id FROM jos_vm_category_xref WHERE category_parent_id='81'
12 SELECT count(jos_vm_product.product_id) as num_rows from jos_vm_product,jos_vm_product_category_xref, jos_vm_category WHERE jos_vm_product_category_xref.category_id='24' AND jos_vm_category.category_id=jos_vm_product_category_xref.category_id AND jos_vm_product.product_id=jos_vm_product_category_xref.product_id AND product_publish='Y' AND product_in_stock > 0
13 SELECT count(jos_vm_product.product_id) as num_rows from jos_vm_product,jos_vm_product_category_xref, jos_vm_category WHERE jos_vm_product_category_xref.category_id='25' AND jos_vm_category.category_id=jos_vm_product_category_xref.category_id AND jos_vm_product.product_id=jos_vm_product_category_xref.product_id AND product_publish='Y' AND product_in_stock > 0
14 SELECT category_child_id FROM jos_vm_category_xref WHERE category_parent_id='25'
15 SELECT category_child_id FROM jos_vm_category_xref WHERE category_parent_id='25'
16 SELECT count(jos_vm_product.product_id) as num_rows from jos_vm_product,jos_vm_product_category_xref, jos_vm_category WHERE jos_vm_product_category_xref.category_id='29' AND jos_vm_category.category_id=jos_vm_product_category_xref.category_id AND jos_vm_product.product_id=jos_vm_product_category_xref.product_id AND product_publish='Y' AND product_in_stock > 0
17 SELECT count(jos_vm_product.product_id) as num_rows from jos_vm_product,jos_vm_product_category_xref, jos_vm_category WHERE jos_vm_product_category_xref.category_id='47' AND jos_vm_category.category_id=jos_vm_product_category_xref.category_id AND jos_vm_product.product_id=jos_vm_product_category_xref.product_id AND product_publish='Y' AND product_in_stock > 0
18 SELECT count(jos_vm_product.product_id) as num_rows from jos_vm_product,jos_vm_product_category_xref, jos_vm_category WHERE jos_vm_product_category_xref.category_id='48' AND jos_vm_category.category_id=jos_vm_product_category_xref.category_id AND jos_vm_product.product_id=jos_vm_product_category_xref.product_id AND product_publish='Y' AND product_in_stock > 0
19 SELECT count(jos_vm_product.product_id) as num_rows from jos_vm_product,jos_vm_product_category_xref, jos_vm_category WHERE jos_vm_product_category_xref.category_id='46' AND jos_vm_category.category_id=jos_vm_product_category_xref.category_id AND jos_vm_product.product_id=jos_vm_product_category_xref.product_id AND product_publish='Y' AND product_in_stock > 0
20 SELECT category_child_id FROM jos_vm_category_xref WHERE category_parent_id='46'
21 SELECT category_child_id FROM jos_vm_category_xref WHERE category_parent_id='46'
22 SELECT count(jos_vm_product.product_id) as num_rows from jos_vm_product,jos_vm_product_category_xref, jos_vm_category WHERE jos_vm_product_category_xref.category_id='28' AND jos_vm_category.category_id=jos_vm_product_category_xref.category_id AND jos_vm_product.product_id=jos_vm_product_category_xref.product_id AND product_publish='Y' AND product_in_stock > 0
23 SELECT count(jos_vm_product.product_id) as num_rows from jos_vm_product,jos_vm_product_category_xref, jos_vm_category WHERE jos_vm_product_category_xref.category_id='30' AND jos_vm_category.category_id=jos_vm_product_category_xref.category_id AND jos_vm_product.product_id=jos_vm_product_category_xref.product_id AND product_publish='Y' AND product_in_stock > 0
24 SELECT count(jos_vm_product.product_id) as num_rows from jos_vm_product,jos_vm_product_category_xref, jos_vm_category WHERE jos_vm_product_category_xref.category_id='42' AND jos_vm_category.category_id=jos_vm_product_category_xref.category_id AND jos_vm_product.product_id=jos_vm_product_category_xref.product_id AND product_publish='Y' AND product_in_stock > 0
25 SELECT count(jos_vm_product.product_id) as num_rows from jos_vm_product,jos_vm_product_category_xref, jos_vm_category WHERE jos_vm_product_category_xref.category_id='61' AND jos_vm_category.category_id=jos_vm_product_category_xref.category_id AND jos_vm_product.product_id=jos_vm_product_category_xref.product_id AND product_publish='Y' AND product_in_stock > 0
26 SELECT count(jos_vm_product.product_id) as num_rows from jos_vm_product,jos_vm_product_category_xref, jos_vm_category WHERE jos_vm_product_category_xref.category_id='56' AND jos_vm_category.category_id=jos_vm_product_category_xref.category_id AND jos_vm_product.product_id=jos_vm_product_category_xref.product_id AND product_publish='Y' AND product_in_stock > 0
27 SELECT count(jos_vm_product.product_id) as num_rows from jos_vm_product,jos_vm_product_category_xref, jos_vm_category WHERE jos_vm_product_category_xref.category_id='12' AND jos_vm_category.category_id=jos_vm_product_category_xref.category_id AND jos_vm_product.product_id=jos_vm_product_category_xref.product_id AND product_publish='Y' AND product_in_stock > 0
28 SELECT count(jos_vm_product.product_id) as num_rows from jos_vm_product,jos_vm_product_category_xref, jos_vm_category WHERE jos_vm_product_category_xref.category_id='69' AND jos_vm_category.category_id=jos_vm_product_category_xref.category_id AND jos_vm_product.product_id=jos_vm_product_category_xref.product_id AND product_publish='Y' AND product_in_stock > 0
29 SELECT count(jos_vm_product.product_id) as num_rows from jos_vm_product,jos_vm_product_category_xref, jos_vm_category WHERE jos_vm_product_category_xref.category_id='67' AND jos_vm_category.category_id=jos_vm_product_category_xref.category_id AND jos_vm_product.product_id=jos_vm_product_category_xref.product_id AND product_publish='Y' AND product_in_stock > 0
30 SELECT count(jos_vm_product.product_id) as num_rows from jos_vm_product,jos_vm_product_category_xref, jos_vm_category WHERE jos_vm_product_category_xref.category_id='74' AND jos_vm_category.category_id=jos_vm_product_category_xref.category_id AND jos_vm_product.product_id=jos_vm_product_category_xref.product_id AND product_publish='Y' AND product_in_stock > 0
31 SELECT count(jos_vm_product.product_id) as num_rows from jos_vm_product,jos_vm_product_category_xref, jos_vm_category WHERE jos_vm_product_category_xref.category_id='76' AND jos_vm_category.category_id=jos_vm_product_category_xref.category_id AND jos_vm_product.product_id=jos_vm_product_category_xref.product_id AND product_publish='Y' AND product_in_stock > 0
32 SELECT count(jos_vm_product.product_id) as num_rows from jos_vm_product,jos_vm_product_category_xref, jos_vm_category WHERE jos_vm_product_category_xref.category_id='78' AND jos_vm_category.category_id=jos_vm_product_category_xref.category_id AND jos_vm_product.product_id=jos_vm_product_category_xref.product_id AND product_publish='Y' AND product_in_stock > 0
33 SELECT count(jos_vm_product.product_id) as num_rows from jos_vm_product,jos_vm_product_category_xref, jos_vm_category WHERE jos_vm_product_category_xref.category_id='79' AND jos_vm_category.category_id=jos_vm_product_category_xref.category_id AND jos_vm_product.product_id=jos_vm_product_category_xref.product_id AND product_publish='Y' AND product_in_stock > 0
34 SELECT count(jos_vm_product.product_id) as num_rows from jos_vm_product,jos_vm_product_category_xref, jos_vm_category WHERE jos_vm_product_category_xref.category_id='80' AND jos_vm_category.category_id=jos_vm_product_category_xref.category_id AND jos_vm_product.product_id=jos_vm_product_category_xref.product_id AND product_publish='Y' AND product_in_stock > 0
35 SELECT count(jos_vm_product.product_id) as num_rows from jos_vm_product,jos_vm_product_category_xref, jos_vm_category WHERE jos_vm_product_category_xref.category_id='83' AND jos_vm_category.category_id=jos_vm_product_category_xref.category_id AND jos_vm_product.product_id=jos_vm_product_category_xref.product_id AND product_publish='Y' AND product_in_stock > 0
36 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 != ''
37 SELECT DISTINCT product_sku FROM jos_vm_product, jos_vm_product_category_xref, jos_vm_category WHERE product_parent_id=''AND jos_vm_product.product_id=jos_vm_product_category_xref.product_id AND jos_vm_category.category_id=jos_vm_product_category_xref.category_id AND product_in_stock > 0 AND jos_vm_product.product_publish='Y' ORDER BY jos_vm_product.product_id DESC LIMIT 0, 30
38 SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='FLDrssBlackRedBelt'
39 SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='12875' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
40 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`='12875'
41 SELECT product_id, `product_name` FROM jos_vm_product WHERE product_id='12875'
42 SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='12875' AND (start_date<='1409666206' OR start_date=0) AND (end_date>='1409614560' OR end_date=0) AND product_discount_id=discount_id
43 SELECT vendor_id FROM jos_vm_product WHERE product_id='12875'
44 SELECT shopper_group_id,shopper_group_discount FROM jos_vm_shopper_group WHERE vendor_id='1' AND `default`='1'
45 SELECT product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='12875'
46 SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='12875' 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
47 SELECT product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='12875'
48 SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='12875' AND shopper_group_id='5' ORDER BY price_quantity_start
49 SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='4CLRLBD'
50 SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='12874' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
51 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`='12874'
52 SELECT product_id, `product_name` FROM jos_vm_product WHERE product_id='12874'
53 SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='12874' AND (start_date<='1409666206' OR start_date=0) AND (end_date>='1409614560' OR end_date=0) AND product_discount_id=discount_id
54 SELECT vendor_id FROM jos_vm_product WHERE product_id='12874'
55 SELECT product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='12874'
56 SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='12874' 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
57 SELECT product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='12874'
58 SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='12874' AND shopper_group_id='5' ORDER BY price_quantity_start
59 SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='KittyPurple'
60 SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='12868' 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`='12868'
62 SELECT product_id, `product_name` FROM jos_vm_product WHERE product_id='12868'
63 SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='12868' AND (start_date<='1409666206' OR start_date=0) AND (end_date>='1409614560' OR end_date=0) AND product_discount_id=discount_id
64 SELECT vendor_id FROM jos_vm_product WHERE product_id='12868'
65 SELECT product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='12868'
66 SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='12868' 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='12868'
68 SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='12868' AND shopper_group_id='5' ORDER BY price_quantity_start
69 SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='Tuxedo4pcSet'
70 SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='12863' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
71 SELECT `jos_vm_product`.`product_parent_id` AS product_parent_id, `jos_vm_category`.`category_flypage` FROM `jos_vm_product` LEFT JOIN `jos_vm_product_category_xref` ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id` LEFT JOIN `jos_vm_category` ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id` WHERE `jos_vm_product`.`product_id`='12863'
72 SELECT product_id, `product_name` FROM jos_vm_product WHERE product_id='12863'
73 SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='12863' AND (start_date<='1409666206' OR start_date=0) AND (end_date>='1409614560' OR end_date=0) AND product_discount_id=discount_id
74 SELECT vendor_id FROM jos_vm_product WHERE product_id='12863'
75 SELECT product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='12863'
76 SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='12863' 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
77 SELECT product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='12863'
78 SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='12863' AND shopper_group_id='5' ORDER BY price_quantity_start
79 SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='3CLRLongSleeve'
80 SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='12854' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
81 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`='12854'
82 SELECT product_id, `product_name` FROM jos_vm_product WHERE product_id='12854'
83 SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='12854' AND (start_date<='1409666206' OR start_date=0) AND (end_date>='1409614560' OR end_date=0) AND product_discount_id=discount_id
84 SELECT vendor_id FROM jos_vm_product WHERE product_id='12854'
85 SELECT product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='12854'
86 SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='12854' 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
87 SELECT product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='12854'
88 SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='12854' AND shopper_group_id='5' ORDER BY price_quantity_start
89 SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='14No8Pants'
90 SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='12845' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
91 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`='12845'
92 SELECT product_id, `product_name` FROM jos_vm_product WHERE product_id='12845'
93 SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='12845' AND (start_date<='1409666206' OR start_date=0) AND (end_date>='1409614560' OR end_date=0) AND product_discount_id=discount_id
94 SELECT vendor_id FROM jos_vm_product WHERE product_id='12845'
95 SELECT product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='12845'
96 SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='12845' 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
97 SELECT product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='12845'
98 SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='12845' AND shopper_group_id='5' ORDER BY price_quantity_start
99 SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='14TGreen'
100 SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='12839' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
101 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`='12839'
102 SELECT product_id, `product_name` FROM jos_vm_product WHERE product_id='12839'
103 SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='12839' AND (start_date<='1409666206' OR start_date=0) AND (end_date>='1409614560' OR end_date=0) AND product_discount_id=discount_id
104 SELECT vendor_id FROM jos_vm_product WHERE product_id='12839'
105 SELECT product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='12839'
106 SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='12839' 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
107 SELECT product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='12839'
108 SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='12839' AND shopper_group_id='5' ORDER BY price_quantity_start
109 SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='14TBlueBus'
110 SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='12833' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
111 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`='12833'
112 SELECT product_id, `product_name` FROM jos_vm_product WHERE product_id='12833'
113 SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='12833' AND (start_date<='1409666206' OR start_date=0) AND (end_date>='1409614560' OR end_date=0) AND product_discount_id=discount_id
114 SELECT vendor_id FROM jos_vm_product WHERE product_id='12833'
115 SELECT product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='12833'
116 SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='12833' 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
117 SELECT product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='12833'
118 SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='12833' AND shopper_group_id='5' ORDER BY price_quantity_start
119 SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='14TMilkCow'
120 SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='12828' 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`='12828'
122 SELECT product_id, `product_name` FROM jos_vm_product WHERE product_id='12828'
123 SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='12828' AND (start_date<='1409666206' OR start_date=0) AND (end_date>='1409614560' OR end_date=0) AND product_discount_id=discount_id
124 SELECT vendor_id FROM jos_vm_product WHERE product_id='12828'
125 SELECT product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='12828'
126 SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='12828' 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='12828'
128 SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='12828' AND shopper_group_id='5' ORDER BY price_quantity_start
129 SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='14TYellowChicago'
130 SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='12823' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
131 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`='12823'
132 SELECT product_id, `product_name` FROM jos_vm_product WHERE product_id='12823'
133 SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='12823' AND (start_date<='1409666206' OR start_date=0) AND (end_date>='1409614560' OR end_date=0) AND product_discount_id=discount_id
134 SELECT vendor_id FROM jos_vm_product WHERE product_id='12823'
135 SELECT product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='12823'
136 SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='12823' 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
137 SELECT product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='12823'
138 SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='12823' AND shopper_group_id='5' ORDER BY price_quantity_start
139 SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='14TMaryGrove'
140 SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='12818' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
141 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`='12818'
142 SELECT product_id, `product_name` FROM jos_vm_product WHERE product_id='12818'
143 SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='12818' AND (start_date<='1409666206' OR start_date=0) AND (end_date>='1409614560' OR end_date=0) AND product_discount_id=discount_id
144 SELECT vendor_id FROM jos_vm_product WHERE product_id='12818'
145 SELECT product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='12818'
146 SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='12818' 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
147 SELECT product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='12818'
148 SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='12818' AND shopper_group_id='5' ORDER BY price_quantity_start
149 SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='14TBRITT'
150 SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='12813' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
151 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`='12813'
152 SELECT product_id, `product_name` FROM jos_vm_product WHERE product_id='12813'
153 SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='12813' AND (start_date<='1409666206' OR start_date=0) AND (end_date>='1409614560' OR end_date=0) AND product_discount_id=discount_id
154 SELECT vendor_id FROM jos_vm_product WHERE product_id='12813'
155 SELECT product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='12813'
156 SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='12813' 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
157 SELECT product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='12813'
158 SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='12813' AND shopper_group_id='5' ORDER BY price_quantity_start
159 SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='YellowRib'
160 SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='12808' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
161 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`='12808'
162 SELECT product_id, `product_name` FROM jos_vm_product WHERE product_id='12808'
163 SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='12808' AND (start_date<='1409666206' OR start_date=0) AND (end_date>='1409614560' OR end_date=0) AND product_discount_id=discount_id
164 SELECT vendor_id FROM jos_vm_product WHERE product_id='12808'
165 SELECT product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='12808'
166 SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='12808' 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
167 SELECT product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='12808'
168 SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='12808' AND shopper_group_id='5' ORDER BY price_quantity_start
169 SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='14TLongYMu'
170 SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='12799' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
171 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`='12799'
172 SELECT product_id, `product_name` FROM jos_vm_product WHERE product_id='12799'
173 SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='12799' AND (start_date<='1409666206' OR start_date=0) AND (end_date>='1409614560' OR end_date=0) AND product_discount_id=discount_id
174 SELECT vendor_id FROM jos_vm_product WHERE product_id='12799'
175 SELECT product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='12799'
176 SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='12799' 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
177 SELECT product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='12799'
178 SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='12799' AND shopper_group_id='5' ORDER BY price_quantity_start
179 SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='13TMustard'
180 SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='12788' 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`='12788'
182 SELECT product_id, `product_name` FROM jos_vm_product WHERE product_id='12788'
183 SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='12788' AND (start_date<='1409666206' OR start_date=0) AND (end_date>='1409614560' OR end_date=0) AND product_discount_id=discount_id
184 SELECT vendor_id FROM jos_vm_product WHERE product_id='12788'
185 SELECT product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='12788'
186 SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='12788' 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='12788'
188 SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='12788' AND shopper_group_id='5' ORDER BY price_quantity_start
189 SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='WhiteNavyCar2pc'
190 SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='12782' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
191 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`='12782'
192 SELECT product_id, `product_name` FROM jos_vm_product WHERE product_id='12782'
193 SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='12782' AND (start_date<='1409666206' OR start_date=0) AND (end_date>='1409614560' OR end_date=0) AND product_discount_id=discount_id
194 SELECT vendor_id FROM jos_vm_product WHERE product_id='12782'
195 SELECT product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='12782'
196 SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='12782' 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
197 SELECT product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='12782'
198 SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='12782' AND shopper_group_id='5' ORDER BY price_quantity_start
199 SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='RedPlainLegging'
200 SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='12776' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
201 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`='12776'
202 SELECT product_id, `product_name` FROM jos_vm_product WHERE product_id='12776'
203 SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='12776' AND (start_date<='1409666206' OR start_date=0) AND (end_date>='1409614560' OR end_date=0) AND product_discount_id=discount_id
204 SELECT vendor_id FROM jos_vm_product WHERE product_id='12776'
205 SELECT product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='12776'
206 SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='12776' 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
207 SELECT product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='12776'
208 SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='12776' AND shopper_group_id='5' ORDER BY price_quantity_start
209 SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='PandaT'
210 SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='12770' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
211 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`='12770'
212 SELECT product_id, `product_name` FROM jos_vm_product WHERE product_id='12770'
213 SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='12770' AND (start_date<='1409666206' OR start_date=0) AND (end_date>='1409614560' OR end_date=0) AND product_discount_id=discount_id
214 SELECT vendor_id FROM jos_vm_product WHERE product_id='12770'
215 SELECT product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='12770'
216 SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='12770' 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
217 SELECT product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='12770'
218 SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='12770' AND shopper_group_id='5' ORDER BY price_quantity_start
219 SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='GsWhtCLRDOTDrs'
220 SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='12753' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
221 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`='12753'
222 SELECT product_id, `product_name` FROM jos_vm_product WHERE product_id='12753'
223 SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='12753' AND (start_date<='1409666206' OR start_date=0) AND (end_date>='1409614560' OR end_date=0) AND product_discount_id=discount_id
224 SELECT vendor_id FROM jos_vm_product WHERE product_id='12753'
225 SELECT product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='12753'
226 SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='12753' 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
227 SELECT product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='12753'
228 SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='12753' AND shopper_group_id='5' ORDER BY price_quantity_start
229 SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='KittyTop'
230 SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='12752' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
231 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`='12752'
232 SELECT product_id, `product_name` FROM jos_vm_product WHERE product_id='12752'
233 SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='12752' AND (start_date<='1409666206' OR start_date=0) AND (end_date>='1409614560' OR end_date=0) AND product_discount_id=discount_id
234 SELECT vendor_id FROM jos_vm_product WHERE product_id='12752'
235 SELECT product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='12752'
236 SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='12752' 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
237 SELECT product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='12752'
238 SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='12752' AND shopper_group_id='5' ORDER BY price_quantity_start
239 SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='14LegCatBlue'
240 SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='12746' 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`='12746'
242 SELECT product_id, `product_name` FROM jos_vm_product WHERE product_id='12746'
243 SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='12746' AND (start_date<='1409666206' OR start_date=0) AND (end_date>='1409614560' OR end_date=0) AND product_discount_id=discount_id
244 SELECT vendor_id FROM jos_vm_product WHERE product_id='12746'
245 SELECT product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='12746'
246 SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='12746' 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='12746'
248 SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='12746' AND shopper_group_id='5' ORDER BY price_quantity_start
249 SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='14FLDrsPinkWhiteFlw'
250 SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='12740' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
251 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`='12740'
252 SELECT product_id, `product_name` FROM jos_vm_product WHERE product_id='12740'
253 SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='12740' AND (start_date<='1409666206' OR start_date=0) AND (end_date>='1409614560' OR end_date=0) AND product_discount_id=discount_id
254 SELECT vendor_id FROM jos_vm_product WHERE product_id='12740'
255 SELECT product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='12740'
256 SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='12740' 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
257 SELECT product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='12740'
258 SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='12740' AND shopper_group_id='5' ORDER BY price_quantity_start
259 SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='FLDrsPurpleDot'
260 SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='12735' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
261 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`='12735'
262 SELECT product_id, `product_name` FROM jos_vm_product WHERE product_id='12735'
263 SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='12735' AND (start_date<='1409666206' OR start_date=0) AND (end_date>='1409614560' OR end_date=0) AND product_discount_id=discount_id
264 SELECT vendor_id FROM jos_vm_product WHERE product_id='12735'
265 SELECT product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='12735'
266 SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='12735' 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
267 SELECT product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='12735'
268 SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='12735' AND shopper_group_id='5' ORDER BY price_quantity_start
269 SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='WkidWhiteBD'
270 SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='12731' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
271 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`='12731'
272 SELECT product_id, `product_name` FROM jos_vm_product WHERE product_id='12731'
273 SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='12731' AND (start_date<='1409666206' OR start_date=0) AND (end_date>='1409614560' OR end_date=0) AND product_discount_id=discount_id
274 SELECT vendor_id FROM jos_vm_product WHERE product_id='12731'
275 SELECT product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='12731'
276 SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='12731' 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
277 SELECT product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='12731'
278 SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='12731' AND shopper_group_id='5' ORDER BY price_quantity_start
279 SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='CTPinkBeeRP'
280 SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='12727' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
281 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`='12727'
282 SELECT product_id, `product_name` FROM jos_vm_product WHERE product_id='12727'
283 SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='12727' AND (start_date<='1409666206' OR start_date=0) AND (end_date>='1409614560' OR end_date=0) AND product_discount_id=discount_id
284 SELECT vendor_id FROM jos_vm_product WHERE product_id='12727'
285 SELECT product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='12727'
286 SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='12727' 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
287 SELECT product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='12727'
288 SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='12727' AND shopper_group_id='5' ORDER BY price_quantity_start
289 SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='DDgirlORGRP'
290 SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='12721' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
291 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`='12721'
292 SELECT product_id, `product_name` FROM jos_vm_product WHERE product_id='12721'
293 SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='12721' AND (start_date<='1409666206' OR start_date=0) AND (end_date>='1409614560' OR end_date=0) AND product_discount_id=discount_id
294 SELECT vendor_id FROM jos_vm_product WHERE product_id='12721'
295 SELECT product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='12721'
296 SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='12721' 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
297 SELECT product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='12721'
298 SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='12721' AND shopper_group_id='5' ORDER BY price_quantity_start
299 SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='PropofMumT'
300 SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='12717' 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`='12717'
302 SELECT product_id, `product_name` FROM jos_vm_product WHERE product_id='12717'
303 SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='12717' AND (start_date<='1409666206' OR start_date=0) AND (end_date>='1409614560' OR end_date=0) AND product_discount_id=discount_id
304 SELECT vendor_id FROM jos_vm_product WHERE product_id='12717'
305 SELECT product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='12717'
306 SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='12717' 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='12717'
308 SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='12717' AND shopper_group_id='5' ORDER BY price_quantity_start
309 SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='KimbalooLightBluePants'
310 SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='12713' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
311 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`='12713'
312 SELECT product_id, `product_name` FROM jos_vm_product WHERE product_id='12713'
313 SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='12713' AND (start_date<='1409666206' OR start_date=0) AND (end_date>='1409614560' OR end_date=0) AND product_discount_id=discount_id
314 SELECT vendor_id FROM jos_vm_product WHERE product_id='12713'
315 SELECT product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='12713'
316 SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='12713' 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
317 SELECT product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='12713'
318 SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='12713' AND shopper_group_id='5' ORDER BY price_quantity_start
319 SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='14CtStrpFlw-Strp'
320 SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='12703' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
321 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`='12703'
322 SELECT product_id, `product_name` FROM jos_vm_product WHERE product_id='12703'
323 SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='12703' AND (start_date<='1409666206' OR start_date=0) AND (end_date>='1409614560' OR end_date=0) AND product_discount_id=discount_id
324 SELECT vendor_id FROM jos_vm_product WHERE product_id='12703'
325 SELECT product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='12703'
326 SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='12703' 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
327 SELECT product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='12703'
328 SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='12703' AND shopper_group_id='5' ORDER BY price_quantity_start
329 SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='14CtStrpFlw-Flwdrs'
330 SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='12697' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
331 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`='12697'
332 SELECT product_id, `product_name` FROM jos_vm_product WHERE product_id='12697'
333 SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='12697' AND (start_date<='1409666206' OR start_date=0) AND (end_date>='1409614560' OR end_date=0) AND product_discount_id=discount_id
334 SELECT vendor_id FROM jos_vm_product WHERE product_id='12697'
335 SELECT product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='12697'
336 SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='12697' 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
337 SELECT product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='12697'
338 SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='12697' AND shopper_group_id='5' ORDER BY price_quantity_start
339 SELECT id FROM jos_menu WHERE link = 'index.php?option=com_search' AND published = 1