(\',st.name,\')\') name, \r\norgprice, st.name stype, m.print_destination\r\n\r\nfrom menu m, menu_categories mc, stocktypes st\r\n\r\nwhere m.name like \'%[namelike]%\' and m.type = st.id \r\nand m.useflag = 1 and m.menu_category = mc.id;','Tests','namelike,value,PLU name like','id,Id,align:right;total:avg;\r\ncname,Category,total:count;\r\nname,Name\r\norgprice,Price,prefix:R ;number:yes;total:sum;align:right;\r\nprint_destination,Printer','stype'),(11,'replist',1,'rep list','Rep List','select distinct folder from tillclients where folder != \'\';','Tests','','folder,rep',''),(13,'13',2,'rollup-no-sum','rollup no sum test','select m.id,mc.name cname,m.name,m.code\r\nfrom menu m, menu_categories mc\r\nwhere mc.id = m.menu_category\r\nlimit 100;','Tests','','id,Id\r\nname,item\r\ncode,PLU','cname'),(14,'14',2,'* Per user turnover','Show summary of sales per user','select\r\nw.name wname, round(sum(qty)*sum(price),2) total, sum(qty) qty, tods.name,\r\nround(sum(qty) * sum(price) / sum(qty) , 2) ahs\r\nfrom \r\n tillordersdetails tods, waitron w\r\nwhere tods.waitron_id = w.id\r\nand date(tods.stamp) > \'[sdate] 06:00:00\'\r\nand date(tods.stamp) < \'[edate] 06:00:00\'\r\nand tods.plu > 0\r\ngroup by tods.name\r\nlimit 10;\r\n','Tests','sdate,date,Start Date\r\nedate,date,End Date','name,PLU Name\r\nqty,QTY,align:right;\r\ntotal,Sales total,align:right;total:sum;prefix:R ;number:yes;\r\nahs,Average Head Spend,total:avg;','wname'),(15,'15',2,'* Address List','Customer address list','select name,ph_address,ph_address1,ph_address2,ph_postcode\r\nfrom tillclients;','Tests','','name,Name\r\nph_address,Address\r\nph_address1,Address1\r\nph_address2,Address2\r\nph_postcode,Address3',''),(19,'15',2,'* Phone List','Customer phone list','select clientgroup,name,telephone,cellphone\r\nfrom tillclients;','Tests','','clientgroup,Group\r\nname,Name\r\ntelephone,Telephone\r\ncellphone,Cellphone',''),(20,'15',2,'* Email List','Customer email list','select clientgroup,name,email\r\nfrom tillclients;','Tests','','clientgroup,Group\r\nname,Name\r\nemail,email',''),(21,'21',2,'* Unit Price Stats','Last, Min, Avg Unit Price','SELECT st.name stype, sc.name cname, si.name siname, si.id sid, \r\n CASE si.units \r\n WHEN 1 THEN \'kg\'\r\n WHEN 2 THEN \'litre\'\r\n WHEN 3 THEN \'each\'\r\n END unit,\r\n SUM(org_qty) qty,\r\n \r\n ROUND(SUBSTRING_INDEX(GROUP_CONCAT(pu.price ORDER BY pu.date DESC), \',\', 1),2) lastprice,\r\n ROUND(MAX(pu.price) , 2) maximumprice,\r\n ROUND(MIN(pu.price) , 2) minprice,\r\n ROUND(AVG(pu.price) , 2) avgprice\r\n \r\n FROM \r\n purchases pu,\r\n stockitems si,\r\n stocktypes st,\r\n stockcats sc\r\n\r\n WHERE si.id = pu.stockitems_id\r\n AND si.type = st.id AND si.stockcats_id = sc.id\r\n AND si.stockitem = 1\r\n\r\nGROUP BY si.id\r\n\r\nORDER BY st.name,sc.name, si.name;','PURCHASES','','stype,C.Center\r\ncname,Category\r\nsiname,Item\r\nsid,Stock ID\r\nunit,Units\r\nqty,Total Qty\r\nlastprice,Last Price\r\nmaximumprice,Max Price\r\nminprice,Min Price\r\navgprice,Avg Price',''),(22,'allitems',1,'allitems','count of all stockitems','select count(id) cnt,\'count all stockitems\' label from stockitems;','Tests','','label,waitron name for drop downs',''),(23,'totaltest',2,'totaltest','count of all stockitems','select [allitems.cnt] allitemz, \r\ncount(stockitems.id)/[allitems.cnt]*100 allitemz2,\r\nif (stockcats.name is not null,stockcats.name,\'N/a\') name,\r\nconcat(count(stockitems.id), \' of [allitems.cnt]\') cnt,\r\nstocktypes.name sname\r\n\r\nfrom stocktypes,stockitems\r\nleft join stockcats on stockcats.id = stockitems.stockcats_id\r\nwhere stocktypes.id = stockitems.type\r\ngroup by stockcats.id;','Tests','allitems.cnt,dropdown,Count all itemz','sname,C.Center,total:count;\r\nname,Category,total:count;\r\ncnt,Items,total:sum;\r\nallitemz2,allcnt2,sufix:%;total:sum;number:yes;\r\n','sname'),(30,'24',2,'Per DB Roolup','Test for Rollup per DB','select name,id from waitron;','Tests','','name,user,total:count;\r\nid,id,total:sum;','db_profile_name'),(32,'31',2,'* Per Category','Sales summary per Category','select\r\nmenucat.name catname,\r\nmenu.name, \r\nsum(tods.price * tods.qty) total\r\nfrom tillordersdetails tods,tillinvoices inv, menu,menu_categories menucat\r\nwhere tods.invoice = inv.id \r\nand (inv.voided is null or inv.voided = 0 or inv.voided = 2)\r\nand menu.id = tods.plu \r\nand menucat.id = menu.menu_category\r\n\r\ngroup by tods.name\r\n;\r\n\r\n','Tests','','name,PLU Name,total:count;\r\ntotal,Sales,total:sum;number:yes;prefix:R\r\n','catname'),(33,'33',2,'Vehicle Spending','Vehicle Fuel Spenditure','select \r\n vh_nr,\r\n MIN(vh_km) kmstart, \r\n MAX(vh_km) kmend,\r\n round(SUM(qty*price),2) totalvalue,\r\n MAX(vh_km) - MIN(vh_km) distance,\r\n SUM(qty) litres,\r\n ROUND( AVG(price), 2) avgprice,\r\n ROUND( ( SUM(qty * price) ) / (MAX(vh_km) - MIN(vh_km)) , 2 ) pusage,\r\n ROUND( SUM(qty) / ( MAX(vh_km) - MIN(vh_km) ) * 100 , 2 ) qtyusage\r\n\r\nfrom purchases\r\n\r\nwhere vh_nr != \'\'\r\n and date >= \'[datestart]\'\r\n and date <= \'[dateend]\'\r\n\r\ngroup by vh_nr\r\nhaving MAX(vh_km) - MIN(vh_km) > 0;\r\n\r\n\r\n\r\n','VEHICLES','datestart,date,Start Date\r\ndateend,date,End Date','vh_nr,Vehicle Reg,total:count;\r\nkmstart,Start (km),align:right;sufix: km;\r\nkmend,End (km),align:right;sufix: km;\r\ndistance,Distance (km),align:right;sufix: km;total:sum;\r\nlitres,Fuel Litres,align:right;sufix: litres;\r\navgprice,Average Price,align:right;prefix:R ;\r\ntotalvalue,Total Value,align:right;prefix:R ;total:sum;\r\nqtyusage,Litres / 100km,align:right;sufix: litres;',''),(34,'2',2,'INVOICES FOR PERIOD','FOOD INVOICES ','SELECT \r\r\n `purchases`.`date`\r\r\n , `suppliers`.`name` AS sname\r\r\n , `purchases`.`invoice`\r\r\n , `purchases`.`qty`\r\r\n , `purchases`.`price`\r\r\n , `purchases`.`org_price`\r\r\n , `purchases`.`discount`\r\r\n , `stockitems`.`name`\r\r\n , `stockitems`.`type`\r\r\n , `stocktypes`.`name` AS stname\r\r\nFROM\r\r\n `purchases`\r\r\n INNER JOIN `suppliers` \r\r\n ON (`purchases`.`supplier_id` = `suppliers`.`id`)\r\r\n INNER JOIN `stockitems` \r\r\n ON (`purchases`.`stockitems_id` = `stockitems`.`id`)\r\r\n INNER JOIN `stocktypes`\r\r\n ON (`stocktypes`.`id` = `stockitems`.`type`)\r\r\nWHERE purchases.f_status = 1 AND purchases.cnote = 0\r\r\nAND stockitems.type = 1\r\r\nAND purchases.date >= \'[sdate]\' AND purchases.date <= \'[edate]\';\r\r\n\r\r\n\r\r\n \r\r\n\r\r\n','PURCHASES','sdate,date,Start Date\r\r\nedate,date,End Date','date,Invoice Date,\r\r\nsname,Supplier Name,\r\r\ninvoice,Invoice Nr,\r\r\nstname,Department,\r\r\nqty,QTY,align:right,\r\r\nprice,Price,number:yes;align:right,\r\r\norg_price,Total,number:yes;total:sum;align:right,\r\r\ndiscount,Discount Total,prefix:R,\r\r\nname,Product Name,',''),(35,'106',2,'Cash Flow Report','Per Date','(SELECT\r\n\r\n tillclients.name,\r\n\r\n tillclients.code,\r\n\r\n tillclients.shop_id,\r\n\r\n accounts.date,\r\n\r\n accounts.tillinvoice_id,\r\n\r\n accounts.document,\r\n\r\n accounts.description,\r\n\r\n ROUND (accounts.credit,2) AS credit\r\n\r\nFROM\r\n\r\n accounts,\r\n\r\n tillclients\r\n\r\nWHERE\r\n\r\n accounts.account = 1 AND\r\n\r\n accounts.transaction_type = \'Cash\' AND\r\n\r\n accounts.credit > 0 AND\r\n\r\n (accounts.date >= \'[sdate]\' AND accounts.date <= \'[edate]\') AND\r\n\r\n tillclients.id = accounts.entityid\r\n\r\nORDER BY accounts.account)\r\n\r\nUNION ALL\r\n\r\n(SELECT\r\n\r\n suppliers.name,\r\n\r\n suppliers.code,\r\n\r\n suppliers.shop_id,\r\n\r\n accounts.date,\r\n\r\n accounts.tillinvoice_id,\r\n\r\n accounts.document,\r\n\r\n accounts.description,\r\n\r\n ROUND (accounts.credit,2) AS credit\r\n\r\nFROM\r\n\r\n accounts,\r\n\r\n suppliers\r\n\r\nWHERE\r\n\r\n accounts.account = 2 AND\r\n\r\n accounts.transaction_type = \'Cash\' AND\r\n\r\n accounts.credit > 0 AND\r\n\r\n (accounts.date >= \'[sdate]\' AND accounts.date <= \'[edate]\') AND\r\n\r\n suppliers.id = accounts.entityid\r\n\r\nORDER BY accounts.account)\r\n\r\nUNION ALL\r\n\r\n(SELECT\r\n\r\n tillclients.name,\r\n\r\n tillclients.code,\r\n\r\n tillclients.shop_id,\r\n\r\n accounts.date,\r\n\r\n accounts.tillinvoice_id,\r\n\r\n accounts.document,\r\n\r\n accounts.description,\r\n\r\n ROUND (accounts.debit * -1,2) AS credit\r\n\r\nFROM\r\n\r\n accounts,\r\n\r\n tillclients\r\n\r\nWHERE\r\n\r\n accounts.account = 1 AND\r\n\r\n accounts.transaction_type = \'Cash\' AND\r\n\r\n accounts.debit > 0 AND\r\n\r\n (accounts.date >= \'[sdate]\' AND accounts.date <= \'[edate]\') AND\r\n\r\n tillclients.id = accounts.entityid\r\n\r\nORDER BY accounts.account)\r\n\r\nUNION ALL\r\n\r\n(SELECT\r\n\r\n suppliers.name,\r\n\r\n suppliers.code,\r\n\r\n suppliers.shop_id,\r\n\r\n accounts.date,\r\n\r\n accounts.tillinvoice_id,\r\n\r\n accounts.document,\r\n\r\n accounts.description,\r\n\r\n ROUND(accounts.debit * -1,2) AS credit\r\n\r\nFROM\r\n\r\n accounts,\r\n\r\n suppliers\r\n\r\nWHERE\r\n\r\n accounts.account = 2 AND\r\n\r\n accounts.transaction_type = \'Cash\' AND\r\n\r\n accounts.debit > 0 AND\r\n\r\n (accounts.date >= \'[sdate]\' AND accounts.date <= \'[edate]\') AND\r\n\r\n suppliers.id = accounts.entityid\r\n\r\nORDER BY accounts.account);','OAKDALE - REPORTS','sdate,date,Start Date\r\nedate,date,End Date','date,CASHUP DATE\r\nname,ACCOUNT NAME\r\ncode,ACCOUNT CODE\r\ntillinvoice_id,INVOICE ID\r\ndocument,DOCUMENT REFERENCE\r\ndescription,DOCUMENT DESCRIPTION\r\ncredit,CASH DEPOSITS/ (CASH WITHDRAWALS),align:right;total:sum;','date'),(36,'36',2,'Placed Orders Detail Report','Order Details for Period','SELECT\r\n `tillordersdetails`.`stamp` AS st\r\n , `tillordersdetails`.`shop_id` AS shop\r\n , `tillordersdetails`.`orders_id` AS id\r\n , `tillordersdetails`.`invoice` AS iv\r\n , `tillordersdetails`.`qty` AS qty\r\n , `tillordersdetails`.`price` AS price\r\n , ROUND(qty * price,2) AS total\r\n , `tillordersdetails`.`name` AS name\r\n , `tillordersdetails`.`till_id` AS till\r\n , `terminals`.`ip` AS ip\r\n , `terminals`.`location` AS loc\r\n , `tillordersdetails`.`waitron_id` AS user\r\n , `waitron`.`name` AS wname\r\nFROM\r\n `tillordersdetails`\r\n INNER JOIN `terminals` \r\n ON (`tillordersdetails`.`till_id` = `terminals`.`id`)\r\n INNER JOIN `waitron` \r\n ON (`tillordersdetails`.`waitron_id` = `waitron`.`id`)\r\n \r\n WHERE tillordersdetails.`f_status` < 101\r\n AND tillordersdetails.stamp >= \'[sdate]:[stime]\' \r\n AND tillordersdetails.stamp <= \'[edate]:[etime]\';','Other Reports','sdate,date,Start Date\r\nedate,date,End Date\r\nstime,value,Start Time\r\netime,value,End Time','shop,SHOP ID\r\nst,TIMESTAMP\r\nid,ORDER NUMBER\r\niv,INVOICE NUMBER\r\nqty,QTY\r\nprice,PRICE\r\ntotal,AMOUNT,total:sum;align:right;number:yes;\r\nname,PLU/INSTRUCTION\r\ntill,TILL NUMBER\r\nip,TERMINAL IP\r\nloc,TILL LOCATION\r\nwname,USER NAME','id'),(38,'37',2,'Sales Report','Breakdown of Sales per Cashup','SELECT\r\n `dcash`.`date` AS date\r\n , `dcashinvoices`.`dcinv_turnover_total` AS tot\r\n , `dcashinvoices`.`staffpromo_total` AS promo\r\n , `dcashinvoices`.`id` AS tinv\r\n , `dcashinvoices`.`returns_total` AS returns\r\n , `dcashinvoices`.`discount_total` AS disc\r\n , `dcashinvoices`.`accounts_total` AS acc\r\n , `dcashinvoices`.`cheque_total` AS chq\r\n , `dcashinvoices`.`eft_total` AS eft\r\n , `dcashinvoices`.`creditcards_total` AS cc\r\n , `stockbins`.`name` AS bin\r\n , (`dcinv_turnover_total`-`staffpromo_total`-`returns_total`-`discount_total`\r\n-`accounts_total`-`cheque_total`-`eft_total`-`creditcards_total`) AS cash\r\n , `tillinvoices`.`till_id` AS terminal\r\n , `waitron`.`name` AS user\r\nFROM\r\n `oakdale_1`.`dcashinvoices`\r\n INNER JOIN `oakdale_1`.`tillinvoices` \r\n ON (`dcashinvoices`.`tillinvoices_id` = `tillinvoices`.`id`)\r\n INNER JOIN `oakdale_1`.`dcashitems` \r\n ON (`dcashitems`.`id` = `dcashinvoices`.`dcashitems_id`)\r\n INNER JOIN `oakdale_1`.`dcash` \r\n ON (`dcash`.`id` = `dcashitems`.`dcash_id`)\r\n INNER JOIN `oakdale_1`.`waitron` \r\n ON (`dcashitems`.`waitron_id` = `waitron`.`id`)\r\n LEFT JOIN `oakdale_1`.`stockbins` \r\n ON (`tillinvoices`.`bin_id` = `stockbins`.`id`)\r\n\r\n\r\nWHERE dcashinvoices.`f_status` < 101\r\nAND dcash.date >= \'[sdate]\' \r\n AND dcash.date <= \'[edate]\';','OAKDALE - REPORTS','sdate,date,Start Date\r\nedate,date,End Date','bin,Bin Name\r\nterminal,Section\r\ndate,Date\r\nuser, Waitron/Bar\r\ntinv, Invoice No.\r\ntot,Invoice Total,total:sum;align:right;number:yes;\r\npromo,Promotions,total:sum;align:right;number:yes;\r\nreturns,Returns,total:sum;align:right;number:yes;\r\ndisc,Discount,total:sum;align:right;number:yes;\r\nacc,Accounts,total:sum;align:right;number:yes;\r\nchq,Cheque Payments,total:sum;align:right;number:yes;\r\neft,EFT Payments,total:sum;align:right;number:yes;\r\ncc,Credit Card Payments,total:sum;align:right;number:yes;\r\ncash, Cash Received,total:sum;align:right;number:yes;','bin'),(39,'107a',2,'PLU Sales Report','By Category','CALL pluSalesReport (\"[sdate]\", \"[edate]\");','OAKDALE - REPORTS','sdate,date,Start Date\r\nedate,date,End Date','shopid,SHOP ID\r\ncategoryName,PLU Category\r\nplu,PLU Number\r\ndescription,PLU Description\r\nqty,QTY Sold,total:sum;align:right;\r\nselling_price_incl,Price(Incl),align:right;\r\ndiscount,Discount,total:sum;align:right;\r\nnet_sales_incl,NET Sales(Incl),number:yes;total:sum;align:right;\r\ntotal_sales_incl,NET T/O(Incl.),number:yes;total:sum;align:right;\r\ntotal_net_sales_excl,Net T/O (Excl.),number:yes;total:sum;align:right;\r\nunit_cost_excl,PLU Cost(Excl.),number:yes;align:right;\r\ngross_profit,Gross Proft(%),total:avg;align:right;','categoryName'),(41,'107a',2,'PLU Sales Report','By Cost Center','CALL pluSalesReport (\"[sdate]\", \"[edate]\");','OAKDALE - REPORTS','sdate,date,Start Date\r\nedate,date,End Date','shopid,SHOP ID\r\ncategoryName,PLU Category\r\nplu,PLU Number\r\ndescription,PLU Description\r\nqty,QTY Sold\r\nselling_price_incl,Price(Incl),align:right;\r\ndiscount,Discount,total:sum;align:right;\r\nnet_sales_incl,NET Sales(Incl),total:sum;align:right;\r\ntotal_sales_incl,NET T/O(Incl.),total:sum;align:right;\r\ntotal_net_sales_excl,Net T/O (Excl.),total:sum;align:right;\r\nunit_cost_excl,PLU Cost(Excl.),align:right;\r\ngross_profit,Gross Proft(%),total:avg;align:right;','stocktype'),(42,'100a',2,'Unit Price Stats for Beverages','Last, Min, Avg Unit Price & GP','SELECT st.name stype, sc.name cname, si.name siname, pu.date, pu.shop_id shop,mu.orgprice, \r\n\r\n CASE si.units \r\n WHEN 1 THEN \'kg\'\r\n WHEN 2 THEN \'litre\'\r\n WHEN 3 THEN \'each\'\r\n END unit,\r\n SUM(org_qty) qty,\r\n ROUND(SUBSTRING_INDEX(GROUP_CONCAT(pu.price ORDER BY pu.date DESC), \',\', 1),2) lastprice,\r\n ROUND(MAX(pu.price) , 2) maximumprice,\r\n ROUND(MIN(pu.price) , 2) minprice,\r\n ROUND(AVG(pu.price) , 2) avgprice,\r\n ROUND(mu.orgprice/1.14,2) AS price,\r\n ROUND(((mu.orgprice/1.14)-(ROUND(SUBSTRING_INDEX(GROUP_CONCAT(pu.price ORDER BY pu.date DESC), \',\', 1),2)))/(mu.orgprice/1.14)*100,2) AS gross\r\n\r\n FROM \r\n\r\n purchases pu,\r\n stockitems si,\r\n stocktypes st,\r\n stockcats sc,\r\n menu mu\r\n WHERE si.id = pu.stockitems_id AND si.id = mu.stockid\r\n AND si.type = st.id AND si.stockcats_id = sc.id\r\n AND mu.orgprice > 0\r\n AND mu.type = 1\r\n AND si.stockitem = 1\r\n AND pu.date >= \'[sdate]\' AND pu.date <= \'[edate]\'\r\n\r\nGROUP BY si.id\r\nORDER BY st.name,sc.name, si.name;','Stock Reports','sdate,date,Start Date\r\nedate,date,End Date','shop,Shop ID\r\nstype,C.Center\r\ncname,Category\r\nsiname,Item\r\nunit,Units\r\nqty,Total Qty\r\nmaximumprice,Max Price\r\nminprice,Min Price\r\navgprice,Avg Price\r\nlastprice,Last Price\r\nprice,SELLING Price\r\ngross,GROSS PERC,total:avg;','cname'),(44,'43',2,'Bin sales','PLU Sales per BIN','SELECT\r\n `stockbins`.`name` AS bin\r\n , `tillordersdetails`.`qty` AS qty\r\n , `tillordersdetails`.`price` AS price\r\n , ROUND(tillordersdetails.qty * tillordersdetails.price,2) AS total\r\n , `tillordersdetails`.`name` AS name\r\n , `tillinvoices`.`f_status`\r\nFROM\r\n `tillordersdetails`\r\n INNER JOIN `tillinvoices` \r\n ON (`tillordersdetails`.`invoice` = `tillinvoices`.`id`)\r\n INNER JOIN `stockbins` \r\n ON (`stockbins`.`id` = `tillordersdetails`.`bin_id`)\r\n \r\n WHERE tillordersdetails.qty > 1\r\n AND tillinvoices.f_status = 1\r\n AND stockbins.id = 2\r\n AND tillordersdetails.stamp >= \'[sdate]\' \r\n AND tillordersdetails.stamp <= \'[edate]\'\r\nGROUP BY tillordersdetails.name;\r\n \r\n','SALES','sdate,date,Start Date\r\nedate,date,End Date','bin,BIN NAME\r\nqty,QTY SOLD\r\nprice,PRICE\r\ntotal,TOTAL\r\nname,PLU NAME',''),(45,'S01',2,'COS INVOICES FOR PERIOD','COS Invoices - Excluding Internal Invoices','SELECT\r\n\r\n `purchases`.`shop_id`\r\n , `purchases`.`date`\r\n , `suppliers`.`name` AS sname\r\n , `purchases`.`invoice`\r\n , `purchases`.`vat` AS rate\r\n , `purchases`.`discount`\r\n , `purchases`.`org_qty` AS pqty\r\n , ROUND(`purchases`.`price`,2) AS price\r\n , ROUND((`purchases`.`org_qty`*price),2) AS `gross`\r\n , `purchases`.`org_qty`*`purchases`.`discount` AS discount\r\n , ROUND((`purchases`.`org_qty`*price)-(`purchases`.`org_qty`*discount),2) AS `amount`\r\n , ROUND(((`purchases`.`org_qty`*price)-(`purchases`.`org_qty`*discount))*`purchases`.`vat`*.15,2) AS vat\r\n , ROUND((((`purchases`.`org_qty`*price)-(`purchases`.`org_qty`*discount))+((`purchases`.`org_qty`*price)-(`purchases`.`org_qty`*discount))*`purchases`.`vat`*.15),2) AS inclusive\r\n , `stockitems`.`name`\r\n , `stockitems`.`type`\r\n , `stocktypes`.`name` AS stname\r\n\r\nFROM\r\n `purchases`\r\n INNER JOIN `suppliers` \r\n ON (`purchases`.`supplier_id` = `suppliers`.`id`)\r\n INNER JOIN `stockitems` \r\n ON (`purchases`.`stockitems_id` = `stockitems`.`id`)\r\n INNER JOIN `stocktypes`\r\n ON (`stocktypes`.`id` = `stockitems`.`type`)\r\n\r\nWHERE purchases.type >= 1\r\nAND stockitems.type >= 1\r\nAND purchases.supplier_id > 1\r\nAND cnote = 0\r\nAND purchases.f_status < 101\r\nAND othertype = 0\r\nAND purchases.date >= \'[sdate]\' AND purchases.date <= \'[edate]\';','PURCHASES','sdate,date,Start Date\r\nedate,date,End Date','stname,Cost Center,\r\ndate,Invoice Date,\r\nsname,Supplier Name,\r\ninvoice,Invoice Nr,\r\nname,Product Name,\r\npqty,QTY,align:right,\r\nprice,Price,align:right,\r\ngross,Amount,total:sum;number:yes;align:right,\r\ndiscount,Disc.Rec,total:sum;number:yes;align:right,\r\namount,Nett Amount,total:sum;number:yes;align:right,\r\nvat,Vat Input,total:sum;number:yes;align:right,\r\ninclusive,Amount(incl),total:sum;number:yes;align:right,','stname'),(46,'S01',2,'COS CREDIT NOTES FOR PERIOD','COS Credit Notes - Excluding Internal C/N\'s','SELECT\r\n\r\n `purchases`.`shop_id`\r\n , `purchases`.`date`\r\n , `suppliers`.`name` AS sname\r\n , `purchases`.`invoice`\r\n , `purchases`.`vat` AS rate\r\n , `purchases`.`discount`\r\n , `purchases`.`org_qty` AS pqty\r\n , ROUND(`purchases`.`price`,2) AS price\r\n , ROUND((`purchases`.`org_qty`*price),2) AS `gross`\r\n , `purchases`.`org_qty`*`purchases`.`discount` AS discount\r\n , ROUND((`purchases`.`org_qty`*price)-(`purchases`.`org_qty`*discount),2) AS `amount`\r\n , ROUND(((`purchases`.`org_qty`*price)-(`purchases`.`org_qty`*discount))*`purchases`.`vat`*.15,2) AS vat\r\n , ROUND((((`purchases`.`org_qty`*price)-(`purchases`.`org_qty`*discount))+((`purchases`.`org_qty`*price)-(`purchases`.`org_qty`*discount))*`purchases`.`vat`*.15),2) AS inclusive\r\n , `stockitems`.`name`\r\n , `stockitems`.`type`\r\n , `stocktypes`.`name` AS stname\r\n\r\nFROM\r\n `purchases`\r\n INNER JOIN `suppliers` \r\n ON (`purchases`.`supplier_id` = `suppliers`.`id`)\r\n INNER JOIN `stockitems` \r\n ON (`purchases`.`stockitems_id` = `stockitems`.`id`)\r\n INNER JOIN `stocktypes`\r\n ON (`stocktypes`.`id` = `stockitems`.`type`)\r\n\r\nWHERE purchases.type >= 1\r\nAND stockitems.type >= 1\r\nAND purchases.supplier_id > 1\r\nAND cnote = 1\r\nAND purchases.f_status < 101\r\nAND othertype = 0\r\nAND purchases.date >= \'[sdate]\' AND purchases.date <= \'[edate]\';','PURCHASES','sdate,date,Start Date\r\nedate,date,End Date','stname,Cost Center,\r\ndate,Invoice Date,\r\nsname,Supplier Name,\r\ninvoice,Invoice Nr,\r\nname,Product Name,\r\npqty,QTY,align:right,\r\nprice,Price,align:right,\r\ngross,Amount,total:sum;align:right,\r\ndiscount,Disc.Rec,total:sum;align:right,\r\namount,Nett Amount,total:sum;align:right,\r\nvat,Vat Input,total:sum;align:right,\r\ninclusive,Amount(incl),total:sum;align:right,','stname'),(48,'S01',2,'COS INVOICES FOR PERIOD','COS Internal Invoices per Cost Center','SELECT\r\n\r\n `purchases`.`shop_id`\r\n\r\n , `purchases`.`date`\r\n\r\n , `suppliers`.`name` AS sname\r\n\r\n , `purchases`.`invoice`\r\n\r\n , `purchases`.`vat` AS rate\r\n\r\n , `purchases`.`discount`\r\n\r\n , `purchases`.`org_qty` AS pqty\r\n\r\n , ROUND(`purchases`.`price`,2) AS price\r\n\r\n , ROUND((`purchases`.`org_qty`*price),2) AS `gross`\r\n\r\n , `purchases`.`org_qty`*`purchases`.`discount` AS discount\r\n\r\n , ROUND((`purchases`.`org_qty`*price)-(`purchases`.`org_qty`*discount),2) AS `amount`\r\n\r\n , ROUND(((`purchases`.`org_qty`*price)-(`purchases`.`org_qty`*discount))*`purchases`.`vat`*.15,2) AS vat\r\n\r\n , ROUND((((`purchases`.`org_qty`*price)-(`purchases`.`org_qty`*discount))+((`purchases`.`org_qty`*price)-(`purchases`.`org_qty`*discount))*`purchases`.`vat`*.15),2) AS inclusive\r\n\r\n , `stockitems`.`name`\r\n\r\n , `stockitems`.`type`\r\n\r\n , `stocktypes`.`name` AS stname\r\n\r\n\r\n\r\nFROM\r\n\r\n `purchases`\r\n\r\n INNER JOIN `suppliers` \r\n\r\n ON (`purchases`.`supplier_id` = `suppliers`.`id`)\r\n\r\n INNER JOIN `stockitems` \r\n\r\n ON (`purchases`.`stockitems_id` = `stockitems`.`id`)\r\n\r\n INNER JOIN `stocktypes`\r\n\r\n ON (`stocktypes`.`id` = `stockitems`.`type`)\r\n\r\n\r\n\r\nWHERE purchases.type >= 1\r\nAND stockitems.type >= 1\r\nAND purchases.supplier_id = 1\r\nAND cnote = 0\r\nAND purchases.f_status < 101\r\nAND othertype = 0\r\nAND purchases.date >= \'[sdate]\' AND purchases.date <= \'[edate]\';','PURCHASES (15%)','sdate,date,Start Date\r\nedate,date,End Date','stname,Cost Center,\r\ndate,Invoice Date,\r\nsname,Supplier Name,\r\ninvoice,Invoice Nr,\r\nname,Product Name,\r\npqty,QTY,align:right,\r\nprice,Price,align:right,\r\ngross,Amount,total:sum;number:yes;align:right,\r\ndiscount,Disc.Rec,total:sum;number:yes;align:right,\r\namount,Nett Amount,total:sum;number:yes;align:right,\r\nvat,Vat Input,total:sum;number:yes;align:right,\r\ninclusive,Amount(incl),total:sum;number:yes;align:right,','stname'),(47,'S01',2,'COS CREDIT NOTES FOR PERIOD','COS Internal Credit Notes per Cost Center','SELECT\r\n\r\n `purchases`.`shop_id`\r\n\r\n , `purchases`.`date`\r\n\r\n , `suppliers`.`name` AS sname\r\n\r\n , `purchases`.`invoice`\r\n\r\n , `purchases`.`vat` AS rate\r\n\r\n , `purchases`.`discount`\r\n\r\n , `purchases`.`org_qty` AS pqty\r\n\r\n , ROUND(`purchases`.`price`,2) AS price\r\n\r\n , ROUND((`purchases`.`org_qty`*price),2) AS `gross`\r\n\r\n , `purchases`.`org_qty`*`purchases`.`discount` AS discount\r\n\r\n , ROUND((`purchases`.`org_qty`*price)-(`purchases`.`org_qty`*discount),2) AS `amount`\r\n\r\n , ROUND(((`purchases`.`org_qty`*price)-(`purchases`.`org_qty`*discount))*`purchases`.`vat`*.15,2) AS vat\r\n\r\n , ROUND((((`purchases`.`org_qty`*price)-(`purchases`.`org_qty`*discount))+((`purchases`.`org_qty`*price)-(`purchases`.`org_qty`*discount))*`purchases`.`vat`*.15),2) AS inclusive\r\n\r\n , `stockitems`.`name`\r\n\r\n , `stockitems`.`type`\r\n\r\n , `stocktypes`.`name` AS stname\r\n\r\n\r\n\r\nFROM\r\n\r\n `purchases`\r\n\r\n INNER JOIN `suppliers` \r\n\r\n ON (`purchases`.`supplier_id` = `suppliers`.`id`)\r\n\r\n INNER JOIN `stockitems` \r\n\r\n ON (`purchases`.`stockitems_id` = `stockitems`.`id`)\r\n\r\n INNER JOIN `stocktypes`\r\n\r\n ON (`stocktypes`.`id` = `stockitems`.`type`)\r\n\r\n\r\n\r\nWHERE purchases.type >= 1\r\nAND stockitems.type >= 1\r\nAND purchases.supplier_id = 1\r\nAND cnote = 1\r\nAND purchases.f_status < 101\r\nAND othertype = 0\r\nAND purchases.date >= \'[sdate]\' AND purchases.date <= \'[edate]\';','PURCHASES (15%)','sdate,date,Start Date\r\nedate,date,End Date','stname,Cost Center,\r\ndate,Invoice Date,\r\nsname,Supplier Name,\r\ninvoice,Invoice Nr,\r\nname,Product Name,\r\npqty,QTY,align:right,\r\nprice,Price,align:right,\r\ngross,Amount,total:sum;number:yes;align:right,\r\ndiscount,Disc.Rec,total:sum;number:yes;align:right,\r\namount,Nett Amount,total:sum;number:yes;align:right,\r\nvat,Vat Input,total:sum;number:yes;align:right,\r\ninclusive,Amount(incl),total:sum;number:yes;align:right,','stname'),(49,'S01',2,'COS CREDIT NOTES FOR PERIOD','COS All Credit Notes','SELECT\r\n\r\n `purchases`.`shop_id`\r\n , `purchases`.`date`\r\n , `suppliers`.`name` AS sname\r\n , `purchases`.`invoice`\r\n , `purchases`.`vat` AS rate\r\n , `purchases`.`discount`\r\n , `purchases`.`org_qty` AS pqty\r\n , ROUND(`purchases`.`price`,2) AS price\r\n , ROUND((`purchases`.`org_qty`*price),2) AS `gross`\r\n , `purchases`.`org_qty`*`purchases`.`discount` AS discount\r\n , ROUND((`purchases`.`org_qty`*price)-(`purchases`.`org_qty`*discount),2) AS `amount`\r\n , ROUND(((`purchases`.`org_qty`*price)-(`purchases`.`org_qty`*discount))*`purchases`.`vat`*.15,2) AS vat\r\n , ROUND((((`purchases`.`org_qty`*price)-(`purchases`.`org_qty`*discount))+((`purchases`.`org_qty`*price)-(`purchases`.`org_qty`*discount))*`purchases`.`vat`*.15),2) AS inclusive\r\n , `stockitems`.`name`\r\n , `stockitems`.`type`\r\n , `stocktypes`.`name` AS stname\r\n\r\n\r\nFROM\r\n\r\n `purchases`\r\n INNER JOIN `suppliers` \r\n ON (`purchases`.`supplier_id` = `suppliers`.`id`)\r\n INNER JOIN `stockitems` \r\n ON (`purchases`.`stockitems_id` = `stockitems`.`id`)\r\n INNER JOIN `stocktypes`\r\n ON (`stocktypes`.`id` = `stockitems`.`type`)\r\n\r\nWHERE purchases.type = 2\r\nAND stockitems.type >= 0\r\nAND supplier_id >= 0\r\nAND cnote = 1\r\nAND purchases.f_status < 101\r\nAND othertype = 0\r\nAND purchases.date >= \'[sdate]\' AND purchases.date <= \'[edate]\';','PURCHASES','sdate,date,Start Date\r\nedate,date,End Date','stname,Cost Center,\r\ndate,Invoice Date,\r\nsname,Supplier Name,\r\ninvoice,Invoice Nr,\r\nname,Product Name,\r\npqty,QTY,align:right,\r\nprice,Price,align:right,\r\ngross,Amount,total:sum;number:yes;align:right,\r\ndiscount,Disc.Rec,total:sum;number:yes;align:right,\r\namount,Nett Amount,total:sum;number:yes;align:right,\r\nvat,Vat Input,total:sum;number:yes;align:right,\r\ninclusive,Amount(incl),total:sum;number:yes;align:right,','stname'),(50,'S01',2,'COS INVOICES FOR PERIOD','COS All Invoices','SELECT\r\n\r\n `purchases`.`shop_id`\r\n , `purchases`.`date`\r\n , `suppliers`.`name` AS sname\r\n , `purchases`.`invoice`\r\n , `purchases`.`vat` AS rate\r\n , `purchases`.`discount`\r\n , `purchases`.`org_qty` AS pqty\r\n , ROUND(`purchases`.`price`,2) AS price\r\n , ROUND((`purchases`.`org_qty`*price),2) AS `gross`\r\n , `purchases`.`org_qty`*`purchases`.`discount` AS discount\r\n , ROUND((`purchases`.`org_qty`*price)-(`purchases`.`org_qty`*discount),2) AS `amount`\r\n , ROUND(((`purchases`.`org_qty`*price)-(`purchases`.`org_qty`*discount))*`purchases`.`vat`*.15,2) AS vat\r\n , ROUND((((`purchases`.`org_qty`*price)-(`purchases`.`org_qty`*discount))+((`purchases`.`org_qty`*price)-(`purchases`.`org_qty`*discount))*`purchases`.`vat`*.15),2) AS inclusive\r\n , `stockitems`.`name`\r\n , `stockitems`.`type`\r\n , `stocktypes`.`name` AS stname\r\n\r\nFROM\r\n `purchases`\r\n INNER JOIN `suppliers` \r\n ON (`purchases`.`supplier_id` = `suppliers`.`id`)\r\n INNER JOIN `stockitems` \r\n ON (`purchases`.`stockitems_id` = `stockitems`.`id`)\r\n INNER JOIN `stocktypes`\r\n ON (`stocktypes`.`id` = `stockitems`.`type`)\r\n\r\nWHERE purchases.type = 2\r\nAND stockitems.type >= 0\r\nAND purchases.supplier_id >= 0\r\nAND cnote = 0\r\nAND purchases.f_status < 101\r\nAND othertype = 0\r\nAND purchases.date >= \'[sdate]\' AND purchases.date <= \'[edate]\';','PURCHASES','sdate,date,Start Date\r\nedate,date,End Date','stname,Cost Center,\r\ndate,Invoice Date,\r\nsname,Supplier Name,\r\ninvoice,Invoice Nr,\r\nname,Product Name,\r\npqty,QTY,align:right,\r\nprice,Price,align:right,\r\ngross,Amount,total:sum;number:yes;align:right,\r\ndiscount,Disc.Rec,total:sum;number:yes;align:right,\r\namount,Nett Amount,total:sum;number:yes;align:right,\r\nvat,Vat Input,total:sum;number:yes;align:right,\r\ninclusive,Amount(incl),total:sum;number:yes;align:right,','stname'),(51,'S01',2,'COS CREDIT NOTES FOR PERIOD','COS All Credit Notes Per Supplier','SELECT\r\n\r\n `purchases`.`shop_id`\r\n\r\n , `purchases`.`date`\r\n\r\n , `suppliers`.`name` AS sname\r\n\r\n , `purchases`.`invoice`\r\n\r\n , `purchases`.`vat` AS rate\r\n\r\n , `purchases`.`discount`\r\n\r\n , `purchases`.`org_qty` AS pqty\r\n\r\n , ROUND(`purchases`.`price`,2) AS price\r\n\r\n , ROUND((`purchases`.`org_qty`*price),2) AS `gross`\r\n\r\n , `purchases`.`org_qty`*`purchases`.`discount` AS discount\r\n\r\n , ROUND((`purchases`.`org_qty`*price)-(`purchases`.`org_qty`*discount),2) AS `amount`\r\n\r\n , ROUND(((`purchases`.`org_qty`*price)-(`purchases`.`org_qty`*discount))*`purchases`.`vat`*.15,2) AS vat\r\n\r\n , ROUND((((`purchases`.`org_qty`*price)-(`purchases`.`org_qty`*discount))+((`purchases`.`org_qty`*price)-(`purchases`.`org_qty`*discount))*`purchases`.`vat`*.15),2) AS inclusive\r\n\r\n , `stockitems`.`name`\r\n\r\n , `stockitems`.`type`\r\n\r\n , `stocktypes`.`name` AS stname\r\n\r\n\r\n\r\nFROM\r\n\r\n `purchases`\r\n\r\n INNER JOIN `suppliers` \r\n\r\n ON (`purchases`.`supplier_id` = `suppliers`.`id`)\r\n\r\n INNER JOIN `stockitems` \r\n\r\n ON (`purchases`.`stockitems_id` = `stockitems`.`id`)\r\n\r\n INNER JOIN `stocktypes`\r\n\r\n ON (`stocktypes`.`id` = `stockitems`.`type`)\r\n\r\n\r\n\r\nWHERE purchases.type >= 1\r\nAND stockitems.type >= 1\r\nAND cnote = 1\r\nAND purchases.f_status < 101\r\nAND othertype = 0\r\nAND purchases.date >= \'[sdate]\' AND purchases.date <= \'[edate]\';','PURCHASES (15%)','sdate,date,Start Date\r\nedate,date,End Date','stname,Cost Center,\r\ndate,Invoice Date,\r\nsname,Supplier Name,\r\ninvoice,Invoice Nr,\r\nname,Product Name,\r\npqty,QTY,align:right,\r\nprice,Price,align:right,\r\ngross,Amount,total:sum;number:yes;align:right,\r\ndiscount,Disc.Rec,total:sum;number:yes;align:right,\r\namount,Nett Amount,total:sum;number:yes;align:right,\r\nvat,Vat Input,total:sum;number:yes;align:right,\r\ninclusive,Amount(incl),total:sum;number:yes;align:right,','sname'),(52,'S01',2,'COS INVOICES FOR PERIOD','COS All Invoices Per Supplier','SELECT\r\n\r\n `purchases`.`shop_id`\r\n\r\n , `purchases`.`date`\r\n\r\n , `suppliers`.`name` AS sname\r\n\r\n , `purchases`.`invoice`\r\n\r\n , `purchases`.`vat` AS rate\r\n\r\n , `purchases`.`discount`\r\n\r\n , `purchases`.`org_qty` AS pqty\r\n\r\n , ROUND(`purchases`.`price`,2) AS price\r\n\r\n , ROUND((`purchases`.`org_qty`*price),2) AS `gross`\r\n\r\n , `purchases`.`org_qty`*`purchases`.`discount` AS discount\r\n\r\n , ROUND((`purchases`.`org_qty`*price)-(`purchases`.`org_qty`*discount),2) AS `amount`\r\n\r\n , ROUND(((`purchases`.`org_qty`*price)-(`purchases`.`org_qty`*discount))*`purchases`.`vat`*.15,2) AS vat\r\n\r\n , ROUND((((`purchases`.`org_qty`*price)-(`purchases`.`org_qty`*discount))+((`purchases`.`org_qty`*price)-(`purchases`.`org_qty`*discount))*`purchases`.`vat`*.15),2) AS inclusive\r\n\r\n , `stockitems`.`name`\r\n\r\n , `stockitems`.`type`\r\n\r\n , `stocktypes`.`name` AS stname\r\n\r\n\r\n\r\nFROM\r\n\r\n `purchases`\r\n\r\n INNER JOIN `suppliers` \r\n\r\n ON (`purchases`.`supplier_id` = `suppliers`.`id`)\r\n\r\n INNER JOIN `stockitems` \r\n\r\n ON (`purchases`.`stockitems_id` = `stockitems`.`id`)\r\n\r\n INNER JOIN `stocktypes`\r\n\r\n ON (`stocktypes`.`id` = `stockitems`.`type`)\r\n\r\n\r\n\r\nWHERE purchases.type >= 1\r\nAND stockitems.type >= 1\r\nAND cnote = 0\r\nAND purchases.f_status < 101\r\nAND othertype = 0\r\nAND purchases.date >= \'[sdate]\' AND purchases.date <= \'[edate]\';','PURCHASES (15%)','sdate,date,Start Date\r\nedate,date,End Date','stname,Cost Center,\r\ndate,Invoice Date,\r\nsname,Supplier Name,\r\ninvoice,Invoice Nr,\r\nname,Product Name,\r\npqty,QTY,align:right,\r\nprice,Price,align:right,\r\ngross,Amount,total:sum;number:yes;align:right,\r\ndiscount,Disc.Rec,total:sum;number:yes;align:right,\r\namount,Nett Amount,total:sum;number:yes;align:right,\r\nvat,Vat Input,total:sum;number:yes;align:right,\r\ninclusive,Amount(incl),total:sum;number:yes;align:right,','sname'),(54,'S04',2,'EXPENSE C/N\'s FOR PERIOD','Expenses Credit Notes per Suppliers Report','SELECT\r\n\r\n `purchases`.`shop_id` AS id\r\n\r\n , `suppliers`.`name` AS name\r\n\r\n , `purchases`.`date` AS date\r\n\r\n , `purchases`.`invoice` AS invoice\r\n\r\n , ROUND(`purchases`.`discount`,2)\r\n\r\n , `purchases`.`org_qty`*-1 AS number\r\n\r\n , ROUND(`purchases`.`price`,2) AS price\r\n\r\n , ROUND(`purchases`.`org_price`*-1,2) AS amount\r\n\r\n , ROUND(`purchases`.`discount`*-1,2) AS discount\r\n\r\n , ROUND((`purchases`.`org_price`+(`purchases`.`discount`))*-1,2) AS gross\r\n\r\n , ROUND(((`purchases`.`org_price`*-1)+(`purchases`.`vat`*0.15*`purchases`.`org_price`*-1)),2) AS inclusive\r\n\r\n , `purchases`.`description` AS description\r\n\r\n , `bufc`.`name` AS category\r\n\r\n , ROUND(`purchases`.`vat`*`purchases`.`org_price`*0.15*-1,2) AS vat\r\n\r\nFROM\r\n\r\n `purchases`\r\n\r\n INNER JOIN `suppliers` \r\n\r\n ON (`purchases`.`supplier_id` = `suppliers`.`id`)\r\n\r\n INNER JOIN `bufc` \r\n\r\n ON (`purchases`.`othertype` = `bufc`.`id`)\r\n\r\n \r\n\r\nWHERE othertype > 0\r\n\r\nAND cnote = 1\r\n\r\nAND purchases.f_status < 101\r\n\r\nAND purchases.date >= \'[sdate]\' AND purchases.date <= \'[edate]\';','PURCHASES (15%)','sdate,date,Start Date\r\nedate,date,End Date','name,Supplier,\r\ndate,Inv.Date,\r\nnumber,Qty,\r\nprice,Price,\r\ngross,Amount,total:sum;\r\ndiscount,Disc.Rec,total:sum;\r\namount,Nett Amount,total:sum;\r\nvat,VAT Input,total:sum;\r\ninclusive,Amount(incl),total:sum;\r\ndescription,Item Detail,\r\ncategory,Category,','name'),(55,'S03',2,' EXPENSE INVOICES FOR PERIOD','Expenses per Suppliers Report','SELECT\r\n\r\n `purchases`.`shop_id` AS id\r\n\r\n , `bufc`.`name` AS category\r\n\r\n , `suppliers`.`name` AS name\r\n\r\n , `purchases`.`description` AS description\r\n\r\n , `purchases`.`date` AS date\r\n\r\n , `purchases`.`invoice` AS invoice\r\n\r\n , `purchases`.`org_qty` AS qty\r\n\r\n , `purchases`.`vat` AS rate\r\n\r\n , ROUND(`purchases`.`price`,2) AS price\r\n\r\n , `purchases`.`discount`\r\n\r\n , qty*`purchases`.`discount` AS discount\r\n\r\n , ROUND((qty*price),2) AS `gross`\r\n\r\n , ROUND((qty*price)-(qty*discount),2) AS `amount`\r\n\r\n , ROUND(((qty*price)-(qty*discount))*`purchases`.`vat`*.15,2) AS vat\r\n\r\n , ROUND((((qty*price)-(qty*discount))+((qty*price)-(qty*discount))*`purchases`.`vat`*.15),2) AS inclusive\r\n\r\n\r\n\r\n\r\n\r\nFROM\r\n\r\n `purchases`\r\n\r\n INNER JOIN `suppliers` \r\n\r\n ON (`purchases`.`supplier_id` = `suppliers`.`id`)\r\n\r\n INNER JOIN `bufc` \r\n\r\n ON (`purchases`.`othertype` = `bufc`.`id`)\r\n\r\n \r\n\r\nWHERE othertype > 0\r\n\r\nAND cnote = 0\r\n\r\nAND purchases.f_status < 101\r\n\r\nAND purchases.date >= \'[sdate]\' AND purchases.date <= \'[edate]\';','PURCHASES (15%)','sdate,date,Start Date\r\nedate,date,End Date','name,Supplier,\r\ndate,Inv.Date,\r\nqty,Qty,\r\nprice,Price,\r\ngross, Gross Amount,total:sum;\r\ndiscount,Disc.Rec,total:sum;\r\namount,Nett Amount,total:sum;\r\nvat,VAT Input,total:sum;\r\ninclusive,Amount(incl),total:sum;\r\ndescription,Item Detail,\r\ncategory,Category,','name'),(56,'S03',2,'EXPENSE INVOICES FOR PERIOD','Expenses per Category Report','SELECT\r\n\r\n `purchases`.`shop_id` AS id\r\n\r\n , `bufc`.`name` AS category\r\n\r\n , `suppliers`.`name` AS name\r\n\r\n , `purchases`.`description` AS description\r\n\r\n , `purchases`.`date` AS date\r\n\r\n , `purchases`.`invoice` AS invoice\r\n\r\n , `purchases`.`org_qty` AS qty\r\n\r\n , `purchases`.`vat` AS rate\r\n\r\n , ROUND(`purchases`.`price`,2) AS price\r\n\r\n , `purchases`.`discount`\r\n\r\n , qty*`purchases`.`discount` AS discount\r\n\r\n , ROUND((qty*price),2) AS `gross`\r\n\r\n , ROUND((qty*price)-(qty*discount),2) AS `amount`\r\n\r\n , ROUND(((qty*price)-(qty*discount))*`purchases`.`vat`*.15,2) AS vat\r\n\r\n , ROUND((((qty*price)-(qty*discount))+((qty*price)-(qty*discount))*`purchases`.`vat`*.15),2) AS inclusive\r\n\r\n\r\n\r\n\r\n\r\nFROM\r\n\r\n `purchases`\r\n\r\n INNER JOIN `suppliers` \r\n\r\n ON (`purchases`.`supplier_id` = `suppliers`.`id`)\r\n\r\n INNER JOIN `bufc` \r\n\r\n ON (`purchases`.`othertype` = `bufc`.`id`)\r\n\r\n \r\n\r\nWHERE othertype > 0\r\n\r\nAND cnote = 0\r\n\r\nAND purchases.f_status < 101\r\n\r\nAND purchases.date >= \'[sdate]\' AND purchases.date <= \'[edate]\';','PURCHASES (15%)','sdate,date,Start Date\r\nedate,date,End Date','name,Supplier,\r\ndate,Inv.Date,\r\nqty,Qty,\r\nprice,Price,\r\ngross, Gross Amount,total:sum;\r\ndiscount,Disc.Rec,total:sum;\r\namount,Nett Amount,total:sum;\r\nvat,VAT Input,total:sum;\r\ninclusive,Amount(incl),total:sum;\r\ndescription,Item Detail,\r\ncategory,Category,','category'),(57,'106',2,'Cash Flow Report','Per Control Accounts','(SELECT\r\n\r\n tillclients.name,\r\n\r\n tillclients.code,\r\ntillclients.note,\r\n\r\n tillclients.shop_id,\r\n\r\n accounts.date,\r\n\r\n accounts.tillinvoice_id,\r\n\r\n accounts.document,\r\n\r\n accounts.description,\r\n\r\n ROUND (accounts.credit,2) AS credit\r\n\r\nFROM\r\n\r\n accounts,\r\n\r\n tillclients\r\n\r\nWHERE\r\n\r\n accounts.account = 1 AND\r\n\r\n accounts.transaction_type = \'Cash\' AND\r\n\r\n accounts.credit > 0 AND\r\n\r\n (accounts.date >= \'[sdate]\' AND accounts.date <= \'[edate]\') AND\r\n\r\n tillclients.id = accounts.entityid\r\n\r\nORDER BY accounts.account)\r\n\r\nUNION ALL\r\n\r\n(SELECT\r\n\r\n suppliers.name,\r\n\r\n suppliers.code,\r\n suppliers.notes AS note,\r\n suppliers.shop_id,\r\n\r\n accounts.date,\r\n\r\n accounts.tillinvoice_id,\r\n\r\n accounts.document,\r\n\r\n accounts.description,\r\n\r\n ROUND (accounts.credit,2) AS credit\r\n\r\nFROM\r\n\r\n accounts,\r\n\r\n suppliers\r\n\r\nWHERE\r\n\r\n accounts.account = 2 AND\r\n\r\n accounts.transaction_type = \'Cash\' AND\r\n\r\n accounts.credit > 0 AND\r\n\r\n (accounts.date >= \'[sdate]\' AND accounts.date <= \'[edate]\') AND\r\n\r\n suppliers.id = accounts.entityid\r\n\r\nORDER BY accounts.account)\r\n\r\nUNION ALL\r\n\r\n(SELECT\r\n\r\n tillclients.name,\r\n\r\n tillclients.code,\r\ntillclients.note,\r\n\r\n tillclients.shop_id,\r\n\r\n accounts.date,\r\n\r\n accounts.tillinvoice_id,\r\n\r\n accounts.document,\r\n\r\n accounts.description,\r\n\r\n ROUND (accounts.debit * -1,2) AS credit\r\n\r\nFROM\r\n\r\n accounts,\r\n\r\n tillclients\r\n\r\nWHERE\r\n\r\n accounts.account = 1 AND\r\n\r\n accounts.transaction_type = \'Cash\' AND\r\n\r\n accounts.debit > 0 AND\r\n\r\n (accounts.date >= \'[sdate]\' AND accounts.date <= \'[edate]\') AND\r\n\r\n tillclients.id = accounts.entityid\r\n\r\nORDER BY accounts.account)\r\n\r\nUNION ALL\r\n\r\n(SELECT\r\n\r\n suppliers.name,\r\n\r\n suppliers.code,\r\n suppliers.notes AS note,\r\n\r\n suppliers.shop_id,\r\n\r\n accounts.date,\r\n\r\n accounts.tillinvoice_id,\r\n\r\n accounts.document,\r\n\r\n accounts.description,\r\n\r\n ROUND(accounts.debit * -1,2) AS credit\r\n\r\nFROM\r\n\r\n accounts,\r\n\r\n suppliers\r\n\r\nWHERE\r\n\r\n accounts.account = 2 AND\r\n\r\n accounts.transaction_type = \'Cash\' AND\r\n\r\n accounts.debit > 0 AND\r\n\r\n (accounts.date >= \'[sdate]\' AND accounts.date <= \'[edate]\') AND\r\n\r\n suppliers.id = accounts.entityid\r\n\r\nORDER BY accounts.account);','OAKDALE - REPORTS','sdate,date,Start Date\r\nedate,date,End Date','date,CASHUP DATE\r\nnote,ACCOUNT TYPE\r\nname,ACCOUNT NAME\r\ncode,ACCOUNT CODE\r\ntillinvoice_id,INVOICE ID\r\ndocument,DOCUMENT REFERENCE\r\ndescription,DOCUMENT DESCRIPTION\r\ncredit,CASH DEPOSITS/ (CASH WITHDRAWALS),align:right;total:sum;','name'),(58,'106',2,'Credit Card Report','Credit Card Receipts on Trade','SELECT\r\n `dcash`.`date`\r\n , `waitron`.`name`\r\n , `dcashinvoices`.`dcinv_turnover_total` AS total\r\n , `dcashinvoices`.`creditcards_total`\r\nFROM\r\n `oakdale_1`.`dcash`\r\n INNER JOIN `oakdale_1`.`dcashitems` \r\n ON (`dcash`.`id` = `dcashitems`.`dcash_id`)\r\n INNER JOIN `oakdale_1`.`dcashinvoices` \r\n ON (`dcashitems`.`id` = `dcashinvoices`.`dcashitems_id`)\r\n INNER JOIN `oakdale_1`.`waitron` \r\n ON (`dcashitems`.`waitron_id` = `waitron`.`id`)\r\n WHERE creditcards_total > 0\r\n AND dcash.`f_status` = 1\r\n and dcashinvoices.f_status = 1 AND\r\n dcash.date >= \'[sdate]\' AND dcash.date <= \'[edate]\';\r\n','OAKDALE - REPORTS','sdate,date,Start Date\r\nedate,date,End Date','date,CASHUP DATE\r\nname,WAITRON NAME\r\ntotal,INVOICE TOTAL\r\ncreditcards_total,CREDIT CARD AMOUNT,total:sum;number:yes;align:right;','date'),(60,'106',2,'Credit Card Report','Credit Card Receipts on Accounts','SELECT\r\n `dcash`.`date`\r\n , `tillclients`.`code`\r\n , `tillclients`.`name`\r\n , `accounts`.`credit`\r\n , `accounts`.`transaction_type`\r\n , `accounts`.`description`\r\nFROM\r\n `dcash`\r\n INNER JOIN `accounts` \r\n ON (`dcash`.`date` = `accounts`.`date`)\r\n INNER JOIN `tillclients` \r\n ON (`accounts`.`entityid` = `tillclients`.`id`)\r\n WHERE account = 1 AND transaction_type = \'Card\' AND accounts.`credit` > 0\r\n AND dcash.date >= \'[sdate]\' AND dcash.date <= \'[edate]\';\r\n','OAKDALE - REPORTS','sdate,date,Start Date\r\nedate,date,End Date','date,CASHUP DATE\r\ncode,MEMBER CODE\r\nname,MEMBER NAME\r\ncredit,CREDIT CARD AMOUNT,total:sum;number:yes;align:right;\r\ndescription,DESCRIPTION','date'),(59,'106',2,'Cash Flow Report','Per Debtors/Creditors','(SELECT\r\n\r\n tillclients.name,\r\n\r\n tillclients.code,\r\n tillclients.note,\r\n\r\n tillclients.shop_id,\r\n\r\n accounts.date,\r\n\r\n accounts.tillinvoice_id,\r\n\r\n accounts.document,\r\n\r\n accounts.description,\r\n\r\n ROUND (accounts.credit,2) AS credit\r\n\r\nFROM\r\n\r\n accounts,\r\n\r\n tillclients\r\n\r\nWHERE\r\n\r\n accounts.account = 1 AND\r\n\r\n accounts.transaction_type = \'Cash\' AND\r\n\r\n accounts.credit > 0 AND\r\n\r\n (accounts.date >= \'[sdate]\' AND accounts.date <= \'[edate]\') AND\r\n\r\n tillclients.id = accounts.entityid\r\n\r\nORDER BY accounts.account)\r\n\r\nUNION ALL\r\n\r\n(SELECT\r\n\r\n suppliers.name,\r\n\r\n suppliers.code,\r\n suppliers.notes AS note,\r\n suppliers.shop_id,\r\n\r\n accounts.date,\r\n\r\n accounts.tillinvoice_id,\r\n\r\n accounts.document,\r\n\r\n accounts.description,\r\n\r\n ROUND (accounts.credit,2) AS credit\r\n\r\nFROM\r\n\r\n accounts,\r\n\r\n suppliers\r\n\r\nWHERE\r\n\r\n accounts.account = 2 AND\r\n\r\n accounts.transaction_type = \'Cash\' AND\r\n\r\n accounts.credit > 0 AND\r\n\r\n (accounts.date >= \'[sdate]\' AND accounts.date <= \'[edate]\') AND\r\n\r\n suppliers.id = accounts.entityid\r\n\r\nORDER BY accounts.account)\r\n\r\nUNION ALL\r\n\r\n(SELECT\r\n\r\n tillclients.name,\r\n\r\n tillclients.code,\r\ntillclients.note,\r\n\r\n tillclients.shop_id,\r\n\r\n accounts.date,\r\n\r\n accounts.tillinvoice_id,\r\n\r\n accounts.document,\r\n\r\n accounts.description,\r\n\r\n ROUND (accounts.debit * -1,2) AS credit\r\n\r\nFROM\r\n\r\n accounts,\r\n\r\n tillclients\r\n\r\nWHERE\r\n\r\n accounts.account = 1 AND\r\n\r\n accounts.transaction_type = \'Cash\' AND\r\n\r\n accounts.debit > 0 AND\r\n\r\n (accounts.date >= \'[sdate]\' AND accounts.date <= \'[edate]\') AND\r\n\r\n tillclients.id = accounts.entityid\r\n\r\nORDER BY accounts.account)\r\n\r\nUNION ALL\r\n\r\n(SELECT\r\n\r\n suppliers.name,\r\n\r\n suppliers.code,\r\n suppliers.notes AS note,\r\n\r\n suppliers.shop_id,\r\n\r\n accounts.date,\r\n\r\n accounts.tillinvoice_id,\r\n\r\n accounts.document,\r\n\r\n accounts.description,\r\n\r\n ROUND(accounts.debit * -1,2) AS credit\r\n\r\nFROM\r\n\r\n accounts,\r\n\r\n suppliers\r\n\r\nWHERE\r\n\r\n accounts.account = 2 AND\r\n\r\n accounts.transaction_type = \'Cash\' AND\r\n\r\n accounts.debit > 0 AND\r\n\r\n (accounts.date >= \'[sdate]\' AND accounts.date <= \'[edate]\') AND\r\n\r\n suppliers.id = accounts.entityid\r\n\r\nORDER BY accounts.account);','OAKDALE - REPORTS','sdate,date,Start Date\r\nedate,date,End Date','date,CASHUP DATE\r\nnote,ACCOUNT TYPE\r\nname,ACCOUNT NAME\r\ncode,ACCOUNT CODE\r\ntillinvoice_id,INVOICE ID\r\ndocument,DOCUMENT REFERENCE\r\ndescription,DOCUMENT DESCRIPTION\r\ncredit,CASH DEPOSITS/ (CASH WITHDRAWALS),align:right;total:sum;','note'),(88,'15',2,'Customer Age Analysis','Sorted by Name','SELECT\r\n `code`\r\n , `name`\r\n , `address`\r\n , `email`\r\n , `cellphone`\r\n , `b_current`\r\n , `b_30`\r\n , `b_60`\r\n , `b_90`\r\n , `b_120`\r\n , `b_120plus`\r\nFROM\r\n `oakdale_2`.`tillclients`\r\n \r\n WHERE f_status = 1\r\n AND active = 1\r\n AND `b_current` <>0.00\r\n OR `b_30` <>0.00\r\n OR `b_60` <>0.00\r\n OR `b_90` <>0.00\r\n OR `b_120` <>0.00\r\n OR `b_120plus` <>0.00\r\n AND CODE LIKE \'ASN%\'\r\n OR CODE LIKE \'A/M%\'\r\n OR CODE LIKE \'HON%\'\r\n\r\norder by name;','CUSTOMER LISTS','','code,Code\r\nname,Name\r\naddress,Address\r\nemail,Email\r\ncellphone,Cellphone\r\nb_current,Current\r\nb_30,30 Days,total:sum;number:yes;align:right;prefix:R\r\nb_60,60 Days,total:sum;number:yes;align:right;prefix:R\r\nb_90,90 Days,total:sum;number:yes;align:right;prefix:R\r\nb_120,120 Days,total:sum;number:yes;align:right;prefix:R\r\nb_120plus, 120Plus Days,total:sum;number:yes;align:right;prefix:R',''),(72,'72',2,'INVOICES - ASN MEMBERS','ALL INVOICES','SELECT\r\n `tillclients`.`name`\r\n , `tillclients`.`code`\r\n , `accounts`.`date`\r\n , `accounts`.`document`\r\n , `accounts`.`debit`\r\n , (`accounts`.`credit` * -1) as amountc\r\n , `accounts`.`description`\r\nFROM\r\n `accounts`\r\n INNER JOIN `tillclients` \r\n ON (`accounts`.`entityid` = `tillclients`.`id`)\r\n \r\nWHERE tillclients.clientgroup = \'MEMBERS\' \r\nAND description = \'INVOICE\'\r\nAND tillclients.active = 1\r\n\r\nAND accounts.date >= \'[sdate]\' AND accounts.date <= \'[edate]\';','OAKDALE - REPORTS','sdate,date,Start Date\r\nedate,date,End Date','date,Invoice Date\r\ndocument,Invoice\r\ndescription,Description\r\ndebit,Amount,align:right;total:sum;number:yes;\r\namountc,Voids,align:right;total:sum;number:yes;','name'),(73,'107a',2,'Plu Sales Report','SALES','CALL pluSalesReport (\"[sdate]\", \"[edate]\");','OAKDALE - REPORTS','sdate,date,Start Date\r\nedate,date,End Date','shopid,SHOP ID\r\ncategoryName,PLU Category\r\nplu,PLU Number\r\ndescription,PLU Description\r\nqty,QTY Sold\r\nselling_price_incl,Price(Incl),number:yes;align:right;\r\ndiscount,Discount,total:sum;number:yes;align:right;\r\nnet_sales_incl,NET Sales(Incl),total:sum;number:yes;align:right;\r\ntotal_sales_incl,NET T/O(Incl.),total:sum;number:yes;align:right;\r\ntotal_net_sales_excl,Net T/O (Excl.),total:sum;number:yes;align:right;\r\nunit_cost_excl,PLU Cost(Excl.),number:yes;align:right;\r\ngross_profit,Gross Proft(%),total:avg;number:yes;align:right;',''),(74,'72',2,'INVOICES - ASSOCIATE MEMBERS','ALL INVOICES','SELECT\r\n `tillclients`.`name`\r\n , `tillclients`.`code`\r\n , `accounts`.`date`\r\n , `accounts`.`document`\r\n , `accounts`.`debit`\r\n , (`accounts`.`credit` * -1) as amountc\r\n , `accounts`.`description`\r\nFROM\r\n `oakdale_1`.`accounts`\r\n INNER JOIN `oakdale_1`.`tillclients` \r\n ON (`accounts`.`entityid` = `tillclients`.`id`)\r\n \r\nWHERE clientgroup = \'ASSOCIATE MEMBERS\' AND description = \'INVOICE\'\r\nOR description = \'VOID\' AND clientgroup = \'MEMBERS\'\r\nAND accounts.date >= \'[sdate]\' AND accounts.date <= \'[edate]\';','OAKDALE - REPORTS','sdate,date,Start Date\r\nedate,date,End Date','date,Invoice Date\r\ndocument,Invoice\r\ndescription,Description\r\ndebit,Amount,align:right;total:sum;number:yes;\r\namountc,Voids,align:right;total:sum;number:yes;','name'),(75,'72',2,'INVOICES - STAFF','ALL INVOICES','SELECT\r\n `tillclients`.`name`\r\n , `tillclients`.`code`\r\n , `accounts`.`date`\r\n , `accounts`.`document`\r\n , `accounts`.`debit`\r\n , (`accounts`.`credit` * -1) as amountc\r\n , `accounts`.`description`\r\nFROM\r\n `accounts`\r\n INNER JOIN `tillclients` \r\n ON (`accounts`.`entityid` = `tillclients`.`id`)\r\n \r\nWHERE clientgroup = \'STAFF\' AND description = \'INVOICE\'\r\nOR description = \'VOID\' AND clientgroup = \'MEMBERS\'\r\nAND accounts.date >= \'[sdate]\' AND accounts.date <= \'[edate]\';','OAKDALE - REPORTS','sdate,date,Start Date\r\nedate,date,End Date','date,Invoice Date\r\ndocument,Invoice\r\ndescription,Description\r\ndebit,Amount,align:right;total:sum;number:yes;\r\namountc,Voids,align:right;total:sum;number:yes;','name'),(76,'72',2,'INVOICES - ASN MEMBERS','BAR INVOICES','SELECT\r\n `tillclients`.`name`\r\n , `tillclients`.`code`\r\n , `accounts`.`date`\r\n , `accounts`.`document`\r\n , `accounts`.`debit`\r\n , (`accounts`.`credit` * -1) as amountc\r\n , `accounts`.`description`\r\nFROM\r\n `accounts`\r\n INNER JOIN `tillclients` \r\n ON (`accounts`.`entityid` = `tillclients`.`id`)\r\n \r\nWHERE clientgroup = \'MEMBERS\' AND description = \'INVOICE\'\r\nAND accounts.debit < 1100\r\nAND accounts.credit >= 0\r\nOR description = \'VOID\' AND clientgroup = \'MEMBERS\'\r\nAND accounts.date >= \'[sdate]\' AND accounts.date <= \'[edate]\';','OAKDALE - REPORTS','sdate,date,Start Date\r\nedate,date,End Date','date,Invoice Date\r\ndocument,Invoice\r\ndescription,Description\r\ndebit,Amount,align:right;total:sum;number:yes;\r\namountc,Voids,align:right;total:sum;number:yes;','name'),(77,'72',2,'INVOICES - ASSOCIATE MEMBERS','BAR INVOICES','SELECT\r\n `tillclients`.`name`\r\n , `tillclients`.`code`\r\n , `accounts`.`date`\r\n , `accounts`.`document`\r\n , `accounts`.`debit`\r\n , `accounts`.`credit`\r\n , (`accounts`.`credit` * -1) as amountc\r\n , `accounts`.`description`\r\nFROM\r\n `oakdale_1`.`accounts`\r\n INNER JOIN `oakdale_1`.`tillclients` \r\n ON (`accounts`.`entityid` = `tillclients`.`id`)\r\n \r\nWHERE clientgroup = \'ASSOCIATE MEMBERS\' AND description = \'INVOICE\'\r\nOR description = \'VOID\' AND clientgroup = \'ASSOCIATE MEMBERS\'\r\nAND accounts.debit < 1100\r\nAND accounts.credit >= 0\r\nAND accounts.date >= \'[sdate]\' AND accounts.date <= \'[edate]\';','OAKDALE - REPORTS','sdate,date,Start Date\r\nedate,date,End Date','date,Invoice Date\r\ndocument,Invoice\r\ndescription,Description\r\ndebit,Amount,align:right;total:sum;number:yes;\r\namountc,Voids,align:right;total:sum;number:yes;','name'),(78,'72',2,'INVOICES - STAFF','BAR INVOICES','SELECT\r\n `tillclients`.`name`\r\n , `tillclients`.`code`\r\n , `accounts`.`date`\r\n , `accounts`.`document`\r\n , `accounts`.`debit`\r\n , (`accounts`.`credit` * -1) as amountc\r\n , `accounts`.`description`\r\nFROM\r\n `oakdale_1`.`accounts`\r\n INNER JOIN `oakdale_1`.`tillclients` \r\n ON (`accounts`.`entityid` = `tillclients`.`id`)\r\n \r\nWHERE clientgroup = \'STAFF\' AND description = \'INVOICE\'\r\nAND accounts.debit < 1100\r\nAND accounts.credit >= 0\r\nOR description = \'VOID\' AND clientgroup = \'STAFF\'\r\nAND accounts.date >= \'[sdate]\' AND accounts.date <= \'[edate]\';','OAKDALE - REPORTS','sdate,date,Start Date\r\nedate,date,End Date','date,Invoice Date\r\ndocument,Invoice\r\ndescription,Description\r\ndebit,Amount,align:right;total:sum;number:yes;\r\namountc,Voids,align:right;total:sum;number:yes;','name'),(79,'79',2,'FUNCTION CONTROLE','PAYMENTS RECEIVED IN ADVANCE','SELECT\r\n `accounts`.`id` AS tran\r\n , `tillclients`.`name`\r\n , `tillclients`.`code`\r\n , `accounts`.`document`\r\n , `accounts`.`description`\r\n , `accounts`.`debit`\r\n , `accounts`.`credit`\r\n , `accounts`.`date`\r\n , `accounts`.`stamp`\r\n , `accounts`.`runningdebit`\r\n , `accounts`.`runningcredit`\r\n , (`accounts`.`runningdebit` - `accounts`.`runningcredit`) AS bal\r\nFROM\r\n `oakdale_1`.`accounts`\r\n INNER JOIN `oakdale_1`.`tillclients` \r\n ON (`accounts`.`entityid` = `tillclients`.`id`)\r\n \r\n WHERE clientgroup = \'FUNCTION/EVENTS\'\r\n\r\nAND accounts.date >= \'[sdate]\' AND accounts.date <= \'[edate]\';\r\n','OAKDALE - REPORTS','sdate,date,Start Date\r\nedate,date,End Date','tran,DB Id\r\nstamp,Date\r\ndocument,Document Ref\r\ndescription,Details\r\ndebit,Amount,number:yes;align:right;total:sum;\r\ncredit,Receipt,number:yes;align:right;total:sum;\r\nbal,Balance,number:yes;align:right;\r\n','name'),(80,'80',2,'CASH REPORT','Cash Payments','SELECT\r\n `accounts`.`date`\r\n , `suppliers`.`name`\r\n , `accounts`.`debit`\r\n , `accounts`.`credit`\r\n , `accounts`.`document`\r\nFROM\r\n `oakdale_1`.`accounts`\r\n INNER JOIN `oakdale_1`.`suppliers` \r\n ON (`accounts`.`entityid` = `suppliers`.`id`)\r\n \r\n WHERE account = 2 \r\n AND DATE >= \'2018-03-01\' \r\n AND transaction_type = \'Cash\'\r\n\r\nAND accounts.date >= \'[sdate]\' AND accounts.date <= \'[edate]\';','OAKDALE - REPORTS','sdate,date,Start Date\r\nedate,date,End Date','date,Invoice Date\r\nname,Supplier Name;\r\ndebit,Debit,number:yes;align:right;total:sum;\r\ncredit,Credit,number:yes;align:right;total:sum;\r\ndocument,Description','name'),(81,'21',2,'Loyalty Customer - SELECT','LOYALTY Customer + Points (SPECIFY Name)','select tc.clientgroup,tc.name,tc.loyalnumber,tc.cellphone,tc.email,tcl.stamp,\r\r\r\r\ntcl.points,tcl.running_points,tc.b_current\r\r\r\r\n\r\r\r\r\nFROM tillclients tc, tillclients_loyalty_points tcl\r\r\r\r\n\r\r\r\r\nWHERE tc.id = tcl.customer_id\r\r\r\r\n\r\r\r\r\nAND\r\r\r\r\n\r\r\r\r\ntcl.stamp >= \'[sdate]\' AND tcl.stamp <= \'[edate]\'\r\r\r\r\n\r\r\r\r\nAND\r\r\r\r\ntc.name = \'[lmember]\';','LOYALTY REPORTS','sdate,date,Start Date\r\r\r\r\nedate,date,End Date\r\r\r\r\nlmember,dropdown,Loyalty Member','clientgroup,Group\r\r\r\r\nname,Name\r\r\r\r\nloyalnumber,Loyalty Card\r\r\r\r\ncellphone,Cellphone\r\r\r\r\nemail,Email\r\r\r\r\nstamp,Transaction Date\r\r\r\r\npoints,Transaction Points\r\r\r\r\nrunning_points,Cumm. Loyalty Points\r\r\r\r\nb_current,Voucher Balance - Current\r\r\r\r\n\r\r\r\r\n',''),(82,'20',2,'Loyalty Customers - ALL','LOYALTY Customers + Points','select tc.clientgroup,tc.name,tc.loyalnumber,tc.cellphone,tc.email,tcl.stamp,\r\r\r\r\ntcl.points,tcl.running_points,tc.b_current\r\r\r\r\n\r\r\r\r\nFROM tillclients tc, tillclients_loyalty_points tcl\r\r\r\r\n\r\r\r\r\nWHERE tc.id = tcl.customer_id\r\r\r\r\n\r\r\r\r\nAND\r\r\r\r\n\r\r\r\r\ntcl.stamp >= \'[sdate]\' AND tcl.stamp <= \'[edate]\';','LOYALTY REPORTS','sdate,date,Start Date\r\r\r\r\nedate,date,End Date\r\r\r\r\n','clientgroup,Group\r\r\r\r\nname,Name\r\r\r\r\nloyalnumber,Loyalty Card\r\r\r\r\ncellphone,Cellphone\r\r\r\r\nemail,Email\r\r\r\r\nstamp,Transaction Date\r\r\r\r\npoints,Transaction Points\r\r\r\r\nrunning_points,Cumm. Loyalty Points\r\r\r\r\nb_current,Voucher Balance - Current\r\r\r\r\n',''),(83,'83',2,'Beverage Inventory','Shows link between Inventory Item / Ingredient with Average Price and Last date purchased','SELECT\r\n stockitems.id,\r\n stockitems.type AS \'Cost Center\',\r\n stockitems.name AS \'Inventory Item\',\r\n ritems.name AS \'Ingredient\',\r\n ritems.avgprice AS \'Avg Price\',\r\n IFNULL(ritems.lastpricedate, \'Never Purchased\') AS \'Purchase Date\',\r\n stockitems.f_status AS \'Status\'\r\nFROM\r\n stockitems\r\n LEFT JOIN ritems\r\n ON stockitems.id = ritems.stockitems_id\r\n \r\nWHERE stockitems.type = 1\r\nAND ritems.lastpricedate >= \'[sdate]\' AND ritems.lastpricedate <= \'[edate]\'\r\nORDER BY stockitems.id ASC;\r\n','Tests','sdate,date,Start Date\r\nedate,date,End Date','id,ID\r\nCost Center,Cost Center\r\nInventory Item,Inventory Item\r\nIngredient,Ingredient\r\nAvg Price,Avg Price\r\nPurchase Date,Purchase Date\r\nStatus,Status',''),(84,'15',2,'Customer Age Analysis','Sorted by Name','SELECT\r\n `code`\r\n , `name`\r\n , `address`\r\n , `email`\r\n , `cellphone`\r\n , `b_current`\r\n , `b_30`\r\n , `b_60`\r\n , `b_90`\r\n , `b_120`\r\n , `b_120plus`\r\nFROM\r\n `oakdale_2`.`tillclients`\r\n \r\n WHERE f_status = 1\r\n AND active = 1\r\n AND CODE LIKE \'ASN%\'\r\n OR CODE LIKE \'A/M%\'\r\n OR CODE LIKE \'HON%\'\r\n\r\norder by name;','CUSTOMER LISTS','','code,Code\r\nname,Name\r\naddress,Address\r\nemail,Email\r\ncellphone,Cellphone\r\nb_current,Current\r\nb_30,30 Days,total:sum;number:yes;align:right;prefix:R\r\nb_60,60 Days,total:sum;number:yes;align:right;prefix:R\r\nb_90,90 Days,total:sum;number:yes;align:right;prefix:R\r\nb_120,120 Days,total:sum;number:yes;align:right;prefix:R\r\nb_120plus, 120Plus Days,total:sum;number:yes;align:right;prefix:R',''),(85,'15',2,'Customer Age Analysis','Sorted by Code','SELECT\r\n `code`\r\n , `name`\r\n , `address`\r\n , `email`\r\n , `cellphone`\r\n , `b_current`\r\n , `b_30`\r\n , `b_60`\r\n , `b_90`\r\n , `b_120`\r\n , `b_120plus`\r\nFROM\r\n `tillclients`\r\n \r\n WHERE f_status = 1\r\n AND active = 1\r\n AND CODE LIKE \'ASN%\'\r\n OR CODE LIKE \'A/M%\'\r\n OR CODE LIKE \'HON%\'\r\n\r\norder by code;','CUSTOMER LISTS','','code,Code\r\nname,Name\r\naddress,Address\r\nemail,Email\r\ncellphone,Cellphone\r\nb_current,Current,total:sum;number:yes;align:right;prefix:R\r\nb_30,30 Days,total:sum;number:yes;align:right;prefix:R\r\nb_60,60 Days,total:sum;number:yes;align:right;prefix:R\r\nb_90,90 Days,total:sum;number:yes;align:right;prefix:R\r\nb_120,120 Days,total:sum;number:yes;align:right;prefix:R\r\nb_120plus, 120Plus Days,total:sum;number:yes;align:right;prefix:R',''),(86,'15',2,'Events Age Analysis','Sorted by Code','SELECT\r\n `code`\r\n , `name`\r\n , `address`\r\n , `email`\r\n , `cellphone`\r\n , `b_current`\r\n , `b_30`\r\n , `b_60`\r\n , `b_90`\r\n , `b_120`\r\n , `b_120plus`\r\n\r\nFROM\r\n `tillclients`\r\n \r\n WHERE f_status = 1\r\n AND active = 1\r\n AND clientgroup like \'FUNCTIONS/EVENTS\'\r\n\r\n\r\norder by code;','CUSTOMER LISTS','','code,Code\r\nname,Name\r\naddress,Address\r\nemail,Email\r\ncellphone,Cellphone\r\nb_current,Current,total:sum;number:yes;align:right;prefix:R\r\nb_30,30 Days,total:sum;number:yes;align:right;prefix:R\r\nb_60,60 Days,total:sum;number:yes;align:right;prefix:R\r\nb_90,90 Days,total:sum;number:yes;align:right;prefix:R\r\nb_120,120 Days,total:sum;number:yes;align:right;prefix:R\r\nb_120plus, 120Plus Days,total:sum;number:yes;align:right;prefix:R',''),(92,'15',2,'Staff Age Analysis','Sorted by Code','SELECT\r\n `code`\r\n , `name`\r\n , `address`\r\n , `email`\r\n , `cellphone`\r\n , `b_current`\r\n , `b_30`\r\n , `b_60`\r\n , `b_90`\r\n , `b_120`\r\n , `b_120plus`\r\n\r\nFROM\r\n `tillclients`\r\n \r\n WHERE f_status = 1\r\n AND active = 1\r\n AND clientgroup like \'staff\'\r\n\r\n\r\norder by code;','CUSTOMER LISTS','','code,Code\r\nname,Name\r\naddress,Address\r\nemail,Email\r\ncellphone,Cellphone\r\nDeb,Total,total:sum;number:yes;align:right;prefix:R\r\nb_current,Current,total:sum;number:yes;align:right;prefix:R\r\nb_30,30 Days,total:sum;number:yes;align:right;prefix:R\r\nb_60,60 Days,total:sum;number:yes;align:right;prefix:R\r\nb_90,90 Days,total:sum;number:yes;align:right;prefix:R\r\nb_120,120 Days,total:sum;number:yes;align:right;prefix:R\r\nb_120plus, 120Plus Days,total:sum;number:yes;align:right;prefix:R',''),(91,'15',2,'All Client Age Analysis','Sorted by Code','SELECT\r\n `code`\r\n , `name`\r\n , `address`\r\n , `email`\r\n , `cellphone`\r\n , `b_current`\r\n , `b_30`\r\n , `b_60`\r\n , `b_90`\r\n , `b_120`\r\n , `b_120plus`\r\n\r\nFROM\r\n `tillclients`\r\n \r\n WHERE f_status = 1\r\n AND active = 1\r\n\r\n\r\n\r\norder by code;','CUSTOMER LISTS','','code,Code\r\nname,Name\r\naddress,Address\r\nemail,Email\r\ncellphone,Cellphone\r\nDeb,Total,total:sum;number:yes;align:right;prefix:R\r\nb_current,Current,total:sum;number:yes;align:right;prefix:R\r\nb_30,30 Days,total:sum;number:yes;align:right;prefix:R\r\nb_60,60 Days,total:sum;number:yes;align:right;prefix:R\r\nb_90,90 Days,total:sum;number:yes;align:right;prefix:R\r\nb_120,120 Days,total:sum;number:yes;align:right;prefix:R\r\nb_120plus, 120Plus Days,total:sum;number:yes;align:right;prefix:R',''),(87,'103a',2,'Cashup - Summarised','Turnover Cashup Report','CALL turnoverReport(\"[sdate]\", \"[edate]\");','Month End Reports','sdate,date,Start Date\r\nedate,date,End Date','shopid,SHOP ID\r\ndcashid,DCASH ID\r\ndcashdateT,CASHUP DATE,total:count;align:center;\r\ncovers_total,COVERS,total:sum;align:center;\r\navgnet,A.H.S,total:avg;number:yes;\r\ngrossto,GROSS T/O,total:sum;number:yes;align:right;\r\ns_fee_retained,RETAINED COMMS,total:sum;number:yes;align:right;\r\ns_fee,COMMS,total:sum;number:yes;align:right;\r\nnettoexc,NET T/O(excl.),total:sum;number:yes;align:right;\r\nvat_total,VAT,total:sum;number:yes;align:right;\r\nstaff_promo,STAFF PROMOS,total:sum;number:yes;align:right;\r\npromo_total,PROMO/DISC,total:sum;number:yes;align:right;\r\nreturns_total, RETURNS,total:sum;number:yes;align:right;\r\naccounts_total, REC. ACCOUNTS,total:sum;number:yes;align:right;\r\neft_total,REC. EFT,total:sum;number:yes;align:right;\r\ncreditcard_total,REC. CREDIT CARDS,total:sum;number:yes;align:right;\r\ncheque_total,REC. CHECQUE,total:sum;number:yes;align:right;\r\ncash,REC. CASH,total:sum;number:yes;align:right;\r\ngrosscash,GROSS CASH,total:sum;number:yes;align:right;\r\npettycash,PETTY CASH,total:sum;number:yes;align:right;\r\ndeposits,DEPOSITS/ WITHDRAWELS,total:sum;number:yes;align:right;\r\ntotalbanked,TOTAL BANKED,total:sum;number:yes;align:right;\r\nBEVERAGES,BEVERAGES,total:sum;number:yes;align:right;\r\nFOOD,FOOD,total:sum;number:yes;align:right;\r\nOtherSalesVenueHire,Venue Rentals,total:sum;number:yes;align:right;\r\nSectionSalesGGRGrandSlots,Slots,total:sum;number:yes;align:right;\r\nOtherIncomeRentalMemberFees,Other Income,total:sum;number:yes;align:right;','db_profile_name'),(89,'89',2,'Beverages Stock value','Stock Value','SELECT\r\n `cstock`.`stockitems_id`\r\n , `stockitems`.`id`\r\n , `stockitems`.`type`\r\n , `stockitems`.`name`\r\n , `cstock`.`qty`\r\n , `cstock`.`value`\r\n , `cstock`.`date`\r\nFROM\r\n `oakdaleclub_1`.`cstock`\r\n INNER JOIN `oakdaleclub_1`.`stockitems` \r\n ON (`cstock`.`stockitems_id` = `stockitems`.`id`)\r\n WHERE cstock.`f_status` = 1\r\n AND stockitems.`type` = 1;','Tests','','name,Stock Name\r\nqty,QTY\r\nvalue,Value,total:sum;align:right;number:yes','date'),(90,'89',2,'Food Stock value','Stock Value','SELECT\r\n `cstock`.`stockitems_id`\r\n , `stockitems`.`id`\r\n , `stockitems`.`type`\r\n , `stockitems`.`name`\r\n , `cstock`.`qty`\r\n , `cstock`.`value`\r\n , `cstock`.`date`\r\nFROM\r\n `oakdaleclub_1`.`cstock`\r\n INNER JOIN `oakdaleclub_1`.`stockitems` \r\n ON (`cstock`.`stockitems_id` = `stockitems`.`id`)\r\n WHERE cstock.`f_status` = 1\r\n AND stockitems.`type` = 2;','Tests','','name,Stock Name\r\nqty,QTY\r\nvalue,Value,total:sum;align:right;number:yes','date'),(93,'15',2,'All Creditors Age Analysis','Sorted by Code','SELECT\r\n `code`\r\n , `name`\r\n , `address`\r\n , `email`\r\n , `b_current`\r\n , `b_30`\r\n , `b_60`\r\n , `b_90`\r\n , `b_120`\r\n , `b_120plus`\r\n\r\nFROM\r\n `suppliers`\r\n \r\n WHERE f_status = 1\r\n AND active = 1\r\n AND me = 2\r\n\r\norder by code;','CREDITORS LISTS','','code,Code\r\nname,Name\r\naddress,Address\r\nemail,Email\r\nDeb,Total,total:sum;number:yes;align:right;prefix:R\r\nb_current,Current,total:sum;number:yes;align:right;prefix:R\r\nb_30,30 Days,total:sum;number:yes;align:right;prefix:R\r\nb_60,60 Days,total:sum;number:yes;align:right;prefix:R\r\nb_90,90 Days,total:sum;number:yes;align:right;prefix:R\r\nb_120,120 Days,total:sum;number:yes;align:right;prefix:R\r\nb_120plus, 120Plus Days,total:sum;number:yes;align:right;prefix:R',''),(94,'94',2,'Purchases','Purchases','SELECT\r\n `purchases`.`date` AS podate\r\n , `purchases`.`type`\r\n , `stockitems`.`type`\r\n , `purchases`.`cnote`\r\n , `purchases`.`f_status`\r\n , `purchases`.`othertype`\r\n , `accounts`.`date` AS del\r\n , `suppliers`.`code` AS ven\r\n , `suppliers`.`name` AS venname\r\n , `purchases`.`invoice` AS ponum\r\n , `stocktypes`.`name` AS type\r\n , `stockitems`.`name` AS stockname\r\n , `stockitems`.`units` AS units\r\n , `purchases`.`qty` AS qty\r\n , `purchases`.`price` AS price\r\n , (`purchases`.`vat`* `purchases`.`qty` * `purchases`.`price` * 15/115) AS vat\r\n , `purchases`.`vat` AS TaxType\r\nFROM\r\n `oakdaleclub_1`.`purchases`\r\n INNER JOIN `oakdaleclub_1`.`suppliers` \r\n ON (`purchases`.`supplier_id` = `suppliers`.`id`)\r\n INNER JOIN `oakdaleclub_1`.`stockitems` \r\n ON (`purchases`.`stockitems_id` = `stockitems`.`id`)\r\n INNER JOIN `oakdaleclub_1`.`accounts` \r\n ON (`suppliers`.`id` = `accounts`.`entityid`)\r\n INNER JOIN `oakdaleclub_1`.`stocktypes` \r\n ON (`stockitems`.`type` = `stocktypes`.`id`)\r\nWHERE purchases.type >= 1\r\nAND stockitems.type >= 1\r\nAND cnote = 0\r\nAND purchases.f_status < 101\r\nAND othertype = 0\r\nAND purchases.date >= \'[sdate]\' AND purchases.date <= \'[edate]\'\r\norder by stockname;\r\n','Tests','sdate,date,Start Date\r\nedate,date,End Date','podate,Date\r\ndel,Delivery Date\r\nven,Vendor\r\nvenname,Vendor Name\r\nponum,P/O Number\r\ntype,Cost Centre\r\nstockname,Inventory Description\r\nunits,UOM\r\nqty,Quantity\r\nprice,Amount\r\nvat,Tax\r\nTaxType,Tax Type\r\n',''),(95,'S01',2,'COS INVOICES FOR PERIOD','COS All Invoices','SELECT\r\n\r\n `purchases`.`id`\r\n , `purchases`.`date`\r\n , `suppliers`.`code`\r\n , `suppliers`.`name` AS sname\r\n , `purchases`.`invoice`\r\n , `purchases`.`vat` AS rate\r\n , `purchases`.`discount`\r\n , `purchases`.`org_qty` AS pqty\r\n , ROUND(`purchases`.`price`,2) AS price\r\n , ROUND((`purchases`.`org_qty`*price),2)AS `gross`\r\n , `purchases`.`org_qty`*`purchases`.`discount` AS discount\r\n , ROUND((`purchases`.`org_qty`*price)-(`purchases`.`org_qty`*discount),2) AS `amount`\r\n , ROUND(((`purchases`.`org_qty`*price)-(`purchases`.`org_qty`*discount))*`purchases`.`vat`*.15,2) AS vat\r\n , ROUND((((`purchases`.`org_qty`*price)-(`purchases`.`org_qty`*discount))+((`purchases`.`org_qty`*price)-(`purchases`.`org_qty`*discount))*`purchases`.`vat`*.15),2) AS inclusive\r\n , `stockitems`.`units`\r\n , `stockitems`.`sku`\r\n , `stockitems`.`name`\r\n , `stockitems`.`type`\r\n , `stockitems`.`vat`\r\n , `stocktypes`.`name` AS stname\r\n\r\nFROM\r\n `purchases`\r\n INNER JOIN `suppliers` \r\n ON (`purchases`.`supplier_id` = `suppliers`.`id`)\r\n INNER JOIN `stockitems` \r\n ON (`purchases`.`stockitems_id` = `stockitems`.`id`)\r\n INNER JOIN `stocktypes`\r\n ON (`stocktypes`.`id` = `stockitems`.`type`)\r\n\r\nWHERE purchases.type >= 1\r\nAND stockitems.type >= 1\r\nAND cnote = 0\r\nAND purchases.f_status < 101\r\nAND othertype = 0\r\nAND`stockitems`.`units` >= 1\r\nAND purchases.date >= \'[sdate]\' AND purchases.date <= \'[edate]\';','Tests','sdate,date,Start Date\r\nedate,date,End Date','date,Invoice Date,\r\ncode,Vendor Code\r\nsname,Vendor Name,\r\ninvoice,Reference,\r\nstname,Cost Center,\r\nsku,Inventory Code\r\nname,Product Name,\r\nunits,UOM\r\npqty,QTY,align:right,\r\nprice,Price,align:right,\r\ngross,Amount,total:sum;number:yes;align:right,\r\nvat,Vat Input,total:sum;align:right,\r\nvat,Tax Type\r\n','sname'),(96,'96',2,'APH SALES','AVERAGE PER INVOICE AND HEAD SPEND','SELECT \r\n dci.date AS \'date\',\r\n w.`name` AS \'user\',\r\n COUNT(dci.tillinvoices_id) AS \'invoices\',\r\n SUM(dci.`dcinv_turnover_total`) AS \'turnover\',\r\n SUM(dci.`dcinv_turnover_total`)/COUNT(dci.`tillinvoices_id`) AS \"average\",\r\n SUM(dci.covers) AS \'covers\',\r\n SUM(dci.`dcinv_turnover_total`)/SUM(dci.`covers`) AS \"AHS\"\r\n \r\nFROM dcashinvoices dci\r\nJOIN tillinvoices ti ON dci.`tillinvoices_id` = ti.`id`\r\nJOIN waitron w ON w.id = ti.`waitron_id`\r\n\r\nWHERE dci.`f_status` = 1 and dci.date >= \'[sdate]\' AND dci.date <= \'[edate]\'\r\n\r\nGROUP BY w.name, dci.date\r\n\r\nORDER BY average desc ;','Tests','sdate,date,Start Date\r\nedate,date,End Date','date,Date\r\nuser,User\r\ninvoices,Invoice Count\r\nturnover,Total Turnover\r\naverage,Invoice Average\r\ncovers,Covers\r\nAHS,AHS','date'),(97,'43',2,'Bowls sales','PLU Sales per Bowls','SELECT\r\n `terminals`.`location`\r\n , `tillordersdetails`.`name`\r\n , `tillordersdetails`.`plu`\r\n , `tillordersdetails`.`qty`\r\n , `tillordersdetails`.`price`\r\n , `tillinvoices`.`voided`\r\n , ROUND((qty*price),2) AS Total\r\nFROM\r\n `oakdaleclub_1`.`tillordersdetails`\r\n INNER JOIN `oakdaleclub_1`.`tillinvoices` \r\n ON (`tillordersdetails`.`invoice` = `tillinvoices`.`id`)\r\n INNER JOIN `oakdaleclub_1`.`terminals` \r\n ON (`tillordersdetails`.`till_id` = `terminals`.`id`)\r\n \r\n WHERE plutype = 1\r\n AND voided IS NULL\r\n AND tillordersdetails.till_id = 16\r\n AND tillordersdetails.stamp >= \'[sdate]\' \r\n AND tillordersdetails.stamp <= \'[edate]\';\r\n \r\n','SALES','sdate,date,Start Date\r\nedate,date,End Date','location,Location\r\nname,PLU NAME\r\nplu,PLU Code\r\nqty,QTY SOLD\r\nprice,PRICE\r\nTotal,TOTAL,total:sum','name'),(98,'43',2,'Bar sales','PLU Sales per Non-Smokers','SELECT\r\n `terminals`.`location`\r\n , `tillordersdetails`.`name`\r\n , `tillordersdetails`.`plu`\r\n , `tillordersdetails`.`qty`\r\n , `tillordersdetails`.`price`\r\n , `tillinvoices`.`voided`\r\n , ROUND((qty*price),2) AS Total\r\nFROM\r\n `oakdaleclub_1`.`tillordersdetails`\r\n INNER JOIN `oakdaleclub_1`.`tillinvoices` \r\n ON (`tillordersdetails`.`invoice` = `tillinvoices`.`id`)\r\n INNER JOIN `oakdaleclub_1`.`terminals` \r\n ON (`tillordersdetails`.`till_id` = `terminals`.`id`)\r\n \r\n WHERE plutype = 1\r\n AND voided IS NULL\r\n AND tillordersdetails.till_id = 2\r\n AND tillordersdetails.stamp >= \'[sdate]\' \r\n AND tillordersdetails.stamp <= \'[edate]\';\r\n \r\n','SALES','sdate,date,Start Date\r\nedate,date,End Date','location,Location\r\nname,PLU NAME\r\nplu,PLU Code\r\nqty,QTY SOLD,total:sum;\r\nprice,PRICE\r\nTotal,TOTAL,total:sum','name'),(99,'43',2,'Bar sales','PLU Sales per Smokers','SELECT\r\n `terminals`.`location`\r\n , `tillordersdetails`.`name`\r\n , `tillordersdetails`.`plu`\r\n , `tillordersdetails`.`qty`\r\n , `tillordersdetails`.`price`\r\n , `tillinvoices`.`voided`\r\n , ROUND((qty*price),2) AS Total\r\nFROM\r\n `oakdaleclub_1`.`tillordersdetails`\r\n INNER JOIN `oakdaleclub_1`.`tillinvoices` \r\n ON (`tillordersdetails`.`invoice` = `tillinvoices`.`id`)\r\n INNER JOIN `oakdaleclub_1`.`terminals` \r\n ON (`tillordersdetails`.`till_id` = `terminals`.`id`)\r\n \r\n WHERE plutype = 1\r\n AND voided IS NULL\r\n AND tillordersdetails.till_id = 5\r\n AND tillordersdetails.stamp >= \'[sdate]\' \r\n AND tillordersdetails.stamp <= \'[edate]\';\r\n \r\n','SALES','sdate,date,Start Date\r\nedate,date,End Date','location,Location\r\nname,PLU NAME\r\nplu,PLU Code\r\nqty,QTY SOLD,total:sum;\r\nprice,PRICE\r\nTotal,TOTAL,total:sum','name'); /*Table structure for table `res_bookings` */ DROP TABLE IF EXISTS `res_bookings`; CREATE TABLE `res_bookings` ( `booking_id` bigint(20) unsigned NOT NULL, `user_id` int(10) NOT NULL DEFAULT '0', `room_id` int(10) unsigned NOT NULL, `rates` decimal(6,2) NOT NULL DEFAULT '0.00', `fees` decimal(6,2) NOT NULL DEFAULT '0.00', `fees_descr` varchar(1024) NOT NULL DEFAULT '', `discount` decimal(6,2) NOT NULL DEFAULT '0.00', `discount_descr` varchar(1024) NOT NULL DEFAULT '', `status` enum('new','confirmed','checkin','checkout','unavailable','canceled') NOT NULL DEFAULT 'new', `arrive_date` datetime DEFAULT NULL, `depart_date` datetime DEFAULT NULL, `checkin_time` datetime DEFAULT NULL, `adults` int(11) NOT NULL DEFAULT '0', `children` int(11) NOT NULL DEFAULT '0', `nights` int(11) NOT NULL DEFAULT '0', `special_req` varchar(512) NOT NULL DEFAULT '', `arrive_by` varchar(50) NOT NULL DEFAULT '', `arrive_time` datetime DEFAULT NULL, `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `created_by` int(10) NOT NULL DEFAULT '0', `updated` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `memo` varchar(1024) NOT NULL DEFAULT '', `payments` varchar(1024) NOT NULL DEFAULT '', `payment_status` tinyint(4) NOT NULL DEFAULT '0', PRIMARY KEY (`booking_id`), KEY `user_id` (`user_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*Data for the table `res_bookings` */ /*Table structure for table `res_creditcard` */ DROP TABLE IF EXISTS `res_creditcard`; CREATE TABLE `res_creditcard` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `cardnum` varchar(50) NOT NULL DEFAULT '', `expire` date NOT NULL DEFAULT '0000-00-00', `ccv` varchar(8) NOT NULL DEFAULT '', `cardholder` varchar(32) NOT NULL DEFAULT '', `addr` varchar(100) NOT NULL DEFAULT '', `user_id` int(10) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `user_id` (`user_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*Data for the table `res_creditcard` */ /*Table structure for table `res_fees` */ DROP TABLE IF EXISTS `res_fees`; CREATE TABLE `res_fees` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `descr` varchar(128) NOT NULL DEFAULT '', `amount` int(11) NOT NULL DEFAULT '0', `units` int(10) unsigned NOT NULL DEFAULT '1', `applytorate` int(10) unsigned NOT NULL DEFAULT '0', `sort_order` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*Data for the table `res_fees` */ /*Table structure for table `res_media` */ DROP TABLE IF EXISTS `res_media`; CREATE TABLE `res_media` ( `media_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `room_id` int(10) unsigned NOT NULL DEFAULT '0', `type_id` mediumint(8) unsigned NOT NULL DEFAULT '0', `prop_id` int(10) unsigned NOT NULL DEFAULT '0', `media_type` enum('ROOM','ROOMTYPE','PROPERTY','OTHERS') NOT NULL DEFAULT 'OTHERS', `media_name` varchar(200) NOT NULL DEFAULT '', `media_descr` varchar(200) NOT NULL DEFAULT '', `media_src` varchar(250) NOT NULL DEFAULT '', `media_spec` text NOT NULL, `media_code` varchar(12) NOT NULL DEFAULT '', `media_token` varchar(100) NOT NULL DEFAULT '', `media_ip` int(20) unsigned NOT NULL DEFAULT '0', `media_size` bigint(20) unsigned NOT NULL DEFAULT '0', `media_md5` varchar(64) NOT NULL DEFAULT '', `media_created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `media_last_download` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `media_status` enum('on','off') NOT NULL DEFAULT 'on', `media_primary` tinyint(4) NOT NULL DEFAULT '0', PRIMARY KEY (`media_id`), KEY `room_id` (`room_id`), KEY `type_id` (`type_id`), KEY `prop_id` (`prop_id`), KEY `media_token` (`media_token`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*Data for the table `res_media` */ /*Table structure for table `res_orders` */ DROP TABLE IF EXISTS `res_orders`; CREATE TABLE `res_orders` ( `id` bigint(20) unsigned NOT NULL, `user_id` int(10) NOT NULL DEFAULT '0', `session_id` varchar(512) NOT NULL DEFAULT '', `booking_id` bigint(20) unsigned NOT NULL, `status` tinyint(4) NOT NULL DEFAULT '0', `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`), KEY `session_id` (`session_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*Data for the table `res_orders` */ /*Table structure for table `res_properties` */ DROP TABLE IF EXISTS `res_properties`; CREATE TABLE `res_properties` ( `prop_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `user_id` int(10) NOT NULL DEFAULT '0', `title` varchar(200) NOT NULL DEFAULT '', `status` enum('on','off') NOT NULL DEFAULT 'on', `sort_order` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`prop_id`), KEY `user_id` (`user_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*Data for the table `res_properties` */ /*Table structure for table `res_rates_adjustment` */ DROP TABLE IF EXISTS `res_rates_adjustment`; CREATE TABLE `res_rates_adjustment` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `descr` varchar(200) NOT NULL DEFAULT '', `start_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `end_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `units` enum('percent','usd') NOT NULL DEFAULT 'usd', `direction` enum('increase','decrease','pernight') DEFAULT NULL, `amount` int(11) DEFAULT NULL, `applydays` enum('all','days') DEFAULT NULL, `daysvalue` varchar(256) NOT NULL DEFAULT '', `applytorate` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*Data for the table `res_rates_adjustment` */ /*Table structure for table `res_rates_plans` */ DROP TABLE IF EXISTS `res_rates_plans`; CREATE TABLE `res_rates_plans` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `title` varchar(128) NOT NULL DEFAULT '', `descr` varchar(512) NOT NULL DEFAULT '', `start_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `end_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `howsrate` enum('weekly','daybyday') DEFAULT NULL, `rates` varchar(4096) NOT NULL DEFAULT '', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*Data for the table `res_rates_plans` */ /*Table structure for table `res_room_type` */ DROP TABLE IF EXISTS `res_room_type`; CREATE TABLE `res_room_type` ( `type_id` mediumint(8) unsigned NOT NULL DEFAULT '0', `type_name` varchar(50) NOT NULL DEFAULT '', `sort_order` int(10) NOT NULL DEFAULT '0', `descr` text, `image` varchar(50) NOT NULL DEFAULT '', `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (`type_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*Data for the table `res_room_type` */ /*Table structure for table `res_rooms` */ DROP TABLE IF EXISTS `res_rooms`; CREATE TABLE `res_rooms` ( `room_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `prop_id` int(10) unsigned NOT NULL DEFAULT '0', `name` varchar(50) NOT NULL DEFAULT '', `unit` int(11) NOT NULL DEFAULT '0', `root_type` mediumint(8) unsigned NOT NULL DEFAULT '0', `occupancy` int(11) NOT NULL DEFAULT '1', `sort_order` int(11) NOT NULL DEFAULT '0', `max_adults` int(11) NOT NULL DEFAULT '0', `max_children` int(11) NOT NULL DEFAULT '0', `status` enum('on','off') NOT NULL DEFAULT 'on', `descr` text, `add_descr` varchar(200) NOT NULL DEFAULT '', `permission` varchar(1024) NOT NULL DEFAULT '', `rate_id` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`room_id`), KEY `prop_id` (`prop_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*Data for the table `res_rooms` */ /*Table structure for table `res_taxs` */ DROP TABLE IF EXISTS `res_taxs`; CREATE TABLE `res_taxs` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `descr` varchar(128) NOT NULL DEFAULT '', `start_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `end_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `amount` int(11) NOT NULL DEFAULT '0', `units` int(10) unsigned NOT NULL DEFAULT '1', `applytorate` int(10) unsigned NOT NULL DEFAULT '0', `sort_order` int(10) NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*Data for the table `res_taxs` */ /*Table structure for table `sessions` */ DROP TABLE IF EXISTS `sessions`; CREATE TABLE `sessions` ( `id` char(32) NOT NULL, `a_session` text NOT NULL, UNIQUE KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*Data for the table `sessions` */ insert into `sessions`(`id`,`a_session`) values ('0e3860548dffe616635e5883563c01c9','1234\0\0\0\n 0e3860548dffe616635e5883563c01c9\0\0\0_SESSION_IDÉÍàd\0\0\0_SESSION_ATIME\r\0\0\0~login-trials\0\0\0\0\0\0\0_SESSION_EXPIRE_LIST\n 127.0.0.1\0\0\0_SESSION_REMOTE_ADDR7°àd\0\0\0_SESSION_CTIME'),('147301b33b1f2ecea65d4e06b32e8303','1234\0\0\0\n 147301b33b1f2ecea65d4e06b32e8303\0\0\0_SESSION_ID@°àd\0\0\0_SESSION_ATIME\0\0\0\0\0\0\0_SESSION_EXPIRE_LIST\n 10.0.0.23\0\0\0_SESSION_REMOTE_ADDR?°àd\0\0\0_SESSION_CTIME'),('9372aa8a2e2a7f46839ecb8802309e57','1234\0\0\0\0\0\0~session_table_id\0\0tax_number=4530101825:posallowcost=1:orderchange=1:proforma=-1:allowclone=-1:posallowcheque=1:lastcost=1:service_fees=:showchange=1:billexcl=-1:changepop=1:clockview=-1:pickhead=ORDER SLIP:compcustomer=-1:customerpins=-1:qtypriceoption=1:alloworderbutton=1:dprefix=ODC/:qtysplitshow=1:show_noqty_stock=-1:suqty=1:putype=1:tillscatfilter=:proplim=1:suprice=1:intranet_printer=T1:susplit=1:tenpercent=-1:allowdiscount=1:currency=R:nosubmit=1:sswidth=2048:plugrouping=-1:qaccount=1:opencdcc=-1:plumode0=-1:accpre=OD:noeditaccount=-1:validateid=1:cdrawer=-1:surecall=1:onholdbut=-1:sfeeshow=-1:depositchange=1:totalizer=1:centround=-1:backuptime=:shop_id=1:ssheight=768:discountbills=1:paymentclr=1:printqnayes=1:sureprint=1:qnaproforma=1:posallowquickpay=1:location=Bellville:recallbutton=1:customershort=-1:meatstore=-1:orderspayment=-1:nozeroring=-1:suclock=1:voidenable=1:bstartmonth=3:autodrawer=-1:ccscreen=1:autofillaccounts=-1:brand=Oakdale Club 2020:pucode=1:abrev=oakdaleclub_1:suaccount=-1:posallowcc=1:jobstimeout=:autoplace=1800:pucat=1:livevariance=-1:backuphost=:refundanypayment=-1:sbgfile=SecondScreenLogos/adl.png:historybutton=1:priceoverride=1:nosplitproforma=1:loyalty=1:stypesummary=:plulinesize=2:accountcard=1:customerwristbands=-1:pmatrix=1:sutransfer=1:sucrefund=1\0\0\0~settings_pm\0\0\0~set_logged_user\0\0\0~set_logged_superuser\0\0\0~set_user_id\n2\0\0\0~set_superviseundo€\0\0\0~set_user_top_category\0\0\0~set_superuser_id\0\0\0~set_superuser_name\n 9372aa8a2e2a7f46839ecb8802309e57\0\0\0_SESSION_ID \0\0\0~setqmode\0\0\0~set_user_name\n0\0\0\0~plumode\nk6tlhcwtq6up\n\0\0\0~logged-in\n 10.0.0.26\0\0\0_SESSION_REMOTE_ADDR™µàd\0\0\0_SESSION_CTIME \0\0\0\n\0\0\0\0posfocus\n1\0\0\0shop_id\nLPT5:\0\0\0cashdrawer_port\n1\0\0\0sharedclientsprofileid\n 10.0.0.26\n\0\0\0station_ip\n1\0\0\0allowcashrefund\nOakdale Club 23\0\0\0profilename\n16\n\0\0\0station_id\n2\0\0\0nocustomerdiscount\nOakdale\0\0\0group\n0 \0\0\0printmode\n 10.0.0.26\r\0\0\0cashdrawer_ip \0\0\0pole_port\n0\n\0\0\0screenmode\n1\n\0\0\0slipscount\n2\0\0\0printinstructions\n\nBowls Club\0\0\0location\0\0\0pole_ip\nOakdale Club 23\0\0\0sharedclientsprofilename\n1\n\0\0\0profile_id\n2\0\0\0disablereturns\n1\0\0\0sharedclientsshopid\n\roakdaleclub_1\0\0\0database\n0\r\0\0\0pluscreenmode\n1\0\0\0noautofillaccount_refund\r\0\0\0tablekeywords\n2\0\0\0allowaddcustomer\n\roakdaleclub_1\0\0\0sharedclientsdatabase\n2\n\0\0\0widescreen\n2\0\0\0secondaryscreen\n1\0\0\0disablepayment\n1.jpg\0\0\0logofile\0\0\0~profile\n1\0\0\0~userpayment2¸àd\0\0\0_SESSION_ATIME\0\0\0\0\0\0\0_SESSION_EXPIRE_LIST€\0\0\0~set_user_favorite_category'),('027349e3a7256fb856a9909a662fcfe6','1234\0\0\0\n 027349e3a7256fb856a9909a662fcfe6\0\0\0_SESSION_IDšµàd\0\0\0_SESSION_ATIME\n 10.0.0.26\0\0\0_SESSION_REMOTE_ADDRšµàd\0\0\0_SESSION_CTIME'),('add87f19f2ad5e1b830c47808e4d9051','1234\0\0\0\n add87f19f2ad5e1b830c47808e4d9051\0\0\0_SESSION_ID\"·àd\0\0\0_SESSION_ATIME\n 10.0.0.20\0\0\0_SESSION_REMOTE_ADDR\"·àd\0\0\0_SESSION_CTIME'),('04d53d56ff600c7957ff40ece58cd2e7','1234\0\0\0\n 04d53d56ff600c7957ff40ece58cd2e7\0\0\0_SESSION_IDV»àd\0\0\0_SESSION_ATIME\0\0\0\0\0\0\0_SESSION_EXPIRE_LIST\n\n10.0.0.139\0\0\0_SESSION_REMOTE_ADDRP»àd\0\0\0_SESSION_CTIME'),('760556aae82157ff58e47360357da24e','1234\0\0\0\n 760556aae82157ff58e47360357da24e\0\0\0_SESSION_IDn»àd\0\0\0_SESSION_ATIME\0\0\0\0\0\0\0_SESSION_EXPIRE_LIST\n 127.0.0.1\0\0\0_SESSION_REMOTE_ADDRl»àd\0\0\0_SESSION_CTIME'),('b2d8998e02b1210555cd832944239fb5','1234\0\0\0\n b2d8998e02b1210555cd832944239fb5\0\0\0_SESSION_IDb¼àd\0\0\0_SESSION_ATIME\n 127.0.0.1\0\0\0_SESSION_REMOTE_ADDRb¼àd\0\0\0_SESSION_CTIME'); /*Table structure for table `settings` */ DROP TABLE IF EXISTS `settings`; CREATE TABLE `settings` ( `name` varchar(32) NOT NULL, `val` varchar(50) NOT NULL DEFAULT '', `db` varchar(30) NOT NULL DEFAULT '', PRIMARY KEY (`name`,`db`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*Data for the table `settings` */ insert into `settings`(`name`,`val`,`db`) values ('onholdbut','-1','oakdale_1'),('pickhead','ORDER SLIP','oakdale_1'),('paymentclr','1','oakdale_1'),('plumode0','-1','oakdale_1'),('autofillaccounts','-1','oakdale_1'),('noeditaccount','-1','oakdale_1'),('depositchange','1','oakdale_1'),('changepop','1','oakdale_1'),('showchange','1','oakdale_1'),('priceoverride','1','oakdale_1'),('orderspayment','-1','oakdale_1'),('recallbutton','1','oakdale_1'),('discountbills','1','oakdale_1'),('historybutton','1','oakdale_1'),('alloworderbutton','1','oakdale_1'),('refundanypayment','-1','oakdale_1'),('allowdiscount','1','oakdale_1'),('qtysplitshow','1','oakdale_1'),('compcustomer','-1','oakdale_1'),('voidenable','1','oakdale_1'),('nosubmit','-1','oakdale_1'),('plugrouping','-1','oakdale_1'),('orderchange','1','oakdale_1'),('posallowcost','1','oakdale_1'),('posallowcc','1','oakdale_1'),('posallowcheque','1','oakdale_1'),('posallowquickpay','1','oakdale_1'),('plulinesize','2','oakdale_1'),('totalizer','1','oakdale_1'),('validateid','1','oakdale_1'),('pmatrix','1','oakdale_1'),('loyalty','1','oakdale_1'),('proplim','1','oakdale_1'),('putype','1','oakdale_1'),('pucode','1','oakdale_1'),('pucat','1','oakdale_1'),('cdrawer','-1','oakdale_1'),('sucrefund','1','oakdale_1'),('surecall','1','oakdale_1'),('suprice','1','oakdale_1'),('suaccount','-1','oakdale_1'),('sutransfer','1','oakdale_1'),('suclock','1','oakdale_1'),('sureprint','1','oakdale_1'),('suqty','1','oakdale_1'),('susplit','1','oakdale_1'),('accpre','OD','oakdale_1'),('dprefix','ODC/','oakdale_1'),('billexcl','-1','oakdale_1'),('stypesummary','','oakdale_1'),('backuphost','','oakdale_1'),('jobstimeout','','oakdale_1'),('backuptime','','oakdale_1'),('bstartmonth','3','oakdale_1'),('qnaproforma','1','oakdale_1'),('show_noqty_stock','-1','oakdale_1'),('printqnayes','1','oakdale_1'),('service_fees','','oakdale_1'),('intranet_printer','T1','oakdale_1'),('currency','R','oakdale_1'),('location','Bellville','oakdale_1'),('brand','','oakdale_1'),('tax_number','4530101825','oakdale_1'),('abrev','oakdale_1','oakdale_1'),('tillscatfilter','','oakdale_1'),('shop_id','1','oakdale_1'),('sfeeshow','-1','oakdale_1'),('ccscreen','1','oakdale_1'),('autodrawer','-1','oakdale_1'),('proforma','-1','oakdale_1'),('customershort','-1','oakdale_1'),('livevariance','-1','oakdale_1'),('nozeroring','-1','oakdale_1'),('nosplitproforma','1','oakdale_1'),('meatstore','-1','oakdale_1'),('qtypriceoption','1','oakdale_1'),('allowclone','-1','oakdale_1'),('customerpins','-1','oakdale_1'),('opencdcc','-1','oakdale_1'),('customerwristbands','-1','oakdale_1'),('tenpercent','-1','oakdale_1'),('lastcost','-1','oakdale_1'),('qaccount','-1','oakdale_1'),('centround','-1','oakdale_1'),('autoplace','40','oakdale_1'),('clockview','-1','oakdale_1'),('sbgfile','SecondScreenLogos/adl.png','oakdale_1'),('sswidth','2048','oakdale_1'),('ssheight','768','oakdale_1'),('customerpins','-1','oakdale_2'),('allowclone','-1','oakdale_2'),('qtypriceoption','1','oakdale_2'),('meatstore','-1','oakdale_2'),('nosplitproforma','1','oakdale_2'),('nozeroring','-1','oakdale_2'),('livevariance','-1','oakdale_2'),('customershort','-1','oakdale_2'),('proforma','-1','oakdale_2'),('autodrawer','-1','oakdale_2'),('ccscreen','1','oakdale_2'),('sfeeshow','-1','oakdale_2'),('onholdbut','-1','oakdale_2'),('pickhead','ORDER SLIP','oakdale_2'),('paymentclr','1','oakdale_2'),('plumode0','-1','oakdale_2'),('autofillaccounts','-1','oakdale_2'),('noeditaccount','-1','oakdale_2'),('depositchange','1','oakdale_2'),('changepop','1','oakdale_2'),('showchange','1','oakdale_2'),('priceoverride','1','oakdale_2'),('orderspayment','-1','oakdale_2'),('recallbutton','1','oakdale_2'),('discountbills','1','oakdale_2'),('historybutton','1','oakdale_2'),('alloworderbutton','1','oakdale_2'),('refundanypayment','-1','oakdale_2'),('allowdiscount','1','oakdale_2'),('qtysplitshow','1','oakdale_2'),('compcustomer','-1','oakdale_2'),('voidenable','1','oakdale_2'),('nosubmit','-1','oakdale_2'),('plugrouping','-1','oakdale_2'),('orderchange','1','oakdale_2'),('posallowcost','1','oakdale_2'),('posallowcc','1','oakdale_2'),('posallowcheque','1','oakdale_2'),('posallowquickpay','1','oakdale_2'),('plulinesize','2','oakdale_2'),('totalizer','1','oakdale_2'),('validateid','1','oakdale_2'),('pmatrix','1','oakdale_2'),('loyalty','1','oakdale_2'),('proplim','1','oakdale_2'),('putype','1','oakdale_2'),('pucode','1','oakdale_2'),('pucat','1','oakdale_2'),('shop_id','1','oakdale_test'),('tillscatfilter','','oakdale_test'),('abrev','oakdale_test','oakdale_test'),('tax_number','4530101825','oakdale_test'),('brand','','oakdale_test'),('location','Bellville','oakdale_test'),('currency','R','oakdale_test'),('intranet_printer','T1','oakdale_test'),('service_fees','','oakdale_test'),('printqnayes','1','oakdale_test'),('show_noqty_stock','-1','oakdale_test'),('qnaproforma','1','oakdale_test'),('bstartmonth','3','oakdale_test'),('backuptime','','oakdale_test'),('jobstimeout','','oakdale_test'),('backuphost','','oakdale_test'),('stypesummary','','oakdale_test'),('billexcl','-1','oakdale_test'),('dprefix','ODC/','oakdale_test'),('accpre','OD','oakdale_test'),('susplit','1','oakdale_test'),('suqty','1','oakdale_test'),('sureprint','1','oakdale_test'),('suclock','1','oakdale_test'),('sutransfer','1','oakdale_test'),('suaccount','-1','oakdale_test'),('suprice','-1','oakdale_test'),('surecall','1','oakdale_test'),('sucrefund','1','oakdale_test'),('cdrawer','-1','oakdale_test'),('pucat','1','oakdale_test'),('pucode','1','oakdale_test'),('putype','1','oakdale_test'),('proplim','1','oakdale_test'),('loyalty','1','oakdale_test'),('pmatrix','1','oakdale_test'),('validateid','1','oakdale_test'),('totalizer','1','oakdale_test'),('plulinesize','2','oakdale_test'),('posallowquickpay','1','oakdale_test'),('posallowcheque','1','oakdale_test'),('posallowcc','1','oakdale_test'),('posallowcost','1','oakdale_test'),('orderchange','1','oakdale_test'),('plugrouping','-1','oakdale_test'),('nosubmit','-1','oakdale_test'),('voidenable','1','oakdale_test'),('compcustomer','-1','oakdale_test'),('qtysplitshow','1','oakdale_test'),('allowdiscount','1','oakdale_test'),('refundanypayment','-1','oakdale_test'),('alloworderbutton','1','oakdale_test'),('historybutton','1','oakdale_test'),('discountbills','1','oakdale_test'),('recallbutton','1','oakdale_test'),('orderspayment','-1','oakdale_test'),('priceoverride','1','oakdale_test'),('showchange','1','oakdale_test'),('changepop','1','oakdale_test'),('depositchange','1','oakdale_test'),('noeditaccount','-1','oakdale_test'),('autofillaccounts','-1','oakdale_test'),('plumode0','-1','oakdale_test'),('paymentclr','1','oakdale_test'),('pickhead','ORDER SLIP','oakdale_test'),('onholdbut','-1','oakdale_test'),('sfeeshow','-1','oakdale_test'),('ccscreen','1','oakdale_test'),('autodrawer','-1','oakdale_test'),('proforma','-1','oakdale_test'),('customershort','-1','oakdale_test'),('livevariance','-1','oakdale_test'),('nozeroring','-1','oakdale_test'),('nosplitproforma','1','oakdale_test'),('meatstore','-1','oakdale_test'),('qtypriceoption','1','oakdale_test'),('allowclone','-1','oakdale_test'),('customerpins','-1','oakdale_test'),('opencdcc','-1','oakdale_test'),('customerwristbands','-1','oakdale_test'),('tenpercent','-1','oakdale_test'),('lastcost','-1','oakdale_test'),('qaccount','-1','oakdale_test'),('centround','-1','oakdale_test'),('autoplace','1800','oakdale_test'),('clockview','-1','oakdale_test'),('sbgfile','SecondScreenLogos/adl.png','oakdale_test'),('sswidth','2048','oakdale_test'),('ssheight','768','oakdale_test'),('cdrawer','-1','oakdale_2'),('sucrefund','1','oakdale_2'),('surecall','1','oakdale_2'),('suprice','1','oakdale_2'),('suaccount','-1','oakdale_2'),('sutransfer','1','oakdale_2'),('suclock','1','oakdale_2'),('sureprint','1','oakdale_2'),('suqty','1','oakdale_2'),('susplit','1','oakdale_2'),('accpre','OD','oakdale_2'),('dprefix','ODC/','oakdale_2'),('billexcl','-1','oakdale_2'),('stypesummary','','oakdale_2'),('backuphost','','oakdale_2'),('jobstimeout','','oakdale_2'),('backuptime','','oakdale_2'),('bstartmonth','3','oakdale_2'),('qnaproforma','1','oakdale_2'),('show_noqty_stock','-1','oakdale_2'),('printqnayes','1','oakdale_2'),('service_fees','','oakdale_2'),('intranet_printer','T1','oakdale_2'),('currency','R','oakdale_2'),('location','Bellville','oakdale_2'),('brand','','oakdale_2'),('tax_number','4530101825','oakdale_2'),('abrev','oakdale_2','oakdale_2'),('tillscatfilter','','oakdale_2'),('shop_id','1','oakdale_2'),('centround','-1','oakdaleclub_1'),('qaccount','1','oakdaleclub_1'),('lastcost','1','oakdaleclub_1'),('tenpercent','-1','oakdaleclub_1'),('customerwristbands','-1','oakdaleclub_1'),('opencdcc','-1','oakdaleclub_1'),('customerpins','-1','oakdaleclub_1'),('qtypriceoption','1','oakdaleclub_1'),('allowclone','-1','oakdaleclub_1'),('meatstore','-1','oakdaleclub_1'),('nozeroring','-1','oakdaleclub_1'),('nosplitproforma','1','oakdaleclub_1'),('livevariance','-1','oakdaleclub_1'),('customershort','-1','oakdaleclub_1'),('proforma','-1','oakdaleclub_1'),('autodrawer','-1','oakdaleclub_1'),('ccscreen','1','oakdaleclub_1'),('onholdbut','-1','oakdaleclub_1'),('sfeeshow','-1','oakdaleclub_1'),('pickhead','ORDER SLIP','oakdaleclub_1'),('paymentclr','1','oakdaleclub_1'),('plumode0','-1','oakdaleclub_1'),('autofillaccounts','-1','oakdaleclub_1'),('opencdcc','-1','oakdale_2'),('customerwristbands','-1','oakdale_2'),('tenpercent','-1','oakdale_2'),('lastcost','-1','oakdale_2'),('qaccount','1','oakdale_2'),('centround','-1','oakdale_2'),('autoplace','1800','oakdale_2'),('clockview','-1','oakdale_2'),('accountcard','1','oakdale_2'),('sbgfile','SecondScreenLogos/adl.png','oakdale_2'),('sswidth','2048','oakdale_2'),('ssheight','768','oakdale_2'),('noeditaccount','-1','oakdaleclub_1'),('depositchange','1','oakdaleclub_1'),('changepop','1','oakdaleclub_1'),('priceoverride','1','oakdaleclub_1'),('showchange','1','oakdaleclub_1'),('orderspayment','-1','oakdaleclub_1'),('recallbutton','1','oakdaleclub_1'),('discountbills','1','oakdaleclub_1'),('historybutton','1','oakdaleclub_1'),('alloworderbutton','1','oakdaleclub_1'),('refundanypayment','-1','oakdaleclub_1'),('allowdiscount','1','oakdaleclub_1'),('qtysplitshow','1','oakdaleclub_1'),('compcustomer','-1','oakdaleclub_1'),('voidenable','1','oakdaleclub_1'),('nosubmit','1','oakdaleclub_1'),('plugrouping','-1','oakdaleclub_1'),('orderchange','1','oakdaleclub_1'),('posallowcost','1','oakdaleclub_1'),('posallowcc','1','oakdaleclub_1'),('posallowcheque','1','oakdaleclub_1'),('posallowquickpay','1','oakdaleclub_1'),('plulinesize','2','oakdaleclub_1'),('totalizer','1','oakdaleclub_1'),('validateid','1','oakdaleclub_1'),('pmatrix','1','oakdaleclub_1'),('loyalty','1','oakdaleclub_1'),('proplim','1','oakdaleclub_1'),('putype','1','oakdaleclub_1'),('pucat','1','oakdaleclub_1'),('pucode','1','oakdaleclub_1'),('cdrawer','-1','oakdaleclub_1'),('sucrefund','1','oakdaleclub_1'),('surecall','1','oakdaleclub_1'),('suprice','1','oakdaleclub_1'),('suaccount','-1','oakdaleclub_1'),('sutransfer','1','oakdaleclub_1'),('suclock','1','oakdaleclub_1'),('sureprint','1','oakdaleclub_1'),('suqty','1','oakdaleclub_1'),('susplit','1','oakdaleclub_1'),('accpre','OD','oakdaleclub_1'),('dprefix','ODC/','oakdaleclub_1'),('billexcl','-1','oakdaleclub_1'),('stypesummary','','oakdaleclub_1'),('backuphost','','oakdaleclub_1'),('jobstimeout','','oakdaleclub_1'),('backuptime','','oakdaleclub_1'),('qnaproforma','1','oakdaleclub_1'),('bstartmonth','3','oakdaleclub_1'),('show_noqty_stock','-1','oakdaleclub_1'),('printqnayes','1','oakdaleclub_1'),('service_fees','','oakdaleclub_1'),('intranet_printer','T1','oakdaleclub_1'),('currency','R','oakdaleclub_1'),('location','Bellville','oakdaleclub_1'),('brand','Oakdale Club 2020','oakdaleclub_1'),('tax_number','4530101825','oakdaleclub_1'),('abrev','oakdaleclub_1','oakdaleclub_1'),('tillscatfilter','','oakdaleclub_1'),('shop_id','1','oakdaleclub_1'),('autoplace','1800','oakdaleclub_1'),('clockview','-1','oakdaleclub_1'),('accountcard','1','oakdaleclub_1'),('sbgfile','SecondScreenLogos/adl.png','oakdaleclub_1'),('sswidth','2048','oakdaleclub_1'),('ssheight','768','oakdaleclub_1'); /*Table structure for table `thumbs` */ DROP TABLE IF EXISTS `thumbs`; CREATE TABLE `thumbs` ( `id` int(11) NOT NULL AUTO_INCREMENT, `pin` varchar(250) DEFAULT NULL, `thumb` blob, `timestamp` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1; /*Data for the table `thumbs` */ insert into `thumbs`(`id`,`pin`,`thumb`,`timestamp`) values (1,'11','\0��*�s\\�A7 �q�U��R��Ҋ0*Fh�>�9oQ}6��jl�^⥐��s�&��\n qԚ�-�n8��T�;�JD��s�9��51R��fk��<�n)�Ŵ5��vKA��֫��3]!I�M�L��W��U��o\0��*�s\\�A7 �q0�U�$o�^F-��Q�I�\Z$��اt�l�� c\r\0akY�}:{�/�Q ��E�AL�Ra�8��Q�\r�|�f�Zz�B��ޔ�M3\"�-򽌼l�+�~��t�M8��;�7��\0�9�E+��*ж�E��M�o>��n�xq-�C#��C,�}��u��\nڂ��bb/�_�-24��p��$��L�H!c0��2�0CL��#�j�͓IaeC��P��rnDW?�u2dD�)�Y��iN��zc��%��|sE&��/�$�(,\\��փނƾ�^^jw�F�d��ٰ�S�\Z.�p_��T�8ԑ�e%�a��^�e��_�4��3��o\0��*�s\\�A7 �q0�U�A\n��Hҧ%�\"\r\'�=l��L�#�!=�\0K��->�s.}\\��Aw��:�U��]��Qj�4D�\\3@r6��l\r,*�B�k��p�2�t�2�!Ml�xbH��itl��Uc�\"F�m��w�@3��%�O�� q��*�iLR��M6�|-(&�j��v$J�Ŕ9[��b�ޝc��\"M~#S��r~��|��\Z�h��Q�g�\" �?��g:}��sUS%��`��\"��|��E*�[dj��V\0�6�B��d$�i��Ɩ\0��`#�ck+�jΉܛ��J�c��y��鏇58�1��6t�^+��u�;(u`l=�1(�oV�B2]JE8�ߓ�J�Wq�#�~G�\0k�y��\0o\0��*�s\\�A7 �q0�U��UoIU��P��S�#k}&�}�g�j��3W��#_|�]T�t7d6��[�&�$r�ڤ�Xah�z�?t��\r��\06ŧ�zf\ri��6��UX�\'\ZB��\0��Voډ��Uv/B CxonlZ��B�Ht>`�\"�,�Ãϐ)��`c-+I��bl��͹.��E��t��z�\\��;��e$�I�no��U��{`��Z#��uE��2�r�ɎR j��W/(b�X��&��u�5��=��!�� Uco��!��\\��h0�J��y�\r�:Y)�L�!A��t��H��ÆJf\0��7~\"��I��vrB�mB�t�fo\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0','2011-11-15 08:03:32'),(2,'1609','\0��*�s\\�A7 �q0EU�`2Y��5H\0�M�:YMi�~��{��g\'�}�D��*r��v?&C�)i�e�G�ت*�4b��L�S��N�(�^l�\n��K.��C��E�\\̚Y1zC��#�D[%t��9��x�:<��<�v8_8�E�C��bڮ��U�M8��-$��я��):N�wKf�\'�EEF�(Kmt�kj\r#;?q6՟9\Z,D�N�+�V��@�em��\n(�D_��m��5��F́\0�9� �\\��X�A�*.cl�-�V�!�c��{�I33�<3ꏃ�b\n�:/w� g�\\�6�9O6�*� �:XDN�J5�ڌ}�Y��\rNcD��.��-��-ƞEVݟ��:v�2o\0��*�s\\�A7 �q�U�{��y�H&�~�ڞ,q��?��r�k�Kb15��9�.&�b��Q��#Bj�[��6)B�\Z�.��P��y��H�(� ��YK��綛�5��:�ꊛ*�]w^m��\Z>L\n��!�tN\r��c�7A|��o��M��v6��2tK��5ύ�GQ��Er@DM��{\"{,MԨ5v�x��ɹTB�ӧ�׬��.3+4R~�k�AJ�BS31n��6(<�ǚM��%�`\'(� �N;z�xMO?KA3�o\0��*�s\\�A7 �qp�U��lBaFe��eS&�ʣ$˓{��dRiԫ�D�`-Y̲\\Y�/&ñ��»��J�x��lʌ��`��|�y&�R��!�\0\"Tk�!�*VX7��/3�}3�pݔ�\r=��T+�aިէTBG��E=��SuJ�o�-��N�;��D3��@�b��W��}�ْ�lXQE> �o-;5��U��Jw&_$�X�Y�{| ��VϏ��`�0�dE��*A,�L��y)��茶�\Z�_SyӂYt�f��3��p��3FvH��W%W7��)��~in�X��U�c��\Z�~2])��l��1��>�<��<�/�dM��o\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0','2011-11-14 18:20:23'),(3,'22','\0��*�s\\�A7 �q0�U�̵�z�Eb��l!<�}n.\\)�h��[��Y�˚Kf~ -ʶX�#4X�P�W��)\Z]��*LL�\'�U�A-͑�\n��`�%E�5�1:��^��\r�]Fu?�FA��i��C_5i��B� 4sE�v�$e��H\n�Ri�1�4�:ւD��q�˘�LD<6ow��Lm��C�j[>Ǉ��Ɇ\"ʲ�e.H~װ7�\\?:��>{�v�A��l`XF�8#��<��}��5�*rs� ��v�$7��3-�H�!5,�`y��>5�f5�$N��Nm�I�I��ns�|N��A��aȸ�!پ�Z��lZ��<��ޠ��Ã��o\0��*�s\\�A7 �q��U��6$��2��E`ѷ��)g}�j1��.��0��F�G��9�1�nJ{��t\n��Qg��E1��\ZԻ��=\nn`%:��\\�e/��v9�@�z}�2�p��stx:*H��v��\Z\0?�:hq4��U��S1�=�V��1e�Xl�Ǐe��8��R3�gsHK<�W��l�ݼ�$.�B��ñ��5�y��\\�S�x\'��䂭se�p:x��k\\��J��iOU~��6g�� /��9��C7u�.�r��İ=L]��˧��JToLa\r@��sTg�>��r�Ȏ]��<ێ{?��\Z��I��b�zp6UW��Լ��%�Q�No\0�t�*�s\\�A7 �q0�U��9��H��w�ᯆ$�aF�:~D�ȇ��Q��̈�!!$�Rھ��\'�]vi\Zw��|P��F�|�؀5f��8D��H�#��j�R] 赪C끹]�,�.A´� �S��#�W:ymh��&��|4<A|6N�q�#A��]p(��|��϶��%�Cq��v�5~jY*��\"1Ũ�s�CP7��\\C\nn�P��hw�a��ơ[& ��Az_Cf�|È �_)�U[:(c��0�p�nPG��´� ��+_k h�V�=��9ޅ��+1��P;�wy>�tBh�sH��Ѝw\0�Jr޺�l��Lj��2��o\0�~�*�s\\�A7 �q�U�ti��l|6\'.�\'I�[O�>,GT�gP��ć\\V��0m��T��|�v��\\Tp�P�A��w��-[��y�r�0�:��<:f��&� a:��%4j�XiE~:l�rG��l�dwT�%��l,x�w ��?��ד�/��&pF�\r5�db؛�w��I��#�H�Յ�F�S^�^8gR��;%}��WI~7��!�@�EIB%��^/\09$4��G��GB5��[�`��d��0Q�^��2��!�]c�7�[�:K�E04j~k��>�;߶�+,�n��\"cio�ܧ춪e��Gn��b��j�37wA�?&�Ae��ː4@[��e��o\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0','2011-11-15 09:23:58'); /*Table structure for table `user_catpermissions` */ DROP TABLE IF EXISTS `user_catpermissions`; CREATE TABLE `user_catpermissions` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `user_id` int(10) NOT NULL DEFAULT '0', `database_name` varchar(50) NOT NULL DEFAULT '', `menu_catid` int(10) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `users_id` (`user_id`), KEY `menu_cat_usr` (`user_id`,`database_name`,`menu_catid`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*Data for the table `user_catpermissions` */ /*Table structure for table `user_permissions` */ DROP TABLE IF EXISTS `user_permissions`; CREATE TABLE `user_permissions` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) DEFAULT NULL, `action` varchar(200) DEFAULT NULL, `subaction` varchar(200) DEFAULT NULL, `command` varchar(200) DEFAULT NULL, `allowance` int(11) DEFAULT '3', PRIMARY KEY (`id`), KEY `user_id` (`user_id`), KEY `action` (`action`), KEY `subaction` (`subaction`), KEY `command` (`command`) ) ENGINE=MyISAM AUTO_INCREMENT=2388 DEFAULT CHARSET=latin1 PAGE_CHECKSUM=1; /*Data for the table `user_permissions` */ insert into `user_permissions`(`id`,`user_id`,`action`,`subaction`,`command`,`allowance`) values (1,9,'0',NULL,NULL,1),(2,9,'17',NULL,NULL,1),(3,9,'18',NULL,NULL,1),(4,9,'19',NULL,NULL,1),(5,9,'20',NULL,NULL,1),(6,9,'21',NULL,NULL,1),(7,9,'22',NULL,NULL,1),(8,9,'28',NULL,NULL,1),(9,9,'29',NULL,NULL,1),(10,9,'30',NULL,NULL,1),(11,9,'31',NULL,NULL,1),(12,9,'32',NULL,NULL,1),(13,9,'33',NULL,NULL,1),(14,9,'34',NULL,NULL,1),(15,9,'35',NULL,NULL,2),(16,9,'36',NULL,NULL,1),(17,9,'37',NULL,NULL,1),(18,9,'38',NULL,NULL,1),(19,9,'39',NULL,NULL,2),(20,9,'40',NULL,NULL,1),(21,9,'51',NULL,NULL,1),(22,9,'52',NULL,NULL,1),(23,9,'53',NULL,NULL,2),(24,9,'54',NULL,NULL,1),(25,9,'55',NULL,NULL,1),(26,9,'56',NULL,NULL,1),(27,9,'57',NULL,NULL,1),(28,9,'58',NULL,NULL,2),(29,9,'70',NULL,NULL,1),(30,9,'71',NULL,NULL,1),(31,9,'72',NULL,NULL,1),(32,9,'73',NULL,NULL,1),(33,9,'74',NULL,NULL,1),(34,9,'75',NULL,NULL,1),(35,9,'76',NULL,NULL,2),(36,9,'77',NULL,NULL,1),(37,9,'78',NULL,NULL,1),(38,9,'79',NULL,NULL,1),(39,9,'80',NULL,NULL,1),(40,9,'90',NULL,NULL,1),(41,9,'91',NULL,NULL,1),(42,9,'92',NULL,NULL,2),(43,9,'100',NULL,NULL,2),(44,9,'101',NULL,NULL,2),(45,9,'102',NULL,NULL,2),(46,9,'110',NULL,NULL,1),(47,9,'200',NULL,NULL,1),(48,9,'201',NULL,NULL,1),(49,9,'202',NULL,NULL,1),(50,9,'203',NULL,NULL,1),(51,9,'204',NULL,NULL,1),(52,9,'205',NULL,NULL,1),(53,9,'206',NULL,NULL,2),(54,9,'207',NULL,NULL,1),(55,9,'208',NULL,NULL,1),(56,9,'209',NULL,NULL,1),(57,9,'210',NULL,NULL,1),(58,9,'211',NULL,NULL,1),(59,9,'212',NULL,NULL,1),(60,9,'213',NULL,NULL,1),(61,9,'214',NULL,NULL,2),(62,9,'215',NULL,NULL,1),(63,9,'216',NULL,NULL,1),(64,9,'217',NULL,NULL,1),(65,9,'218',NULL,NULL,1),(66,9,'220',NULL,NULL,1),(67,9,'221',NULL,NULL,1),(68,9,'222',NULL,NULL,1),(69,9,'223',NULL,NULL,1),(70,9,'224',NULL,NULL,1),(71,9,'300',NULL,NULL,1),(72,9,'301',NULL,NULL,1),(73,9,'302',NULL,NULL,2),(74,9,'303',NULL,NULL,2),(75,9,'304',NULL,NULL,2),(76,9,'305',NULL,NULL,1),(77,9,'320',NULL,NULL,1),(78,9,'321',NULL,NULL,1),(79,9,'322',NULL,NULL,1),(80,9,'323',NULL,NULL,1),(81,9,'324',NULL,NULL,1),(82,9,'325',NULL,NULL,1),(83,9,'326',NULL,NULL,1),(84,9,'327',NULL,NULL,1),(85,9,'328',NULL,NULL,1),(86,9,'330',NULL,NULL,1),(87,9,'331',NULL,NULL,1),(88,9,'332',NULL,NULL,1),(89,9,'333',NULL,NULL,1),(90,9,'334',NULL,NULL,2),(91,9,'335',NULL,NULL,2),(92,9,'336',NULL,NULL,1),(93,9,'339',NULL,NULL,1),(94,9,'340',NULL,NULL,2),(95,9,'341',NULL,NULL,1),(96,9,'342',NULL,NULL,1),(97,9,'400',NULL,NULL,1),(98,9,'401',NULL,NULL,1),(99,9,'402',NULL,NULL,1),(100,9,'410',NULL,NULL,1),(101,9,'412',NULL,NULL,1),(102,9,'413',NULL,NULL,1),(103,9,'414',NULL,NULL,1),(104,9,'415',NULL,NULL,1),(105,9,'416',NULL,NULL,1),(106,9,'450',NULL,NULL,1),(107,9,'451',NULL,NULL,1),(108,9,'500',NULL,NULL,2),(109,9,'501',NULL,NULL,2),(110,9,'502',NULL,NULL,2),(111,9,'503',NULL,NULL,2),(112,9,'504',NULL,NULL,2),(113,9,'505',NULL,NULL,2),(114,9,'506',NULL,NULL,2),(115,9,'507',NULL,NULL,2),(116,9,'508',NULL,NULL,2),(117,9,'509',NULL,NULL,2),(118,9,'510',NULL,NULL,2),(119,9,'511',NULL,NULL,2),(120,13,'0',NULL,NULL,1),(121,13,'17',NULL,NULL,1),(122,13,'18',NULL,NULL,1),(123,13,'19',NULL,NULL,1),(124,13,'20',NULL,NULL,1),(125,13,'21',NULL,NULL,1),(126,13,'22',NULL,NULL,1),(127,13,'28',NULL,NULL,1),(128,13,'29',NULL,NULL,1),(129,13,'30',NULL,NULL,1),(130,13,'31',NULL,NULL,1),(131,13,'32',NULL,NULL,1),(132,13,'33',NULL,NULL,2),(133,13,'34',NULL,NULL,1),(134,13,'35',NULL,NULL,2),(135,13,'36',NULL,NULL,1),(136,13,'37',NULL,NULL,1),(137,13,'38',NULL,NULL,1),(138,13,'39',NULL,NULL,2),(139,13,'40',NULL,NULL,1),(140,13,'51',NULL,NULL,1),(141,13,'52',NULL,NULL,1),(142,13,'53',NULL,NULL,2),(143,13,'54',NULL,NULL,1),(144,13,'55',NULL,NULL,1),(145,13,'56',NULL,NULL,1),(146,13,'57',NULL,NULL,1),(147,13,'58',NULL,NULL,2),(148,13,'70',NULL,NULL,1),(149,13,'71',NULL,NULL,1),(150,13,'72',NULL,NULL,1),(151,13,'73',NULL,NULL,1),(152,13,'74',NULL,NULL,1),(153,13,'75',NULL,NULL,1),(154,13,'76',NULL,NULL,2),(155,13,'77',NULL,NULL,1),(156,13,'78',NULL,NULL,1),(157,13,'79',NULL,NULL,1),(158,13,'80',NULL,NULL,1),(159,13,'90',NULL,NULL,1),(160,13,'91',NULL,NULL,2),(161,13,'92',NULL,NULL,2),(162,13,'100',NULL,NULL,2),(163,13,'101',NULL,NULL,2),(164,13,'102',NULL,NULL,2),(165,13,'110',NULL,NULL,2),(166,13,'200',NULL,NULL,1),(167,13,'201',NULL,NULL,1),(168,13,'202',NULL,NULL,1),(169,13,'203',NULL,NULL,1),(170,13,'204',NULL,NULL,1),(171,13,'205',NULL,NULL,1),(172,13,'206',NULL,NULL,1),(173,13,'207',NULL,NULL,1),(174,13,'208',NULL,NULL,1),(175,13,'209',NULL,NULL,1),(176,13,'210',NULL,NULL,1),(177,13,'211',NULL,NULL,1),(178,13,'212',NULL,NULL,1),(179,13,'213',NULL,NULL,1),(180,13,'214',NULL,NULL,2),(181,13,'215',NULL,NULL,1),(182,13,'216',NULL,NULL,1),(183,13,'217',NULL,NULL,1),(184,13,'218',NULL,NULL,1),(185,13,'220',NULL,NULL,1),(186,13,'221',NULL,NULL,1),(187,13,'222',NULL,NULL,1),(188,13,'223',NULL,NULL,1),(189,13,'224',NULL,NULL,1),(190,13,'300',NULL,NULL,1),(191,13,'301',NULL,NULL,1),(192,13,'302',NULL,NULL,1),(193,13,'303',NULL,NULL,1),(194,13,'304',NULL,NULL,1),(195,13,'305',NULL,NULL,1),(196,13,'320',NULL,NULL,1),(197,13,'321',NULL,NULL,1),(198,13,'322',NULL,NULL,1),(199,13,'323',NULL,NULL,1),(200,13,'324',NULL,NULL,1),(201,13,'325',NULL,NULL,1),(202,13,'326',NULL,NULL,1),(203,13,'327',NULL,NULL,1),(204,13,'328',NULL,NULL,1),(205,13,'330',NULL,NULL,1),(206,13,'331',NULL,NULL,1),(207,13,'332',NULL,NULL,1),(208,13,'333',NULL,NULL,1),(209,13,'334',NULL,NULL,1),(210,13,'335',NULL,NULL,1),(211,13,'336',NULL,NULL,1),(212,13,'339',NULL,NULL,1),(213,13,'340',NULL,NULL,1),(214,13,'341',NULL,NULL,1),(215,13,'342',NULL,NULL,1),(216,13,'400',NULL,NULL,1),(217,13,'401',NULL,NULL,1),(218,13,'402',NULL,NULL,1),(219,13,'410',NULL,NULL,1),(220,13,'412',NULL,NULL,1),(221,13,'413',NULL,NULL,1),(222,13,'414',NULL,NULL,1),(223,13,'415',NULL,NULL,1),(224,13,'416',NULL,NULL,1),(225,13,'450',NULL,NULL,1),(226,13,'451',NULL,NULL,1),(227,13,'500',NULL,NULL,2),(228,13,'501',NULL,NULL,1),(229,13,'502',NULL,NULL,1),(230,13,'503',NULL,NULL,1),(231,13,'504',NULL,NULL,1),(232,13,'505',NULL,NULL,1),(233,13,'506',NULL,NULL,1),(234,13,'507',NULL,NULL,1),(235,13,'508',NULL,NULL,1),(236,13,'509',NULL,NULL,1),(237,13,'510',NULL,NULL,1),(238,13,'511',NULL,NULL,1),(239,19,'0',NULL,NULL,1),(240,19,'17',NULL,NULL,1),(241,19,'18',NULL,NULL,1),(242,19,'19',NULL,NULL,2),(243,19,'20',NULL,NULL,2),(244,19,'21',NULL,NULL,2),(245,19,'22',NULL,NULL,2),(246,19,'28',NULL,NULL,1),(247,19,'29',NULL,NULL,1),(248,19,'30',NULL,NULL,1),(249,19,'31',NULL,NULL,1),(250,19,'32',NULL,NULL,1),(251,19,'33',NULL,NULL,2),(252,19,'34',NULL,NULL,1),(253,19,'35',NULL,NULL,2),(254,19,'36',NULL,NULL,1),(255,19,'37',NULL,NULL,1),(256,19,'38',NULL,NULL,1),(257,19,'39',NULL,NULL,2),(258,19,'40',NULL,NULL,1),(259,19,'51',NULL,NULL,1),(260,19,'52',NULL,NULL,1),(261,19,'53',NULL,NULL,2),(262,19,'54',NULL,NULL,1),(263,19,'55',NULL,NULL,1),(264,19,'56',NULL,NULL,1),(265,19,'57',NULL,NULL,1),(266,19,'58',NULL,NULL,2),(267,19,'70',NULL,NULL,1),(268,19,'71',NULL,NULL,1),(269,19,'72',NULL,NULL,1),(270,19,'73',NULL,NULL,1),(271,19,'74',NULL,NULL,1),(272,19,'75',NULL,NULL,1),(273,19,'76',NULL,NULL,2),(274,19,'77',NULL,NULL,1),(275,19,'78',NULL,NULL,1),(276,19,'79',NULL,NULL,1),(277,19,'80',NULL,NULL,1),(278,19,'90',NULL,NULL,1),(279,19,'91',NULL,NULL,2),(280,19,'92',NULL,NULL,2),(281,19,'100',NULL,NULL,2),(282,19,'101',NULL,NULL,2),(283,19,'102',NULL,NULL,2),(284,19,'110',NULL,NULL,1),(285,19,'200',NULL,NULL,1),(286,19,'201',NULL,NULL,1),(287,19,'202',NULL,NULL,1),(288,19,'203',NULL,NULL,1),(289,19,'204',NULL,NULL,1),(290,19,'205',NULL,NULL,1),(291,19,'206',NULL,NULL,1),(292,19,'207',NULL,NULL,1),(293,19,'208',NULL,NULL,1),(294,19,'209',NULL,NULL,1),(295,19,'210',NULL,NULL,1),(296,19,'211',NULL,NULL,1),(297,19,'212',NULL,NULL,1),(298,19,'213',NULL,NULL,1),(299,19,'214',NULL,NULL,1),(300,19,'215',NULL,NULL,1),(301,19,'216',NULL,NULL,1),(302,19,'217',NULL,NULL,1),(303,19,'218',NULL,NULL,1),(304,19,'220',NULL,NULL,1),(305,19,'221',NULL,NULL,1),(306,19,'222',NULL,NULL,1),(307,19,'223',NULL,NULL,1),(308,19,'224',NULL,NULL,1),(309,19,'300',NULL,NULL,1),(310,19,'301',NULL,NULL,1),(311,19,'302',NULL,NULL,1),(312,19,'303',NULL,NULL,1),(313,19,'304',NULL,NULL,1),(314,19,'305',NULL,NULL,1),(315,19,'320',NULL,NULL,1),(316,19,'321',NULL,NULL,1),(317,19,'322',NULL,NULL,1),(318,19,'323',NULL,NULL,1),(319,19,'324',NULL,NULL,1),(320,19,'325',NULL,NULL,1),(321,19,'326',NULL,NULL,1),(322,19,'327',NULL,NULL,1),(323,19,'328',NULL,NULL,1),(324,19,'330',NULL,NULL,1),(325,19,'331',NULL,NULL,1),(326,19,'332',NULL,NULL,1),(327,19,'333',NULL,NULL,1),(328,19,'334',NULL,NULL,1),(329,19,'335',NULL,NULL,1),(330,19,'336',NULL,NULL,1),(331,19,'339',NULL,NULL,1),(332,19,'340',NULL,NULL,1),(333,19,'341',NULL,NULL,1),(334,19,'342',NULL,NULL,1),(335,19,'400',NULL,NULL,1),(336,19,'401',NULL,NULL,1),(337,19,'402',NULL,NULL,1),(338,19,'410',NULL,NULL,1),(339,19,'412',NULL,NULL,1),(340,19,'413',NULL,NULL,1),(341,19,'414',NULL,NULL,1),(342,19,'415',NULL,NULL,1),(343,19,'416',NULL,NULL,1),(344,19,'450',NULL,NULL,1),(345,19,'451',NULL,NULL,1),(346,19,'500',NULL,NULL,2),(347,19,'501',NULL,NULL,2),(348,19,'502',NULL,NULL,2),(349,19,'503',NULL,NULL,2),(350,19,'504',NULL,NULL,2),(351,19,'505',NULL,NULL,2),(352,19,'506',NULL,NULL,2),(353,19,'507',NULL,NULL,2),(354,19,'508',NULL,NULL,2),(355,19,'509',NULL,NULL,2),(356,19,'510',NULL,NULL,2),(357,19,'511',NULL,NULL,2),(358,20,'0',NULL,NULL,1),(359,20,'17',NULL,NULL,1),(360,20,'18',NULL,NULL,1),(361,20,'19',NULL,NULL,2),(362,20,'20',NULL,NULL,2),(363,20,'21',NULL,NULL,2),(364,20,'22',NULL,NULL,2),(365,20,'28',NULL,NULL,2),(366,20,'29',NULL,NULL,2),(367,20,'30',NULL,NULL,1),(368,20,'31',NULL,NULL,1),(369,20,'32',NULL,NULL,1),(370,20,'33',NULL,NULL,2),(371,20,'34',NULL,NULL,2),(372,20,'35',NULL,NULL,2),(373,20,'36',NULL,NULL,2),(374,20,'37',NULL,NULL,2),(375,20,'38',NULL,NULL,2),(376,20,'39',NULL,NULL,2),(377,20,'40',NULL,NULL,1),(378,20,'51',NULL,NULL,1),(379,20,'52',NULL,NULL,1),(380,20,'53',NULL,NULL,1),(381,20,'54',NULL,NULL,2),(382,20,'55',NULL,NULL,2),(383,20,'56',NULL,NULL,2),(384,20,'57',NULL,NULL,2),(385,20,'58',NULL,NULL,2),(386,20,'70',NULL,NULL,2),(387,20,'71',NULL,NULL,2),(388,20,'72',NULL,NULL,2),(389,20,'73',NULL,NULL,2),(390,20,'74',NULL,NULL,2),(391,20,'75',NULL,NULL,2),(392,20,'76',NULL,NULL,2),(393,20,'77',NULL,NULL,2),(394,20,'78',NULL,NULL,2),(395,20,'79',NULL,NULL,2),(396,20,'80',NULL,NULL,2),(397,20,'90',NULL,NULL,1),(398,20,'91',NULL,NULL,2),(399,20,'92',NULL,NULL,2),(400,20,'100',NULL,NULL,2),(401,20,'101',NULL,NULL,2),(402,20,'102',NULL,NULL,2),(403,20,'110',NULL,NULL,2),(404,20,'200',NULL,NULL,1),(405,20,'201',NULL,NULL,1),(406,20,'202',NULL,NULL,2),(407,20,'203',NULL,NULL,2),(408,20,'204',NULL,NULL,2),(409,20,'205',NULL,NULL,2),(410,20,'206',NULL,NULL,2),(411,20,'207',NULL,NULL,2),(412,20,'208',NULL,NULL,1),(413,20,'209',NULL,NULL,1),(414,20,'210',NULL,NULL,1),(415,20,'211',NULL,NULL,1),(416,20,'212',NULL,NULL,1),(417,20,'213',NULL,NULL,1),(418,20,'214',NULL,NULL,2),(419,20,'215',NULL,NULL,1),(420,20,'216',NULL,NULL,2),(421,20,'217',NULL,NULL,2),(422,20,'218',NULL,NULL,2),(423,20,'220',NULL,NULL,1),(424,20,'221',NULL,NULL,1),(425,20,'222',NULL,NULL,1),(426,20,'223',NULL,NULL,1),(427,20,'224',NULL,NULL,1),(428,20,'300',NULL,NULL,1),(429,20,'301',NULL,NULL,1),(430,20,'302',NULL,NULL,2),(431,20,'303',NULL,NULL,2),(432,20,'304',NULL,NULL,2),(433,20,'305',NULL,NULL,1),(434,20,'320',NULL,NULL,1),(435,20,'321',NULL,NULL,1),(436,20,'322',NULL,NULL,1),(437,20,'323',NULL,NULL,1),(438,20,'324',NULL,NULL,1),(439,20,'325',NULL,NULL,1),(440,20,'326',NULL,NULL,1),(441,20,'327',NULL,NULL,1),(442,20,'328',NULL,NULL,1),(443,20,'330',NULL,NULL,1),(444,20,'331',NULL,NULL,1),(445,20,'332',NULL,NULL,1),(446,20,'333',NULL,NULL,1),(447,20,'334',NULL,NULL,1),(448,20,'335',NULL,NULL,1),(449,20,'336',NULL,NULL,1),(450,20,'339',NULL,NULL,1),(451,20,'340',NULL,NULL,1),(452,20,'341',NULL,NULL,1),(453,20,'342',NULL,NULL,1),(454,20,'400',NULL,NULL,1),(455,20,'401',NULL,NULL,1),(456,20,'402',NULL,NULL,1),(457,20,'410',NULL,NULL,1),(458,20,'412',NULL,NULL,1),(459,20,'413',NULL,NULL,1),(460,20,'414',NULL,NULL,1),(461,20,'415',NULL,NULL,1),(462,20,'416',NULL,NULL,1),(463,20,'450',NULL,NULL,1),(464,20,'451',NULL,NULL,1),(465,20,'500',NULL,NULL,2),(466,20,'501',NULL,NULL,2),(467,20,'502',NULL,NULL,2),(468,20,'503',NULL,NULL,2),(469,20,'504',NULL,NULL,2),(470,20,'505',NULL,NULL,2),(471,20,'506',NULL,NULL,2),(472,20,'507',NULL,NULL,2),(473,20,'508',NULL,NULL,2),(474,20,'509',NULL,NULL,2),(475,20,'510',NULL,NULL,2),(476,20,'511',NULL,NULL,2),(477,21,'0',NULL,NULL,1),(478,21,'17',NULL,NULL,1),(479,21,'18',NULL,NULL,1),(480,21,'19',NULL,NULL,1),(481,21,'20',NULL,NULL,1),(482,21,'21',NULL,NULL,2),(483,21,'22',NULL,NULL,2),(484,21,'28',NULL,NULL,2),(485,21,'29',NULL,NULL,2),(486,21,'30',NULL,NULL,2),(487,21,'31',NULL,NULL,2),(488,21,'32',NULL,NULL,2),(489,21,'33',NULL,NULL,2),(490,21,'34',NULL,NULL,2),(491,21,'35',NULL,NULL,2),(492,21,'36',NULL,NULL,2),(493,21,'37',NULL,NULL,2),(494,21,'38',NULL,NULL,2),(495,21,'39',NULL,NULL,2),(496,21,'40',NULL,NULL,2),(497,21,'51',NULL,NULL,1),(498,21,'52',NULL,NULL,1),(499,21,'53',NULL,NULL,2),(500,21,'54',NULL,NULL,2),(501,21,'55',NULL,NULL,2),(502,21,'56',NULL,NULL,2),(503,21,'57',NULL,NULL,2),(504,21,'58',NULL,NULL,2),(505,21,'70',NULL,NULL,2),(506,21,'71',NULL,NULL,2),(507,21,'72',NULL,NULL,2),(508,21,'73',NULL,NULL,2),(509,21,'74',NULL,NULL,2),(510,21,'75',NULL,NULL,2),(511,21,'76',NULL,NULL,2),(512,21,'77',NULL,NULL,2),(513,21,'78',NULL,NULL,2),(514,21,'79',NULL,NULL,2),(515,21,'80',NULL,NULL,2),(516,21,'90',NULL,NULL,1),(517,21,'91',NULL,NULL,2),(518,21,'92',NULL,NULL,2),(519,21,'100',NULL,NULL,2),(520,21,'101',NULL,NULL,2),(521,21,'102',NULL,NULL,2),(522,21,'110',NULL,NULL,2),(523,21,'200',NULL,NULL,1),(524,21,'201',NULL,NULL,1),(525,21,'202',NULL,NULL,2),(526,21,'203',NULL,NULL,2),(527,21,'204',NULL,NULL,2),(528,21,'205',NULL,NULL,2),(529,21,'206',NULL,NULL,2),(530,21,'207',NULL,NULL,2),(531,21,'208',NULL,NULL,1),(532,21,'209',NULL,NULL,2),(533,21,'210',NULL,NULL,1),(534,21,'211',NULL,NULL,1),(535,21,'212',NULL,NULL,1),(536,21,'213',NULL,NULL,2),(537,21,'214',NULL,NULL,2),(538,21,'215',NULL,NULL,2),(539,21,'216',NULL,NULL,2),(540,21,'217',NULL,NULL,2),(541,21,'218',NULL,NULL,2),(542,21,'220',NULL,NULL,2),(543,21,'221',NULL,NULL,2),(544,21,'222',NULL,NULL,2),(545,21,'223',NULL,NULL,2),(546,21,'224',NULL,NULL,2),(547,21,'300',NULL,NULL,1),(548,21,'301',NULL,NULL,2),(549,21,'302',NULL,NULL,2),(550,21,'303',NULL,NULL,2),(551,21,'304',NULL,NULL,2),(552,21,'305',NULL,NULL,2),(553,21,'320',NULL,NULL,1),(554,21,'321',NULL,NULL,1),(555,21,'322',NULL,NULL,1),(556,21,'323',NULL,NULL,2),(557,21,'324',NULL,NULL,1),(558,21,'325',NULL,NULL,1),(559,21,'326',NULL,NULL,1),(560,21,'327',NULL,NULL,1),(561,21,'328',NULL,NULL,1),(562,21,'330',NULL,NULL,1),(563,21,'331',NULL,NULL,1),(564,21,'332',NULL,NULL,1),(565,21,'333',NULL,NULL,1),(566,21,'334',NULL,NULL,2),(567,21,'335',NULL,NULL,2),(568,21,'336',NULL,NULL,1),(569,21,'339',NULL,NULL,1),(570,21,'340',NULL,NULL,2),(571,21,'341',NULL,NULL,1),(572,21,'342',NULL,NULL,1),(573,21,'400',NULL,NULL,2),(574,21,'401',NULL,NULL,2),(575,21,'402',NULL,NULL,2),(576,21,'410',NULL,NULL,1),(577,21,'412',NULL,NULL,1),(578,21,'413',NULL,NULL,1),(579,21,'414',NULL,NULL,1),(580,21,'415',NULL,NULL,1),(581,21,'416',NULL,NULL,1),(582,21,'450',NULL,NULL,1),(583,21,'451',NULL,NULL,2),(584,21,'500',NULL,NULL,2),(585,21,'501',NULL,NULL,2),(586,21,'502',NULL,NULL,2),(587,21,'503',NULL,NULL,2),(588,21,'504',NULL,NULL,2),(589,21,'505',NULL,NULL,2),(590,21,'506',NULL,NULL,2),(591,21,'507',NULL,NULL,2),(592,21,'508',NULL,NULL,2),(593,21,'509',NULL,NULL,2),(594,21,'510',NULL,NULL,2),(595,21,'511',NULL,NULL,2),(596,24,'0',NULL,NULL,1),(597,24,'17',NULL,NULL,1),(598,24,'18',NULL,NULL,1),(599,24,'19',NULL,NULL,1),(600,24,'20',NULL,NULL,1),(601,24,'21',NULL,NULL,1),(602,24,'22',NULL,NULL,1),(603,24,'28',NULL,NULL,1),(604,24,'29',NULL,NULL,1),(605,24,'30',NULL,NULL,1),(606,24,'31',NULL,NULL,1),(607,24,'32',NULL,NULL,2),(608,24,'33',NULL,NULL,2),(609,24,'34',NULL,NULL,2),(610,24,'35',NULL,NULL,2),(611,24,'36',NULL,NULL,2),(612,24,'37',NULL,NULL,2),(613,24,'38',NULL,NULL,2),(614,24,'39',NULL,NULL,2),(615,24,'40',NULL,NULL,2),(616,24,'51',NULL,NULL,1),(617,24,'52',NULL,NULL,1),(618,24,'53',NULL,NULL,1),(619,24,'54',NULL,NULL,1),(620,24,'55',NULL,NULL,2),(621,24,'56',NULL,NULL,2),(622,24,'57',NULL,NULL,2),(623,24,'58',NULL,NULL,2),(624,24,'70',NULL,NULL,1),(625,24,'71',NULL,NULL,1),(626,24,'72',NULL,NULL,2),(627,24,'73',NULL,NULL,1),(628,24,'74',NULL,NULL,1),(629,24,'75',NULL,NULL,1),(630,24,'76',NULL,NULL,1),(631,24,'77',NULL,NULL,1),(632,24,'78',NULL,NULL,2),(633,24,'79',NULL,NULL,1),(634,24,'80',NULL,NULL,1),(635,24,'90',NULL,NULL,1),(636,24,'91',NULL,NULL,2),(637,24,'92',NULL,NULL,2),(638,24,'100',NULL,NULL,1),(639,24,'101',NULL,NULL,1),(640,24,'102',NULL,NULL,1),(641,24,'110',NULL,NULL,2),(642,24,'200',NULL,NULL,1),(643,24,'201',NULL,NULL,1),(644,24,'202',NULL,NULL,1),(645,24,'203',NULL,NULL,1),(646,24,'204',NULL,NULL,1),(647,24,'205',NULL,NULL,1),(648,24,'206',NULL,NULL,1),(649,24,'207',NULL,NULL,1),(650,24,'208',NULL,NULL,1),(651,24,'209',NULL,NULL,1),(652,24,'210',NULL,NULL,1),(653,24,'211',NULL,NULL,1),(654,24,'212',NULL,NULL,1),(655,24,'213',NULL,NULL,1),(656,24,'214',NULL,NULL,1),(657,24,'215',NULL,NULL,1),(658,24,'216',NULL,NULL,1),(659,24,'217',NULL,NULL,1),(660,24,'218',NULL,NULL,1),(661,24,'220',NULL,NULL,1),(662,24,'221',NULL,NULL,1),(663,24,'222',NULL,NULL,1),(664,24,'223',NULL,NULL,1),(665,24,'224',NULL,NULL,1),(666,24,'300',NULL,NULL,1),(667,24,'301',NULL,NULL,1),(668,24,'302',NULL,NULL,1),(669,24,'303',NULL,NULL,1),(670,24,'304',NULL,NULL,1),(671,24,'305',NULL,NULL,1),(672,24,'320',NULL,NULL,1),(673,24,'321',NULL,NULL,1),(674,24,'322',NULL,NULL,1),(675,24,'323',NULL,NULL,1),(676,24,'324',NULL,NULL,1),(677,24,'325',NULL,NULL,1),(678,24,'326',NULL,NULL,1),(679,24,'327',NULL,NULL,1),(680,24,'328',NULL,NULL,1),(681,24,'330',NULL,NULL,1),(682,24,'331',NULL,NULL,1),(683,24,'332',NULL,NULL,1),(684,24,'333',NULL,NULL,1),(685,24,'334',NULL,NULL,1),(686,24,'335',NULL,NULL,1),(687,24,'336',NULL,NULL,1),(688,24,'339',NULL,NULL,1),(689,24,'340',NULL,NULL,1),(690,24,'341',NULL,NULL,1),(691,24,'342',NULL,NULL,1),(692,24,'400',NULL,NULL,1),(693,24,'401',NULL,NULL,1),(694,24,'402',NULL,NULL,1),(695,24,'410',NULL,NULL,1),(696,24,'412',NULL,NULL,1),(697,24,'413',NULL,NULL,1),(698,24,'414',NULL,NULL,1),(699,24,'415',NULL,NULL,1),(700,24,'416',NULL,NULL,2),(701,24,'450',NULL,NULL,2),(702,24,'451',NULL,NULL,2),(703,24,'500',NULL,NULL,2),(704,24,'501',NULL,NULL,2),(705,24,'502',NULL,NULL,2),(706,24,'503',NULL,NULL,2),(707,24,'504',NULL,NULL,2),(708,24,'505',NULL,NULL,2),(709,24,'506',NULL,NULL,2),(710,24,'507',NULL,NULL,2),(711,24,'508',NULL,NULL,2),(712,24,'509',NULL,NULL,2),(713,24,'510',NULL,NULL,2),(714,24,'511',NULL,NULL,2),(715,25,'0',NULL,NULL,1),(716,25,'17',NULL,NULL,1),(717,25,'18',NULL,NULL,1),(718,25,'19',NULL,NULL,1),(719,25,'20',NULL,NULL,1),(720,25,'21',NULL,NULL,1),(721,25,'22',NULL,NULL,1),(722,25,'28',NULL,NULL,1),(723,25,'29',NULL,NULL,1),(724,25,'30',NULL,NULL,1),(725,25,'31',NULL,NULL,1),(726,25,'32',NULL,NULL,1),(727,25,'33',NULL,NULL,2),(728,25,'34',NULL,NULL,2),(729,25,'35',NULL,NULL,2),(730,25,'36',NULL,NULL,2),(731,25,'37',NULL,NULL,2),(732,25,'38',NULL,NULL,2),(733,25,'39',NULL,NULL,2),(734,25,'40',NULL,NULL,2),(735,25,'51',NULL,NULL,1),(736,25,'52',NULL,NULL,1),(737,25,'53',NULL,NULL,1),(738,25,'54',NULL,NULL,1),(739,25,'55',NULL,NULL,2),(740,25,'56',NULL,NULL,2),(741,25,'57',NULL,NULL,2),(742,25,'58',NULL,NULL,2),(743,25,'70',NULL,NULL,1),(744,25,'71',NULL,NULL,1),(745,25,'72',NULL,NULL,2),(746,25,'73',NULL,NULL,1),(747,25,'74',NULL,NULL,1),(748,25,'75',NULL,NULL,1),(749,25,'76',NULL,NULL,1),(750,25,'77',NULL,NULL,1),(751,25,'78',NULL,NULL,2),(752,25,'79',NULL,NULL,1),(753,25,'80',NULL,NULL,1),(754,25,'90',NULL,NULL,1),(755,25,'91',NULL,NULL,1),(756,25,'92',NULL,NULL,1),(757,25,'100',NULL,NULL,1),(758,25,'101',NULL,NULL,1),(759,25,'102',NULL,NULL,1),(760,25,'110',NULL,NULL,1),(761,25,'200',NULL,NULL,1),(762,25,'201',NULL,NULL,1),(763,25,'202',NULL,NULL,1),(764,25,'203',NULL,NULL,1),(765,25,'204',NULL,NULL,1),(766,25,'205',NULL,NULL,1),(767,25,'206',NULL,NULL,1),(768,25,'207',NULL,NULL,1),(769,25,'208',NULL,NULL,1),(770,25,'209',NULL,NULL,1),(771,25,'210',NULL,NULL,1),(772,25,'211',NULL,NULL,1),(773,25,'212',NULL,NULL,1),(774,25,'213',NULL,NULL,1),(775,25,'214',NULL,NULL,1),(776,25,'215',NULL,NULL,1),(777,25,'216',NULL,NULL,1),(778,25,'217',NULL,NULL,1),(779,25,'218',NULL,NULL,1),(780,25,'220',NULL,NULL,1),(781,25,'221',NULL,NULL,1),(782,25,'222',NULL,NULL,1),(783,25,'223',NULL,NULL,1),(784,25,'224',NULL,NULL,1),(785,25,'300',NULL,NULL,1),(786,25,'301',NULL,NULL,1),(787,25,'302',NULL,NULL,1),(788,25,'303',NULL,NULL,1),(789,25,'304',NULL,NULL,1),(790,25,'305',NULL,NULL,1),(791,25,'320',NULL,NULL,1),(792,25,'321',NULL,NULL,1),(793,25,'322',NULL,NULL,1),(794,25,'323',NULL,NULL,1),(795,25,'324',NULL,NULL,1),(796,25,'325',NULL,NULL,1),(797,25,'326',NULL,NULL,1),(798,25,'327',NULL,NULL,1),(799,25,'328',NULL,NULL,1),(800,25,'330',NULL,NULL,1),(801,25,'331',NULL,NULL,1),(802,25,'332',NULL,NULL,1),(803,25,'333',NULL,NULL,1),(804,25,'334',NULL,NULL,1),(805,25,'335',NULL,NULL,1),(806,25,'336',NULL,NULL,1),(807,25,'339',NULL,NULL,1),(808,25,'340',NULL,NULL,1),(809,25,'341',NULL,NULL,1),(810,25,'342',NULL,NULL,1),(811,25,'400',NULL,NULL,1),(812,25,'401',NULL,NULL,1),(813,25,'402',NULL,NULL,1),(814,25,'410',NULL,NULL,1),(815,25,'412',NULL,NULL,1),(816,25,'413',NULL,NULL,1),(817,25,'414',NULL,NULL,1),(818,25,'415',NULL,NULL,1),(819,25,'416',NULL,NULL,2),(820,25,'450',NULL,NULL,2),(821,25,'451',NULL,NULL,2),(822,25,'500',NULL,NULL,2),(823,25,'501',NULL,NULL,2),(824,25,'502',NULL,NULL,2),(825,25,'503',NULL,NULL,2),(826,25,'504',NULL,NULL,2),(827,25,'505',NULL,NULL,2),(828,25,'506',NULL,NULL,2),(829,25,'507',NULL,NULL,2),(830,25,'508',NULL,NULL,2),(831,25,'509',NULL,NULL,2),(832,25,'510',NULL,NULL,2),(833,25,'511',NULL,NULL,2),(834,26,'0',NULL,NULL,1),(835,26,'17',NULL,NULL,1),(836,26,'18',NULL,NULL,1),(837,26,'19',NULL,NULL,1),(838,26,'20',NULL,NULL,1),(839,26,'21',NULL,NULL,1),(840,26,'22',NULL,NULL,1),(841,26,'28',NULL,NULL,1),(842,26,'29',NULL,NULL,1),(843,26,'30',NULL,NULL,1),(844,26,'31',NULL,NULL,1),(845,26,'32',NULL,NULL,1),(846,26,'33',NULL,NULL,2),(847,26,'34',NULL,NULL,2),(848,26,'35',NULL,NULL,2),(849,26,'36',NULL,NULL,2),(850,26,'37',NULL,NULL,2),(851,26,'38',NULL,NULL,2),(852,26,'39',NULL,NULL,2),(853,26,'40',NULL,NULL,2),(854,26,'51',NULL,NULL,1),(855,26,'52',NULL,NULL,1),(856,26,'53',NULL,NULL,1),(857,26,'54',NULL,NULL,1),(858,26,'55',NULL,NULL,1),(859,26,'56',NULL,NULL,1),(860,26,'57',NULL,NULL,1),(861,26,'58',NULL,NULL,1),(862,26,'70',NULL,NULL,1),(863,26,'71',NULL,NULL,1),(864,26,'72',NULL,NULL,1),(865,26,'73',NULL,NULL,1),(866,26,'74',NULL,NULL,1),(867,26,'75',NULL,NULL,1),(868,26,'76',NULL,NULL,1),(869,26,'77',NULL,NULL,1),(870,26,'78',NULL,NULL,2),(871,26,'79',NULL,NULL,1),(872,26,'80',NULL,NULL,1),(873,26,'90',NULL,NULL,1),(874,26,'91',NULL,NULL,2),(875,26,'92',NULL,NULL,1),(876,26,'100',NULL,NULL,1),(877,26,'101',NULL,NULL,1),(878,26,'102',NULL,NULL,1),(879,26,'110',NULL,NULL,1),(880,26,'200',NULL,NULL,1),(881,26,'201',NULL,NULL,1),(882,26,'202',NULL,NULL,1),(883,26,'203',NULL,NULL,1),(884,26,'204',NULL,NULL,1),(885,26,'205',NULL,NULL,1),(886,26,'206',NULL,NULL,1),(887,26,'207',NULL,NULL,1),(888,26,'208',NULL,NULL,1),(889,26,'209',NULL,NULL,1),(890,26,'210',NULL,NULL,1),(891,26,'211',NULL,NULL,1),(892,26,'212',NULL,NULL,1),(893,26,'213',NULL,NULL,1),(894,26,'214',NULL,NULL,1),(895,26,'215',NULL,NULL,1),(896,26,'216',NULL,NULL,1),(897,26,'217',NULL,NULL,1),(898,26,'218',NULL,NULL,1),(899,26,'220',NULL,NULL,1),(900,26,'221',NULL,NULL,1),(901,26,'222',NULL,NULL,1),(902,26,'223',NULL,NULL,1),(903,26,'224',NULL,NULL,1),(904,26,'300',NULL,NULL,1),(905,26,'301',NULL,NULL,1),(906,26,'302',NULL,NULL,1),(907,26,'303',NULL,NULL,1),(908,26,'304',NULL,NULL,1),(909,26,'305',NULL,NULL,1),(910,26,'320',NULL,NULL,1),(911,26,'321',NULL,NULL,1),(912,26,'322',NULL,NULL,1),(913,26,'323',NULL,NULL,1),(914,26,'324',NULL,NULL,1),(915,26,'325',NULL,NULL,1),(916,26,'326',NULL,NULL,1),(917,26,'327',NULL,NULL,1),(918,26,'328',NULL,NULL,1),(919,26,'330',NULL,NULL,1),(920,26,'331',NULL,NULL,1),(921,26,'332',NULL,NULL,1),(922,26,'333',NULL,NULL,1),(923,26,'334',NULL,NULL,1),(924,26,'335',NULL,NULL,1),(925,26,'336',NULL,NULL,1),(926,26,'339',NULL,NULL,1),(927,26,'340',NULL,NULL,1),(928,26,'341',NULL,NULL,1),(929,26,'342',NULL,NULL,1),(930,26,'400',NULL,NULL,1),(931,26,'401',NULL,NULL,1),(932,26,'402',NULL,NULL,1),(933,26,'410',NULL,NULL,2),(934,26,'412',NULL,NULL,2),(935,26,'413',NULL,NULL,2),(936,26,'414',NULL,NULL,2),(937,26,'415',NULL,NULL,2),(938,26,'416',NULL,NULL,2),(939,26,'450',NULL,NULL,2),(940,26,'451',NULL,NULL,2),(941,26,'500',NULL,NULL,1),(942,26,'501',NULL,NULL,1),(943,26,'502',NULL,NULL,1),(944,26,'503',NULL,NULL,1),(945,26,'504',NULL,NULL,1),(946,26,'505',NULL,NULL,1),(947,26,'506',NULL,NULL,1),(948,26,'507',NULL,NULL,1),(949,26,'508',NULL,NULL,1),(950,26,'509',NULL,NULL,1),(951,26,'510',NULL,NULL,1),(952,26,'511',NULL,NULL,1),(953,29,'0',NULL,NULL,1),(954,29,'17',NULL,NULL,1),(955,29,'18',NULL,NULL,1),(956,29,'19',NULL,NULL,1),(957,29,'20',NULL,NULL,1),(958,29,'21',NULL,NULL,1),(959,29,'22',NULL,NULL,1),(960,29,'28',NULL,NULL,1),(961,29,'29',NULL,NULL,1),(962,29,'30',NULL,NULL,1),(963,29,'31',NULL,NULL,1),(964,29,'32',NULL,NULL,1),(965,29,'33',NULL,NULL,1),(966,29,'34',NULL,NULL,1),(967,29,'35',NULL,NULL,1),(968,29,'36',NULL,NULL,1),(969,29,'37',NULL,NULL,1),(970,29,'38',NULL,NULL,1),(971,29,'39',NULL,NULL,1),(972,29,'40',NULL,NULL,1),(973,29,'51',NULL,NULL,1),(974,29,'52',NULL,NULL,1),(975,29,'53',NULL,NULL,1),(976,29,'54',NULL,NULL,1),(977,29,'55',NULL,NULL,1),(978,29,'56',NULL,NULL,1),(979,29,'57',NULL,NULL,1),(980,29,'58',NULL,NULL,1),(981,29,'70',NULL,NULL,1),(982,29,'71',NULL,NULL,1),(983,29,'72',NULL,NULL,1),(984,29,'73',NULL,NULL,1),(985,29,'74',NULL,NULL,1),(986,29,'75',NULL,NULL,1),(987,29,'76',NULL,NULL,1),(988,29,'77',NULL,NULL,1),(989,29,'78',NULL,NULL,1),(990,29,'79',NULL,NULL,1),(991,29,'80',NULL,NULL,1),(992,29,'90',NULL,NULL,1),(993,29,'91',NULL,NULL,1),(994,29,'92',NULL,NULL,1),(995,29,'100',NULL,NULL,1),(996,29,'101',NULL,NULL,1),(997,29,'102',NULL,NULL,1),(998,29,'110',NULL,NULL,1),(999,29,'200',NULL,NULL,1),(1000,29,'201',NULL,NULL,1),(1001,29,'202',NULL,NULL,1),(1002,29,'203',NULL,NULL,1),(1003,29,'204',NULL,NULL,1),(1004,29,'205',NULL,NULL,1),(1005,29,'206',NULL,NULL,1),(1006,29,'207',NULL,NULL,1),(1007,29,'208',NULL,NULL,1),(1008,29,'209',NULL,NULL,1),(1009,29,'210',NULL,NULL,1),(1010,29,'211',NULL,NULL,1),(1011,29,'212',NULL,NULL,1),(1012,29,'213',NULL,NULL,1),(1013,29,'214',NULL,NULL,1),(1014,29,'215',NULL,NULL,1),(1015,29,'216',NULL,NULL,1),(1016,29,'217',NULL,NULL,1),(1017,29,'218',NULL,NULL,1),(1018,29,'220',NULL,NULL,1),(1019,29,'221',NULL,NULL,1),(1020,29,'222',NULL,NULL,1),(1021,29,'223',NULL,NULL,1),(1022,29,'224',NULL,NULL,1),(1023,29,'300',NULL,NULL,1),(1024,29,'301',NULL,NULL,1),(1025,29,'302',NULL,NULL,1),(1026,29,'303',NULL,NULL,1),(1027,29,'304',NULL,NULL,1),(1028,29,'305',NULL,NULL,1),(1029,29,'320',NULL,NULL,1),(1030,29,'321',NULL,NULL,1),(1031,29,'322',NULL,NULL,1),(1032,29,'323',NULL,NULL,1),(1033,29,'324',NULL,NULL,1),(1034,29,'325',NULL,NULL,1),(1035,29,'326',NULL,NULL,1),(1036,29,'327',NULL,NULL,1),(1037,29,'328',NULL,NULL,1),(1038,29,'330',NULL,NULL,1),(1039,29,'331',NULL,NULL,1),(1040,29,'332',NULL,NULL,1),(1041,29,'333',NULL,NULL,1),(1042,29,'334',NULL,NULL,1),(1043,29,'335',NULL,NULL,1),(1044,29,'336',NULL,NULL,1),(1045,29,'339',NULL,NULL,1),(1046,29,'340',NULL,NULL,1),(1047,29,'341',NULL,NULL,1),(1048,29,'342',NULL,NULL,1),(1049,29,'400',NULL,NULL,1),(1050,29,'401',NULL,NULL,1),(1051,29,'402',NULL,NULL,1),(1052,29,'410',NULL,NULL,1),(1053,29,'412',NULL,NULL,1),(1054,29,'413',NULL,NULL,1),(1055,29,'414',NULL,NULL,1),(1056,29,'415',NULL,NULL,1),(1057,29,'416',NULL,NULL,1),(1058,29,'450',NULL,NULL,1),(1059,29,'451',NULL,NULL,1),(1060,29,'500',NULL,NULL,1),(1061,29,'501',NULL,NULL,1),(1062,29,'502',NULL,NULL,1),(1063,29,'503',NULL,NULL,1),(1064,29,'504',NULL,NULL,1),(1065,29,'505',NULL,NULL,1),(1066,29,'506',NULL,NULL,1),(1067,29,'507',NULL,NULL,1),(1068,29,'508',NULL,NULL,1),(1069,29,'509',NULL,NULL,1),(1070,29,'510',NULL,NULL,1),(1071,29,'511',NULL,NULL,1),(1072,12,'0',NULL,NULL,1),(1073,12,'17',NULL,NULL,1),(1074,12,'18',NULL,NULL,1),(1075,12,'19',NULL,NULL,1),(1076,12,'20',NULL,NULL,1),(1077,12,'21',NULL,NULL,1),(1078,12,'22',NULL,NULL,1),(1079,12,'28',NULL,NULL,1),(1080,12,'29',NULL,NULL,1),(1081,12,'30',NULL,NULL,1),(1082,12,'31',NULL,NULL,1),(1083,12,'32',NULL,NULL,1),(1084,12,'33',NULL,NULL,2),(1085,12,'34',NULL,NULL,2),(1086,12,'35',NULL,NULL,2),(1087,12,'36',NULL,NULL,2),(1088,12,'37',NULL,NULL,1),(1089,12,'38',NULL,NULL,1),(1090,12,'39',NULL,NULL,2),(1091,12,'40',NULL,NULL,2),(1092,12,'51',NULL,NULL,1),(1093,12,'52',NULL,NULL,1),(1094,12,'53',NULL,NULL,1),(1095,12,'54',NULL,NULL,1),(1096,12,'55',NULL,NULL,1),(1097,12,'56',NULL,NULL,1),(1098,12,'57',NULL,NULL,1),(1099,12,'58',NULL,NULL,1),(1100,12,'70',NULL,NULL,1),(1101,12,'71',NULL,NULL,2),(1102,12,'72',NULL,NULL,2),(1103,12,'73',NULL,NULL,2),(1104,12,'74',NULL,NULL,2),(1105,12,'75',NULL,NULL,2),(1106,12,'76',NULL,NULL,2),(1107,12,'77',NULL,NULL,2),(1108,12,'78',NULL,NULL,2),(1109,12,'79',NULL,NULL,2),(1110,12,'80',NULL,NULL,2),(1111,12,'90',NULL,NULL,1),(1112,12,'91',NULL,NULL,1),(1113,12,'92',NULL,NULL,1),(1114,12,'100',NULL,NULL,1),(1115,12,'101',NULL,NULL,1),(1116,12,'102',NULL,NULL,1),(1117,12,'110',NULL,NULL,1),(1118,12,'200',NULL,NULL,2),(1119,12,'201',NULL,NULL,2),(1120,12,'202',NULL,NULL,2),(1121,12,'203',NULL,NULL,2),(1122,12,'204',NULL,NULL,2),(1123,12,'205',NULL,NULL,2),(1124,12,'206',NULL,NULL,2),(1125,12,'207',NULL,NULL,2),(1126,12,'208',NULL,NULL,2),(1127,12,'209',NULL,NULL,2),(1128,12,'210',NULL,NULL,2),(1129,12,'211',NULL,NULL,2),(1130,12,'212',NULL,NULL,2),(1131,12,'213',NULL,NULL,2),(1132,12,'214',NULL,NULL,2),(1133,12,'215',NULL,NULL,2),(1134,12,'216',NULL,NULL,2),(1135,12,'217',NULL,NULL,2),(1136,12,'218',NULL,NULL,2),(1137,12,'220',NULL,NULL,2),(1138,12,'221',NULL,NULL,2),(1139,12,'222',NULL,NULL,2),(1140,12,'223',NULL,NULL,2),(1141,12,'224',NULL,NULL,2),(1142,12,'300',NULL,NULL,1),(1143,12,'301',NULL,NULL,2),(1144,12,'302',NULL,NULL,2),(1145,12,'303',NULL,NULL,2),(1146,12,'304',NULL,NULL,2),(1147,12,'305',NULL,NULL,2),(1148,12,'320',NULL,NULL,2),(1149,12,'321',NULL,NULL,2),(1150,12,'322',NULL,NULL,2),(1151,12,'323',NULL,NULL,2),(1152,12,'324',NULL,NULL,2),(1153,12,'325',NULL,NULL,2),(1154,12,'326',NULL,NULL,2),(1155,12,'327',NULL,NULL,1),(1156,12,'328',NULL,NULL,1),(1157,12,'330',NULL,NULL,1),(1158,12,'331',NULL,NULL,1),(1159,12,'332',NULL,NULL,2),(1160,12,'333',NULL,NULL,2),(1161,12,'334',NULL,NULL,2),(1162,12,'335',NULL,NULL,2),(1163,12,'336',NULL,NULL,1),(1164,12,'339',NULL,NULL,2),(1165,12,'340',NULL,NULL,2),(1166,12,'341',NULL,NULL,1),(1167,12,'342',NULL,NULL,1),(1168,12,'400',NULL,NULL,2),(1169,12,'401',NULL,NULL,2),(1170,12,'402',NULL,NULL,2),(1171,12,'410',NULL,NULL,1),(1172,12,'412',NULL,NULL,1),(1173,12,'413',NULL,NULL,2),(1174,12,'414',NULL,NULL,1),(1175,12,'415',NULL,NULL,2),(1176,12,'416',NULL,NULL,2),(1177,12,'450',NULL,NULL,2),(1178,12,'451',NULL,NULL,2),(1179,12,'500',NULL,NULL,2),(1180,12,'501',NULL,NULL,2),(1181,12,'502',NULL,NULL,2),(1182,12,'503',NULL,NULL,2),(1183,12,'504',NULL,NULL,2),(1184,12,'505',NULL,NULL,2),(1185,12,'506',NULL,NULL,2),(1186,12,'507',NULL,NULL,2),(1187,12,'508',NULL,NULL,2),(1188,12,'509',NULL,NULL,2),(1189,12,'510',NULL,NULL,2),(1190,12,'511',NULL,NULL,2),(1191,23,'0',NULL,NULL,1),(1192,23,'17',NULL,NULL,1),(1193,23,'18',NULL,NULL,1),(1194,23,'19',NULL,NULL,1),(1195,23,'20',NULL,NULL,1),(1196,23,'21',NULL,NULL,1),(1197,23,'22',NULL,NULL,1),(1198,23,'28',NULL,NULL,2),(1199,23,'29',NULL,NULL,1),(1200,23,'30',NULL,NULL,2),(1201,23,'31',NULL,NULL,2),(1202,23,'32',NULL,NULL,2),(1203,23,'33',NULL,NULL,2),(1204,23,'34',NULL,NULL,2),(1205,23,'35',NULL,NULL,2),(1206,23,'36',NULL,NULL,2),(1207,23,'37',NULL,NULL,2),(1208,23,'38',NULL,NULL,2),(1209,23,'39',NULL,NULL,2),(1210,23,'40',NULL,NULL,2),(1211,23,'51',NULL,NULL,1),(1212,23,'52',NULL,NULL,1),(1213,23,'53',NULL,NULL,1),(1214,23,'54',NULL,NULL,2),(1215,23,'55',NULL,NULL,2),(1216,23,'56',NULL,NULL,2),(1217,23,'57',NULL,NULL,2),(1218,23,'58',NULL,NULL,2),(1219,23,'70',NULL,NULL,1),(1220,23,'71',NULL,NULL,2),(1221,23,'72',NULL,NULL,2),(1222,23,'73',NULL,NULL,2),(1223,23,'74',NULL,NULL,2),(1224,23,'75',NULL,NULL,2),(1225,23,'76',NULL,NULL,2),(1226,23,'77',NULL,NULL,2),(1227,23,'78',NULL,NULL,2),(1228,23,'79',NULL,NULL,2),(1229,23,'80',NULL,NULL,2),(1230,23,'90',NULL,NULL,1),(1231,23,'91',NULL,NULL,2),(1232,23,'92',NULL,NULL,2),(1233,23,'100',NULL,NULL,2),(1234,23,'101',NULL,NULL,2),(1235,23,'102',NULL,NULL,2),(1236,23,'110',NULL,NULL,2),(1237,23,'200',NULL,NULL,2),(1238,23,'201',NULL,NULL,1),(1239,23,'202',NULL,NULL,2),(1240,23,'203',NULL,NULL,2),(1241,23,'204',NULL,NULL,2),(1242,23,'205',NULL,NULL,2),(1243,23,'206',NULL,NULL,2),(1244,23,'207',NULL,NULL,2),(1245,23,'208',NULL,NULL,2),(1246,23,'209',NULL,NULL,2),(1247,23,'210',NULL,NULL,2),(1248,23,'211',NULL,NULL,2),(1249,23,'212',NULL,NULL,2),(1250,23,'213',NULL,NULL,2),(1251,23,'214',NULL,NULL,2),(1252,23,'215',NULL,NULL,2),(1253,23,'216',NULL,NULL,2),(1254,23,'217',NULL,NULL,2),(1255,23,'218',NULL,NULL,2),(1256,23,'220',NULL,NULL,2),(1257,23,'221',NULL,NULL,2),(1258,23,'222',NULL,NULL,2),(1259,23,'223',NULL,NULL,2),(1260,23,'224',NULL,NULL,2),(1261,23,'300',NULL,NULL,2),(1262,23,'301',NULL,NULL,2),(1263,23,'302',NULL,NULL,2),(1264,23,'303',NULL,NULL,2),(1265,23,'304',NULL,NULL,2),(1266,23,'305',NULL,NULL,2),(1267,23,'320',NULL,NULL,2),(1268,23,'321',NULL,NULL,2),(1269,23,'322',NULL,NULL,2),(1270,23,'323',NULL,NULL,2),(1271,23,'324',NULL,NULL,2),(1272,23,'325',NULL,NULL,2),(1273,23,'326',NULL,NULL,2),(1274,23,'327',NULL,NULL,2),(1275,23,'328',NULL,NULL,2),(1276,23,'330',NULL,NULL,2),(1277,23,'331',NULL,NULL,2),(1278,23,'332',NULL,NULL,2),(1279,23,'333',NULL,NULL,2),(1280,23,'334',NULL,NULL,2),(1281,23,'335',NULL,NULL,2),(1282,23,'336',NULL,NULL,2),(1283,23,'339',NULL,NULL,2),(1284,23,'340',NULL,NULL,2),(1285,23,'341',NULL,NULL,2),(1286,23,'342',NULL,NULL,2),(1287,23,'400',NULL,NULL,2),(1288,23,'401',NULL,NULL,2),(1289,23,'402',NULL,NULL,2),(1290,23,'410',NULL,NULL,2),(1291,23,'412',NULL,NULL,2),(1292,23,'413',NULL,NULL,2),(1293,23,'414',NULL,NULL,2),(1294,23,'415',NULL,NULL,2),(1295,23,'416',NULL,NULL,2),(1296,23,'450',NULL,NULL,2),(1297,23,'451',NULL,NULL,2),(1298,23,'500',NULL,NULL,2),(1299,23,'501',NULL,NULL,2),(1300,23,'502',NULL,NULL,2),(1301,23,'503',NULL,NULL,2),(1302,23,'504',NULL,NULL,2),(1303,23,'505',NULL,NULL,2),(1304,23,'506',NULL,NULL,2),(1305,23,'507',NULL,NULL,2),(1306,23,'508',NULL,NULL,2),(1307,23,'509',NULL,NULL,2),(1308,23,'510',NULL,NULL,2),(1309,23,'511',NULL,NULL,2),(1310,30,'0',NULL,NULL,1),(1311,30,'17',NULL,NULL,1),(1312,30,'18',NULL,NULL,1),(1313,30,'19',NULL,NULL,1),(1314,30,'20',NULL,NULL,1),(1315,30,'21',NULL,NULL,1),(1316,30,'22',NULL,NULL,1),(1317,30,'28',NULL,NULL,1),(1318,30,'29',NULL,NULL,1),(1319,30,'30',NULL,NULL,2),(1320,30,'31',NULL,NULL,2),(1321,30,'32',NULL,NULL,2),(1322,30,'33',NULL,NULL,2),(1323,30,'34',NULL,NULL,2),(1324,30,'35',NULL,NULL,2),(1325,30,'36',NULL,NULL,2),(1326,30,'37',NULL,NULL,2),(1327,30,'38',NULL,NULL,2),(1328,30,'39',NULL,NULL,2),(1329,30,'40',NULL,NULL,2),(1330,30,'51',NULL,NULL,1),(1331,30,'52',NULL,NULL,1),(1332,30,'53',NULL,NULL,1),(1333,30,'54',NULL,NULL,2),(1334,30,'55',NULL,NULL,2),(1335,30,'56',NULL,NULL,2),(1336,30,'57',NULL,NULL,2),(1337,30,'58',NULL,NULL,2),(1338,30,'70',NULL,NULL,1),(1339,30,'71',NULL,NULL,1),(1340,30,'72',NULL,NULL,2),(1341,30,'73',NULL,NULL,2),(1342,30,'74',NULL,NULL,2),(1343,30,'75',NULL,NULL,1),(1344,30,'76',NULL,NULL,2),(1345,30,'77',NULL,NULL,2),(1346,30,'78',NULL,NULL,1),(1347,30,'79',NULL,NULL,1),(1348,30,'80',NULL,NULL,2),(1349,30,'90',NULL,NULL,1),(1350,30,'91',NULL,NULL,1),(1351,30,'92',NULL,NULL,1),(1352,30,'100',NULL,NULL,1),(1353,30,'101',NULL,NULL,1),(1354,30,'102',NULL,NULL,1),(1355,30,'110',NULL,NULL,1),(1356,30,'200',NULL,NULL,1),(1357,30,'201',NULL,NULL,1),(1358,30,'202',NULL,NULL,1),(1359,30,'203',NULL,NULL,2),(1360,30,'204',NULL,NULL,2),(1361,30,'205',NULL,NULL,2),(1362,30,'206',NULL,NULL,2),(1363,30,'207',NULL,NULL,1),(1364,30,'208',NULL,NULL,1),(1365,30,'209',NULL,NULL,1),(1366,30,'210',NULL,NULL,1),(1367,30,'211',NULL,NULL,1),(1368,30,'212',NULL,NULL,1),(1369,30,'213',NULL,NULL,2),(1370,30,'214',NULL,NULL,2),(1371,30,'215',NULL,NULL,2),(1372,30,'216',NULL,NULL,2),(1373,30,'217',NULL,NULL,2),(1374,30,'218',NULL,NULL,2),(1375,30,'220',NULL,NULL,2),(1376,30,'221',NULL,NULL,2),(1377,30,'222',NULL,NULL,2),(1378,30,'223',NULL,NULL,2),(1379,30,'224',NULL,NULL,2),(1380,30,'300',NULL,NULL,2),(1381,30,'301',NULL,NULL,1),(1382,30,'302',NULL,NULL,2),(1383,30,'303',NULL,NULL,2),(1384,30,'304',NULL,NULL,2),(1385,30,'305',NULL,NULL,1),(1386,30,'320',NULL,NULL,2),(1387,30,'321',NULL,NULL,2),(1388,30,'322',NULL,NULL,2),(1389,30,'323',NULL,NULL,2),(1390,30,'324',NULL,NULL,2),(1391,30,'325',NULL,NULL,2),(1392,30,'326',NULL,NULL,2),(1393,30,'327',NULL,NULL,1),(1394,30,'328',NULL,NULL,1),(1395,30,'330',NULL,NULL,1),(1396,30,'331',NULL,NULL,1),(1397,30,'332',NULL,NULL,1),(1398,30,'333',NULL,NULL,1),(1399,30,'334',NULL,NULL,1),(1400,30,'335',NULL,NULL,1),(1401,30,'336',NULL,NULL,1),(1402,30,'339',NULL,NULL,1),(1403,30,'340',NULL,NULL,1),(1404,30,'341',NULL,NULL,1),(1405,30,'342',NULL,NULL,1),(1406,30,'400',NULL,NULL,1),(1407,30,'401',NULL,NULL,1),(1408,30,'402',NULL,NULL,1),(1409,30,'410',NULL,NULL,1),(1410,30,'412',NULL,NULL,1),(1411,30,'413',NULL,NULL,1),(1412,30,'414',NULL,NULL,1),(1413,30,'415',NULL,NULL,1),(1414,30,'416',NULL,NULL,1),(1415,30,'450',NULL,NULL,1),(1416,30,'451',NULL,NULL,1),(1417,30,'500',NULL,NULL,2),(1418,30,'501',NULL,NULL,2),(1419,30,'502',NULL,NULL,2),(1420,30,'503',NULL,NULL,2),(1421,30,'504',NULL,NULL,2),(1422,30,'505',NULL,NULL,2),(1423,30,'506',NULL,NULL,2),(1424,30,'507',NULL,NULL,2),(1425,30,'508',NULL,NULL,2),(1426,30,'509',NULL,NULL,2),(1427,30,'510',NULL,NULL,2),(1428,30,'511',NULL,NULL,2),(1429,32,'0',NULL,NULL,1),(1430,32,'17',NULL,NULL,1),(1431,32,'18',NULL,NULL,1),(1432,32,'19',NULL,NULL,1),(1433,32,'20',NULL,NULL,1),(1434,32,'21',NULL,NULL,1),(1435,32,'22',NULL,NULL,1),(1436,32,'28',NULL,NULL,1),(1437,32,'29',NULL,NULL,1),(1438,32,'30',NULL,NULL,1),(1439,32,'31',NULL,NULL,1),(1440,32,'32',NULL,NULL,1),(1441,32,'33',NULL,NULL,2),(1442,32,'34',NULL,NULL,2),(1443,32,'35',NULL,NULL,2),(1444,32,'36',NULL,NULL,2),(1445,32,'37',NULL,NULL,2),(1446,32,'38',NULL,NULL,2),(1447,32,'39',NULL,NULL,2),(1448,32,'40',NULL,NULL,2),(1449,32,'51',NULL,NULL,1),(1450,32,'52',NULL,NULL,1),(1451,32,'53',NULL,NULL,1),(1452,32,'54',NULL,NULL,1),(1453,32,'55',NULL,NULL,1),(1454,32,'56',NULL,NULL,1),(1455,32,'57',NULL,NULL,2),(1456,32,'58',NULL,NULL,2),(1457,32,'70',NULL,NULL,1),(1458,32,'71',NULL,NULL,1),(1459,32,'72',NULL,NULL,1),(1460,32,'73',NULL,NULL,1),(1461,32,'74',NULL,NULL,1),(1462,32,'75',NULL,NULL,1),(1463,32,'76',NULL,NULL,1),(1464,32,'77',NULL,NULL,1),(1465,32,'78',NULL,NULL,2),(1466,32,'79',NULL,NULL,1),(1467,32,'80',NULL,NULL,1),(1468,32,'90',NULL,NULL,1),(1469,32,'91',NULL,NULL,2),(1470,32,'92',NULL,NULL,2),(1471,32,'100',NULL,NULL,1),(1472,32,'101',NULL,NULL,1),(1473,32,'102',NULL,NULL,1),(1474,32,'110',NULL,NULL,1),(1475,32,'200',NULL,NULL,1),(1476,32,'201',NULL,NULL,1),(1477,32,'202',NULL,NULL,1),(1478,32,'203',NULL,NULL,1),(1479,32,'204',NULL,NULL,1),(1480,32,'205',NULL,NULL,1),(1481,32,'206',NULL,NULL,1),(1482,32,'207',NULL,NULL,1),(1483,32,'208',NULL,NULL,1),(1484,32,'209',NULL,NULL,1),(1485,32,'210',NULL,NULL,1),(1486,32,'211',NULL,NULL,1),(1487,32,'212',NULL,NULL,1),(1488,32,'213',NULL,NULL,1),(1489,32,'214',NULL,NULL,1),(1490,32,'215',NULL,NULL,1),(1491,32,'216',NULL,NULL,1),(1492,32,'217',NULL,NULL,1),(1493,32,'218',NULL,NULL,1),(1494,32,'220',NULL,NULL,1),(1495,32,'221',NULL,NULL,1),(1496,32,'222',NULL,NULL,1),(1497,32,'223',NULL,NULL,1),(1498,32,'224',NULL,NULL,1),(1499,32,'300',NULL,NULL,1),(1500,32,'301',NULL,NULL,1),(1501,32,'302',NULL,NULL,1),(1502,32,'303',NULL,NULL,1),(1503,32,'304',NULL,NULL,1),(1504,32,'305',NULL,NULL,1),(1505,32,'320',NULL,NULL,1),(1506,32,'321',NULL,NULL,1),(1507,32,'322',NULL,NULL,1),(1508,32,'323',NULL,NULL,1),(1509,32,'324',NULL,NULL,1),(1510,32,'325',NULL,NULL,1),(1511,32,'326',NULL,NULL,1),(1512,32,'327',NULL,NULL,1),(1513,32,'328',NULL,NULL,1),(1514,32,'330',NULL,NULL,1),(1515,32,'331',NULL,NULL,1),(1516,32,'332',NULL,NULL,1),(1517,32,'333',NULL,NULL,1),(1518,32,'334',NULL,NULL,1),(1519,32,'335',NULL,NULL,1),(1520,32,'336',NULL,NULL,1),(1521,32,'339',NULL,NULL,1),(1522,32,'340',NULL,NULL,1),(1523,32,'341',NULL,NULL,1),(1524,32,'342',NULL,NULL,1),(1525,32,'400',NULL,NULL,1),(1526,32,'401',NULL,NULL,1),(1527,32,'402',NULL,NULL,1),(1528,32,'410',NULL,NULL,1),(1529,32,'412',NULL,NULL,1),(1530,32,'413',NULL,NULL,1),(1531,32,'414',NULL,NULL,1),(1532,32,'415',NULL,NULL,1),(1533,32,'416',NULL,NULL,1),(1534,32,'450',NULL,NULL,2),(1535,32,'451',NULL,NULL,2),(1536,32,'500',NULL,NULL,1),(1537,32,'501',NULL,NULL,1),(1538,32,'502',NULL,NULL,1),(1539,32,'503',NULL,NULL,1),(1540,32,'504',NULL,NULL,1),(1541,32,'505',NULL,NULL,1),(1542,32,'506',NULL,NULL,1),(1543,32,'507',NULL,NULL,1),(1544,32,'508',NULL,NULL,1),(1545,32,'509',NULL,NULL,1),(1546,32,'510',NULL,NULL,1),(1547,32,'511',NULL,NULL,1),(1548,34,'0',NULL,NULL,1),(1549,34,'17',NULL,NULL,1),(1550,34,'18',NULL,NULL,1),(1551,34,'19',NULL,NULL,1),(1552,34,'20',NULL,NULL,1),(1553,34,'21',NULL,NULL,1),(1554,34,'22',NULL,NULL,1),(1555,34,'28',NULL,NULL,1),(1556,34,'29',NULL,NULL,1),(1557,34,'30',NULL,NULL,1),(1558,34,'31',NULL,NULL,1),(1559,34,'32',NULL,NULL,1),(1560,34,'33',NULL,NULL,1),(1561,34,'34',NULL,NULL,1),(1562,34,'35',NULL,NULL,1),(1563,34,'36',NULL,NULL,1),(1564,34,'37',NULL,NULL,1),(1565,34,'38',NULL,NULL,1),(1566,34,'39',NULL,NULL,1),(1567,34,'40',NULL,NULL,1),(1568,34,'51',NULL,NULL,1),(1569,34,'52',NULL,NULL,1),(1570,34,'53',NULL,NULL,1),(1571,34,'54',NULL,NULL,1),(1572,34,'55',NULL,NULL,1),(1573,34,'56',NULL,NULL,1),(1574,34,'57',NULL,NULL,1),(1575,34,'58',NULL,NULL,1),(1576,34,'70',NULL,NULL,1),(1577,34,'71',NULL,NULL,1),(1578,34,'72',NULL,NULL,1),(1579,34,'73',NULL,NULL,1),(1580,34,'74',NULL,NULL,1),(1581,34,'75',NULL,NULL,1),(1582,34,'76',NULL,NULL,1),(1583,34,'77',NULL,NULL,1),(1584,34,'78',NULL,NULL,1),(1585,34,'79',NULL,NULL,1),(1586,34,'80',NULL,NULL,1),(1587,34,'90',NULL,NULL,1),(1588,34,'91',NULL,NULL,1),(1589,34,'92',NULL,NULL,1),(1590,34,'100',NULL,NULL,1),(1591,34,'101',NULL,NULL,1),(1592,34,'102',NULL,NULL,1),(1593,34,'110',NULL,NULL,1),(1594,34,'200',NULL,NULL,1),(1595,34,'201',NULL,NULL,1),(1596,34,'202',NULL,NULL,1),(1597,34,'203',NULL,NULL,1),(1598,34,'204',NULL,NULL,1),(1599,34,'205',NULL,NULL,1),(1600,34,'206',NULL,NULL,1),(1601,34,'207',NULL,NULL,1),(1602,34,'208',NULL,NULL,1),(1603,34,'209',NULL,NULL,1),(1604,34,'210',NULL,NULL,1),(1605,34,'211',NULL,NULL,1),(1606,34,'212',NULL,NULL,1),(1607,34,'213',NULL,NULL,1),(1608,34,'214',NULL,NULL,1),(1609,34,'215',NULL,NULL,1),(1610,34,'216',NULL,NULL,1),(1611,34,'217',NULL,NULL,1),(1612,34,'218',NULL,NULL,1),(1613,34,'220',NULL,NULL,1),(1614,34,'221',NULL,NULL,1),(1615,34,'222',NULL,NULL,1),(1616,34,'223',NULL,NULL,1),(1617,34,'224',NULL,NULL,1),(1618,34,'300',NULL,NULL,1),(1619,34,'301',NULL,NULL,1),(1620,34,'302',NULL,NULL,1),(1621,34,'303',NULL,NULL,1),(1622,34,'304',NULL,NULL,1),(1623,34,'305',NULL,NULL,1),(1624,34,'320',NULL,NULL,1),(1625,34,'321',NULL,NULL,1),(1626,34,'322',NULL,NULL,1),(1627,34,'323',NULL,NULL,1),(1628,34,'324',NULL,NULL,1),(1629,34,'325',NULL,NULL,1),(1630,34,'326',NULL,NULL,1),(1631,34,'327',NULL,NULL,1),(1632,34,'328',NULL,NULL,1),(1633,34,'330',NULL,NULL,1),(1634,34,'331',NULL,NULL,1),(1635,34,'332',NULL,NULL,1),(1636,34,'333',NULL,NULL,1),(1637,34,'334',NULL,NULL,1),(1638,34,'335',NULL,NULL,1),(1639,34,'336',NULL,NULL,1),(1640,34,'339',NULL,NULL,1),(1641,34,'340',NULL,NULL,1),(1642,34,'341',NULL,NULL,1),(1643,34,'342',NULL,NULL,1),(1644,34,'400',NULL,NULL,1),(1645,34,'401',NULL,NULL,1),(1646,34,'402',NULL,NULL,1),(1647,34,'410',NULL,NULL,1),(1648,34,'412',NULL,NULL,1),(1649,34,'413',NULL,NULL,1),(1650,34,'414',NULL,NULL,1),(1651,34,'415',NULL,NULL,1),(1652,34,'416',NULL,NULL,1),(1653,34,'450',NULL,NULL,1),(1654,34,'451',NULL,NULL,1),(1655,34,'500',NULL,NULL,1),(1656,34,'501',NULL,NULL,1),(1657,34,'502',NULL,NULL,1),(1658,34,'503',NULL,NULL,1),(1659,34,'504',NULL,NULL,1),(1660,34,'505',NULL,NULL,1),(1661,34,'506',NULL,NULL,1),(1662,34,'507',NULL,NULL,1),(1663,34,'508',NULL,NULL,1),(1664,34,'509',NULL,NULL,1),(1665,34,'510',NULL,NULL,1),(1666,34,'511',NULL,NULL,1),(1667,22,'0',NULL,NULL,1),(1668,22,'17',NULL,NULL,1),(1669,22,'18',NULL,NULL,1),(1670,22,'19',NULL,NULL,1),(1671,22,'20',NULL,NULL,1),(1672,22,'21',NULL,NULL,1),(1673,22,'22',NULL,NULL,1),(1674,22,'28',NULL,NULL,1),(1675,22,'29',NULL,NULL,1),(1676,22,'30',NULL,NULL,1),(1677,22,'31',NULL,NULL,1),(1678,22,'32',NULL,NULL,1),(1679,22,'33',NULL,NULL,1),(1680,22,'34',NULL,NULL,1),(1681,22,'35',NULL,NULL,1),(1682,22,'36',NULL,NULL,1),(1683,22,'37',NULL,NULL,1),(1684,22,'38',NULL,NULL,1),(1685,22,'39',NULL,NULL,1),(1686,22,'40',NULL,NULL,1),(1687,22,'51',NULL,NULL,1),(1688,22,'52',NULL,NULL,1),(1689,22,'53',NULL,NULL,1),(1690,22,'54',NULL,NULL,1),(1691,22,'55',NULL,NULL,1),(1692,22,'56',NULL,NULL,1),(1693,22,'57',NULL,NULL,1),(1694,22,'58',NULL,NULL,1),(1695,22,'70',NULL,NULL,1),(1696,22,'71',NULL,NULL,1),(1697,22,'72',NULL,NULL,1),(1698,22,'73',NULL,NULL,1),(1699,22,'74',NULL,NULL,1),(1700,22,'75',NULL,NULL,1),(1701,22,'76',NULL,NULL,1),(1702,22,'77',NULL,NULL,1),(1703,22,'78',NULL,NULL,1),(1704,22,'79',NULL,NULL,1),(1705,22,'80',NULL,NULL,1),(1706,22,'90',NULL,NULL,1),(1707,22,'91',NULL,NULL,1),(1708,22,'92',NULL,NULL,1),(1709,22,'100',NULL,NULL,1),(1710,22,'101',NULL,NULL,1),(1711,22,'102',NULL,NULL,1),(1712,22,'110',NULL,NULL,1),(1713,22,'200',NULL,NULL,1),(1714,22,'201',NULL,NULL,1),(1715,22,'202',NULL,NULL,1),(1716,22,'203',NULL,NULL,1),(1717,22,'204',NULL,NULL,1),(1718,22,'205',NULL,NULL,1),(1719,22,'206',NULL,NULL,1),(1720,22,'207',NULL,NULL,1),(1721,22,'208',NULL,NULL,1),(1722,22,'209',NULL,NULL,1),(1723,22,'210',NULL,NULL,1),(1724,22,'211',NULL,NULL,1),(1725,22,'212',NULL,NULL,1),(1726,22,'213',NULL,NULL,1),(1727,22,'214',NULL,NULL,1),(1728,22,'215',NULL,NULL,1),(1729,22,'216',NULL,NULL,1),(1730,22,'217',NULL,NULL,1),(1731,22,'218',NULL,NULL,1),(1732,22,'220',NULL,NULL,1),(1733,22,'221',NULL,NULL,1),(1734,22,'222',NULL,NULL,1),(1735,22,'223',NULL,NULL,1),(1736,22,'224',NULL,NULL,1),(1737,22,'300',NULL,NULL,1),(1738,22,'301',NULL,NULL,1),(1739,22,'302',NULL,NULL,1),(1740,22,'303',NULL,NULL,1),(1741,22,'304',NULL,NULL,1),(1742,22,'305',NULL,NULL,1),(1743,22,'320',NULL,NULL,1),(1744,22,'321',NULL,NULL,1),(1745,22,'322',NULL,NULL,1),(1746,22,'323',NULL,NULL,1),(1747,22,'324',NULL,NULL,1),(1748,22,'325',NULL,NULL,1),(1749,22,'326',NULL,NULL,1),(1750,22,'327',NULL,NULL,1),(1751,22,'328',NULL,NULL,1),(1752,22,'330',NULL,NULL,1),(1753,22,'331',NULL,NULL,1),(1754,22,'332',NULL,NULL,1),(1755,22,'333',NULL,NULL,1),(1756,22,'334',NULL,NULL,1),(1757,22,'335',NULL,NULL,1),(1758,22,'336',NULL,NULL,1),(1759,22,'339',NULL,NULL,1),(1760,22,'340',NULL,NULL,1),(1761,22,'341',NULL,NULL,1),(1762,22,'342',NULL,NULL,1),(1763,22,'400',NULL,NULL,1),(1764,22,'401',NULL,NULL,1),(1765,22,'402',NULL,NULL,1),(1766,22,'410',NULL,NULL,1),(1767,22,'412',NULL,NULL,1),(1768,22,'413',NULL,NULL,1),(1769,22,'414',NULL,NULL,1),(1770,22,'415',NULL,NULL,1),(1771,22,'416',NULL,NULL,1),(1772,22,'450',NULL,NULL,1),(1773,22,'451',NULL,NULL,1),(1774,22,'500',NULL,NULL,1),(1775,22,'501',NULL,NULL,1),(1776,22,'502',NULL,NULL,1),(1777,22,'503',NULL,NULL,1),(1778,22,'504',NULL,NULL,1),(1779,22,'505',NULL,NULL,1),(1780,22,'506',NULL,NULL,1),(1781,22,'507',NULL,NULL,1),(1782,22,'508',NULL,NULL,1),(1783,22,'509',NULL,NULL,1),(1784,22,'510',NULL,NULL,1),(1785,22,'511',NULL,NULL,1),(1786,36,'0',NULL,NULL,1),(1787,36,'17',NULL,NULL,1),(1788,36,'18',NULL,NULL,1),(1789,36,'19',NULL,NULL,1),(1790,36,'20',NULL,NULL,1),(1791,36,'21',NULL,NULL,1),(1792,36,'22',NULL,NULL,1),(1793,36,'28',NULL,NULL,1),(1794,36,'29',NULL,NULL,2),(1795,36,'30',NULL,NULL,1),(1796,36,'31',NULL,NULL,2),(1797,36,'32',NULL,NULL,2),(1798,36,'33',NULL,NULL,2),(1799,36,'34',NULL,NULL,2),(1800,36,'35',NULL,NULL,2),(1801,36,'36',NULL,NULL,2),(1802,36,'37',NULL,NULL,1),(1803,36,'38',NULL,NULL,1),(1804,36,'39',NULL,NULL,1),(1805,36,'40',NULL,NULL,1),(1806,36,'51',NULL,NULL,1),(1807,36,'52',NULL,NULL,1),(1808,36,'53',NULL,NULL,1),(1809,36,'54',NULL,NULL,1),(1810,36,'55',NULL,NULL,1),(1811,36,'56',NULL,NULL,1),(1812,36,'57',NULL,NULL,1),(1813,36,'58',NULL,NULL,1),(1814,36,'70',NULL,NULL,1),(1815,36,'71',NULL,NULL,1),(1816,36,'72',NULL,NULL,1),(1817,36,'73',NULL,NULL,1),(1818,36,'74',NULL,NULL,1),(1819,36,'75',NULL,NULL,1),(1820,36,'76',NULL,NULL,1),(1821,36,'77',NULL,NULL,1),(1822,36,'78',NULL,NULL,1),(1823,36,'79',NULL,NULL,1),(1824,36,'80',NULL,NULL,1),(1825,36,'90',NULL,NULL,1),(1826,36,'91',NULL,NULL,1),(1827,36,'92',NULL,NULL,1),(1828,36,'100',NULL,NULL,1),(1829,36,'101',NULL,NULL,1),(1830,36,'102',NULL,NULL,1),(1831,36,'110',NULL,NULL,1),(1832,36,'200',NULL,NULL,1),(1833,36,'201',NULL,NULL,1),(1834,36,'202',NULL,NULL,1),(1835,36,'203',NULL,NULL,1),(1836,36,'204',NULL,NULL,1),(1837,36,'205',NULL,NULL,1),(1838,36,'206',NULL,NULL,1),(1839,36,'207',NULL,NULL,1),(1840,36,'208',NULL,NULL,1),(1841,36,'209',NULL,NULL,1),(1842,36,'210',NULL,NULL,1),(1843,36,'211',NULL,NULL,1),(1844,36,'212',NULL,NULL,1),(1845,36,'213',NULL,NULL,1),(1846,36,'214',NULL,NULL,1),(1847,36,'215',NULL,NULL,1),(1848,36,'216',NULL,NULL,1),(1849,36,'217',NULL,NULL,1),(1850,36,'218',NULL,NULL,1),(1851,36,'220',NULL,NULL,1),(1852,36,'221',NULL,NULL,1),(1853,36,'222',NULL,NULL,1),(1854,36,'223',NULL,NULL,1),(1855,36,'224',NULL,NULL,1),(1856,36,'300',NULL,NULL,1),(1857,36,'301',NULL,NULL,1),(1858,36,'302',NULL,NULL,1),(1859,36,'303',NULL,NULL,1),(1860,36,'304',NULL,NULL,1),(1861,36,'305',NULL,NULL,1),(1862,36,'320',NULL,NULL,1),(1863,36,'321',NULL,NULL,1),(1864,36,'322',NULL,NULL,1),(1865,36,'323',NULL,NULL,1),(1866,36,'324',NULL,NULL,1),(1867,36,'325',NULL,NULL,1),(1868,36,'326',NULL,NULL,1),(1869,36,'327',NULL,NULL,1),(1870,36,'328',NULL,NULL,1),(1871,36,'330',NULL,NULL,1),(1872,36,'331',NULL,NULL,1),(1873,36,'332',NULL,NULL,1),(1874,36,'333',NULL,NULL,1),(1875,36,'334',NULL,NULL,1),(1876,36,'335',NULL,NULL,1),(1877,36,'336',NULL,NULL,1),(1878,36,'339',NULL,NULL,1),(1879,36,'340',NULL,NULL,1),(1880,36,'341',NULL,NULL,1),(1881,36,'342',NULL,NULL,1),(1882,36,'400',NULL,NULL,1),(1883,36,'401',NULL,NULL,1),(1884,36,'402',NULL,NULL,1),(1885,36,'403',NULL,NULL,1),(1886,36,'410',NULL,NULL,1),(1887,36,'412',NULL,NULL,1),(1888,36,'413',NULL,NULL,1),(1889,36,'414',NULL,NULL,1),(1890,36,'415',NULL,NULL,1),(1891,36,'416',NULL,NULL,1),(1892,36,'450',NULL,NULL,1),(1893,36,'451',NULL,NULL,1),(1894,36,'500',NULL,NULL,1),(1895,36,'501',NULL,NULL,1),(1896,36,'502',NULL,NULL,1),(1897,36,'503',NULL,NULL,1),(1898,36,'504',NULL,NULL,1),(1899,36,'505',NULL,NULL,1),(1900,36,'506',NULL,NULL,1),(1901,36,'507',NULL,NULL,1),(1902,36,'508',NULL,NULL,1),(1903,36,'509',NULL,NULL,1),(1904,36,'510',NULL,NULL,1),(1905,36,'511',NULL,NULL,1),(1906,12,'403',NULL,NULL,1),(1907,18,'0',NULL,NULL,1),(1908,18,'17',NULL,NULL,1),(1909,18,'18',NULL,NULL,1),(1910,18,'19',NULL,NULL,1),(1911,18,'20',NULL,NULL,1),(1912,18,'21',NULL,NULL,1),(1913,18,'22',NULL,NULL,1),(1914,18,'28',NULL,NULL,1),(1915,18,'29',NULL,NULL,1),(1916,18,'30',NULL,NULL,1),(1917,18,'31',NULL,NULL,1),(1918,18,'32',NULL,NULL,1),(1919,18,'33',NULL,NULL,1),(1920,18,'34',NULL,NULL,1),(1921,18,'35',NULL,NULL,1),(1922,18,'36',NULL,NULL,1),(1923,18,'37',NULL,NULL,1),(1924,18,'38',NULL,NULL,1),(1925,18,'39',NULL,NULL,1),(1926,18,'40',NULL,NULL,1),(1927,18,'51',NULL,NULL,1),(1928,18,'52',NULL,NULL,1),(1929,18,'53',NULL,NULL,1),(1930,18,'54',NULL,NULL,1),(1931,18,'55',NULL,NULL,1),(1932,18,'56',NULL,NULL,1),(1933,18,'57',NULL,NULL,1),(1934,18,'58',NULL,NULL,1),(1935,18,'70',NULL,NULL,1),(1936,18,'71',NULL,NULL,1),(1937,18,'72',NULL,NULL,1),(1938,18,'73',NULL,NULL,1),(1939,18,'74',NULL,NULL,1),(1940,18,'75',NULL,NULL,1),(1941,18,'76',NULL,NULL,1),(1942,18,'77',NULL,NULL,1),(1943,18,'78',NULL,NULL,1),(1944,18,'79',NULL,NULL,1),(1945,18,'80',NULL,NULL,1),(1946,18,'90',NULL,NULL,1),(1947,18,'91',NULL,NULL,1),(1948,18,'92',NULL,NULL,1),(1949,18,'100',NULL,NULL,1),(1950,18,'101',NULL,NULL,1),(1951,18,'102',NULL,NULL,1),(1952,18,'110',NULL,NULL,1),(1953,18,'200',NULL,NULL,1),(1954,18,'201',NULL,NULL,1),(1955,18,'202',NULL,NULL,1),(1956,18,'203',NULL,NULL,1),(1957,18,'204',NULL,NULL,1),(1958,18,'205',NULL,NULL,1),(1959,18,'206',NULL,NULL,1),(1960,18,'207',NULL,NULL,1),(1961,18,'208',NULL,NULL,1),(1962,18,'209',NULL,NULL,1),(1963,18,'210',NULL,NULL,1),(1964,18,'211',NULL,NULL,1),(1965,18,'212',NULL,NULL,1),(1966,18,'213',NULL,NULL,1),(1967,18,'214',NULL,NULL,1),(1968,18,'215',NULL,NULL,1),(1969,18,'216',NULL,NULL,1),(1970,18,'217',NULL,NULL,1),(1971,18,'218',NULL,NULL,1),(1972,18,'220',NULL,NULL,1),(1973,18,'221',NULL,NULL,1),(1974,18,'222',NULL,NULL,1),(1975,18,'223',NULL,NULL,1),(1976,18,'224',NULL,NULL,1),(1977,18,'300',NULL,NULL,1),(1978,18,'301',NULL,NULL,1),(1979,18,'302',NULL,NULL,1),(1980,18,'303',NULL,NULL,1),(1981,18,'304',NULL,NULL,1),(1982,18,'305',NULL,NULL,1),(1983,18,'320',NULL,NULL,1),(1984,18,'321',NULL,NULL,1),(1985,18,'322',NULL,NULL,1),(1986,18,'323',NULL,NULL,1),(1987,18,'324',NULL,NULL,1),(1988,18,'325',NULL,NULL,1),(1989,18,'326',NULL,NULL,1),(1990,18,'327',NULL,NULL,1),(1991,18,'328',NULL,NULL,1),(1992,18,'330',NULL,NULL,1),(1993,18,'331',NULL,NULL,1),(1994,18,'332',NULL,NULL,1),(1995,18,'333',NULL,NULL,1),(1996,18,'334',NULL,NULL,1),(1997,18,'335',NULL,NULL,1),(1998,18,'336',NULL,NULL,1),(1999,18,'339',NULL,NULL,1),(2000,18,'340',NULL,NULL,1),(2001,18,'341',NULL,NULL,1),(2002,18,'342',NULL,NULL,1),(2003,18,'400',NULL,NULL,1),(2004,18,'401',NULL,NULL,1),(2005,18,'402',NULL,NULL,1),(2006,18,'403',NULL,NULL,1),(2007,18,'410',NULL,NULL,1),(2008,18,'412',NULL,NULL,1),(2009,18,'413',NULL,NULL,1),(2010,18,'414',NULL,NULL,1),(2011,18,'415',NULL,NULL,1),(2012,18,'416',NULL,NULL,1),(2013,18,'450',NULL,NULL,1),(2014,18,'451',NULL,NULL,1),(2015,18,'500',NULL,NULL,1),(2016,18,'501',NULL,NULL,1),(2017,18,'502',NULL,NULL,1),(2018,18,'503',NULL,NULL,1),(2019,18,'504',NULL,NULL,1),(2020,18,'505',NULL,NULL,1),(2021,18,'506',NULL,NULL,1),(2022,18,'507',NULL,NULL,1),(2023,18,'508',NULL,NULL,1),(2024,18,'509',NULL,NULL,1),(2025,18,'510',NULL,NULL,1),(2026,18,'511',NULL,NULL,1),(2027,41,'0',NULL,NULL,1),(2028,41,'17',NULL,NULL,1),(2029,41,'18',NULL,NULL,1),(2030,41,'19',NULL,NULL,1),(2031,41,'20',NULL,NULL,1),(2032,41,'21',NULL,NULL,1),(2033,41,'22',NULL,NULL,1),(2034,41,'28',NULL,NULL,1),(2035,41,'29',NULL,NULL,1),(2036,41,'30',NULL,NULL,1),(2037,41,'31',NULL,NULL,1),(2038,41,'32',NULL,NULL,1),(2039,41,'33',NULL,NULL,1),(2040,41,'34',NULL,NULL,1),(2041,41,'35',NULL,NULL,1),(2042,41,'36',NULL,NULL,1),(2043,41,'37',NULL,NULL,1),(2044,41,'38',NULL,NULL,1),(2045,41,'39',NULL,NULL,1),(2046,41,'40',NULL,NULL,1),(2047,41,'51',NULL,NULL,1),(2048,41,'52',NULL,NULL,1),(2049,41,'53',NULL,NULL,1),(2050,41,'54',NULL,NULL,1),(2051,41,'55',NULL,NULL,1),(2052,41,'56',NULL,NULL,1),(2053,41,'57',NULL,NULL,1),(2054,41,'58',NULL,NULL,1),(2055,41,'70',NULL,NULL,1),(2056,41,'71',NULL,NULL,1),(2057,41,'72',NULL,NULL,1),(2058,41,'73',NULL,NULL,1),(2059,41,'74',NULL,NULL,1),(2060,41,'75',NULL,NULL,1),(2061,41,'76',NULL,NULL,1),(2062,41,'77',NULL,NULL,1),(2063,41,'78',NULL,NULL,1),(2064,41,'79',NULL,NULL,1),(2065,41,'80',NULL,NULL,1),(2066,41,'90',NULL,NULL,1),(2067,41,'91',NULL,NULL,1),(2068,41,'92',NULL,NULL,1),(2069,41,'100',NULL,NULL,1),(2070,41,'101',NULL,NULL,1),(2071,41,'102',NULL,NULL,1),(2072,41,'110',NULL,NULL,1),(2073,41,'200',NULL,NULL,1),(2074,41,'201',NULL,NULL,1),(2075,41,'202',NULL,NULL,1),(2076,41,'203',NULL,NULL,1),(2077,41,'204',NULL,NULL,1),(2078,41,'205',NULL,NULL,1),(2079,41,'206',NULL,NULL,1),(2080,41,'207',NULL,NULL,1),(2081,41,'208',NULL,NULL,1),(2082,41,'209',NULL,NULL,1),(2083,41,'210',NULL,NULL,1),(2084,41,'211',NULL,NULL,1),(2085,41,'212',NULL,NULL,1),(2086,41,'213',NULL,NULL,1),(2087,41,'214',NULL,NULL,1),(2088,41,'215',NULL,NULL,1),(2089,41,'216',NULL,NULL,1),(2090,41,'217',NULL,NULL,1),(2091,41,'218',NULL,NULL,1),(2092,41,'220',NULL,NULL,1),(2093,41,'221',NULL,NULL,1),(2094,41,'222',NULL,NULL,1),(2095,41,'223',NULL,NULL,1),(2096,41,'224',NULL,NULL,1),(2097,41,'300',NULL,NULL,1),(2098,41,'301',NULL,NULL,1),(2099,41,'302',NULL,NULL,1),(2100,41,'303',NULL,NULL,1),(2101,41,'304',NULL,NULL,1),(2102,41,'305',NULL,NULL,1),(2103,41,'320',NULL,NULL,1),(2104,41,'321',NULL,NULL,1),(2105,41,'322',NULL,NULL,1),(2106,41,'323',NULL,NULL,1),(2107,41,'324',NULL,NULL,1),(2108,41,'325',NULL,NULL,1),(2109,41,'326',NULL,NULL,1),(2110,41,'327',NULL,NULL,1),(2111,41,'328',NULL,NULL,1),(2112,41,'330',NULL,NULL,1),(2113,41,'331',NULL,NULL,1),(2114,41,'332',NULL,NULL,1),(2115,41,'333',NULL,NULL,1),(2116,41,'334',NULL,NULL,1),(2117,41,'335',NULL,NULL,1),(2118,41,'336',NULL,NULL,1),(2119,41,'339',NULL,NULL,1),(2120,41,'340',NULL,NULL,1),(2121,41,'341',NULL,NULL,1),(2122,41,'342',NULL,NULL,1),(2123,41,'400',NULL,NULL,1),(2124,41,'401',NULL,NULL,1),(2125,41,'402',NULL,NULL,1),(2126,41,'403',NULL,NULL,1),(2127,41,'410',NULL,NULL,1),(2128,41,'412',NULL,NULL,1),(2129,41,'413',NULL,NULL,1),(2130,41,'414',NULL,NULL,1),(2131,41,'415',NULL,NULL,1),(2132,41,'416',NULL,NULL,1),(2133,41,'450',NULL,NULL,1),(2134,41,'451',NULL,NULL,1),(2135,41,'500',NULL,NULL,1),(2136,41,'501',NULL,NULL,1),(2137,41,'502',NULL,NULL,1),(2138,41,'503',NULL,NULL,1),(2139,41,'504',NULL,NULL,1),(2140,41,'505',NULL,NULL,1),(2141,41,'506',NULL,NULL,1),(2142,41,'507',NULL,NULL,1),(2143,41,'508',NULL,NULL,1),(2144,41,'509',NULL,NULL,1),(2145,41,'510',NULL,NULL,1),(2146,41,'511',NULL,NULL,1),(2147,30,'403',NULL,NULL,1),(2148,43,'0',NULL,NULL,1),(2149,43,'17',NULL,NULL,1),(2150,43,'18',NULL,NULL,1),(2151,43,'19',NULL,NULL,1),(2152,43,'20',NULL,NULL,1),(2153,43,'21',NULL,NULL,1),(2154,43,'22',NULL,NULL,1),(2155,43,'28',NULL,NULL,1),(2156,43,'29',NULL,NULL,1),(2157,43,'30',NULL,NULL,2),(2158,43,'31',NULL,NULL,1),(2159,43,'32',NULL,NULL,1),(2160,43,'33',NULL,NULL,2),(2161,43,'34',NULL,NULL,2),(2162,43,'35',NULL,NULL,2),(2163,43,'36',NULL,NULL,2),(2164,43,'37',NULL,NULL,2),(2165,43,'38',NULL,NULL,2),(2166,43,'39',NULL,NULL,2),(2167,43,'40',NULL,NULL,2),(2168,43,'51',NULL,NULL,1),(2169,43,'52',NULL,NULL,1),(2170,43,'53',NULL,NULL,1),(2171,43,'54',NULL,NULL,2),(2172,43,'55',NULL,NULL,2),(2173,43,'56',NULL,NULL,2),(2174,43,'57',NULL,NULL,2),(2175,43,'58',NULL,NULL,2),(2176,43,'70',NULL,NULL,1),(2177,43,'71',NULL,NULL,1),(2178,43,'72',NULL,NULL,1),(2179,43,'73',NULL,NULL,1),(2180,43,'74',NULL,NULL,1),(2181,43,'75',NULL,NULL,1),(2182,43,'76',NULL,NULL,1),(2183,43,'77',NULL,NULL,1),(2184,43,'78',NULL,NULL,1),(2185,43,'79',NULL,NULL,1),(2186,43,'80',NULL,NULL,1),(2187,43,'90',NULL,NULL,1),(2188,43,'91',NULL,NULL,1),(2189,43,'92',NULL,NULL,1),(2190,43,'100',NULL,NULL,1),(2191,43,'101',NULL,NULL,2),(2192,43,'102',NULL,NULL,2),(2193,43,'110',NULL,NULL,1),(2194,43,'200',NULL,NULL,1),(2195,43,'201',NULL,NULL,1),(2196,43,'202',NULL,NULL,2),(2197,43,'203',NULL,NULL,2),(2198,43,'204',NULL,NULL,2),(2199,43,'205',NULL,NULL,2),(2200,43,'206',NULL,NULL,2),(2201,43,'207',NULL,NULL,2),(2202,43,'208',NULL,NULL,1),(2203,43,'209',NULL,NULL,1),(2204,43,'210',NULL,NULL,1),(2205,43,'211',NULL,NULL,1),(2206,43,'212',NULL,NULL,1),(2207,43,'213',NULL,NULL,1),(2208,43,'214',NULL,NULL,1),(2209,43,'215',NULL,NULL,1),(2210,43,'216',NULL,NULL,1),(2211,43,'217',NULL,NULL,1),(2212,43,'218',NULL,NULL,1),(2213,43,'220',NULL,NULL,2),(2214,43,'221',NULL,NULL,1),(2215,43,'222',NULL,NULL,1),(2216,43,'223',NULL,NULL,1),(2217,43,'224',NULL,NULL,1),(2218,43,'300',NULL,NULL,1),(2219,43,'301',NULL,NULL,1),(2220,43,'302',NULL,NULL,1),(2221,43,'303',NULL,NULL,1),(2222,43,'304',NULL,NULL,1),(2223,43,'305',NULL,NULL,1),(2224,43,'320',NULL,NULL,1),(2225,43,'321',NULL,NULL,1),(2226,43,'322',NULL,NULL,1),(2227,43,'323',NULL,NULL,1),(2228,43,'324',NULL,NULL,1),(2229,43,'325',NULL,NULL,1),(2230,43,'326',NULL,NULL,1),(2231,43,'327',NULL,NULL,1),(2232,43,'328',NULL,NULL,1),(2233,43,'330',NULL,NULL,1),(2234,43,'331',NULL,NULL,1),(2235,43,'332',NULL,NULL,1),(2236,43,'333',NULL,NULL,1),(2237,43,'334',NULL,NULL,1),(2238,43,'335',NULL,NULL,1),(2239,43,'336',NULL,NULL,1),(2240,43,'339',NULL,NULL,1),(2241,43,'340',NULL,NULL,1),(2242,43,'341',NULL,NULL,1),(2243,43,'342',NULL,NULL,1),(2244,43,'400',NULL,NULL,1),(2245,43,'401',NULL,NULL,1),(2246,43,'402',NULL,NULL,1),(2247,43,'403',NULL,NULL,1),(2248,43,'410',NULL,NULL,1),(2249,43,'412',NULL,NULL,1),(2250,43,'413',NULL,NULL,1),(2251,43,'414',NULL,NULL,1),(2252,43,'415',NULL,NULL,1),(2253,43,'416',NULL,NULL,1),(2254,43,'450',NULL,NULL,1),(2255,43,'451',NULL,NULL,1),(2256,43,'500',NULL,NULL,1),(2257,43,'501',NULL,NULL,1),(2258,43,'502',NULL,NULL,1),(2259,43,'503',NULL,NULL,1),(2260,43,'504',NULL,NULL,1),(2261,43,'505',NULL,NULL,1),(2262,43,'506',NULL,NULL,1),(2263,43,'507',NULL,NULL,1),(2264,43,'508',NULL,NULL,1),(2265,43,'509',NULL,NULL,1),(2266,43,'510',NULL,NULL,1),(2267,43,'511',NULL,NULL,1),(2268,46,'0',NULL,NULL,1),(2269,46,'17',NULL,NULL,1),(2270,46,'18',NULL,NULL,1),(2271,46,'19',NULL,NULL,1),(2272,46,'20',NULL,NULL,1),(2273,46,'21',NULL,NULL,1),(2274,46,'22',NULL,NULL,1),(2275,46,'28',NULL,NULL,2),(2276,46,'29',NULL,NULL,2),(2277,46,'30',NULL,NULL,2),(2278,46,'31',NULL,NULL,2),(2279,46,'32',NULL,NULL,2),(2280,46,'33',NULL,NULL,2),(2281,46,'34',NULL,NULL,2),(2282,46,'35',NULL,NULL,2),(2283,46,'36',NULL,NULL,2),(2284,46,'37',NULL,NULL,2),(2285,46,'38',NULL,NULL,2),(2286,46,'39',NULL,NULL,2),(2287,46,'40',NULL,NULL,2),(2288,46,'51',NULL,NULL,2),(2289,46,'52',NULL,NULL,2),(2290,46,'53',NULL,NULL,2),(2291,46,'54',NULL,NULL,2),(2292,46,'55',NULL,NULL,2),(2293,46,'56',NULL,NULL,2),(2294,46,'57',NULL,NULL,2),(2295,46,'58',NULL,NULL,2),(2296,46,'70',NULL,NULL,2),(2297,46,'71',NULL,NULL,2),(2298,46,'72',NULL,NULL,2),(2299,46,'73',NULL,NULL,2),(2300,46,'74',NULL,NULL,2),(2301,46,'75',NULL,NULL,2),(2302,46,'76',NULL,NULL,2),(2303,46,'77',NULL,NULL,2),(2304,46,'78',NULL,NULL,2),(2305,46,'79',NULL,NULL,2),(2306,46,'80',NULL,NULL,2),(2307,46,'90',NULL,NULL,2),(2308,46,'91',NULL,NULL,2),(2309,46,'92',NULL,NULL,2),(2310,46,'100',NULL,NULL,2),(2311,46,'101',NULL,NULL,2),(2312,46,'102',NULL,NULL,2),(2313,46,'110',NULL,NULL,2),(2314,46,'200',NULL,NULL,2),(2315,46,'201',NULL,NULL,2),(2316,46,'202',NULL,NULL,2),(2317,46,'203',NULL,NULL,2),(2318,46,'204',NULL,NULL,2),(2319,46,'205',NULL,NULL,2),(2320,46,'206',NULL,NULL,2),(2321,46,'207',NULL,NULL,2),(2322,46,'208',NULL,NULL,2),(2323,46,'209',NULL,NULL,2),(2324,46,'210',NULL,NULL,2),(2325,46,'211',NULL,NULL,2),(2326,46,'212',NULL,NULL,2),(2327,46,'213',NULL,NULL,2),(2328,46,'214',NULL,NULL,2),(2329,46,'215',NULL,NULL,2),(2330,46,'216',NULL,NULL,2),(2331,46,'217',NULL,NULL,2),(2332,46,'218',NULL,NULL,2),(2333,46,'220',NULL,NULL,2),(2334,46,'221',NULL,NULL,2),(2335,46,'222',NULL,NULL,2),(2336,46,'223',NULL,NULL,2),(2337,46,'224',NULL,NULL,2),(2338,46,'300',NULL,NULL,1),(2339,46,'301',NULL,NULL,2),(2340,46,'302',NULL,NULL,2),(2341,46,'303',NULL,NULL,2),(2342,46,'304',NULL,NULL,2),(2343,46,'305',NULL,NULL,2),(2344,46,'320',NULL,NULL,2),(2345,46,'321',NULL,NULL,2),(2346,46,'322',NULL,NULL,2),(2347,46,'323',NULL,NULL,2),(2348,46,'324',NULL,NULL,2),(2349,46,'325',NULL,NULL,2),(2350,46,'326',NULL,NULL,2),(2351,46,'327',NULL,NULL,2),(2352,46,'328',NULL,NULL,2),(2353,46,'330',NULL,NULL,2),(2354,46,'331',NULL,NULL,2),(2355,46,'332',NULL,NULL,2),(2356,46,'333',NULL,NULL,2),(2357,46,'334',NULL,NULL,2),(2358,46,'335',NULL,NULL,2),(2359,46,'336',NULL,NULL,2),(2360,46,'339',NULL,NULL,2),(2361,46,'340',NULL,NULL,2),(2362,46,'341',NULL,NULL,2),(2363,46,'342',NULL,NULL,2),(2364,46,'400',NULL,NULL,2),(2365,46,'401',NULL,NULL,2),(2366,46,'402',NULL,NULL,2),(2367,46,'403',NULL,NULL,2),(2368,46,'410',NULL,NULL,1),(2369,46,'412',NULL,NULL,2),(2370,46,'413',NULL,NULL,1),(2371,46,'414',NULL,NULL,2),(2372,46,'415',NULL,NULL,2),(2373,46,'416',NULL,NULL,2),(2374,46,'450',NULL,NULL,1),(2375,46,'451',NULL,NULL,2),(2376,46,'500',NULL,NULL,2),(2377,46,'501',NULL,NULL,2),(2378,46,'502',NULL,NULL,2),(2379,46,'503',NULL,NULL,2),(2380,46,'504',NULL,NULL,2),(2381,46,'505',NULL,NULL,2),(2382,46,'506',NULL,NULL,2),(2383,46,'507',NULL,NULL,2),(2384,46,'508',NULL,NULL,2),(2385,46,'509',NULL,NULL,2),(2386,46,'510',NULL,NULL,2),(2387,46,'511',NULL,NULL,2); /*Table structure for table `user_profiles` */ DROP TABLE IF EXISTS `user_profiles`; CREATE TABLE `user_profiles` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) DEFAULT NULL, `profile_id` int(11) DEFAULT NULL, `active` tinyint(4) DEFAULT '1', PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=113 DEFAULT CHARSET=latin1 PAGE_CHECKSUM=1; /*Data for the table `user_profiles` */ insert into `user_profiles`(`id`,`user_id`,`profile_id`,`active`) values (26,1,1,1),(88,2,1,1),(34,1,3,1),(90,2,3,1),(85,11,4,1),(37,2,4,1),(38,1,5,1),(39,2,5,1),(40,1,6,1),(41,2,6,1),(42,2,7,1),(43,1,7,1),(44,4,1,1),(45,5,1,1),(46,6,1,1),(47,7,1,1),(48,8,1,1),(50,10,1,1),(51,11,1,1),(52,12,1,1),(54,18,1,1),(55,14,1,1),(56,16,1,1),(57,15,1,1),(58,17,1,1),(66,27,1,1),(67,28,1,1),(69,30,1,1),(71,31,1,1),(72,11,2,1),(74,11,3,1),(76,9,3,1),(77,12,3,1),(86,18,3,1),(80,22,3,1),(93,33,1,1),(87,18,4,1),(103,18,2,1),(97,35,3,1),(102,15,2,1),(108,42,1,1),(109,19,1,1),(110,43,1,1),(111,45,1,1),(112,46,1,1); /*Table structure for table `users` */ DROP TABLE IF EXISTS `users`; CREATE TABLE `users` ( `id` int(11) NOT NULL AUTO_INCREMENT, `username` varchar(100) DEFAULT NULL, `password` varchar(100) DEFAULT NULL, `fullname` varchar(100) DEFAULT NULL, `email` varchar(100) DEFAULT NULL, `cellphone` varchar(100) DEFAULT NULL, `type` int(11) DEFAULT '1', `active` int(11) DEFAULT '1', PRIMARY KEY (`id`), KEY `username` (`username`), KEY `password` (`password`) ) ENGINE=MyISAM AUTO_INCREMENT=47 DEFAULT CHARSET=latin1; /*Data for the table `users` */ insert into `users`(`id`,`username`,`password`,`fullname`,`email`,`cellphone`,`type`,`active`) values (1,'admin','admin','Oakdale','','',1,1),(2,'1',NULL,NULL,NULL,NULL,3,1),(3,'space','4ildren',NULL,NULL,NULL,2,1),(4,'2','2','','','',3,1),(5,'3','3','','','',3,1),(6,'4','4','','','',3,1),(7,'5','5','','','',3,1),(8,'6','6','','','',3,1),(9,'STEVEN','1803','','','',1,2),(10,'7','7','','','',3,1),(11,'space','4ildren','spacebiz','','',1,1),(12,'ZENDA','2001','','','',1,1),(13,'Johan','6212','Jaco','','',1,2),(14,'wouter','wouter','Wouter','','',1,1),(15,'niel','niel','Niel Swanepoel','','',1,1),(16,'david','david','David ffoulkes','da.ffoulkes@mweb.co.za','+27832602937',1,1),(17,'lisbe','lisbe','Lisbe','','',1,1),(18,'Trudie','Trudie','Trudie Hoskin','','',1,1),(19,'eddie','eddie','Eddie','','',1,1),(20,'Ronel','Gerrie1','Ronel Bothma','','',1,2),(21,'annalie','annalie','Annalie de Rosnay','','',1,2),(22,'Andre','1234','Andre','','',1,2),(23,'natashja','natashja','Natashja','','',1,2),(24,'Pieter','9612','','','',1,2),(25,'Emil','9398973','Emil Odendal','','083 594 5599',1,2),(26,'Arthur','082209','','','',1,2),(27,'15','15','','','',3,1),(28,'8','8','','','',3,1),(29,'Kevin','1410','','','073 463 3670',1,2),(30,'Chante ','Hermanus','Chante Harmse','services@oakdaleclub.co.za','0713663188',1,1),(31,'16','16','','','',3,1),(32,'Leon','6408','Leon Carstens','','073 459 3178',1,2),(33,'17','17','','','',3,1),(34,'Herman','Hartenbos','','greatsstuff@gmail.com','',1,2),(35,'Jaco Swanepoel','sKAAPSKER','Jaco Swanepoel','','+27646445360',1,2),(36,'Pedri Groenewald','studio69','Pedri Groenewald','pietergroenewald69@gmail.com','0662735061',1,2),(37,'Jaco Reeders','6258','Jaco Reeders','jaco@oakdaleclub.co.za','',1,2),(38,'Monique','Monique','Monique Smit','','',1,2),(39,'Franco','Franco','Franco Buratti','','',1,2),(40,'Jaime','2359','Jaime Sloane McGivern','','0833532359',1,2),(41,'Craig','750109','Craig Lawrence','services@oakdaleclub.co.za','',1,2),(42,'Mary-Anne','Kyara','','','',1,1),(43,'angelene','angelene','','club@oakdelclub.co.za','',1,1),(44,'angelene','angelene','','','',1,2),(45,'11','11','','','',3,1),(46,'nick','nick','','','',1,1); /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;