# Sort by pseudoprice

**URL:** <https://forum.shopware.com/t/sort-by-pseudoprice/52823>\
**Category:** International (English Only)\
**Tags:** programming\
**Created:** [9. Mai 2018 um 17:55 UTC](https://forum.shopware.com/t/sort-by-pseudoprice/52823 "2018-05-09T17:55:42Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![amr](https://avatars.discourse-cdn.com/v4/letter/a/73ab20/32.png) [@amr](https://forum.shopware.com/u/amr)\
**Post date:** [9. Mai 2018 um 17:55 UTC](https://forum.shopware.com/t/sort-by-pseudoprice/52823/1 "2018-05-09T17:55:42Z")

</div>

Hello  
I am trying to add a new sorting method to list all products which have a pseudoprice.

I am using this [plugin](https://store.shopware.com/en/colo328219905291/enhanced-sorting.html) which adds more sorting method and the ability to use sql queries:  
[Enhanced sorting | System | Administration | Extensions | Shopware Community Store](https://store.shopware.com/en/colo328219905291/enhanced-sorting.html)

Can any one guide me with an sql query to select the all products which&nbsp; have&nbsp;pseudoprice?

Thank you!

---

<div class="post-metadata">

**Author:** ![jonathan](https://avatars.discourse-cdn.com/v4/letter/j/aeb1de/32.png) [@jonathan](https://forum.shopware.com/u/jonathan)\
**Post date:** [9. Mai 2018 um 19:35 UTC](https://forum.shopware.com/t/sort-by-pseudoprice/52823/2 "2018-05-09T19:35:01Z")

</div>

Hi,

as described in the support email the SQL code is: **(listing\_price.pseudoprice\> 0) DESC**  
And you have to use a price sorting field to make the listing\_price.pseudoprice avaible in the SQL-Call.

Best wishes