Subversion Repositories SmartDukaan

Rev

Rev 14470 | Rev 14472 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 14470 Rev 14471
Line 28... Line 28...
28 
 
 28 
 
29 
ORDERS_QUERY='''
 29 
ORDERS_QUERY='''
30 
select o.*, u.username from order_view o join users u on u.id=o.user_id order by id desc limit %s offset %s
 30 
select o.*, u.username from order_view o join users u on u.id=o.user_id order by id desc limit %s offset %s
31 
'''
 31 
'''
32 
ORDERS_DATE_QUERY = '''
 32 
ORDERS_DATE_QUERY = '''
33 
select o.*, u.username from order_view o join users u on u.id=o.user_id order by id desc where created > %s and store_id = %s
33 
select o.*, u.username from order_view o join users u on u.id=o.user_id where created > %s and store_id = %s
34 
'''
 34 
'''
35 
ORDERS_DATE_QUERY1 = '''
 35 
ORDERS_DATE_QUERY1 = '''
36 
select * from orders where created > %s and store_id = %s
36 
select * from orders where created > %s and store_id = %s
37 
'''
 37 
'''
38 
 
 38