database error!
DB_NAME
select CARDS.AUTO from CARDS where CARDS.SHOP_SHOW=1 and CARDS.NEWS_DATE >= DATE_SUB(CURDATE(), INTERVAL 3 MONTH) order by CARDS.NEWS_DATE desc limit 100
database error!
DB_NAME
select CARDS.AUTO, sum(INVOICE_L.AMOUNT) as sales from INVOICE_H, INVOICE_L, CARDS where CARDS.SHOP_SHOW=1 and INVOICE_H.IN_DATE >= DATE_SUB(CURDATE(), INTERVAL 3 MONTH) and INVOICE_H.AUTO = INVOICE_L.ID_INVOICE_H and INVOICE_L.ID_CARDS=CARDS.AUTO group by CARDS.AUTO order by sales desc limit 100
database error!
DB_NAME
select CARDS.AUTO from CARDS, L_STATUS_CARD where CARDS.SHOP_SHOW=1 and CARDS.TOP=1 and CARDS.ID_L_STATUS_CARD=L_STATUS_CARD.AUTO and L_STATUS_CARD.ESHOP=1 order by AUTO desc limit 100
database error!
DB_NAME
select count(CARDS.AUTO) as cnt, CARDS.ID_CLIENTS, CLIENTS.FIRMA from CARDS, CLIENTS where CARDS.ID_CLIENTS!=0 and CARDS.ID_CLIENTS = CLIENTS.AUTO group by CARDS.ID_CLIENTS order by cnt desc