Sort by pseudoprice

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

I am using this plugin which adds more sorting method and the ability to use sql queries:
Enhanced sorting | System | Administration | Extensions | Shopware Community Store

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

Thank you!

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