Vior - Now less than 50 in stock and the last we can get hold of until restrictions from the continent are lifted so don't delay in ordering, safer still have a spare one in stock.
An Elimar Preferred Supplier
An Elimar Preferred Supplier
An Elimar Preferred Supplier
An Elimar Preferred Supplier
An Elimar Preferred Supplier
An Elimar Preferred Supplier
An Elimar Preferred Supplier
An Elimar Preferred Supplier
An Elimar Preferred Supplier
An Elimar Preferred Supplier
An Elimar Preferred Supplier
An Elimar Preferred Supplier
SELECT l.*, rvl.id AS recently_viewed_listings_id FROM ppbv7_listings AS l INNER JOIN ppbv7_recently_viewed_listings AS rvl ON rvl.listing_id = l.id WHERE (l.listing_type IN ('auction')) AND (l.draft = 0) AND (l.active = 1) AND (l.approved = 1) AND (rvl.user_token = '') GROUP BY l.id ORDER BY IF(rvl.updated_at is null, rvl.created_at, rvl.updated_at) DESC