iconHome iconShop iconContact iconNews iconLinks iContents   Your Cart Show Cart Your Cart is currently empty. iconShop Spareparts GSM CDMA Accessories Dual Services PDA Multimedia Player Perdana 2nd GSM 2nd CDMA 2nd PDA 2nd 2nd CDMA Search Advanced Search Authorized Reseller A-data Apple Asia Track Asus Audiovox Badio Bazel BenQ Beyonce BlackBerry Blue Tech Capdase Coolpad Covertec Creative D-One Dopod Esia Eten Fest Flexi Fren Galeno Garmin Gigabyte Haier Hi-Tech HP HTC Hua Wei I Tech I-mate I-Mobile I-Tech iconhp service im3 Imo Indosat Innopocket Jabra K-Touch Kliptek Kozi Krussel Kyocera Lexcron LG Logitech Manufacturer Martin Case MiTAC Mito Mobile Action Modotel Motorola MWg My G Nexian Nokia O2 OEM Okion Omiz Palm Panasonic Pd Air Pd Ware Philips Piel Frama Pro XL Q-tek Qda Qool Samsung San Disk Sanex Screen Mask Siemens Sierra Wireless Sim Max simpati Sleek Smart Keyboard Snap n Type Sony Sony Ericsson Spirit star one StarTech Swaahoo Sync Gear T-Mobile Takamaru Tarasel Taxco Telkomsel Titan V-Gen Vaio VirtuV Wellcom Xplore Zire ZTE New HP / PDA Nokia 7610 + 128 Rp 1.665.000 Samsung U 900 Rp 1.900.000 Sony Ericsson C510 Rp 1.590.000 Sony Ericsson W 508 Rp 1.700.000 2nd HP / PDA 2nd Apple Iphone 3G 16gb Rp 5.400.000 2nd BlackBerry 9000 BOLD Rp 3.400.000 2nd BlackBerry 9630 TOUR Rp 2.700.000 2nd O2 Atom Exec Rp 850.000 Home Lowongan Kerja di iconhp.com 1. SPG berpengalaman di bidang HP : Berpenampilan menarik Mengerti harga pasaran HP / PDA Mengerti spesifikasi HP / PDA Mampu berkomunikasi dengan baik 2. Operator computer : Windows XP dan Microsoft Office Bisa install program2 HP di computer seperti : PC Suite, Activesync etc Bisa install program untuk HP Bisa Syncrhonise antara HP dan computer Bisa bongkar pasang computer 3. Teknisi berpengalaman : Bisa bongkar pasang HP / PDA Mengerti tentang solder / menyolder Mengerti spesifikasi HP /PDA System gaji dan bonus di terapkan kepada yang berhasil. Hubungi 0216321988 untuk pengaturan jadwal interview. Untuk interview siapkan : Data pribadi : KTP / SIM No telp yang bisa di hubungi CV : daftar sekolah dan pengalaman bekerja Semoga sukses. Last Updated ( Thursday, 18 February 2010 )   iconNews - pda, hp, gadget news New!! NEW: Huawei U8860-51 (Huawei Honor) Expected Release Date: February, 2012 OS: Google Android 2.3.6 (Gingerbread) Features: ... See Detailed Specs NEW: Huawei C8810 Release Date: January, 2012 OS: Google Android 2.3.5 (Gingerbread) Features: ... See Detailed Specs NEW: DataWind UbiSlate 7+ Expected Release Date: February, 2012 OS: Google Android 2.3 (Gingerbread) Features: ... See Detailed Specs EARLIER: DataWind Aakash UbiSlate 7 Release Date: October, 2011 OS: Google Android 2.2 (Froyo) Features: ... See Detailed Specs NEW: Fujitsu Stylistic M350/CA2 Expected Release Date: February, 2012 OS: Google Android 2.3.5 (Gingerbread) Features: ... See Detailed Specs Engadget Refresh Roundup: week of January 30, 2012 Your smartphone and / or tablet is just begging for an update. From time to time, these mobile devices are blessed with maintenance refreshes, bug fixes, custom ROMs and anything in between, and so many of them are floating around that it's easy for a sizable chunk to get lost in the mix. To make sure they don't escape without notice, we've gathered every possible update, hack, and other miscellaneous tomfoolery we could find during the last week and crammed them into one convenient roundup.... Engadget Mobile Podcast 124 - 02.05.2012 There are Samsung phones, there are Motorola phones. There are BlackBerry Phones, there are Nokia phones. But you know what really gets us excited? KDDI phones with ten keys and heart of Japanese Gold. It's the Engadget Mobile Podcast. Hosts: Myriam Joire (tnkgrl), Brad Molen Guests: Joseph Volpe, Dante Cesa Producer:Trent Wolbe Music: Tycho - Coastal Brake (Ghostly International) 00:00:59 - Galaxy Nexus and other CDMA devices removed from Google Support pages 00:03:58 - Motorola Droid RAZR Maxx review 00:20:36 -... Vimeo app lands for Windows Phone, lets you upload your next student film over 3G Hello there Mango fans, is YouTube just a little too lowbrow for you? Well, fret not, Vimeo is here to stream all the HD student shorts your little Microsoft-loving heart desires. The official app doesn't just let you browse, search and view clips on the site, though -- it completely integrates with your account, allowing you to upload HD video, tweak the details of your uploads and even check stats. Basically, with this app in your pocket there's almost no reason to visit... Windows Phone exec Brandon Watson leaves Microsoft, headed to Amazon There's some more corporate reshuffling going on in the Windows Phone universe this week, now that Brandon Watson has confirmed his departure from Microsoft. Watson, who served as head of the WP Developer Experience, announced the news on his Twitter page Friday, and later told ZDNet that he's heading to Amazon, where he'll be Director of the Kindle Cross Platform team. In an e-mail to ZDNet's Mary Jo Foley, Watson acknowledged the difficulty of the decision, but ultimately decided that "the... Sony Ericsson hangs ten, launches Xperia Active Billabong Edition Sony Ericsson is looking to start a bromance with the McTwist-loving, Double-Cork-landing, A-Frame-riding masses jonesing for a new Android device. The handset maker has announced a "global strategic alliance" with Billabong to launch the Xperia Active Billabong Edition smartphone in select markets. The handset will come preloaded with exclusive content, including Billabong screen savers, and bundle several Billabong-branded games and applications. As the two companies tell it, the Xperia ABE is the "ideal smartphone for extreme sports enthusiasts."... detikcom Kompas Tekno Last Updated ( Sunday, 17 January 2010 )   Other Products Touch Screen Audiovox Thera Rp 125.000 Sarung Nokia N95 Rp 200.000 Asus P320 Rp 2.850.000 Screen Guard Nokia 6270 Rp 35.000 Sarung Harrier 6600 Cdma Rp 100.000 Setting Rp 100.000 Sarung Dopod 838 Pro Krussel Rp 320.000 Charger Palm Rp 150.000 Nokia 5310 Rp 1.525.000 Battery Dopod 838 Rp 180.000 Nokia N 86 Rp 4.125.000 Sarung Samsung Rp 325.000 Upgrade Rp 100.000 Card Reader Pocket Multi Card Rp 80.000 Battery Dopod 900 Rp 225.000 Nokia E 75 Rp 3.025.000 Imo G 100 Rp 825.000 Perdana Mentari  Call for Pricing Cassing O2 Xphone2m Rp 420.000 Stylus Dopod 838 Pro Rp 50.000 YM Status pockethp lt.1: pockethp lt.1: iconhp lt.3: iconhp lt.3: Advertisement   You are here because :

1
SET sql_mode = 'MYSQL40'
2
SELECT folder, element, published, params
 FROM jos_mambots
 WHERE published >= 1
 AND access <= 0
 AND folder = 'system'
 ORDER BY ordering
3
SELECT params FROM jos_mambots WHERE element = 'pdabot' AND folder = 'system'
4
SELECT id, link
 FROM jos_menu
 WHERE menutype = 'mainmenu'
 AND published = 1
 ORDER BY parent, ordering
LIMIT 1
5
SELECT template
 FROM jos_templates_menu
 WHERE client_id = 0
 AND ( menuid = 0  OR menuid = 1 )
 ORDER BY menuid DESC
LIMIT 1
6
DELETE FROM jos_session
 WHERE (
 ( time < '1328461774' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1328461774' )
 AND guest = 1
 AND userid = 0
 )
7
SELECT COUNT(*)
 FROM jos_stats_agents
 WHERE agent = 'Unknown'
 AND type = 0
8
UPDATE jos_stats_agents
 SET hits = ( hits + 1 )
 WHERE agent = 'Unknown'
 AND type = 0
9
SELECT COUNT(*)
 FROM jos_stats_agents
 WHERE agent = 'Unknown'
 AND type = 1
10
UPDATE jos_stats_agents
 SET hits = ( hits + 1 )
 WHERE agent = 'Unknown'
 AND type = 1
11
SELECT COUNT(*)
 FROM jos_stats_agents
 WHERE agent = 'Unknown'
 AND type = 2
12
UPDATE jos_stats_agents
 SET hits = ( hits + 1 )
 WHERE agent = 'Unknown'
 AND type = 2
13
SELECT *
 FROM jos_menu
 WHERE id = 1
14
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 <= '2012-02-06 00:24' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-02-06 00:24' )
 AND s.published = 1
 AND cc.published = 1
 AND a.access <= 0
 AND s.access <= 0
 AND cc.access <= 0
15
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 <= '2012-02-06 00:24' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-02-06 00:24' )
 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
16
SELECT folder, element, published, params
 FROM jos_mambots
 WHERE access <= 0
 AND folder = 'content'
 ORDER BY ordering
17
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_ts' AND folder = 'content'
18
SELECT *
 FROM jos_mambots
 WHERE id = '23'
19
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);
20
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'
21
SELECT `name` FROM `jos_core_acl_aro_groups` WHERE `group_id` =29
22
SELECT `lft`, `rgt` FROM `jos_core_acl_aro_groups` WHERE `name`='Public Frontend'
23
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
24
SELECT `lft`, `rgt` FROM `jos_core_acl_aro_groups` WHERE `name`='Public Backend'
25
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
26
SELECT id FROM jos_mambots WHERE element = 'kl_rssfeed' AND folder = 'content'
27
SELECT *
 FROM jos_mambots
 WHERE id = '24'
28
SELECT id FROM jos_mambots WHERE element = 'kl_rssfeed' AND folder = 'content'
29
SELECT *
 FROM jos_mambots
 WHERE id = '24'
30
SELECT id FROM jos_mambots WHERE element = 'kl_rssfeed' AND folder = 'content'
31
SELECT *
 FROM jos_mambots
 WHERE id = '24'
32
SELECT id FROM jos_mambots WHERE element = 'kl_rssfeed' AND folder = 'content'
33
SELECT *
 FROM jos_mambots
 WHERE id = '24'
34
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_ts' AND folder = 'content'
35
SELECT *
 FROM jos_mambots
 WHERE id = '23'
36
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'
37
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
38
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'topmenu'
 AND published = 1
 AND access <= 0
 AND parent = 0
 ORDER BY ordering
39
SELECT id
 FROM jos_menu
 WHERE link = 'index.php?option=com_search'
 AND published = 1
40
SELECT id FROM jos_menu WHERE link='index.php?option=com_virtuemart' AND published=1 AND access=0
41
SELECT user_info_id from `jos_vm_user_info` WHERE user_id='0' AND address_type='BT'
42
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
43
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 != ''
44
SELECT a.manufacturer_id,a.mf_name FROM jos_vm_manufacturer AS a ORDER BY a.mf_name ASC
45
SELECT *
 FROM jos_banner
 WHERE showBanner=1
46
UPDATE jos_banner
 SET impmade = impmade + 1
 WHERE bid = 9
47
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'
48
SELECT p.*, c.category_name, c.category_id, c.category_flypage, m.mf_name, m.mf_url, m.manufacturer_id  FROM jos_vm_product AS p LEFT JOIN jos_vm_product_votes AS pv ON (pv.product_id = p.product_id) LEFT JOIN jos_vm_product_price AS pp ON (pp.product_id = p.product_id),jos_vm_product_category_xref as pcx, jos_vm_category AS c, jos_vm_category_xref as cx, jos_vm_product_mf_xref AS mx, jos_vm_manufacturer as m  WHERE c.category_publish = 'Y'  AND c.category_id = pcx.category_id AND (pcx.product_id = p.product_id OR pcx.product_id = p.product_parent_id) AND mx.product_id = p.product_id AND m.manufacturer_id = mx.manufacturer_id  AND p.product_publish='Y' AND (pcx.category_id = 1 OR pcx.category_id = 2 OR pcx.category_id = 3 OR pcx.category_id = 4 OR pcx.category_id = 5 OR pcx.category_id = 6 OR pcx.category_id = 7 OR pcx.category_id = 8 OR pcx.category_id = 9 OR pcx.category_id = 10 OR pcx.category_id = 11 OR pcx.category_id = 12 OR pcx.category_id = 13 OR pcx.category_id = 14 OR pcx.category_id = 15 OR pcx.category_id = 16 OR pcx.category_id = 17 OR pcx.category_id = 18 OR pcx.category_id = 19 OR pcx.category_id = 20)  AND cx.category_child_id = pcx.category_id AND p.product_full_image <> '' GROUP BY p.product_id ORDER BY RAND()  LIMIT 4
49
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='1227'
50
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='1227' AND (start_date<='1328462676' OR start_date=0) AND (end_date>='1328459760' OR end_date=0) AND product_discount_id=discount_id
51
SELECT vendor_id FROM jos_vm_product WHERE product_id='1227'
52
SELECT shopper_group_id,shopper_group_discount FROM jos_vm_shopper_group WHERE vendor_id='1' AND `default`='1'
53
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='1227'
54
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='1227' 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='1227'
56
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='1227' 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='1227'
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` FROM jos_vm_product WHERE product_id='325'
60
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='325' AND (start_date<='1328462676' OR start_date=0) AND (end_date>='1328459760' OR end_date=0) AND product_discount_id=discount_id
61
SELECT vendor_id FROM jos_vm_product WHERE product_id='325'
62
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='325'
63
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='325' 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
64
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='325'
65
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='325' AND shopper_group_id='5'  ORDER BY price_quantity_start
66
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='325'
67
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='1448'
68
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='1448' AND (start_date<='1328462676' OR start_date=0) AND (end_date>='1328459760' OR end_date=0) AND product_discount_id=discount_id
69
SELECT vendor_id FROM jos_vm_product WHERE product_id='1448'
70
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='1448'
71
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='1448' 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
72
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='1448'
73
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='1448' AND shopper_group_id='5'  ORDER BY price_quantity_start
74
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='1448'
75
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='1485'
76
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='1485' AND (start_date<='1328462676' OR start_date=0) AND (end_date>='1328459760' OR end_date=0) AND product_discount_id=discount_id
77
SELECT vendor_id FROM jos_vm_product WHERE product_id='1485'
78
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='1485'
79
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='1485' 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
80
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='1485'
81
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='1485' AND shopper_group_id='5'  ORDER BY price_quantity_start
82
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='1485'
83
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'
84
SELECT p.*, c.category_name, c.category_id, c.category_flypage, m.mf_name, m.mf_url, m.manufacturer_id  FROM jos_vm_product AS p LEFT JOIN jos_vm_product_votes AS pv ON (pv.product_id = p.product_id) LEFT JOIN jos_vm_product_price AS pp ON (pp.product_id = p.product_id),jos_vm_product_category_xref as pcx, jos_vm_category AS c, jos_vm_category_xref as cx, jos_vm_product_mf_xref AS mx, jos_vm_manufacturer as m  WHERE c.category_publish = 'Y'  AND c.category_id = pcx.category_id AND (pcx.product_id = p.product_id OR pcx.product_id = p.product_parent_id) AND mx.product_id = p.product_id AND m.manufacturer_id = mx.manufacturer_id  AND p.product_publish='Y' AND (pcx.category_id = 86 OR pcx.category_id = 87 OR pcx.category_id = 88 OR pcx.category_id = 89 OR pcx.category_id = 90 OR pcx.category_id = 91 OR pcx.category_id = 92 OR pcx.category_id = 93 OR pcx.category_id = 94 OR pcx.category_id = 95 OR pcx.category_id = 96 OR pcx.category_id = 97 OR pcx.category_id = 98 OR pcx.category_id = 99 OR pcx.category_id = 100 OR pcx.category_id = 101 OR pcx.category_id = 102 OR pcx.category_id = 103 OR pcx.category_id = 104 OR pcx.category_id = 105 OR pcx.category_id = 106 OR pcx.category_id = 107 OR pcx.category_id = 108 OR pcx.category_id = 109 OR pcx.category_id = 110 OR pcx.category_id = 111 OR pcx.category_id = 112 OR pcx.category_id = 113 OR pcx.category_id = 114 OR pcx.category_id = 115 OR pcx.category_id = 116 OR pcx.category_id = 117 OR pcx.category_id = 118 OR pcx.category_id = 119 OR pcx.category_id = 120 OR pcx.category_id = 121 OR pcx.category_id = 122 OR pcx.category_id = 123 OR pcx.category_id = 124 OR pcx.category_id = 125 OR pcx.category_id = 126 OR pcx.category_id = 127 OR pcx.category_id = 128 OR pcx.category_id = 129 OR pcx.category_id = 130)  AND cx.category_child_id = pcx.category_id AND p.product_full_image <> '' GROUP BY p.product_id ORDER BY RAND()  LIMIT 4
85
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='1720'
86
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='1720' AND (start_date<='1328462676' OR start_date=0) AND (end_date>='1328459760' OR end_date=0) AND product_discount_id=discount_id
87
SELECT vendor_id FROM jos_vm_product WHERE product_id='1720'
88
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='1720'
89
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='1720' 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
90
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='1720'
91
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='1720' AND shopper_group_id='5'  ORDER BY price_quantity_start
92
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='1720'
93
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='1597'
94
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='1597' AND (start_date<='1328462676' OR start_date=0) AND (end_date>='1328459760' OR end_date=0) AND product_discount_id=discount_id
95
SELECT vendor_id FROM jos_vm_product WHERE product_id='1597'
96
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='1597'
97
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='1597' 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
98
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='1597'
99
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='1597' AND shopper_group_id='5'  ORDER BY price_quantity_start
100
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='1597'
101
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='1599'
102
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='1599' AND (start_date<='1328462676' OR start_date=0) AND (end_date>='1328459760' OR end_date=0) AND product_discount_id=discount_id
103
SELECT vendor_id FROM jos_vm_product WHERE product_id='1599'
104
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='1599'
105
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='1599' 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
106
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='1599'
107
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='1599' AND shopper_group_id='5'  ORDER BY price_quantity_start
108
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='1599'
109
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='2123'
110
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='2123' AND (start_date<='1328462676' OR start_date=0) AND (end_date>='1328459760' OR end_date=0) AND product_discount_id=discount_id
111
SELECT vendor_id FROM jos_vm_product WHERE product_id='2123'
112
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='2123'
113
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='2123' 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
114
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='2123'
115
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='2123' AND shopper_group_id='5'  ORDER BY price_quantity_start
116
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='2123'
117
SELECT id, name, link, parent, type, menutype, access
 FROM jos_menu
 WHERE published = 1
 AND access <= 0
 ORDER BY menutype, parent, ordering
118
SELECT p.product_sku FROM jos_vm_product AS p
 WHERE p.product_publish = 'Y' AND product_parent_id=0 
 ORDER BY RAND() LIMIT 20
119
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='Tchs Audiovox Thera'
120
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='944' 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`='944'
122
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='944'
123
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='944' AND (start_date<='1328462676' OR start_date=0) AND (end_date>='1328459760' OR end_date=0) AND product_discount_id=discount_id
124
SELECT vendor_id FROM jos_vm_product WHERE product_id='944'
125
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='944'
126
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='944' 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='944'
128
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='944' 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='944'
130
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='Sr Nokia N95'
131
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='814' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
132
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`='814'
133
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='814'
134
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='814' AND (start_date<='1328462676' OR start_date=0) AND (end_date>='1328459760' OR end_date=0) AND product_discount_id=discount_id
135
SELECT vendor_id FROM jos_vm_product WHERE product_id='814'
136
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='814'
137
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='814' 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
138
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='814'
139
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='814' AND shopper_group_id='5'  ORDER BY price_quantity_start
140
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='814'
141
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='Asus P320'
142
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='1525' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
143
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`='1525'
144
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='1525'
145
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='1525' AND (start_date<='1328462676' OR start_date=0) AND (end_date>='1328459760' OR end_date=0) AND product_discount_id=discount_id
146
SELECT vendor_id FROM jos_vm_product WHERE product_id='1525'
147
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='1525'
148
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='1525' 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
149
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='1525'
150
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='1525' AND shopper_group_id='5'  ORDER BY price_quantity_start
151
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='1525'
152
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='Sg Nokia 6270'
153
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='653' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
154
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`='653'
155
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='653'
156
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='653' AND (start_date<='1328462676' OR start_date=0) AND (end_date>='1328459760' OR end_date=0) AND product_discount_id=discount_id
157
SELECT vendor_id FROM jos_vm_product WHERE product_id='653'
158
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='653'
159
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='653' 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
160
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='653'
161
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='653' AND shopper_group_id='5'  ORDER BY price_quantity_start
162
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='653'
163
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='Sr Harrier 6600'
164
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='766' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
165
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`='766'
166
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='766'
167
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='766' AND (start_date<='1328462676' OR start_date=0) AND (end_date>='1328459760' OR end_date=0) AND product_discount_id=discount_id
168
SELECT vendor_id FROM jos_vm_product WHERE product_id='766'
169
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='766'
170
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='766' 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
171
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='766'
172
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='766' AND shopper_group_id='5'  ORDER BY price_quantity_start
173
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='766'
174
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='Setting'
175
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='623' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
176
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`='623'
177
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='623'
178
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='623' AND (start_date<='1328462676' OR start_date=0) AND (end_date>='1328459760' OR end_date=0) AND product_discount_id=discount_id
179
SELECT vendor_id FROM jos_vm_product WHERE product_id='623'
180
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='623'
181
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='623' 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
182
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='623'
183
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='623' AND shopper_group_id='5'  ORDER BY price_quantity_start
184
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='623'
185
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='Sr Dopod 838 Pro Krussel'
186
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='748' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
187
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`='748'
188
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='748'
189
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='748' AND (start_date<='1328462676' OR start_date=0) AND (end_date>='1328459760' OR end_date=0) AND product_discount_id=discount_id
190
SELECT vendor_id FROM jos_vm_product WHERE product_id='748'
191
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='748'
192
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='748' 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
193
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='748'
194
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='748' AND shopper_group_id='5'  ORDER BY price_quantity_start
195
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='748'
196
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='Chr Palm'
197
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='332' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
198
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`='332'
199
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='332'
200
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='332' AND (start_date<='1328462676' OR start_date=0) AND (end_date>='1328459760' OR end_date=0) AND product_discount_id=discount_id
201
SELECT vendor_id FROM jos_vm_product WHERE product_id='332'
202
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='332'
203
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='332' 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
204
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='332'
205
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='332' AND shopper_group_id='5'  ORDER BY price_quantity_start
206
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='332'
207
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='Nokia 5310'
208
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='1186' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
209
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`='1186'
210
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='1186'
211
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='1186' AND (start_date<='1328462676' OR start_date=0) AND (end_date>='1328459760' OR end_date=0) AND product_discount_id=discount_id
212
SELECT vendor_id FROM jos_vm_product WHERE product_id='1186'
213
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='1186'
214
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='1186' 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
215
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='1186'
216
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='1186' AND shopper_group_id='5'  ORDER BY price_quantity_start
217
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='1186'
218
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='Bat Dopod 838'
219
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='13' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
220
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`='13'
221
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='13'
222
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='13' AND (start_date<='1328462676' OR start_date=0) AND (end_date>='1328459760' OR end_date=0) AND product_discount_id=discount_id
223
SELECT vendor_id FROM jos_vm_product WHERE product_id='13'
224
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='13'
225
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='13' 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
226
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='13'
227
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='13' AND shopper_group_id='5'  ORDER BY price_quantity_start
228
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='13'
229
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='Nokia N 86'
230
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='1481' 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`='1481'
232
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='1481'
233
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='1481' AND (start_date<='1328462676' OR start_date=0) AND (end_date>='1328459760' OR end_date=0) AND product_discount_id=discount_id
234
SELECT vendor_id FROM jos_vm_product WHERE product_id='1481'
235
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='1481'
236
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='1481' 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='1481'
238
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='1481' AND shopper_group_id='5'  ORDER BY price_quantity_start
239
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='1481'
240
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='Sr Samsung'
241
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='853' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
242
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`='853'
243
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='853'
244
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='853' AND (start_date<='1328462676' OR start_date=0) AND (end_date>='1328459760' OR end_date=0) AND product_discount_id=discount_id
245
SELECT vendor_id FROM jos_vm_product WHERE product_id='853'
246
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='853'
247
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='853' 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
248
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='853'
249
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='853' AND shopper_group_id='5'  ORDER BY price_quantity_start
250
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='853'
251
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='Upgrade'
252
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='955' 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`='955'
254
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='955'
255
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='955' AND (start_date<='1328462676' OR start_date=0) AND (end_date>='1328459760' OR end_date=0) AND product_discount_id=discount_id
256
SELECT vendor_id FROM jos_vm_product WHERE product_id='955'
257
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='955'
258
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='955' 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='955'
260
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='955' 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='955'
262
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='Crdr Multi'
263
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='383' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
264
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`='383'
265
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='383'
266
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='383' AND (start_date<='1328462676' OR start_date=0) AND (end_date>='1328459760' OR end_date=0) AND product_discount_id=discount_id
267
SELECT vendor_id FROM jos_vm_product WHERE product_id='383'
268
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='383'
269
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='383' 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
270
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='383'
271
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='383' AND shopper_group_id='5'  ORDER BY price_quantity_start
272
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='383'
273
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='Bat Dopod 900'
274
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='15' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
275
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`='15'
276
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='15'
277
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='15' AND (start_date<='1328462676' OR start_date=0) AND (end_date>='1328459760' OR end_date=0) AND product_discount_id=discount_id
278
SELECT vendor_id FROM jos_vm_product WHERE product_id='15'
279
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='15'
280
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='15' 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
281
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='15'
282
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='15' AND shopper_group_id='5'  ORDER BY price_quantity_start
283
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='15'
284
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='Nokia E 75'
285
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='1453' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
286
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`='1453'
287
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='1453'
288
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='1453' AND (start_date<='1328462676' OR start_date=0) AND (end_date>='1328459760' OR end_date=0) AND product_discount_id=discount_id
289
SELECT vendor_id FROM jos_vm_product WHERE product_id='1453'
290
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='1453'
291
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='1453' 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
292
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='1453'
293
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='1453' AND shopper_group_id='5'  ORDER BY price_quantity_start
294
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='1453'
295
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='Imo G 100'
296
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='1441' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
297
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`='1441'
298
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='1441'
299
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='1441' AND (start_date<='1328462676' OR start_date=0) AND (end_date>='1328459760' OR end_date=0) AND product_discount_id=discount_id
300
SELECT vendor_id FROM jos_vm_product WHERE product_id='1441'
301
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='1441'
302
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='1441' 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
303
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='1441'
304
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='1441' AND shopper_group_id='5'  ORDER BY price_quantity_start
305
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='1441'
306
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='Perdana Men'
307
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='1330' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
308
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`='1330'
309
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='1330'
310
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='1330' AND (start_date<='1328462676' OR start_date=0) AND (end_date>='1328459760' OR end_date=0) AND product_discount_id=discount_id
311
SELECT vendor_id FROM jos_vm_product WHERE product_id='1330'
312
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='1330'
313
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='1330' 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
314
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='1330' 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
315
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='0' 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
316
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='0' 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='1330'
318
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='1330' AND shopper_group_id='5'  ORDER BY price_quantity_start
319
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='1330' AND shopper_group_id='5'  ORDER BY price_quantity_start
320
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='0' AND shopper_group_id='5'  ORDER BY price_quantity_start
321
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='0' AND shopper_group_id='5'  ORDER BY price_quantity_start
322
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='Chs O2 Xphone2m'
323
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='367' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
324
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`='367'
325
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='367'
326
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='367' AND (start_date<='1328462676' OR start_date=0) AND (end_date>='1328459760' OR end_date=0) AND product_discount_id=discount_id
327
SELECT vendor_id FROM jos_vm_product WHERE product_id='367'
328
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='367'
329
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='367' 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
330
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='367'
331
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='367' AND shopper_group_id='5'  ORDER BY price_quantity_start
332
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='367'
333
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='Sty Dopod 838pro'
334
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='905' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
335
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`='905'
336
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='905'
337
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='905' AND (start_date<='1328462676' OR start_date=0) AND (end_date>='1328459760' OR end_date=0) AND product_discount_id=discount_id
338
SELECT vendor_id FROM jos_vm_product WHERE product_id='905'
339
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='905'
340
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='905' 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
341
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='905'
342
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='905' AND shopper_group_id='5'  ORDER BY price_quantity_start
343
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='905'
344
SELECT jos_artbannersplus.* FROM jos_artbannersplus,
                          jos_artbannersplus_categories,
                          jos_artbannersplus_clients
      WHERE 1 AND 
		  (('2012-02-06' <= publish_down_date OR publish_down_date = '0000-00-00')
		  AND '2012-02-06' >= publish_up_date
		  AND ((reccurtype = 0)
		      OR (reccurtype = 1 AND reccurweekdays LIKE '%1%'))
		  AND '11:24:36' >= publish_up_time
		  AND ('11:24:36' <= publish_down_time OR publish_down_time = '00:00:00')
		  AND access <= '0'
      AND state = '1'
      AND jos_artbannersplus.tid = jos_artbannersplus_categories.id
      AND jos_artbannersplus_categories.published = 1
      AND jos_artbannersplus.cid = jos_artbannersplus_clients.cid
      AND jos_artbannersplus_clients.published = 1 ) ORDER BY last_show ASC, msec ASC
345
SELECT jos_artbannersplus.* FROM jos_artbannersplus,
                          jos_artbannersplus_categories,
                          jos_artbannersplus_clients
      WHERE 1 AND 
		  (('2012-02-06' <= publish_down_date OR publish_down_date = '0000-00-00')
		  AND '2012-02-06' >= publish_up_date
		  AND ((reccurtype = 0)
		      OR (reccurtype = 1 AND reccurweekdays LIKE '%1%'))
		  AND '11:24:36' >= publish_up_time
		  AND ('11:24:36' <= publish_down_time OR publish_down_time = '00:00:00')
		  AND access <= '0'
      AND state = '1'
      AND jos_artbannersplus.tid = jos_artbannersplus_categories.id
      AND jos_artbannersplus_categories.published = 1
      AND jos_artbannersplus.cid = jos_artbannersplus_clients.cid
      AND jos_artbannersplus_clients.published = 1 ) ORDER BY last_show ASC, msec ASC