Query
Template:/home/therockinn.com/www/browse.cfm
Execution Time (ms):0
Recordcount:1
Cached:No
Lazy:No
SQL:
SELECT
categories.category_name,
categories.category_link,
categories_pages.cp_text,
categories_pages.cp_meta_description,
categories_pages.cp_feature_product_id,
manufacturers.manufacturer_id,
manufacturers.manufacturer_name,
manufacturers.manufacturer_link,
inventory.inv_id,
inventory.inv_name,
inventory.inv_link,
inventory.inv_description,
inventory.inv_specs,
inventory.inv_sold,
inventory.inv_price_from,
inventory.inv_price_special,
inventory.inv_price_retail,
inventory.inv_used,
inventory_photos.ip_filename
FROM
categories
INNER JOIN
categories_pages
ON
categories.category_id = categories_pages.cp_category_id
LEFT JOIN
inventory
ON
categories_pages.cp_feature_product_id = inventory.inv_id
AND
inventory.active = 1
AND
inventory.deleted = 0
LEFT JOIN
manufacturers
ON
inventory.inv_manufacturer_id = manufacturers.manufacturer_id
AND
manufacturers.active = 1
AND
manufacturers.deleted = 0
LEFT JOIN
inventory_photos
ON
inventory.inv_id = inventory_photos.ip_inv_id
AND
inventory_photos.active = 1
AND
inventory_photos.deleted = 0
WHERE
categories_pages.cp_store_id = 1
AND
categories_pages.cp_category_id = 1
ORDER BY
inventory_photos.display_order
LIMIT
1
category_namecategory_linkcp_textcp_meta_descriptioncp_feature_product_idmanufacturer_idmanufacturer_namemanufacturer_linkinv_idinv_nameinv_linkinv_descriptioninv_specsinv_soldinv_price_frominv_price_specialinv_price_retailinv_usedip_filename
1New GuitarsNew_Guitars<p><font face="Helvetica" size="2"><b>As a <i>total guitar store </i>we try to provide the best of all brands and prices. If we don't have it listed, contact us and we will find what you're looking for!</b></font><br><font face="Helvetica" size="2"> </font> </p> <p><font face="Helvetica" size="2">We endeavour to keep the Guitars section up-to-date with current stock available, but as new stock is always arriving and going is can be difficult to list all stock on the site, so if there is a particular model that you are after that is not listed, please give us a call!<br></font> </p> <p><font face="Helvetica" size="2">All you <b>left handed players </b>out there! Left handed versions of most of the new guitars are available and can be ordered in. If you're interested in a particular guitar just let us know!<br></font> </p> <p align="center"> <font face="Helvetica"><b><font size="2">Read below for all the latest in New Guitar gear - or click a brand on the right to get started<font size="3"><u>!</u></font></font></b></font></p><div align="center"><b><font face="Helvetica" size="3"></font></b><hr width="100%" size="2"></div><div align="center"><u><b>NEW ARRIVALS - NEW GUITARS!</b></u><br><br><font size="2"><font face="Helvetica">Gibson 2014 Les Paul 60's Tribute<br>Danelectro DC59 12-string<br>Danelectro 59 Modified Go Go Blue<br>Danelectro 59 Modified - Black</font></font><br><a href="/manufacturer.cfm?Cat_ID=1&amp;Man_ID=205"><font face="Helvetica" size="2">Airline H78 Semi-Hollowbody</font></a><br><font face="Helvetica" size="2"></font><a href="/manufacturer.cfm?Cat_ID=1&amp;Man_ID=149"><font face="Helvetica" size="2">Eastwood Classic 12 (12-string) Walnut<br></font><font face="Helvetica" size="2">Eastwood P-90 Special - TV Yellow<br></font><font face="Helvetica" size="2">Eastwood Phase 5 4 - White<br></font><font face="Helvetica" size="2">Eastwood Classic 4 Bass - Honey Burst</font> <br><font face="Helvetica" size="2">Eastwood Delya-6 Electric Resonator</font><br><font face="Helvetica" size="2">Eastwood Mandocaster - Electric Mandolin<br>Eastwood Mandola - Sea Foam Green</font><br><font face="Helvetica" size="2">Eastwood Warren Ellis Tenor Guitar 2P - Cherry<br>Eastwood Sidejack DLX - Green Burst<br>Eastwood Sidejack DLX Electric XII Bass - Cream</font></a><font face="Helvetica" size="2"><br><a href="/manufacturer.cfm?Cat_ID=1&amp;Man_ID=1">Fender Blacktop Stratocaster Floyd Rose - Black<br>Fender Jim Adkins JA-90 Thinline Telecaster<br>Fender Custom Shop '65 Stratocaster Relic - Faded White</a><br></font><a href="/manufacturer.cfm?Cat_ID=1&amp;Man_ID=2"><font face="Helvetica" size="2">Gibson '58 VOS Les Paul 2014 - Cherry Sunburst<br>Gibson '58 VOS Les Paul 2014 - Iced Tea Sunburst<br>Gibson '63 VOS ES-335 Block Inlay - Cherry Red<br>Gibson USA 2014 Les Paul Studio - Trans Red</font><br><font face="Helvetica" size="2"><font face="Helvetica" size="2">Gibson USA 2014 Les Paul Studio 60's Tribute - Black</font></font><br><font face="Helvetica" size="2"><font face="Helvetica" size="2"><font face="Helvetica" size="2">Gibson USA 2014 LPJ<br>Gibson USA 2014 Melody Maker<br>Gibson USA 2014 SG Special - Cherry Red Vintage Gloss</font></font></font></a><font face="Helvetica" size="2"><font face="Helvetica" size="2"><font face="Helvetica" size="2"><br></font></font>Gretsch G5622T 3 pickup centre block - Green metallic<br><br><br></font><hr><br><img src="/assets/ckfinder/images/Logo_Duesenberg_538.gif"><br></div><p align="center"><font><font size="4"><b><font size="3"><span style="font-family: Helvetica;">DUESENBERG GUITARS AUSTRALIA<br></span></font></b></font></font></p><div align="justify"><font face="Helvetica" size="2"><b>We are very proud to offer this amazing range of Duesenberg Guitars in Australia! The whole range is available for order (including strings, parts and pickups) at very competitive global prices. The Rock inn is committed to the Duesenberg brand in Australia and will happily assist with any quote or enquiry! Please contact us for anything regarding Duesenberg guitars in Australia.<br><br>Duesenberg Guitars</b> are a unique combination of German engineering and classic art-deco styling. They deliver tones from the golden age of rock n roll with playability features incorporating modern guitar innovations. These guitars will feel as comfortable as a vintage favorite, yet will delight you with their subtle and useful enhancements. Since the mid 1990s, Duesenberg has tirelessly focused on developing a line of guitars and basses that meets and exceeds the demands of a seasoned professional. Each Duesenberg guitar and bass has been painstakingly hand assembled, making Duesenberg one of the finest sounding and playing guitars in the world. This includes the handcrafting of all hardware, including machine heads, knobs, tremolo and even the switch tip!</font><br><br><font face="Helvetica" size="2">Players include <b>Billy Gibbons</b> (ZZ Top), <b>Bob Dylan</b>, <b>Mike Campbell</b> (Tom Petty &amp; The Heartbreakers), <b>John Mayer,</b> <b>Glenn Frey</b> and <b>Joe Walsh</b> (Eagles), <b>Eddie Vedder </b>and <b>Mike McCready</b> (Pearl Jam).</font><br><br> Click <a target="_blank" href="http://www.youtube.com/watch?v=Fii0LW0bsVM">HERE</a> to watch a video of <b>Leigh Siragusa</b> playing the new<b> Dragster Double Cut</b> (Cherry Red) in-store!<br> <br> <div align="center"><iframe src="http://www.youtube.com/embed/Fii0LW0bsVM" allowfullscreen="" frameborder="0" height="315" width="560"></iframe><br></div> <br> Click <a target="_blank" href="http://www.youtube.com/watch?v=ouFqvH41QvU&amp;feature=youtu.be">HERE</a> to watch a video of <b>Jakob Teepe</b> playing the<b> Starplayer TV "Rebound"</b> model in-store!<br> <br> <div align="center"><iframe src="http://www.youtube.com/embed/ouFqvH41QvU" allowfullscreen="" frameborder="0" height="315" width="560"></iframe><br><br></div><div align="center"><font><font size="4"><b>&nbsp;&nbsp;&nbsp;&nbsp; </b></font></font><font face="Helvetica" size="2"><a target="_blank" href="http://www.duesenberg.de/">We can order any guitar from Duesenberg at good prices. Check out the Duesenberg website here for the full range!</a></font></div></div><p align="center"><br>&nbsp;&nbsp;</p><p align="center">&nbsp; <br></p><p align="center"><br></p>Guitar store Perth Australia. Huge range of new electric guitars. Fender, Gibson, Duesenberg Guitars, Maton, Burns, Gretsch, Squier Tokai0