Rental Equipment
Digital Cameras and Accessories Digital Backs Film SLR Cameras Lenses Video Camcorders & Accesories Multimedia Projectors Slide Projectors Studio Equipment Studio Accessories Flash Units Flash Meters Medium Format Equipment Large Format Equipment Power Supplies Battery Packs and Cables Grip Equipment Cases Cords AV Cables

The rental you selected has moved or no longer existsquery = SELECT DISTINCT p.sql_ID, p.sql_CODE, p.sql_NAME, p.sql_DESC, p.sql_SBTCLASS, p.sql_PAGE_VIEW, p.sql_MANUFACTURER, p.sql_MFR_NUMBER, p.sql_COST, p.sql_PRICE, p.sql_MAP, p.sql_MSRP, p.sql_THUMBNAIL, p.sql_IMAGE, r.day_rate, r.deposit, p.sql_LARGE, p.sql_ACTIVE, p.sql_TAXABLE, op.sql_header, op.sql_footer, i.sql_INVENTORY, p.sql_WEIGHT, ip.sql_ACTIVE AS inv_tracking FROM merchant2_00000001_products_dbf AS p LEFT JOIN merchant2_00000001_inv_cnt_dbf AS i ON i.sql_PRODUCT_ID = p.sql_ID LEFT JOIN rental_rates AS r ON r.product_CODE = p.sql_CODE LEFT JOIN merchant2_00000001_oui_ouiprds_dbf as op ON op.sql_product_id = p.sql_ID LEFT JOIN merchant2_00000001_inv_prd_dbf AS ip ON ip.sql_PRODUCT_ID = p.sql_ID WHERE p.sql_deleted != 1 AND p.sql_CODE = '800070' AND p.sql_SBTCLASS = '80'