Home Products Contact Us

Main Menu

Home

Products

Contact Us

Shopping Cart

Your Cart is currently empty.

---

Product Scroller

Pes Ikan Bakar

RM2.00

Beauty Almond

RM20.00

Pes Kari Ayam Daging

RM3.00

Pistachio Nest

RM25.00

Jalinan Keju

RM25.00

Chocolate Moose

RM20.00

Pes Kari Ikan Mami

RM3.00

Almond Tears

RM20.00

ShortBread

RM25.00

Set Farisah

RM25.00

Search

Designed by:

Joomla Templates

Pembekal Pes & Kuih Raya Written by Web Master    Saturday, 12 June 2004 Memperkenalkan Pes Ikan Bakar -- Tak perlu menumbuk, memotong atau menumis lagi! Hanya sapu atas ikan atau sumbat dalam ikan, dan bakar. Kesedapan dijamin! Juga ada pes untuk ayam/daging berperisa satay. Untuk setiap ketika, nikmatilah Nani's Cookies...   Hubungi: Noridahwatty Mohammad Nawi Email: This e-mail address is being protected from spam bots, you need JavaScript enabled to view it Tel: +6 (019) 472-8818 Last Updated ( Sunday, 06 July 2008 ) Read more...

Who's Online

http://www.aynuf.com, Powered by Joomla! and designed by SiteGround web hosting

1
SELECT folder, element, published, params
 FROM jos_mambots
 WHERE published >= 1
 AND access <= 0
 AND folder = 'system'
 ORDER BY ordering
2
SELECT id, link
 FROM jos_menu
 WHERE menutype = 'mainmenu'
 AND published = 1
 ORDER BY parent, ordering
LIMIT 1
3
SELECT template
 FROM jos_templates_menu
 WHERE client_id = 0
 AND ( menuid = 0  OR menuid = 1 )
 ORDER BY menuid DESC
LIMIT 1
4
DELETE FROM jos_session
 WHERE (
 ( time < '1227137030' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1227137030' )
 AND guest = 1
 AND userid = 0
 )
5
SELECT *
 FROM jos_menu
 WHERE id = 1
6
SELECT COUNT(a.id)
 FROM jos_content AS a
 INNER JOIN jos_content_frontpage AS f ON f.content_id = a.id
 INNER JOIN jos_categories AS cc ON cc.id = a.catid
 INNER JOIN jos_sections AS s ON s.id = a.sectionid
 LEFT JOIN jos_users AS u ON u.id = a.created_by
 LEFT JOIN jos_groups AS g ON a.access = g.id
 WHERE a.state = 1
 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2008-11-19 23:38' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2008-11-19 23:38' )
 AND s.published = 1
 AND cc.published = 1
 AND a.access <= 0
 AND s.access <= 0
 AND cc.access <= 0
7
SELECT a.id, a.title, a.title_alias, a.introtext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by,
 a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.ordering, a.metakey, a.metadesc, a.access, a.hits,
 CHAR_LENGTH( a.fulltext ) AS readmore, u.name AS author, u.usertype, s.name AS section, cc.name AS category, g.name AS groups
, s.id AS sec_id, cc.id as cat_id
 FROM jos_content AS a
 INNER JOIN jos_content_frontpage AS f ON f.content_id = a.id
 INNER JOIN jos_categories AS cc ON cc.id = a.catid
 INNER JOIN jos_sections AS s ON s.id = a.sectionid
 LEFT JOIN jos_users AS u ON u.id = a.created_by
 LEFT JOIN jos_groups AS g ON a.access = g.id
 WHERE a.state = 1
 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2008-11-19 23:38' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2008-11-19 23:38' )
 AND s.published = 1
 AND cc.published = 1
 AND a.access <= 0
 AND s.access <= 0
 AND cc.access <= 0
 ORDER BY  f.ordering
LIMIT 4
8
SELECT folder, element, published, params
 FROM jos_mambots
 WHERE access <= 0
 AND folder = 'content'
 ORDER BY ordering
9
SELECT params
 FROM jos_mambots
 WHERE element = 'mosemailcloak'
 AND folder = 'content'
10
SELECT a.*
 FROM jos_components AS a
 WHERE ( a.admin_menu_link = 'option=com_syndicate' OR a.admin_menu_link = 'option=com_syndicate&hidemainmenu=1' )
 AND a.option = 'com_syndicate'
11
SELECT id, name, link FROM jos_menu WHERE menutype='mainmenu' and parent='0' AND access<='0' AND sublevel='0' AND published='1' ORDER BY ordering LIMIT 5
12
SELECT id, title, module, position, content, showtitle, params
 FROM jos_modules AS m
 INNER JOIN jos_modules_menu AS mm ON mm.moduleid = m.id
 WHERE m.published = 1
 AND m.access <= 0
 AND m.client_id != 1
 AND ( mm.menuid = 0 OR mm.menuid = 1 )
 ORDER BY ordering
13
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'mainmenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
14
SELECT group_id,group_name,group_level FROM `jos_vm_auth_group` ORDER BY group_level
15
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'
16
SELECT `name` FROM `jos_core_acl_aro_groups` WHERE `group_id` =29
17
SELECT `lft`, `rgt` FROM `jos_core_acl_aro_groups` WHERE `name`='Public Frontend'
18
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
19
SELECT `lft`, `rgt` FROM `jos_core_acl_aro_groups` WHERE `name`='Public Backend'
20
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
21
SELECT vendor_id, vendor_min_pov,vendor_name,vendor_store_name,contact_email,vendor_full_image, vendor_freeshipping,
					vendor_address_1, vendor_city, vendor_state, vendor_country, country_2_code, country_3_code,
					vendor_zip, vendor_phone, vendor_store_desc, vendor_currency, vendor_currency_display_style,
					vendor_accepted_currencies, vendor_address_format, vendor_date_format
				FROM (`jos_vm_vendor`, `jos_vm_country`)
				WHERE `vendor_id`=1
				AND (vendor_country=country_2_code OR vendor_country=country_3_code);
22
SELECT params FROM jos_menu WHERE id='1'
23
SELECT id FROM jos_menu WHERE link='index.php?option=com_virtuemart' AND published=1
24
SELECT p.product_sku FROM jos_vm_product AS p
JOIN jos_vm_product_category_xref as pc ON p.product_id=pc.product_id
JOIN jos_vm_category as c ON pc.category_id=c.category_id
 WHERE p.product_publish = 'Y' AND c.category_publish = 'Y' AND product_parent_id=0 
 ORDER BY RAND() LIMIT 10
25
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='AP01'
26
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='17' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
27
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`='17'
28
SELECT product_id, `jos_vm_product`.* FROM `jos_vm_product` WHERE `product_id`=17
29
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='17' AND (start_date<='1227137933' OR start_date=0) AND (end_date>='1227051360' OR end_date=0) AND product_discount_id=discount_id
30
SELECT product_parent_id FROM jos_vm_product WHERE product_id=17
31
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='0' AND (start_date<='1227137933' OR start_date=0) AND (end_date>='1227051360' OR end_date=0) AND product_discount_id=discount_id
32
SELECT vendor_id FROM jos_vm_product WHERE product_id='17'
33
SELECT shopper_group_id,shopper_group_discount FROM jos_vm_shopper_group WHERE vendor_id='1' AND `default`='1'
34
SELECT `product_price`, `product_price_id`, `product_currency` FROM `jos_vm_product_price` WHERE product_id=17 AND shopper_group_id=5   ORDER BY price_quantity_start
35
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='17'
36
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
37
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='AC05'
38
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
39
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'
40
SELECT product_id, `jos_vm_product`.* FROM `jos_vm_product` WHERE `product_id`=35
41
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='35' AND (start_date<='1227137934' OR start_date=0) AND (end_date>='1227051360' OR end_date=0) AND product_discount_id=discount_id
42
SELECT product_parent_id FROM jos_vm_product WHERE product_id=35
43
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='0' AND (start_date<='1227137934' OR start_date=0) AND (end_date>='1227051360' OR end_date=0) AND product_discount_id=discount_id
44
SELECT vendor_id FROM jos_vm_product WHERE product_id='35'
45
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
46
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='35'
47
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
48
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='AP03'
49
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='19' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
50
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`='19'
51
SELECT product_id, `jos_vm_product`.* FROM `jos_vm_product` WHERE `product_id`=19
52
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='19' AND (start_date<='1227137934' OR start_date=0) AND (end_date>='1227051360' OR end_date=0) AND product_discount_id=discount_id
53
SELECT product_parent_id FROM jos_vm_product WHERE product_id=19
54
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='0' AND (start_date<='1227137934' OR start_date=0) AND (end_date>='1227051360' OR end_date=0) AND product_discount_id=discount_id
55
SELECT vendor_id FROM jos_vm_product WHERE product_id='19'
56
SELECT `product_price`, `product_price_id`, `product_currency` FROM `jos_vm_product_price` WHERE product_id=19 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='19'
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='AC07'
60
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='33' 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`='33'
62
SELECT product_id, `jos_vm_product`.* FROM `jos_vm_product` WHERE `product_id`=33
63
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='33' AND (start_date<='1227137934' OR start_date=0) AND (end_date>='1227051360' OR end_date=0) AND product_discount_id=discount_id
64
SELECT product_parent_id FROM jos_vm_product WHERE product_id=33
65
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='0' AND (start_date<='1227137934' OR start_date=0) AND (end_date>='1227051360' OR end_date=0) AND product_discount_id=discount_id
66
SELECT vendor_id FROM jos_vm_product WHERE product_id='33'
67
SELECT `product_price`, `product_price_id`, `product_currency` FROM `jos_vm_product_price` WHERE product_id=33 AND shopper_group_id=5   ORDER BY price_quantity_start
68
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='33'
69
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
70
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='AC03'
71
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='24' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
72
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`='24'
73
SELECT product_id, `jos_vm_product`.* FROM `jos_vm_product` WHERE `product_id`=24
74
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='24' AND (start_date<='1227137934' OR start_date=0) AND (end_date>='1227051360' OR end_date=0) AND product_discount_id=discount_id
75
SELECT product_parent_id FROM jos_vm_product WHERE product_id=24
76
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='0' AND (start_date<='1227137934' OR start_date=0) AND (end_date>='1227051360' OR end_date=0) AND product_discount_id=discount_id
77
SELECT vendor_id FROM jos_vm_product WHERE product_id='24'
78
SELECT `product_price`, `product_price_id`, `product_currency` FROM `jos_vm_product_price` WHERE product_id=24 AND shopper_group_id=5   ORDER BY price_quantity_start
79
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='24'
80
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
81
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='AC15'
82
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='40' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
83
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`='40'
84
SELECT product_id, `jos_vm_product`.* FROM `jos_vm_product` WHERE `product_id`=40
85
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='40' AND (start_date<='1227137934' OR start_date=0) AND (end_date>='1227051360' OR end_date=0) AND product_discount_id=discount_id
86
SELECT product_parent_id FROM jos_vm_product WHERE product_id=40
87
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='0' AND (start_date<='1227137934' OR start_date=0) AND (end_date>='1227051360' OR end_date=0) AND product_discount_id=discount_id
88
SELECT vendor_id FROM jos_vm_product WHERE product_id='40'
89
SELECT `product_price`, `product_price_id`, `product_currency` FROM `jos_vm_product_price` WHERE product_id=40 AND shopper_group_id=5   ORDER BY price_quantity_start
90
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='40'
91
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
92
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='AP04'
93
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='20' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
94
SELECT
                                `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                `jos_vm_category`.`category_flypage`
                        FROM
                                `jos_vm_product`

                        LEFT JOIN `jos_vm_product_category_xref` ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                        LEFT JOIN `jos_vm_category` ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`

                        WHERE `jos_vm_product`.`product_id`='20'
95
SELECT product_id, `jos_vm_product`.* FROM `jos_vm_product` WHERE `product_id`=20
96
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='20' AND (start_date<='1227137934' OR start_date=0) AND (end_date>='1227051360' OR end_date=0) AND product_discount_id=discount_id
97
SELECT product_parent_id FROM jos_vm_product WHERE product_id=20
98
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='0' AND (start_date<='1227137934' OR start_date=0) AND (end_date>='1227051360' OR end_date=0) AND product_discount_id=discount_id
99
SELECT vendor_id FROM jos_vm_product WHERE product_id='20'
100
SELECT `product_price`, `product_price_id`, `product_currency` FROM `jos_vm_product_price` WHERE product_id=20 AND shopper_group_id=5   ORDER BY price_quantity_start
101
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='20'
102
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
103
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='AC12'
104
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='38' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
105
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`='38'
106
SELECT product_id, `jos_vm_product`.* FROM `jos_vm_product` WHERE `product_id`=38
107
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='38' AND (start_date<='1227137934' OR start_date=0) AND (end_date>='1227051360' OR end_date=0) AND product_discount_id=discount_id
108
SELECT product_parent_id FROM jos_vm_product WHERE product_id=38
109
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='0' AND (start_date<='1227137934' OR start_date=0) AND (end_date>='1227051360' OR end_date=0) AND product_discount_id=discount_id
110
SELECT vendor_id FROM jos_vm_product WHERE product_id='38'
111
SELECT `product_price`, `product_price_id`, `product_currency` FROM `jos_vm_product_price` WHERE product_id=38 AND shopper_group_id=5   ORDER BY price_quantity_start
112
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='38'
113
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
114
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='AC06'
115
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='27' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
116
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`='27'
117
SELECT product_id, `jos_vm_product`.* FROM `jos_vm_product` WHERE `product_id`=27
118
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='27' AND (start_date<='1227137934' OR start_date=0) AND (end_date>='1227051360' OR end_date=0) AND product_discount_id=discount_id
119
SELECT product_parent_id FROM jos_vm_product WHERE product_id=27
120
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='0' AND (start_date<='1227137934' OR start_date=0) AND (end_date>='1227051360' OR end_date=0) AND product_discount_id=discount_id
121
SELECT vendor_id FROM jos_vm_product WHERE product_id='27'
122
SELECT `product_price`, `product_price_id`, `product_currency` FROM `jos_vm_product_price` WHERE product_id=27 AND shopper_group_id=5   ORDER BY price_quantity_start
123
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='27'
124
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
125
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='AC09'
126
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='30' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
127
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`='30'
128
SELECT product_id, `jos_vm_product`.* FROM `jos_vm_product` WHERE `product_id`=30
129
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='30' AND (start_date<='1227137934' OR start_date=0) AND (end_date>='1227051360' OR end_date=0) AND product_discount_id=discount_id
130
SELECT product_parent_id FROM jos_vm_product WHERE product_id=30
131
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='0' AND (start_date<='1227137934' OR start_date=0) AND (end_date>='1227051360' OR end_date=0) AND product_discount_id=discount_id
132
SELECT vendor_id FROM jos_vm_product WHERE product_id='30'
133
SELECT `product_price`, `product_price_id`, `product_currency` FROM `jos_vm_product_price` WHERE product_id=30 AND shopper_group_id=5   ORDER BY price_quantity_start
134
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='30'
135
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
136
SELECT id
 FROM jos_menu
 WHERE link = 'index.php?option=com_search'
 AND published = 1
137
SELECT guest, usertype
 FROM jos_session