Query
Template:C:\FTP\YLang23\Htdocs\_breadcrumbs.cfm Execution Time (ms):47 Recordcount:24 Cached:No SQL: SELECT DISTINCT TOP(24) ACTIVE,CATEGORYNAME,COLLECTIONNAME,COLLECTION_SORT_ORDER,COLOR,DESIGN, DESIGNERNAME,DESIGNER_SORT_ORDER,ENDPRICE,HIRESPHOTO, ISDESIGNERAPPAREL,ISMING,ISZOOMIMAGE,ITEMID,ITEMNAME,ITEMNUMBER, ITEMREF1,ITEMREF2,ITEMREF3,ITEMREF4,ITEMTYPE,JOANNESPICK,LARGEPHOTO, MATERIALCONTENT,MEDIUMPHOTO,NOTINSTOCK,ONSALE,PRICE,PRICEUPONREQUEST, SALE_DISCOUNT,SEASONAL,SECTION_SORT_ORDER,SHOWPRODUCT, SMALLPHOTO,SORT_ORDER,STARTPRICE,STYLENUMBER,TINYPHOTO,Y23GIVES, DESIGNERID,DESIGNERNAME,noPrice, SCRAMBLE,SHOWDESIGNER,MarkAsSold,restList,SpecialMessage FROM (SELECT Items.ACTIVE,Items.CATEGORYNAME,Items.COLLECTIONNAME,Items.COLLECTION_SORT_ORDER,Items.COLOR,Items.DESIGN, Items.DESIGNER_SORT_ORDER,Items.ENDPRICE,Items.HIRESPHOTO, Items.ISDESIGNERAPPAREL,Items.ISMING,Items.ISZOOMIMAGE,Items.ITEMID,Items.ITEMNAME,Items.ITEMNUMBER, Items.ITEMREF1,Items.ITEMREF2,Items.ITEMREF3,Items.ITEMREF4,Items.ITEMTYPE,Items.JOANNESPICK,Items.LARGEPHOTO, Items.MATERIALCONTENT,Items.MEDIUMPHOTO,Items.NOTINSTOCK,Items.ONSALE,Items.PRICE,Items.PRICEUPONREQUEST, Items.SALE_DISCOUNT,Items.SEASONAL,Items.SECTION_SORT_ORDER,Items.SHOWPRODUCT, Items.SMALLPHOTO,Items.SORT_ORDER,Items.STARTPRICE,Items.STYLENUMBER,Items.TINYPHOTO,Items.Y23GIVES, Designers.DESIGNERID,Designers.DESIGNERNAME,Items.noPrice, Designers.SCRAMBLE,Designers.SHOWDESIGNER,Items.MarkAsSold,dbo.fn_CreateRestrictionList(Items.itemID) AS restList,Items.SpecialMessage, ROW_NUMBER() OVER ( ORDER BY Items.ItemID DESC ) AS RowNum FROM Items INNER JOIN designers ON (designers.designername = items.designername) WHERE Items.ItemType = 'Jewelry' AND Items.ShowProduct = 1 AND Items.active = 1 AND Designers.ShowDesigner = 1 ) AS RowConstrainedResult WHERE RowNum >= 1 ORDER BY ItemID DESC
|
|
ACTIVE |
CATEGORYNAME |
COLLECTIONNAME |
COLLECTION_SORT_ORDER |
COLOR |
DESIGN |
DESIGNERNAME |
DESIGNER_SORT_ORDER |
ENDPRICE |
HIRESPHOTO |
ISDESIGNERAPPAREL |
ISMING |
ISZOOMIMAGE |
ITEMID |
ITEMNAME |
ITEMNUMBER |
ITEMREF1 |
ITEMREF2 |
ITEMREF3 |
ITEMREF4 |
ITEMTYPE |
JOANNESPICK |
LARGEPHOTO |
MATERIALCONTENT |
MEDIUMPHOTO |
NOTINSTOCK |
ONSALE |
PRICE |
PRICEUPONREQUEST |
SALE_DISCOUNT |
SEASONAL |
SECTION_SORT_ORDER |
SHOWPRODUCT |
SMALLPHOTO |
SORT_ORDER |
STARTPRICE |
STYLENUMBER |
TINYPHOTO |
Y23GIVES |
DESIGNERID |
noPrice |
SCRAMBLE |
SHOWDESIGNER |
MarkAsSold |
restList |
SpecialMessage |
| 1 |
1 |
Rings |
Other Collections |
0 |
|
|
Jennifer Meyer |
0 |
0 |
29051702jm_hires.jpg |
1 |
0 |
1 |
39919 |
Circle Stacking Ring - White Gold |
JM 29051702 |
null |
null |
null |
null |
Jewelry |
0 |
29051702jm.jpg |
|
29051702jm_medium.jpg |
1 |
0 |
250 |
0 |
0 |
0 |
0 |
1 |
29051702jm_small.jpg |
13 |
0 |
|
29051702jm_tiny.jpg |
0 |
137 |
0 |
0 |
1 |
0 |
1 |
|
| 2 |
1 |
Rings |
Other Collections |
0 |
|
|
Jennifer Meyer |
0 |
0 |
29051700jm_hires.jpg |
1 |
0 |
1 |
39918 |
Circle Stacking Ring - Yellow Gold |
JM 29051700 |
null |
null |
null |
null |
Jewelry |
0 |
29051700jm.jpg |
|
29051700jm_medium.jpg |
1 |
0 |
250 |
0 |
0 |
0 |
0 |
1 |
29051700jm_small.jpg |
13 |
0 |
|
29051700jm_tiny.jpg |
0 |
137 |
0 |
0 |
1 |
0 |
1 |
|
| 3 |
1 |
Earrings |
Other Collections |
0 |
|
|
Jennifer Meyer |
0 |
0 |
29051703jm_hires.jpg |
1 |
0 |
0 |
39917 |
Long Dome Earrings with Diamonds - Yellow Gold |
JM 29051703 |
null |
null |
null |
null |
Jewelry |
0 |
29051703jm.jpg |
|
29051703jm_medium.jpg |
1 |
0 |
15000 |
0 |
0 |
0 |
0 |
1 |
29051703jm_small.jpg |
13 |
0 |
|
29051703jm_tiny.jpg |
0 |
137 |
0 |
0 |
1 |
0 |
1 |
|
| 4 |
1 |
Necklaces |
Other Collections |
0 |
|
|
Virgins, Saints & Angels |
0 |
0 |
29051703vsa_hires.jpg |
1 |
0 |
1 |
39916 |
Magdalena Necklace in Gold | Clear |
VSA 29051703 |
null |
null |
null |
null |
Jewelry |
0 |
29051703vsa.jpg |
|
29051703vsa_medium.jpg |
0 |
0 |
222 |
0 |
0 |
0 |
0 |
1 |
29051703vsa_small.jpg |
13 |
0 |
|
29051703vsa_tiny.jpg |
0 |
122 |
0 |
1 |
1 |
0 |
2, 1 |
|
| 5 |
1 |
Earrings |
Other Collections |
0 |
|
|
Cathy Waterman |
0 |
0 |
29051701cw_hires.jpg |
1 |
0 |
1 |
39915 |
Double Four Petal Earrings |
CW 29051701 |
null |
null |
null |
null |
Jewelry |
0 |
29051701cw.jpg |
|
29051701cw_medium.jpg |
0 |
0 |
2930 |
0 |
0 |
0 |
0 |
1 |
29051701cw_small.jpg |
13 |
0 |
e345.d |
29051701cw_tiny.jpg |
0 |
1 |
0 |
0 |
1 |
0 |
1 |
|
| 6 |
1 |
Rings |
Other Collections |
0 |
|
|
Cathy Waterman |
0 |
0 |
29051700cw_hires.jpg |
1 |
0 |
1 |
39914 |
Love Ring with Diamonds - 22 Karat |
CW 29051700 |
null |
null |
null |
null |
Jewelry |
0 |
29051700cw.jpg |
|
29051700cw_medium.jpg |
0 |
0 |
5240 |
0 |
0 |
0 |
0 |
1 |
29051700cw_small.jpg |
13 |
0 |
r1519.1 |
29051700cw_tiny.jpg |
0 |
1 |
0 |
0 |
1 |
0 |
1 |
|
| 7 |
1 |
Bracelets |
Other Collections |
0 |
|
|
Hipanema |
673197 |
0 |
29051512hip_hires.jpg |
1 |
0 |
1 |
39913 |
Santiago Bracelet |
HIP 29051512 |
null |
null |
null |
null |
Jewelry |
0 |
29051512hip.jpg |
|
29051512hip_medium.jpg |
0 |
0 |
98 |
0 |
0 |
0 |
0 |
1 |
29051512hip_small.jpg |
13 |
0 |
|
29051512hip_tiny.jpg |
0 |
219 |
0 |
1 |
1 |
0 |
1 |
|
| 8 |
1 |
Bracelets |
Other Collections |
0 |
|
|
Hipanema |
463112 |
0 |
29051515hip_hires.jpg |
1 |
0 |
1 |
39912 |
Alesia Bracelet |
HIP 29051515 |
null |
null |
null |
null |
Jewelry |
0 |
29051515hip.jpg |
|
29051515hip_medium.jpg |
0 |
0 |
98 |
0 |
0 |
0 |
0 |
1 |
29051515hip_small.jpg |
13 |
0 |
|
29051515hip_tiny.jpg |
0 |
219 |
0 |
1 |
1 |
0 |
1 |
|
| 9 |
1 |
Bracelets |
Other Collections |
0 |
|
|
Hipanema |
232275 |
0 |
29051506hip_hires.jpg |
1 |
0 |
1 |
39911 |
Cuzco Bracelet |
HIP 29051506 |
null |
null |
null |
null |
Jewelry |
0 |
29051506hip.jpg |
|
29051506hip_medium.jpg |
0 |
0 |
108 |
0 |
0 |
0 |
0 |
1 |
29051506hip_small.jpg |
13 |
0 |
|
29051506hip_tiny.jpg |
0 |
219 |
0 |
1 |
1 |
0 |
1 |
|
| 10 |
1 |
Bracelets |
Other Collections |
0 |
|
|
Hipanema |
791486 |
0 |
29051507hip_hires.jpg |
1 |
0 |
1 |
39910 |
Pampa Bracelet |
HIP 29051507 |
null |
null |
null |
null |
Jewelry |
0 |
29051507hip.jpg |
|
29051507hip_medium.jpg |
0 |
0 |
98 |
0 |
0 |
0 |
0 |
1 |
29051507hip_small.jpg |
13 |
0 |
|
29051507hip_tiny.jpg |
0 |
219 |
0 |
1 |
1 |
0 |
1 |
|
| 11 |
1 |
Bracelets |
Other Collections |
0 |
|
|
Hipanema |
717728 |
0 |
29051505hip_hires.jpg |
1 |
0 |
1 |
39909 |
Choc Bracelet |
HIP 29051505 |
null |
null |
null |
null |
Jewelry |
0 |
29051505hip.jpg |
|
29051505hip_medium.jpg |
0 |
0 |
58 |
0 |
0 |
0 |
0 |
1 |
29051505hip_small.jpg |
13 |
0 |
|
29051505hip_tiny.jpg |
0 |
219 |
0 |
1 |
1 |
0 |
1 |
|
| 12 |
1 |
Bracelets |
Other Collections |
0 |
|
|
Hipanema |
990607 |
0 |
29051513hip_hires.jpg |
1 |
0 |
1 |
39908 |
Sun Bracelet |
HIP 29051513 |
null |
null |
null |
null |
Jewelry |
0 |
29051513hip.jpg |
|
29051513hip_medium.jpg |
0 |
0 |
58 |
0 |
0 |
0 |
0 |
1 |
29051513hip_small.jpg |
13 |
0 |
|
29051513hip_tiny.jpg |
0 |
219 |
0 |
1 |
1 |
0 |
1 |
|
| 13 |
1 |
Bracelets |
Other Collections |
0 |
|
|
Hipanema |
710220 |
0 |
29051504hip_hires.jpg |
1 |
0 |
1 |
39907 |
BoaVista Bracelet |
HIP 29051504 |
null |
null |
null |
null |
Jewelry |
0 |
29051504hip.jpg |
|
29051504hip_medium.jpg |
0 |
0 |
108 |
0 |
0 |
0 |
0 |
1 |
29051504hip_small.jpg |
13 |
0 |
|
29051504hip_tiny.jpg |
0 |
219 |
0 |
1 |
1 |
0 |
1 |
|
| 14 |
1 |
Bracelets |
Other Collections |
0 |
|
|
Hipanema |
188295 |
0 |
29051503hip_hires.jpg |
1 |
0 |
1 |
39906 |
Nice Bracelet |
HIP 29051503 |
null |
null |
null |
null |
Jewelry |
0 |
29051503hip.jpg |
|
29051503hip_medium.jpg |
0 |
0 |
58 |
0 |
0 |
0 |
0 |
1 |
29051503hip_small.jpg |
13 |
0 |
|
29051503hip_tiny.jpg |
0 |
219 |
0 |
1 |
1 |
0 |
1 |
|
| 15 |
1 |
Bracelets |
Other Collections |
0 |
|
|
Hipanema |
58501 |
0 |
29051501hip_hires.jpg |
1 |
0 |
1 |
39905 |
Massilla Bracelet |
HIP 29051501 |
null |
null |
null |
null |
Jewelry |
0 |
29051501hip.jpg |
|
29051501hip_medium.jpg |
0 |
0 |
98 |
0 |
0 |
0 |
0 |
1 |
29051501hip_small.jpg |
13 |
0 |
|
29051501hip_tiny.jpg |
0 |
219 |
0 |
1 |
1 |
0 |
1 |
|
| 16 |
1 |
Bracelets |
Other Collections |
0 |
|
|
Hipanema |
303264 |
0 |
29051510hip_hires.jpg |
1 |
0 |
1 |
39904 |
Amazonas Bracelet |
HIP 29051510 |
null |
null |
null |
null |
Jewelry |
0 |
29051510hip.jpg |
|
29051510hip_medium.jpg |
0 |
0 |
108 |
0 |
0 |
0 |
0 |
1 |
29051510hip_small.jpg |
13 |
0 |
|
29051510hip_tiny.jpg |
0 |
219 |
0 |
1 |
1 |
0 |
1 |
|
| 17 |
1 |
Bracelets |
Other Collections |
0 |
|
|
Hipanema |
14785 |
0 |
29051508hip_hires.jpg |
1 |
0 |
1 |
39903 |
Recife Bracelet |
HIP 29051508 |
null |
null |
null |
null |
Jewelry |
0 |
29051508hip.jpg |
|
29051508hip_medium.jpg |
0 |
0 |
98 |
0 |
0 |
0 |
0 |
1 |
29051508hip_small.jpg |
13 |
0 |
|
29051508hip_tiny.jpg |
0 |
219 |
0 |
1 |
1 |
0 |
1 |
|
| 18 |
1 |
Bracelets |
Other Collections |
0 |
|
|
Hipanema |
908808 |
0 |
29051511hip_hires.jpg |
1 |
0 |
1 |
39902 |
Mexico Bracelet |
HIP 29051511 |
null |
null |
null |
null |
Jewelry |
0 |
29051511hip.jpg |
|
29051511hip_medium.jpg |
0 |
0 |
108 |
0 |
0 |
0 |
0 |
1 |
29051511hip_small.jpg |
13 |
0 |
|
29051511hip_tiny.jpg |
0 |
219 |
0 |
1 |
1 |
0 |
1 |
|
| 19 |
1 |
Bracelets |
Other Collections |
0 |
|
|
Hipanema |
240149 |
0 |
29051514hip_hires.jpg |
1 |
0 |
1 |
39901 |
Saint Tropez Bracelet |
HIP 29051514 |
null |
null |
null |
null |
Jewelry |
0 |
29051514hip.jpg |
|
29051514hip_medium.jpg |
0 |
0 |
108 |
0 |
0 |
0 |
0 |
1 |
29051514hip_small.jpg |
13 |
0 |
|
29051514hip_tiny.jpg |
0 |
219 |
0 |
1 |
1 |
0 |
1 |
|
| 20 |
1 |
Bracelets |
Other Collections |
0 |
|
|
Hipanema |
279461 |
0 |
29051500hip_hires.jpg |
1 |
0 |
1 |
39900 |
Good Bracelet |
HIP 29051500 |
null |
null |
null |
null |
Jewelry |
0 |
29051500hip.jpg |
|
29051500hip_medium.jpg |
0 |
0 |
58 |
0 |
0 |
0 |
0 |
1 |
29051500hip_small.jpg |
13 |
0 |
|
29051500hip_tiny.jpg |
0 |
219 |
0 |
1 |
1 |
0 |
1 |
|
| 21 |
1 |
Rings |
Joanne's Top Picks, One-of-a-Kind |
0 |
|
|
Jennifer Meyer |
0 |
0 |
29051600jm1_hires.jpg |
1 |
0 |
0 |
39898 |
3-4 Letter Custom Name Ring |
JM 29051600 |
null |
null |
null |
null |
Jewelry |
0 |
29051600jm1.jpg |
|
29051600jm1_medium.jpg |
1 |
0 |
1500 |
0 |
0 |
0 |
0 |
1 |
29051600jm1_small.jpg |
13 |
0 |
name ring |
29051600jm1_tiny.jpg |
0 |
137 |
0 |
0 |
1 |
0 |
1 |
|
| 22 |
1 |
Bracelets |
Other Collections |
0 |
|
|
Hipanema |
186847 |
0 |
29051502hip_hires.jpg |
1 |
0 |
1 |
39897 |
Biarritz Bracelet |
HIP 29051502 |
null |
null |
null |
null |
Jewelry |
0 |
29051502hip.jpg |
|
29051502hip_medium.jpg |
0 |
0 |
118 |
0 |
0 |
0 |
0 |
1 |
29051502hip_small.jpg |
13 |
0 |
|
29051502hip_tiny.jpg |
0 |
219 |
0 |
1 |
1 |
0 |
1 |
|
| 23 |
1 |
Bracelets |
Other Collections |
0 |
|
|
Hipanema |
382781 |
0 |
29051516hip_hires.jpg |
1 |
0 |
1 |
39896 |
Beach Bracelet |
HIP 29051516 |
null |
null |
null |
null |
Jewelry |
0 |
29051516hip.jpg |
|
29051516hip_medium.jpg |
0 |
0 |
58 |
0 |
0 |
0 |
0 |
1 |
29051516hip_small.jpg |
13 |
0 |
|
29051516hip_tiny.jpg |
0 |
219 |
0 |
1 |
1 |
0 |
1 |
|
| 24 |
1 |
Necklaces |
Other Collections |
0 |
|
|
Nicole Romano |
0 |
0 |
29051321nr_hires.jpg |
1 |
0 |
1 |
39895 |
Crystal Wrapped Aurora Borealis Glass Drop Necklace |
NR 29051321 |
null |
null |
null |
null |
Jewelry |
0 |
29051321nr.jpg |
|
29051321nr_medium.jpg |
0 |
0 |
410 |
0 |
0 |
0 |
0 |
1 |
29051321nr_small.jpg |
13 |
0 |
977 |
29051321nr_tiny.jpg |
0 |
217 |
0 |
0 |
1 |
0 |
1 |
|
|