Your Cart

Show Cart
Your Cart is currently empty.
powered_by.png, 1 kB

New HP / PDA

Sony Ericsson W705
Sony Ericsson W705
Rp 2.625.000
Samsung 3653 Corby
Samsung 3653 Corby
Rp 1.565.000
Nokia 6700
Nokia 6700
Rp 2.165.000
Sony Ericsson W395
Sony Ericsson W395
Rp 1.100.000

2nd HP / PDA


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 :
  1. Data pribadi : KTP / SIM
  2. No telp yang bisa di hubungi
  3. CV : daftar sekolah dan pengalaman bekerja
Semoga sukses.
Last Updated ( Thursday, 18 February 2010 )
 
iconNews - pda, hp, gadget news

New!!


Engadget


  • HTC Titan II works its charm on the FCC with AT&T LTE included

    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

FlAshdisk Vaio 8gb
FlAshdisk Vaio 8gb
Rp 400.000

Stylus Sony Ericsson P990
Stylus Sony Ericsson P990
Rp 175.000

Sarung Nokia 9500 Pd Air
Sarung Nokia 9500 Pd Air
Rp 175.000

Cable Data Samsung I700
Cable Data Samsung I700
Rp 75.000

Sarung Nokia N95
Sarung Nokia N95
Rp 200.000

Battery Ipaq 6300
Battery Ipaq 6300
Rp 175.000

Sekring Audiovox Thera
Sekring Audiovox Thera
Rp 75.000

2nd Nokia 6600 fold
2nd Nokia 6600 fold
Rp 1.300.000

Battery Treo 650
Battery Treo 650
Rp 225.000

K-Touch D700
K-Touch D700
Rp 960.000

Cable Data Ipod Blue Tech
Cable Data Ipod Blue Tech
Rp 75.000

Motorola V 9
Motorola V 9
Rp 3.500.000

Stylus Dopod D 810
Stylus Dopod D 810
Rp 50.000

Lcd O2 Xphone
Lcd O2 Xphone
Rp 1.500.000

Handsfree Motorola
Handsfree Motorola
Rp 30.000

Speaker O2 Xda Mini
Speaker O2 Xda Mini
Rp 50.000

Motorola Ht 820
Motorola Ht 820
Rp 875.000

Sarung Samsung
Sarung Samsung
Rp 325.000

Sony Ericsson T 700i
Sony Ericsson T 700i
Rp 1.615.000

Speaker Atom
Speaker Atom
Rp 300.000

YM Status

pockethp lt.1:
Online/Offline status
pockethp lt.1:
Online/Offline status

iconhp lt.3:
Online/Offline status
iconhp lt.3:
Online/Offline status

Advertisement

 

You are here because :

© 2012 iconhp.com : your mobility center
development by dotcodotid.com
340 queries executed
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 < '1327697432' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1327697432' )
 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='1447'
50
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='1447' AND (start_date<='1327698339' 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='1447'
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='1447'
54
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='1447' 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='1447'
56
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='1447' 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='1447'
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='1564'
60
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='1564' AND (start_date<='1327698339' 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='1564'
62
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='1564'
63
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='1564' 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='1564'
65
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='1564' 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='1564'
67
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='1536'
68
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='1536' AND (start_date<='1327698339' 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='1536'
70
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='1536'
71
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='1536' 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='1536'
73
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='1536' 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='1536'
75
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='1456'
76
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='1456' AND (start_date<='1327698339' 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='1456'
78
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='1456'
79
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='1456' 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='1456'
81
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='1456' 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='1456'
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='2122'
86
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='2122' AND (start_date<='1327698339' 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='2122'
88
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='2122'
89
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
90
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='2122'
91
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
92
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='2122'
93
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='2007'
94
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='2007' AND (start_date<='1327698339' 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='2007'
96
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='2007'
97
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='2007' 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='2007'
99
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='2007' 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='2007'
101
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='2127'
102
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='2127' AND (start_date<='1327698339' 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='2127'
104
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='2127'
105
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='2127' 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='2127'
107
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='2127' 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='2127'
109
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='1720'
110
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='1720' AND (start_date<='1327698339' 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='1720'
112
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='1720'
113
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
114
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='1720'
115
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
116
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='1720'
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='Fdisk Vaio 8gb'
120
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='409' 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`='409'
122
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='409'
123
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='409' AND (start_date<='1327698339' 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='409'
125
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='409'
126
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='409' 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='409'
128
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='409' 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='409'
130
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='Sty SE P990'
131
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='933' 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`='933'
133
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='933'
134
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='933' AND (start_date<='1327698339' 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='933'
136
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='933'
137
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='933' 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='933'
139
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='933' 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='933'
141
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='Sr Nokia 95 Pd Air'
142
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='800' 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`='800'
144
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='800'
145
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='800' AND (start_date<='1327698340' 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='800'
147
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='800'
148
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='800' 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='800'
150
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='800' 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='800'
152
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='Cd Sam I700'
153
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='300' 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`='300'
155
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='300'
156
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='300' AND (start_date<='1327698340' 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='300'
158
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='300'
159
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='300' 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='300'
161
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='300' 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='300'
163
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='Sr Nokia N95'
164
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
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`='814'
166
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='814'
167
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='814' AND (start_date<='1327698340' 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='814'
169
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='814'
170
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
171
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='814'
172
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
173
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='814'
174
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='Bat HP Ipaq 6300'
175
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='18' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
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`='18'
177
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='18'
178
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='18' AND (start_date<='1327698340' 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='18'
180
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='18'
181
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='18' AND shopper_group_id='5'  AND (('0' >= price_quantity_start AND '0' <= price_quantity_end)
                                OR (price_quantity_end='0') OR ('0' > price_quantity_end)) ORDER BY price_quantity_end DESC
182
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='18'
183
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='18' AND shopper_group_id='5'  ORDER BY price_quantity_start
184
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='18'
185
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='Sekring Audiovox Thera'
186
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='621' 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`='621'
188
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='621'
189
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='621' AND (start_date<='1327698340' 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='621'
191
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='621'
192
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='621' 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='621'
194
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='621' 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='621'
196
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='2nd  Nokia 6600 fold'
197
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='2010' 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`='2010'
199
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='2010'
200
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='2010' AND (start_date<='1327698340' 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='2010'
202
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='2010'
203
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
204
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='2010'
205
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
206
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='2010'
207
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='Bat Treo 650'
208
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='90' 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`='90'
210
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='90'
211
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='90' AND (start_date<='1327698340' OR start_date=0) AND (end_date>='1327682160' OR end_date=0) AND product_discount_id=discount_id
212
SELECT vendor_id FROM jos_vm_product WHERE product_id='90'
213
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='90'
214
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='90' 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='90'
216
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='90' 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='90'
218
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='K-Touch D700'
219
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='197' 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`='197'
221
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='197'
222
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='197' AND (start_date<='1327698340' OR start_date=0) AND (end_date>='1327682160' OR end_date=0) AND product_discount_id=discount_id
223
SELECT vendor_id FROM jos_vm_product WHERE product_id='197'
224
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='197'
225
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='197' 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='197'
227
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='197' 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='197'
229
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='Cd Ipod'
230
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='289' 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`='289'
232
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='289'
233
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='289' AND (start_date<='1327698340' OR start_date=0) AND (end_date>='1327682160' OR end_date=0) AND product_discount_id=discount_id
234
SELECT vendor_id FROM jos_vm_product WHERE product_id='289'
235
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='289'
236
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='289' 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='289'
238
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='289' 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='289'
240
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='Motorola V 9'
241
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='44' 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`='44'
243
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='44'
244
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='44' AND (start_date<='1327698340' OR start_date=0) AND (end_date>='1327682160' OR end_date=0) AND product_discount_id=discount_id
245
SELECT vendor_id FROM jos_vm_product WHERE product_id='44'
246
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='44'
247
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='44' 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='44'
249
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='44' 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='44'
251
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='Sty Dopod D810'
252
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='907' 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`='907'
254
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='907'
255
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='907' AND (start_date<='1327698340' OR start_date=0) AND (end_date>='1327682160' OR end_date=0) AND product_discount_id=discount_id
256
SELECT vendor_id FROM jos_vm_product WHERE product_id='907'
257
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='907'
258
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='907' 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='907'
260
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='907' 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='907'
262
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='Lcd O2 Xphone'
263
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='993' 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`='993'
265
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='993'
266
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='993' AND (start_date<='1327698340' OR start_date=0) AND (end_date>='1327682160' OR end_date=0) AND product_discount_id=discount_id
267
SELECT vendor_id FROM jos_vm_product WHERE product_id='993'
268
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='993'
269
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='993' 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='993'
271
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='993' 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='993'
273
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='Hf Mot'
274
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='433' 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`='433'
276
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='433'
277
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='433' AND (start_date<='1327698340' OR start_date=0) AND (end_date>='1327682160' OR end_date=0) AND product_discount_id=discount_id
278
SELECT vendor_id FROM jos_vm_product WHERE product_id='433'
279
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='433'
280
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='433' 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='433'
282
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='433' 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='433'
284
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='Speaker Mini'
285
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='724' 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`='724'
287
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='724'
288
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='724' AND (start_date<='1327698340' OR start_date=0) AND (end_date>='1327682160' OR end_date=0) AND product_discount_id=discount_id
289
SELECT vendor_id FROM jos_vm_product WHERE product_id='724'
290
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='724'
291
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='724' 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='724'
293
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='724' 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='724'
295
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='Bths Mot Ht 820'
296
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='142' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
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`='142'
298
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='142'
299
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='142' AND (start_date<='1327698340' OR start_date=0) AND (end_date>='1327682160' OR end_date=0) AND product_discount_id=discount_id
300
SELECT vendor_id FROM jos_vm_product WHERE product_id='142'
301
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='142'
302
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='142' AND shopper_group_id='5'  AND (('0' >= price_quantity_start AND '0' <= price_quantity_end)
                                OR (price_quantity_end='0') OR ('0' > price_quantity_end)) ORDER BY price_quantity_end DESC
303
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='142'
304
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='142' AND shopper_group_id='5'  ORDER BY price_quantity_start
305
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='142'
306
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='Sr Samsung'
307
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
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`='853'
309
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='853'
310
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='853' AND (start_date<='1327698340' OR start_date=0) AND (end_date>='1327682160' OR end_date=0) AND product_discount_id=discount_id
311
SELECT vendor_id FROM jos_vm_product WHERE product_id='853'
312
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='853'
313
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
314
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='853'
315
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
316
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='853'
317
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='SE T700i'
318
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='1433' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
319
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`='1433'
320
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='1433'
321
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='1433' AND (start_date<='1327698340' OR start_date=0) AND (end_date>='1327682160' OR end_date=0) AND product_discount_id=discount_id
322
SELECT vendor_id FROM jos_vm_product WHERE product_id='1433'
323
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='1433'
324
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='1433' 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
325
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='1433'
326
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='1433' AND shopper_group_id='5'  ORDER BY price_quantity_start
327
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='1433'
328
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='Spk Batzer O2 Atom'
329
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='727' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
330
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`='727'
331
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='727'
332
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='727' AND (start_date<='1327698340' OR start_date=0) AND (end_date>='1327682160' OR end_date=0) AND product_discount_id=discount_id
333
SELECT vendor_id FROM jos_vm_product WHERE product_id='727'
334
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='727'
335
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='727' 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
336
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='727'
337
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='727' AND shopper_group_id='5'  ORDER BY price_quantity_start
338
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='727'
339
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:40' >= publish_up_time
		  AND ('15:05:40' <= 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
340
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:40' >= publish_up_time
		  AND ('15:05:40' <= 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