|
|
|
ProductType » 19 inch » passenger |
Select A1.ID,A1.ModelNumber,A1.Pic1,A2.CName As BigTypeName FROM Products A1 LEFT JOIN BigType A2 ON A1.BigTypeCode = A2.Code Where A1.IsEnable = 1 AND BigTypeCode = '19inch' AND SmallTypeCode = 'passenger' Order by A1.IsTop DESC,A1.DataIndex, A1.ModelNumber DESC
|
|
PREV | 1 2 3 4 5 6 | NEXT
|
|
|