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 Motorola Q8 Rp 1.050.000 Samsung C6625 Rp 1.750.000 Sony Ericsson T707 Rp 1.725.000 Motorola W 175 Rp 250.000 2nd HP / PDA 2nd Blackberry 9500 STORM Rp 2.700.000 2nd HTC Tytn II Rp 2.500.000 2nd Nokia 6600 fold Rp 1.300.000 2nd O2 Atom 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!! COMING SOON: HTC Primo Expected Release Date: March, 2012 OS: Google Android 4.0.1 (Ice Cream Sandwich) Features: ... See Detailed Specs COMING SOON: ZTE T72 Expected Release Date: February, 2012 OS: Google Android 2.3.5 (Gingerbread) Features: ... See Detailed Specs FUTURE: LG Optimus 3D 2 (LG CX2) Expected Release Date: April, 2012 Successor of LG P920 Optimus 3D / P920H OS: Google Android 2.3.7 (Gingerbread) Features: ... See Detailed Specs COMING SOON: ZTE Light Tab 2 (ZTE V9A) Expected Release Date: February, 2012 OS: Google Android 2.3.5 (Gingerbread) Features: ... See Detailed Specs NEW: Orange Tahiti Release Date: January, 2012 OS: Google Android 3.2.1 Features: ... See Detailed Specs Engadget HTC Titan II works its charm on the FCC with AT&T LTE included What's that? An HTC PI86100 Windows Phone with AT&T-specific LTE (bands 4 and 17) showing up in the hallowed halls of the FCC? Why, this must be the Titan II, announced a tad over a fortnight ago. Docs show that a production unit of the device, sporting the aforementioned LTE bands as well as 850 / 1900 3G (also AT&T compatible), is ready to take on its new Windows Phone competition sometime... Insert Coin: Dash car stereo gives your iPhone a new home, away from the cupholder (video) In Insert Coin, we look at an exciting new tech project that requires funding before it can hit production. If you'd like to pitch a project, please send us a tip with "Insert Coin" as the subject line. We're pretty fond of new ways to integrate smartphones with car stereos here at Engadget, which is why we're particularly intrigued by a new Kickstarter project called Dash. Unlike MirrorLink, which reflects a phone's interface onto a larger touchscreen, this nifty creation puts the smartphone front and center in the stereo... The Love Box is an analog video mixer, house of mirrors for your iPhone (video) There's something romantic about hacking the iPhone, especially when it means finding ways to personalize the massively popular handset. Apps like Instagram may help you realize artistic talent, but software just doesn't get those creative juices flowing like an old-fashioned piece of hardware can. Despite its taboo-sounding name, The Love Box isn't an adult toy in the traditional sense, instead serving as an analog video (and stills) mixer for your iPhone 4 or 4S. Consisting of a wooden box and an angled sliding mirror, the homegrown contraption... Sony Xperia S jogs past the FCC carrying AT&T 3G radios The FCC boys were clutching at their multimeters in horror when they saw how much work they'd have to do when Sony's new Xperia S rolled into the bunker. Still, their loss is connectivity's gain, as the Ericsson-branded (for now, at least) phone packs quad-band GSM / EDGE, 850 / 900 / 1900 / 2100 UMTS and HSPA, RFID, Bluetooth 2.0 + EDR, 802.11 WiFi b/g/n and GPS. ANT+ is also included, which is a healthy sign that support for the fitness tracker will... Strategy Analytics: Nokia tops global handset shipments, Apple sees quarterly surge Fresh off the publication of its latest tablet report, Strategy Analytics has come out with a new batch of statistics on the global mobile market. In a report published yesterday, the research firm crowned Apple as the world's largest smartphone vendor by volume, on the strength of the 37 million iPhones it shipped during Q4 2011 -- good for 23.9 percent of the market. Samsung wasn't too far... detikcom Kompas Tekno Last Updated ( Sunday, 17 January 2010 )   Other Products Charger O2 Xphone2 Rp 180.000 Lcd Ipaq 6300 Rp 650.000 Screen Guard Xplore G 18/88 Rp 50.000 Modem Audiovox Thera Rp 125.000 Nokia 5130 Xpress music Rp 1.050.000 Nokia 7610 + 128 Rp 1.665.000 Battery O2 Xda Mini Rp 250.000 HP Ipaq 1950  Call for Pricing Perdana Mentari  Call for Pricing Stylus Ipaq 4150 Rp 50.000 Screen Guard DopoD S300 Rp 50.000 Sarung HTC TyTn Rp 320.000 Screen Guard Samsung I600 Rp 50.000 Screen Guard Sony Ericsson Z 520 Rp 50.000 Battery Nokia 9500 Rp 375.000 Battery Nokia 6585 Bld-3 Rp 25.000 Car Charger Nokia Rp 75.000 Lcd Atom Rp 800.000 Speaker O2 Xda2s Rp 50.000 Sarung O2 Xda Mini Kristal 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 < '1327697441' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1327697441' )
 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-01-28 04:05' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-01-28 04:05' )
 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-01-28 04:05' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-01-28 04:05' )
 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='1490'
50
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='1490' AND (start_date<='1327698342' OR start_date=0) AND (end_date>='1327682160' OR end_date=0) AND product_discount_id=discount_id
51
SELECT vendor_id FROM jos_vm_product WHERE product_id='1490'
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='1490'
54
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='1490' 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='1490'
56
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='1490' 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='1490'
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='1489'
60
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='1489' AND (start_date<='1327698342' OR start_date=0) AND (end_date>='1327682160' OR end_date=0) AND product_discount_id=discount_id
61
SELECT vendor_id FROM jos_vm_product WHERE product_id='1489'
62
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='1489'
63
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='1489' 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='1489'
65
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='1489' 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='1489'
67
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='1488'
68
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='1488' AND (start_date<='1327698342' OR start_date=0) AND (end_date>='1327682160' OR end_date=0) AND product_discount_id=discount_id
69
SELECT vendor_id FROM jos_vm_product WHERE product_id='1488'
70
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='1488'
71
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='1488' 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='1488'
73
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='1488' 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='1488'
75
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='1514'
76
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='1514' AND (start_date<='1327698342' OR start_date=0) AND (end_date>='1327682160' OR end_date=0) AND product_discount_id=discount_id
77
SELECT vendor_id FROM jos_vm_product WHERE product_id='1514'
78
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='1514'
79
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='1514' 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='1514'
81
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='1514' 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='1514'
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='1598'
86
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='1598' AND (start_date<='1327698342' OR start_date=0) AND (end_date>='1327682160' OR end_date=0) AND product_discount_id=discount_id
87
SELECT vendor_id FROM jos_vm_product WHERE product_id='1598'
88
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='1598'
89
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='1598' 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='1598'
91
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='1598' 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='1598'
93
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='1674'
94
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='1674' AND (start_date<='1327698342' OR start_date=0) AND (end_date>='1327682160' OR end_date=0) AND product_discount_id=discount_id
95
SELECT vendor_id FROM jos_vm_product WHERE product_id='1674'
96
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='1674'
97
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='1674' 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='1674'
99
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='1674' 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='1674'
101
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='2010'
102
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='2010' AND (start_date<='1327698342' OR start_date=0) AND (end_date>='1327682160' OR end_date=0) AND product_discount_id=discount_id
103
SELECT vendor_id FROM jos_vm_product WHERE product_id='2010'
104
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='2010'
105
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='2010' 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='2010'
107
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='2010' 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='2010'
109
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='2122'
110
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='2122' AND (start_date<='1327698342' OR start_date=0) AND (end_date>='1327682160' OR end_date=0) AND product_discount_id=discount_id
111
SELECT vendor_id FROM jos_vm_product WHERE product_id='2122'
112
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='2122'
113
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='2122' 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='2122'
115
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='2122' 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='2122'
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='Chr O2 Xphone2'
120
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='331' 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`='331'
122
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='331'
123
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='331' AND (start_date<='1327698342' OR start_date=0) AND (end_date>='1327682160' OR end_date=0) AND product_discount_id=discount_id
124
SELECT vendor_id FROM jos_vm_product WHERE product_id='331'
125
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='331'
126
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='331' 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='331'
128
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='331' 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='331'
130
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='Lcd HP Ipaq 6300'
131
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='984' 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`='984'
133
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='984'
134
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='984' AND (start_date<='1327698342' OR start_date=0) AND (end_date>='1327682160' OR end_date=0) AND product_discount_id=discount_id
135
SELECT vendor_id FROM jos_vm_product WHERE product_id='984'
136
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='984'
137
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='984' 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='984'
139
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='984' 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='984'
141
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='Sg Xplore G18'
142
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='703' 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`='703'
144
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='703'
145
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='703' AND (start_date<='1327698342' OR start_date=0) AND (end_date>='1327682160' OR end_date=0) AND product_discount_id=discount_id
146
SELECT vendor_id FROM jos_vm_product WHERE product_id='703'
147
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='703'
148
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='703' 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='703'
150
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='703' 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='703'
152
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='Modem Audiovox Thera'
153
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='1089' 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`='1089'
155
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='1089'
156
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='1089' AND (start_date<='1327698342' OR start_date=0) AND (end_date>='1327682160' OR end_date=0) AND product_discount_id=discount_id
157
SELECT vendor_id FROM jos_vm_product WHERE product_id='1089'
158
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='1089'
159
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='1089' 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='1089'
161
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='1089' 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='1089'
163
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='Nokia 5130 Xpress music'
164
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='1442' 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`='1442'
166
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='1442'
167
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='1442' AND (start_date<='1327698342' OR start_date=0) AND (end_date>='1327682160' OR end_date=0) AND product_discount_id=discount_id
168
SELECT vendor_id FROM jos_vm_product WHERE product_id='1442'
169
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='1442'
170
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='1442' 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='1442'
172
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='1442' 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='1442'
174
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='Nokia 7610'
175
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='1227' 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`='1227'
177
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='1227'
178
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='1227' AND (start_date<='1327698342' OR start_date=0) AND (end_date>='1327682160' OR end_date=0) AND product_discount_id=discount_id
179
SELECT vendor_id FROM jos_vm_product WHERE product_id='1227'
180
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='1227'
181
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
182
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='1227'
183
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
184
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='1227'
185
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='Bat O2 Xda Mini'
186
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='75' 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`='75'
188
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='75'
189
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='75' AND (start_date<='1327698342' OR start_date=0) AND (end_date>='1327682160' OR end_date=0) AND product_discount_id=discount_id
190
SELECT vendor_id FROM jos_vm_product WHERE product_id='75'
191
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='75'
192
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='75' 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='75'
194
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='75' 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='75'
196
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='HP Ipaq 1950'
197
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='451' 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`='451'
199
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='451'
200
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='451' AND (start_date<='1327698342' OR start_date=0) AND (end_date>='1327682160' OR end_date=0) AND product_discount_id=discount_id
201
SELECT vendor_id FROM jos_vm_product WHERE product_id='451'
202
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='451'
203
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='451' 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_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='451' 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
205
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
206
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
207
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='451'
208
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='451' AND shopper_group_id='5'  ORDER BY price_quantity_start
209
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='451' AND shopper_group_id='5'  ORDER BY price_quantity_start
210
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
211
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
212
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='Perdana Men'
213
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
214
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'
215
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='1330'
216
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='1330' AND (start_date<='1327698342' OR start_date=0) AND (end_date>='1327682160' OR end_date=0) AND product_discount_id=discount_id
217
SELECT vendor_id FROM jos_vm_product WHERE product_id='1330'
218
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='1330'
219
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
220
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
221
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
222
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
223
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='1330'
224
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
225
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
226
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
227
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
228
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='Sty HP Ipaq 4150'
229
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='913' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
230
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`='913'
231
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='913'
232
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='913' AND (start_date<='1327698342' OR start_date=0) AND (end_date>='1327682160' OR end_date=0) AND product_discount_id=discount_id
233
SELECT vendor_id FROM jos_vm_product WHERE product_id='913'
234
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='913'
235
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='913' 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
236
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='913'
237
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='913' AND shopper_group_id='5'  ORDER BY price_quantity_start
238
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='913'
239
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='Sg Dopod S300'
240
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='627' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
241
SELECT
                                `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                `jos_vm_category`.`category_flypage`
                        FROM
                                `jos_vm_product`

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

                        WHERE `jos_vm_product`.`product_id`='627'
242
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='627'
243
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='627' AND (start_date<='1327698342' OR start_date=0) AND (end_date>='1327682160' OR end_date=0) AND product_discount_id=discount_id
244
SELECT vendor_id FROM jos_vm_product WHERE product_id='627'
245
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='627'
246
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='627' AND shopper_group_id='5'  AND (('0' >= price_quantity_start AND '0' <= price_quantity_end)
                                OR (price_quantity_end='0') OR ('0' > price_quantity_end)) ORDER BY price_quantity_end DESC
247
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='627'
248
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='627' AND shopper_group_id='5'  ORDER BY price_quantity_start
249
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='627'
250
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='Sr HTC TyTn'
251
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='778' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
252
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`='778'
253
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='778'
254
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='778' AND (start_date<='1327698342' OR start_date=0) AND (end_date>='1327682160' OR end_date=0) AND product_discount_id=discount_id
255
SELECT vendor_id FROM jos_vm_product WHERE product_id='778'
256
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='778'
257
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='778' 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
258
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='778'
259
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='778' AND shopper_group_id='5'  ORDER BY price_quantity_start
260
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='778'
261
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='Sg Sam I600'
262
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='682' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
263
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`='682'
264
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='682'
265
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='682' AND (start_date<='1327698342' OR start_date=0) AND (end_date>='1327682160' OR end_date=0) AND product_discount_id=discount_id
266
SELECT vendor_id FROM jos_vm_product WHERE product_id='682'
267
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='682'
268
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='682' 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
269
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='682'
270
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='682' AND shopper_group_id='5'  ORDER BY price_quantity_start
271
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='682'
272
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='Sg SE Z520'
273
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='700' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
274
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`='700'
275
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='700'
276
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='700' AND (start_date<='1327698342' OR start_date=0) AND (end_date>='1327682160' OR end_date=0) AND product_discount_id=discount_id
277
SELECT vendor_id FROM jos_vm_product WHERE product_id='700'
278
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='700'
279
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='700' 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
280
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='700'
281
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='700' AND shopper_group_id='5'  ORDER BY price_quantity_start
282
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='700'
283
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='Bat Nokia 9500'
284
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
285
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'
286
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='33'
287
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='33' AND (start_date<='1327698342' OR start_date=0) AND (end_date>='1327682160' OR end_date=0) AND product_discount_id=discount_id
288
SELECT vendor_id FROM jos_vm_product WHERE product_id='33'
289
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='33'
290
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='33' 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
291
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='33'
292
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
293
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='33'
294
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='Bat Nokia 6585'
295
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='28' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
296
SELECT
                                `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                `jos_vm_category`.`category_flypage`
                        FROM
                                `jos_vm_product`

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

                        WHERE `jos_vm_product`.`product_id`='28'
297
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='28'
298
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='28' AND (start_date<='1327698342' OR start_date=0) AND (end_date>='1327682160' OR end_date=0) AND product_discount_id=discount_id
299
SELECT vendor_id FROM jos_vm_product WHERE product_id='28'
300
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='28'
301
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='28' AND shopper_group_id='5'  AND (('0' >= price_quantity_start AND '0' <= price_quantity_end)
                                OR (price_quantity_end='0') OR ('0' > price_quantity_end)) ORDER BY price_quantity_end DESC
302
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='28'
303
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='28' AND shopper_group_id='5'  ORDER BY price_quantity_start
304
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='28'
305
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='Cc Nokia'
306
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='278' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
307
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`='278'
308
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='278'
309
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='278' AND (start_date<='1327698342' OR start_date=0) AND (end_date>='1327682160' OR end_date=0) AND product_discount_id=discount_id
310
SELECT vendor_id FROM jos_vm_product WHERE product_id='278'
311
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='278'
312
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='278' 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
313
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='278'
314
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='278' AND shopper_group_id='5'  ORDER BY price_quantity_start
315
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='278'
316
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='Lcd O2 Atom'
317
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='987' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
318
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`='987'
319
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='987'
320
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='987' AND (start_date<='1327698342' OR start_date=0) AND (end_date>='1327682160' OR end_date=0) AND product_discount_id=discount_id
321
SELECT vendor_id FROM jos_vm_product WHERE product_id='987'
322
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='987'
323
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='987' 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
324
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='987'
325
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='987' AND shopper_group_id='5'  ORDER BY price_quantity_start
326
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='987'
327
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='Spk Bzr O2 Xda2s'
328
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='730' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
329
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`='730'
330
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='730'
331
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='730' AND (start_date<='1327698342' OR start_date=0) AND (end_date>='1327682160' OR end_date=0) AND product_discount_id=discount_id
332
SELECT vendor_id FROM jos_vm_product WHERE product_id='730'
333
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='730'
334
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='730' 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
335
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='730'
336
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='730' AND shopper_group_id='5'  ORDER BY price_quantity_start
337
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='730'
338
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='Sr Mini Krussel'
339
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='785' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
340
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`='785'
341
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='785'
342
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='785' AND (start_date<='1327698342' OR start_date=0) AND (end_date>='1327682160' OR end_date=0) AND product_discount_id=discount_id
343
SELECT vendor_id FROM jos_vm_product WHERE product_id='785'
344
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='785'
345
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='785' 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
346
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='785'
347
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='785' AND shopper_group_id='5'  ORDER BY price_quantity_start
348
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='785'
349
SELECT jos_artbannersplus.* FROM jos_artbannersplus,
                          jos_artbannersplus_categories,
                          jos_artbannersplus_clients
      WHERE 1 AND 
		  (('2012-01-28' <= publish_down_date OR publish_down_date = '0000-00-00')
		  AND '2012-01-28' >= publish_up_date
		  AND ((reccurtype = 0)
		      OR (reccurtype = 1 AND reccurweekdays LIKE '%6%'))
		  AND '15:05:42' >= publish_up_time
		  AND ('15:05:42' <= 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
350
SELECT jos_artbannersplus.* FROM jos_artbannersplus,
                          jos_artbannersplus_categories,
                          jos_artbannersplus_clients
      WHERE 1 AND 
		  (('2012-01-28' <= publish_down_date OR publish_down_date = '0000-00-00')
		  AND '2012-01-28' >= publish_up_date
		  AND ((reccurtype = 0)
		      OR (reccurtype = 1 AND reccurweekdays LIKE '%6%'))
		  AND '15:05:42' >= publish_up_time
		  AND ('15:05:42' <= 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