SELECT * , urlname FROM items_ as items LEFT JOIN brands on brands.id = items.brand LEFT JOIN categories ON categories.id = items.category WHERE 1=1 AND categories.iname = 'bag' AND country = 'SG' AND cost >= 500 AND (image IS NOT NULL) ORDER BY date DESC LIMIT 3960,15