The problem is i am attempting to use the Latest module to show the latest releases (logical right?), ordered by the date available, the trouble is i have many pre-order items and only want to show what is currently released and not the pre-orders.
i have changed date_added to date_available in catalog/model/catalog/product.php this orders them how i wish but includes all the pre orders and with a limit of 1 currently shows the product being released in december 2015
i have attempted to change the getLatestProducts function aswell but any changes result in no physical change.
i was thinking of something like ORDER BY p.date_available <= NOW() (not sure if correct syntax) but i am unsure how exactly to implement this
Thank you

i am running OC 1.5.6.4