3065 - Expression #2 of ORDER BY clause is not in SELECT list, references column 'harpercl_creloaded.xp.products_id' which is not in SELECT list; this is incompatible with DISTINCT

select distinct p.products_id, p.products_image, p.products_price, p.manufacturers_id, pd.products_name, p.products_tax_class_id, p.products_date_added, p.products_image , xp.xsell_id products_price from (products p left join specials s on p.products_id = s.products_id), products_xsell xp, products_description pd where xp.products_id = '46' and p.products_id = xp.xsell_id and pd.products_id = xp.xsell_id and pd.language_id = '1' and p.products_status = '1' order by rand(), xp.products_id asc limit 4

[TEP STOP]

Home  >  AKA  >  Uno White Crop T-Shirt
Uno White Crop T-Shirt
Uno White Crop T-Shirt
£28.99

Top by AKA

  • Off White
  • Logo to Front
  • Cropped Length
  • Small logo and slits to back

 

ABOUT AKA

Founded and created in Manchester. AKA is the quintessential brand to showcase your individuality and freedom to be, washes, dying processes and distressed finishes, combined with digital Printing - the signature handwriting of the AKA brand. The result is a garment to inspire your alter ego. Who are you today? We are also know as ... AKA
Size:   

ABOUT ME

95% Cotton, 5% Elastane

CARE INFO

Wash inside out, After wash remove promptly and hang to dry. Cool iron on reverse. Do not iron print

SIZE AND MEASUREMENTS

Model wears: UK 8 Model Height: 5ft 9"

Additional Info: Jeans and shoes are models own.

Please see our Delivery Info Page for full information on deliveries.

 

1 - 3 Working Day Delivery UK (Orders over £50)FREE
1 - 3 Working Day Delivery UK (Orders under £50) £3.99
Next Day Delivery UK £5.99
Saturday Delivery  £7.99

 

We hope you are happy with all of your purchases but if you ever need to return an item, you can do so within 14 days from the date your parcel was shipped.

Click here to view our full Returns policy