without references

gistfile1.sql

SELECT "spree_line_items".* FROM "spree_line_items" 
LEFT OUTER JOIN "spree_variants" "variant" 
  ON "variant"."id" = "spree_line_items"."variant_id" 
LEFT OUTER JOIN "spree_products" "product" 
  ON "product"."id" = "variant"."product_id" 
LEFT OUTER JOIN "spree_tax_categories" 
  ON "spree_tax_categories"."deleted_at" IS NULL 
    AND "spree_tax_categories"."id" = "product"."tax_category_id" 
LEFT OUTER JOIN "spree_tax_rates" 
  ON "spree_tax_rates"."deleted_at" IS NULL 
    AND "spree_tax_rates"."tax_category_id" = "spree_tax_categories"."id" 
LEFT OUTER JOIN "enterprises" "supplier" 
  ON "supplier"."id" = "product"."supplier_id" 
    WHERE "spree_line_items"."id" = $1 
ORDER BY supplier.name, product.name, variant.display_name