SQL = SELECT count(sid) AS CNT FROM web_session WHERE sid = 's4fnkms1'

SQL = SELECT count(sid) AS CNT FROM web_session WHERE sid = 'ofik26py'

SQL = SELECT count(sid) AS CNT FROM web_session WHERE sid = 'w3lfqh29'

SQL = SELECT count(sid) AS CNT FROM web_session WHERE sid = 'w094qrzi'

SQL = SELECT count(sid) AS CNT FROM web_session WHERE sid = 'we6g0yhp'

SQL = SELECT count(sid) AS CNT FROM web_session WHERE sid = 'e09h7zg3'

SQL = SELECT count(sid) AS CNT FROM web_session WHERE sid = '21jsjl2g'

SQL = SELECT count(sid) AS CNT FROM web_session WHERE sid = 'mckc3jvz'

SQL = SELECT count(sid) AS CNT FROM web_session WHERE sid = 'y1fy0xoe'

SQL = SELECT count(sid) AS CNT FROM web_session WHERE sid = 'xxv4xb8z'

SQL = SELECT count(sid) AS CNT FROM web_session WHERE sid = 'dssxeve0'

SQL = SELECT count(sid) AS CNT FROM web_session WHERE sid = '7zcai8ah'

SQL = insert into web_session (sid, hr, email,sdate) VALUES ('7zcai8ah','','0',sysdate)

SQL = select p.ts_id, p.name, m.name, p.description, p.price, CASE WHEN LENGTH(TRIM(p.edate_yr)) > 0 THEN CASE WHEN CURRENT_DATE > TO_DATE(p.edate_mo || '/' || p.edate_day || '/' || p.edate_yr || ':23:59', 'MM/DD/YYYY:HH24:MI') THEN 0 ELSE p.rebate END ELSE p.rebate END as arebate, p.image, m.image, p.click, p.srp, p.mfr_id, p.instock, p.equote, to_char(begin_rebate_dt, 'YYYYMMDD') begin_rebate_dt,p.rebate_url, p.rebate_file, m.id as mid, p.replace_ts_id, p.supplier_id, p.maximum_price, p.basket_min, p.price_msg from product p, manufacturer m where p.ts_id='HPPXE743R' and p.mfr=m.id and p.ts_show='1'

SQL = select psl.store_id, psl.levels, s.name from product_store_levels psl, store s where psl.product_id='HPPXE743R' and s.id=psl.store_id and s.viewable = 1

SQL = select name from levels where id='65'

SQL = select p.ts_id, p.name, m.name, p.mfr_id, p.tristate_phone_id from product p, manufacturer m where p.ts_id='HPPXE743R' and p.mfr=m.id

SQL = SELECT phone_number, display_text FROM tristate_phone WHERE is_default = 'Y'

SQL = SELECT name FROM store WHERE id = '4'

SQL = select name from levels where id=65

SQL = SELECT metatag,metatag2,alttop,altmid,altbot,comments,tracking FROM store_levels WHERE levels='0065' AND store_id=4

SQL = SELECT metatag,metatag2,alttop,altmid,altbot,comments,tracking FROM store_levels WHERE levels='0000' AND store_id=4

Computer > Desktops

Need Help? Call Us 800-221-1926

HP PAVILION XE743 DESKTOP (REFURB)

Product Search:

December 2, 2008   SQL = SELECT name FROM store WHERE id = '4' Computer SQL = select name from levels where id=65   Desktops SQL = select distinct SUBSTRING(sl.levels, 5, 4), levels.name from store_levels sl, levels where sl.store_id='4' and sl.levels like '0065%' and SUBSTRING(sl.levels, 5, 4) != '' and TRIM(leading '0' from SUBSTRING(sl.levels, 5, 4)) = levels.id order by levels.name   ------Select------ Digital Camera Camcorder MP3 Player Printer Projector Find the best quality and lowest prices in Point & Shoot Cameras, SLR Cameras & Lenses, Digital Cameras & Memory, Film Scanners, DVD Players, Camcorders, Inkjet Printers, Laser Printers, Plasma TVs, Multimedia Projectors, Desktop Video, Notebooks, PDAs, Copiers & Toners, Fax Machines & Supplies.     © 2005 TriState Camera		SQL = DELETE FROM ITEMS_VIEWED WHERE sid = '7zcai8ah' AND sku = 'HPPXE743R' SQL = INSERT INTO ITEMS_VIEWED (sid, sku, date_viewed) VALUES ('7zcai8ah', 'HPPXE743R', now())		PAVILION XE743 DESKTOP (REFURB) Item #: HPPXE743R Mfr Part #: P1465AR#ABA   SQL = select * from product_store_levels where product_id='HPPXE743R' SQL = select item, item_ts_id from product_item where ts_id='HPPXE743R' order by sort_order Email a Friend   View Similar Products   View Description   Price: $549.99 Enjoy No Interest for 6 Months on orders over $500   Subject to credit approval. See Details     SQL = select p.ts_id, p.name, p.price, CASE WHEN LENGTH(TRIM(p.edate_yr)) > 0 THEN CASE WHEN CURRENT_DATE > TO_DATE(p.edate_mo || '/' || p.edate_day || '/' || p.edate_yr || ':23:59', 'MM/DD/YYYY:HH24:MI') THEN 0 ELSE p.rebate END ELSE p.rebate END as arebate, m.name as mname, p.instock, to_char(p.begin_rebate_dt, 'YYYYMMDD') begin_rebate_dt, p.click, p.equote from product p, manufacturer m where ts_id in (select ts_id from product_item where item_ts_id = 'HPPXE743R') and p.ts_show='1' and m.id=p.mfr and p.ts_id <> 'HPPXE743R' and p.ts_id <> 'HPPXE743R' order by price SQL = SELECT p.name, m.name as mname FROM product p, manufacturer m WHERE m.id=p.mfr and p.ts_id = 'HPPXE743R' Description: The HP Pavilion XE743 home PC delivers all the features you need for home computing. Everything from music to the Internet is bundled into a stylishly designed mini-tower. Also, the Intel® CeleronTM processor 600MHz ensures maximum performance and a full-bore multimedia experience. When nothing but the latest and greatest can satisfy you, the HP Pavilion XE743 home PC promises instant gratification. Warranty This product is refurbished and includes the following warranty: Warranty Length: This product comes with a 90-day (parts & labor) warranty. Coverage: The warranty covers repair or replacement of the product. Provider: This warranty is provided by Hewlett-Packard's Home Products Division (HPD). Contact: If you have a problem with this product that requires warranty service, please phone the HPD Customer Care Center at 1-208-323-HOME (1-208-323-4663). Technical Support: Should you require technical support on this product, please phone HPD's Technical Support line at 1-208-323-4663. Additional Info.: An extended warranty is available through the manufacturer. For information, please call 1-800-597-8017. HP warranty and extended warranty is not available in Canada. SQL = select feature_name from prod_feat where product_id='HPPXE743R' order by id Major Features: Intel® CeleronTM Processor 600MHz 64MB SDRAM 20GB Hard Drive 48X CD-ROM ITU V.90 K56flex modem 10/100Base-T network card Integrated Intel® Direct AGP 3D graphics Up to 11MB of dynamic video memory Polk Audio Stereo Speakers One-touch keyboard with Internet access 2-button PS/2 compatible mouse Microsoft® Windows® 98 Second Edition   Continue Shopping   Back to top SQL = select a.product_id, pa.atype from accessory a, product_accessory pa, product p where a.id=pa.accessory_id and pa.product_id='HPPXE743R' and p.ts_id = a.product_id and p.price <> 0.00 and instock='I' and p.ts_show = '1' order by pa.atype desc, a.product_id