Linq Tip #2 – Find overlapping date ranges

/*
* A deceptively ~simple self-join query to find all date ranges in a table that overlap.
* A date range is defined by the range between InTime and OutTime.
* The "Seq != Seq" filter is required so that each record does not match itself and
* Distinct is required to remove duplicates so we end up with only records
* that overlap date ranges.
* Which means (StartA <= EndB) And (EndA >= StartB)
*/
var rr = (
  from t1 in db.TimeLogs
  from t2 in db.TimeLogs
  where t1.Seq != t2.Seq
  where t1.InTime <= t2.OutTime && t1.OutTime >= t2.InTime
  select t1).Distinct();
ObjectDumper.Write(rr);

Data:
image

Output:

Seq=26  EmpID=10        InTime=9/20/2007        OutTime=9/20/2007       Employee={ }    TotalHours=4    Duration=04:00:00
Seq=27  EmpID=10        InTime=9/20/2007        OutTime=9/20/2007       Employee={ }    TotalHours=3    Duration=03:00:00
Seq=28  EmpID=10        InTime=9/20/2007        OutTime=9/20/2007       Employee={ }    TotalHours=2    Duration=02:00:00

CLR Objects

Here is a generic static method to do this with any IEnumerable<T>. To be generic, our function needs a some help from caller. We need to know what the Start and End dates are in the object. We could handle this by interface or by Functions. The caller can pass simple lambda expressions. We also added a filter function that allows you to pick from the list the record or records you want to restrict matches to. You could add another overload and hide the filter or just pass a lambda that returns true for anything. Example: (T t)=>true

// Takes a list and returns all records that have overlapping time ranges.
public static IEnumerable<T> GetOverlappedTimes<T>(IEnumerable<T> list, Func<T, bool> filter, Func<T,DateTime> start, Func<T, DateTime> end)
{
    // Selects all records that match filter() on left side and returns all records on right side that overlap.
    var overlap = from t1 in list
                  where filter(t1)
                  from t2 in list
                  where !object.Equals(t1, t2) // Don’t match the same object on right side.
                  let in1 = start(t1)
                  let out1 = end(t1)
                  let in2 = start(t2)
                  let out2 = end(t2)
                  where in1 <= out2 && out1 >= in2
                  let totover = GetMins(in1, out1, in2, out2)
                  select t2;
    return overlap;
}

public static void TestOverlap()
{
    var tl1 = new TempTimeEntry() { ID = 1, Name = "Bill", In = "1/1/08 1:00pm".ToDate(), Out = "1/1/08 4:00pm".ToDate() };
    var tl2 = new TempTimeEntry() { ID = 2, Name = "John", In = "1/1/08 5:00pm".ToDate(), Out = "1/1/08 6:00pm".ToDate() };
    var tl3 = new TempTimeEntry() { ID = 3, Name = "Lisa", In = "1/1/08 7:00pm".ToDate(), Out = "1/1/08 9:00pm".ToDate() };
    var tl4 = new TempTimeEntry() { ID = 4, Name = "Joe", In = "1/1/08 3:00pm".ToDate(), Out = "1/1/08 8:00pm".ToDate() };
    var tl5 = new TempTimeEntry() { ID = 1, Name = "Bill", In = "1/1/08 8:01pm".ToDate(), Out = "1/1/08 8:00pm".ToDate() };
    var list = new List<TempTimeEntry>() { tl1, tl2, tl3, tl4, tl5 };
    var overlap = GetOverlappedTimes(list, (TempTimeEntry t1)=>t1.ID==1, (TempTimeEntry tIn) => tIn.In, (TempTimeEntry tOut) => tOut.Out);

    Console.WriteLine("\nRecords overlap:");
    foreach (var tl in overlap)
        Console.WriteLine("Name:{0} T1In:{1} T1Out:{2}", tl.Name, tl.In, tl.Out);
    Console.WriteLine("Done");
    /*  Output:
        Records overlap:
        Name:Joe T1In:1/1/2008 3:00:00 PM T1Out:1/1/2008 8:00:00 PM
        Name:Lisa T1In:1/1/2008 7:00:00 PM T1Out:1/1/2008 9:00:00 PM
        Done
     */
}

Advertisements
This entry was posted in C#. Bookmark the permalink.

9 Responses to Linq Tip #2 – Find overlapping date ranges

  1. Single says:

    http://mail-order-bridws.freehostia.com dating mail-order-bridrs.freehostia.com date girls http://mail-order-brid.freehostia.com russia mail-order-bridts.Co.CC mail-order-bridts.Co.CC mail-order-bridws.Co.CC mail-order-bridqs.Co.CC mail-order-bridts.freehostia.com mail-order-bridys.freehostia.com mail-order-bridus.freehostia.com mail-order-bridos.freehostia.com mail-order-bridps.freehostia.com mail-order-bridas.freehostia.com mail-order-bridss.freehostia.com mail-order-bridds.freehostia.com http://champmail-order-bridis.tripod.com/

  2. Unknown says:

    http://www.batterygoshop.co.uk/mitac/bp-8050.htm mitac bp-8050 battery , http://www.batterygoshop.co.uk/mitac/minote-8080.htm mitac minote 8080 battery , http://www.batterygoshop.co.uk/mitac/minote-8090.htm mitac minote 8090 battery , http://www.batterygoshop.co.uk/mitac/8375.htm mitac 8375 battery , http://www.batterygoshop.co.uk/mitac/e2000.htm mitac e2000 battery , http://www.batterygoshop.co.uk/mitac/8×75.htm mitac 8×75 battery , http://www.batterygoshop.co.uk/mitac/8575.htm mitac 8575 battery , http://www.batterygoshop.co.uk/mitac/bp-8089.htm mitac bp-8089 battery , http://www.batterygoshop.co.uk/mitac/bp-8089x.htm mitac bp-8089x battery , http://www.batterygoshop.co.uk/mitac/bp-8389.htm mitac bp-8389 battery , http://www.batterygoshop.co.uk/mitac/bp-8089p.htm mitac bp-8089p battery , http://www.batterygoshop.co.uk/mitac/e680.htm mitac e680 battery , http://www.batterygoshop.co.uk/mitac/winbook-w200.htm mitac winbook w200 battery , http://www.batterygoshop.co.uk/mitac/winbook-w235.htm mitac winbook w235 battery , http://www.batterygoshop.co.uk/mitac/bp-8011.htm mitac bp-8011 battery , http://www.batterygoshop.co.uk/mitac/bp-8×11.htm mitac bp-8×11 battery , http://www.batterygoshop.co.uk/mitac/black-bp-8011.htm mitac black bp-8011 battery , http://www.batterygoshop.co.uk/mitac/bp-8×99.htm mitac bp-8×99 battery , http://www.batterygoshop.co.uk/mitac/bp-8599.htm mitac bp-8599 battery , http://www.batterygoshop.co.uk/nec/op-570-75303.htm nec op-570-75303 battery , http://www.batterygoshop.co.uk/nec/pc-vp-wp25.htm nec pc-vp-wp25 battery , http://www.batterygoshop.co.uk/nec/pc-vp-wp44.htm nec pc-vp-wp44 battery , http://www.batterygoshop.co.uk/nec/op-570-75901.htm nec op-570-75901 battery , http://www.batterygoshop.co.uk/nec/m300.htm nec m300 battery , http://www.batterygoshop.co.uk/nec/m500.htm nec m500 battery , http://www.batterygoshop.co.uk/sony/pcga-bp2sa.htm sony pcga-bp2sa battery , http://www.batterygoshop.co.uk/sony/pcga-bp2s.htm sony pcga-bp2s battery , http://www.batterygoshop.co.uk/sony/pcga-bp2t.htm sony pcga-bp2t battery , http://www.batterygoshop.co.uk/sony/pcga-bp2v.htm sony pcga-bp2v battery , http://www.batterygoshop.co.uk/sony/pcg-z1.htm sony pcg-z1 battery , http://www.batterygoshop.co.uk/sony/pcg-v505.htm sony pcg-v505 battery , http://www.batterygoshop.co.uk/sony/pcga-bp2e.htm sony pcga-bp2e battery , http://www.batterygoshop.co.uk/sony/vgp-bp2ea.htm sony vgp-bp2ea battery , http://www.batterygoshop.co.uk/sony/pcg-gr100.htm sony pcg-gr100 battery , http://www.batterygoshop.co.uk/sony/pcg-gr150.htm sony pcg-gr150 battery , http://www.batterygoshop.co.uk/sony/pcg-gr250.htm sony pcg-gr250 battery , http://www.batterygoshop.co.uk/sony/pcg-gr270.htm sony pcg-gr270 battery , http://www.batterygoshop.co.uk/sony/vgp-bps2a.htm sony vgp-bps2a battery , http://www.batterygoshop.co.uk/sony/vgp-bps2b.htm sony vgp-bps2b battery , http://www.batterygoshop.co.uk/sony/vgp-bps2.htm sony vgp-bps2 battery , http://www.batterygoshop.co.uk/sony/vgp-bps2b.htm sony vgp-bps2b battery , http://www.batterygoshop.co.uk/sony/vgp-bps2c.htm sony vgp-bps2c battery , http://www.batterygoshop.co.uk/sony/vgp-bpl2c.htm sony vgp-bpl2c battery , http://www.batterygoshop.co.uk/toshiba/satellite-1200.htm toshiba satellite 1200 battery ,

  3. Unknown says:

    http://www.batterylaptoppower.com/acer/btp-agd1.php acer btp-63d1 btp-agd1 3020 3610 http://www.batterylaptoppower.com/acer/lcbtp03003.php New battery fit Acer LIP-4084QUPC SQU-401 5000 http://www.batterylaptoppower.com/acer/tm3002-battery.php New Battery Acer TravelMate 3002WTCi 3002WTMi http://www.batterylaptoppower.com/acer/tm3200e.php laptop battery for 3UR18650F-3-QC151 tm3200 http://www.batterylaptoppower.com/acer/tm4200.php Battery ACER BATBL50L6 Travelmate 4200 4203 4230 4260 4280 http://www.batterylaptoppower.com/acer/um08a71.php Black Battery for Acer Aspire One UM08A71 UM08A72 UM08A73 NEW http://www.batterylaptoppower.com/acer/um08a72.php Blue Battery for Acer Aspire One UM08B71 UM08B72 UM08B73 NEW http://www.batterylaptoppower.com/acer/um08a73.php white Battery for Acer Aspire One ZG5 NEW http://www.batterylaptoppower.com/acer/um08a74.php Black Battery for Aspire One A110 NEW http://www.batterylaptoppower.com/acer/um08b72.php Blue Battery for Acer Aspire One 150L NEW http://www.batterylaptoppower.com/acer/um08b73.php white Battery for Acer Aspire One 150X NEW http://www.batterylaptoppower.com/apple/a1022.php apple powerbook g4 a1022 a1079 m9324 http://www.batterylaptoppower.com/apple/a1078.php apple a1045 a1078 e68043 m9325 m9756 http://www.batterylaptoppower.com/apple/a1175.php apple A1175 Macbook Pro 15-4 http://www.batterylaptoppower.com/apple/a1185.php NEW Hi-Cap 5500mAh Battery for MacBook 13 A1185 WHITE http://www.batterylaptoppower.com/apple/a1185-2.php NEW Hi-Cap 5500mAh Battery for MacBook 13 A1185 black http://www.batterylaptoppower.com/asus/90-n901b1000.php asus W1 W1000 A42-W1 W1G W1Ga http://www.batterylaptoppower.com/asus/a42-w1.php asus W1 W1000 A42-W1 W1G W1Ga http://www.batterylaptoppower.com/asus/90-nca1b2000.php asus A42-W3 W3A W3N W3V W3000 W3000A grey http://www.batterylaptoppower.com/asus/a3000.php asus a42-a3 a3000 z9100 a3l a3n http://www.batterylaptoppower.com/asus/a31-s5.php ASUS A31-S5 A32-S5 S52N S5000 S5200N S5N http://www.batterylaptoppower.com/asus/a31-s5-2.php ASUS A31-S5 A32-S5 S52N S5000 S5200N S5N http://www.batterylaptoppower.com/asus/a32-f3.php A32-F3 Battery ASUS F3 F3J F3Q F3JA F3JM F3JF Hi-Capaci http://www.batterylaptoppower.com/asus/a42-a2-battery.php A42-A2 Battery to ASUS A2C A2D A2000 A2500H A2S A2K Z80 http://www.batterylaptoppower.com/asus/a42-a4.php asus a4 a4d a4g a4k a4l a4s a4000 a42-a4 http://www.batterylaptoppower.com/asus/a42-v6.php New Battery fit Asus A42-V6 VX1 V6 V6V V6000 V6000V http://www.batterylaptoppower.com/asus/m3000.php Battery For ASUS M3 M3N M3NP M3000 M3000N M3000NP 4S2P black http://www.batterylaptoppower.com/asus/m6n.php asus a42-m6 m6n m67 m68n m6000 http://www.batterylaptoppower.com/asus/m6-2.php asus a42-m6 m6n m67 m68n m6000 http://www.batterylaptoppower.com/clevo/m540.php clevo m540 87-M54GS-4J4 http://www.batterylaptoppower.com/compaq/116314-001.php Battery fits COMPAQ Presario 1200 1600 1800 116314-001 http://www.batterylaptoppower.com/compaq/134111-b21-battery.php Battery For Compaq PROSIGNIA 170 PP2041B ARMADA M700 http://www.batterylaptoppower.com/compaq/191169-001.php New battery fit Compaq NC6000 NW8000 V1000 NC8000 NX5000 http://www.batterylaptoppower.com/compaq/229783-001.php Battery fits COMPAQ EVO N600 N600C N610C N610 N620C http://www.batterylaptoppower.com/compaq/372114-001.php Battery for HP/COMPAQ NX1050 NX9000 NX9005 NX901 http://www.batterylaptoppower.com/compaq/372114-001-2.php Battery for HP/COMPAQ NX1050 NX9000 NX9005 NX901 http://www.batterylaptoppower.com/compaq/nc4200-battery.php Battery for NC4200 NC4400 TC4200 383510-001 http://www.batterylaptoppower.com/compaq/pp2162s.php Battery For Compaq Presario 311227-001 PP2162S Laptop http://www.batterylaptoppower.com/dell/0u003.php NEW Laptop Battery For Dell Latitude D400 9T119 312-009 http://www.batterylaptoppower.com/dell/1525.php laptop battery for dell Dell Inspiron 1525 1526 http://www.batterylaptoppower.com/dell/2k184.php New 7.4V battery fits DELL Latitude X200 312-0058 8U443 http://www.batterylaptoppower.com/dell/310-5351-battery.php New GENUINE Dell Latitude D810 M70 Y4367 Battery

  4. Unknown says:

    http://www.akkuliste.com/hp/dv2200.htm hp dv2200 akku http://www.akkuliste.com/hp/dv6000.htm hp dv6000 akku http://www.akkuliste.com/hp/dv9000.htm hp dv9000 akku http://www.akkuliste.com/hp/dv9200.htm hp dv9200 akku http://www.akkuliste.com/hp/dv9100.htm hp dv9100 akku http://www.akkuliste.com/hp/dv9500.htm hp dv9500 akku http://www.akkuliste.com/hp/dv9600.htm hp dv9600 akku http://www.akkuliste.com/hp/dv9700.htm hp dv9700 akku http://www.akkuliste.com/hp/hstnn-ib44.htm hp hstnn-ib44 akku http://www.akkuliste.com/hp/510.htm hp 510 akku http://www.akkuliste.com/hp/530.htm hp 530 akku http://www.akkuliste.com/hp/hstnn-fb44.htm hp hstnn-fb44 akku http://www.akkuliste.com/hp/hstnn-c29c.htm hp hstnn-c29c akku http://www.akkuliste.com/hp/520.htm hp 520 akku http://www.akkuliste.com/hp/500.htm hp 500 akku http://www.akkuliste.com/hp/dv8000.htm hp dv8000 akku http://www.akkuliste.com/hp/dv8100.htm hp dv8100 akku http://www.akkuliste.com/hp/dv8200.htm hp dv8200 akku http://www.akkuliste.com/hp/dv8300.htm hp dv8300 akku http://www.akkuliste.com/hp/hstnn-db20.htm hp hstnn-db20 akku http://www.akkuliste.com/hp/hstnn-db02.htm hp hstnn-db02 akku http://www.akkuliste.com/hp/dp399a.htm hp dp399a akku http://www.akkuliste.com/hp/383968-001.htm hp 383968-001 akku http://www.akkuliste.com/hp/m2000.htm hp m2000 akku http://www.akkuliste.com/hp/dv1000.htm hp dv1000 akku http://www.akkuliste.com/hp/dv4000.htm hp dv4000 akku http://www.akkuliste.com/hp/ze2000.htm hp ze2000 akku http://www.akkuliste.com/hp/hstnn-db17.htm hp hstnn-db17 akku http://www.akkuliste.com/hp/nc2400.htm hp nc2400 akku http://www.akkuliste.com/hp/hstnn-fb21.htm hp hstnn-fb21 akku http://www.akkuliste.com/hp/2510p.htm hp 2510p akku http://www.akkuliste.com/hp/nc4000.htm hp nc4000 akku http://www.akkuliste.com/hp/nc4010.htm hp nc4010 akku http://www.akkuliste.com/hp/dd880.htm hp dd880 akku http://www.akkuliste.com/hp/315338-001.htm hp 315338-001 akku http://www.akkuliste.com/hp/nc6000.htm hp nc6000 akku http://www.akkuliste.com/hp/nx5000.htm hp nx5000 akku http://www.akkuliste.com/hp/nw8000.htm hp nw8000 akku http://www.akkuliste.com/hp/nc8000.htm hp nc8000 akku http://www.akkuliste.com/hp/v1000.htm hp v1000 akku http://www.akkuliste.com/mitac/bp-8050.htm mitac bp-8050 akku http://www.akkuliste.com/mitac/8375.htm mitac 8375 akku http://www.akkuliste.com/mitac/e2000.htm mitac e2000 akku http://www.akkuliste.com/mitac/8×75.htm mitac 8×75 akku

  5. Unknown says:

    http://www.batterygoshop.co.uk/compaq/presario-1600.htm compaq presario 1600 battery , http://www.batterygoshop.co.uk/compaq/presario-1800.htm compaq presario 1800 battery , http://www.batterygoshop.co.uk/compaq/prosignia-170.htm compaq prosignia 170 battery , http://www.batterygoshop.co.uk/compaq/pp2041b.htm compaq pp2041b battery , http://www.batterygoshop.co.uk/compaq/armada-m700.htm compaq armada m700 battery , http://www.batterygoshop.co.uk/compaq/nw8000.htm compaq nw8000 battery , http://www.batterygoshop.co.uk/compaq/nc8000.htm compaq nc8000 battery , http://www.batterygoshop.co.uk/compaq/v1000.htm compaq v1000 battery , http://www.batterygoshop.co.uk/compaq/nc6000.htm compaq nc6000 battery , http://www.batterygoshop.co.uk/compaq/nx5000.htm compaq nx5000 battery , http://www.batterygoshop.co.uk/compaq/n600.htm compaq n600 battery , http://www.batterygoshop.co.uk/compaq/n600c.htm compaq n600c battery , http://www.batterygoshop.co.uk/compaq/n610c.htm compaq n610c battery , http://www.batterygoshop.co.uk/compaq/n610v.htm compaq n610v battery , http://www.batterygoshop.co.uk/compaq/n620c.htm compaq n620c battery , http://www.batterygoshop.co.uk/compaq/nx9000.htm compaq nx9000 battery , http://www.batterygoshop.co.uk/compaq/nx9005.htm compaq nx9005 battery , http://www.batterygoshop.co.uk/compaq/nx9010.htm compaq nx9010 battery , http://www.batterygoshop.co.uk/compaq/nx9020.htm compaq nx9020 battery , http://www.batterygoshop.co.uk/compaq/nc4200.htm compaq nc4200 battery , http://www.batterygoshop.co.uk/compaq/nc4400.htm compaq nc4400 battery , http://www.batterygoshop.co.uk/compaq/tc4200.htm compaq tc4200 battery , http://www.batterygoshop.co.uk/compaq/tc4400.htm compaq tc4400 battery , http://www.batterygoshop.co.uk/dell/d400.htm dell d400 battery , http://www.batterygoshop.co.uk/dell/latitude-d400.htm dell latitude d400 battery , http://www.batterygoshop.co.uk/dell/inspiron-4000.htm dell inspiron 4000 battery , http://www.batterygoshop.co.uk/dell/inspiron-1100-series.htm dell inspiron 1100 series battery , http://www.batterygoshop.co.uk/dell/inspiron-1150.htm dell inspiron 1150 battery , http://www.batterygoshop.co.uk/dell/inspiron-5150.htm dell inspiron 5150 battery , http://www.batterygoshop.co.uk/dell/inspiron-5100.htm dell inspiron 5100 battery , http://www.batterygoshop.co.uk/dell/inspiron-1000.htm dell inspiron 1000 battery , http://www.batterygoshop.co.uk/dell/inspiron-1200.htm dell inspiron 1200 battery , http://www.batterygoshop.co.uk/dell/inspiron-2200.htm dell inspiron 2200 battery , http://www.batterygoshop.co.uk/dell/e1405.htm dell e1405 battery , http://www.batterygoshop.co.uk/dell/inspiron-630m.htm dell inspiron 630m battery , http://www.batterygoshop.co.uk/dell/inspiron-640m.htm dell inspiron 640m battery , http://www.batterygoshop.co.uk/dell/xps-m140.htm dell xps m140 battery , http://www.batterygoshop.co.uk/dell/xps-1330.htm dell xps 1330 battery , http://www.batterygoshop.co.uk/dell/xps-m1330.htm dell xps m1330 battery , http://www.batterygoshop.co.uk/dell/inspiron-6400.htm dell inspiron 6400 battery , http://www.batterygoshop.co.uk/dell/Latitude-131L.htm dell Latitude 131L battery , http://www.batterygoshop.co.uk/dell/Vostro-1000.htm dell Vostro 1000 battery , http://www.batterygoshop.co.uk/dell/1501.htm dell 1501 battery , http://www.batterygoshop.co.uk/dell/e1505.htm dell e1505 battery ,

  6. Unknown says:

    http://www.adapterlist.com/sony/pcg-gr150.htm sony pcg-gr150 battery http://www.adapterlist.com/sony/pcg-gr250.htm sony pcg-gr250 battery http://www.adapterlist.com/sony/pcg-gr270.htm sony pcg-gr270 battery http://www.adapterlist.com/sony/vgp-bps2a.htm sony vgp-bps2a battery http://www.adapterlist.com/sony/vgp-bps2b.htm sony vgp-bps2b battery http://www.adapterlist.com/sony/vgp-bps2.htm sony vgp-bps2 battery http://www.adapterlist.com/sony/vgp-bps2b.htm sony vgp-bps2b battery http://www.adapterlist.com/sony/vgp-bps2c.htm sony vgp-bps2c battery http://www.adapterlist.com/sony/vgp-bpl2c.htm sony vgp-bpl2c battery http://www.adapterlist.com/toshiba/pa3128u.htm toshiba pa3128u battery http://www.adapterlist.com/toshiba/pa3191u.htm toshiba pa3191u battery http://www.adapterlist.com/toshiba/portege-4000.htm toshiba portege 4000 battery http://www.adapterlist.com/toshiba/portege-m200.htm toshiba portege m200 battery http://www.adapterlist.com/toshiba/portege-m205.htm toshiba portege m205 battery http://www.adapterlist.com/toshiba/portege-m400.htm toshiba portege m400 battery http://www.adapterlist.com/toshiba/pa3128u-grey.htm toshiba pa3128u grey battery http://www.adapterlist.com/toshiba/pa3191u-grey.htm toshiba pa3191u grey battery http://www.adapterlist.com/toshiba/te2000-grey.htm toshiba te2000 grey battery http://www.adapterlist.com/toshiba/pa3209u.htm toshiba pa3209u battery http://www.adapterlist.com/toshiba/satellite-1100.htm toshiba satellite 1100 battery http://www.adapterlist.com/toshiba/satellite-1110.htm toshiba satellite 1110 battery http://www.adapterlist.com/toshiba/pa3210u.htm toshiba pa3210u battery http://www.adapterlist.com/toshiba/satellite-1115.htm toshiba satellite 1115 battery http://www.adapterlist.com/toshiba/pa3399u-1bas.htm toshiba pa3399u-1bas battery http://www.adapterlist.com/toshiba/satellite-a100.htm toshiba satellite a100 battery http://www.adapterlist.com/toshiba/satellite-m100.htm toshiba satellite m100 battery http://www.adapterlist.com/toshiba/pa3399u-1bas.htm toshiba pa3399u-1bas battery http://www.adapterlist.com/toshiba/satellite-a100.htm toshiba satellite a100 battery http://www.adapterlist.com/toshiba/satellite-a105.htm toshiba satellite a105 battery http://www.adapterlist.com/toshiba/satellite-a80.htm toshiba satellite a80 battery http://www.adapterlist.com/toshiba/satellite-m100.htm toshiba satellite m100 battery http://www.adapterlist.com/toshiba/satellite-m105.htm toshiba satellite m105 battery http://www.adapterlist.com/toshiba/satellite-m110.htm toshiba satellite m110 battery http://www.adapterlist.com/toshiba/satellite-m115.htm toshiba satellite m115 battery http://www.adapterlist.com/toshiba/satellite-m40.htm toshiba satellite m40 battery http://www.adapterlist.com/toshiba/satellite-m45.htm toshiba satellite m45 battery http://www.adapterlist.com/toshiba/satellite-m50.htm toshiba satellite m50 battery http://www.adapterlist.com/toshiba/satellite-m55.htm toshiba satellite m55 battery http://www.adapterlist.com/toshiba/pa3356u.htm toshiba pa3356u battery http://www.adapterlist.com/toshiba/a50.htm toshiba a50 battery http://www.adapterlist.com/toshiba/a55.htm toshiba a55 battery http://www.adapterlist.com/toshiba/portege-m300.htm toshiba portege m300 battery http://www.adapterlist.com/toshiba/portege-m500.htm toshiba portege m500 battery http://www.adapterlist.com/toshiba/portege-s100.htm toshiba portege s100 battery http://www.adapterlist.com/toshiba/qosmio-f20.htm toshiba qosmio f20 battery http://www.adapterlist.com/sony/pcg-gr150.htm sony pcg-gr151 battery

  7. Unknown says:

    http://www.batteryfast.com.au/hp/nx5000.htm hp nx5000 battery , http://www.batteryfast.com.au/hp/nw8000.htm hp nw8000 battery , http://www.batteryfast.com.au/hp/nc8000.htm hp nc8000 battery , http://www.batteryfast.com.au/hp/v1000.htm hp v1000 battery , http://www.batteryfast.com.au/hp/zt1000.htm hp zt1000 battery , http://www.batteryfast.com.au/hp/f2299a.htm hp f2299a battery , http://www.batteryfast.com.au/hp/f3172b.htm hp f3172b battery , http://www.batteryfast.com.au/hp/f3172a.htm hp f3172a battery , http://www.batteryfast.com.au/ibm/thinkpad-660.htm ibm thinkpad 660 battery , http://www.batteryfast.com.au/ibm/thinkpad-600.htm ibm thinkpad 600 battery , http://www.batteryfast.com.au/ibm/thinkpad-r32.htm ibm thinkpad r32 battery , http://www.batteryfast.com.au/ibm/thinkpad-r40.htm ibm thinkpad r40 battery , http://www.batteryfast.com.au/ibm/02k7072.htm ibm 02k7072 battery , http://www.batteryfast.com.au/ibm/thinkpad-t30.htm ibm thinkpad t30 battery , http://www.batteryfast.com.au/ibm/thinkpad-t60.htm ibm thinkpad t60 battery , http://www.batteryfast.com.au/ibm/thinkpad-x40.htm ibm thinkpad x40 battery , http://www.batteryfast.com.au/ibm/FRU-92P1167.htm ibm FRU 92P1167 battery , http://www.batteryfast.com.au/ibm/FRU-92P1169.htm ibm FRU 92P1169 battery , http://www.batteryfast.com.au/mitac/bp-8050.htm mitac bp-8050 battery , http://www.batteryfast.com.au/mitac/minote-8080.htm mitac minote 8080 battery , http://www.batteryfast.com.au/mitac/minote-8090.htm mitac minote 8090 battery , http://www.batteryfast.com.au/mitac/8375.htm mitac 8375 battery , http://www.batteryfast.com.au/mitac/e2000.htm mitac e2000 battery , http://www.batteryfast.com.au/mitac/8×75.htm mitac 8×75 battery , http://www.batteryfast.com.au/mitac/8575.htm mitac 8575 battery , http://www.batteryfast.com.au/mitac/bp-8089.htm mitac bp-8089 battery , http://www.batteryfast.com.au/mitac/bp-8089x.htm mitac bp-8089x battery , http://www.batteryfast.com.au/mitac/bp-8389.htm mitac bp-8389 battery , http://www.batteryfast.com.au/mitac/bp-8089p.htm mitac bp-8089p battery , http://www.batteryfast.com.au/mitac/e680.htm mitac e680 battery , http://www.batteryfast.com.au/mitac/winbook-w200.htm mitac winbook w200 battery , http://www.batteryfast.com.au/mitac/winbook-w235.htm mitac winbook w235 battery , http://www.batteryfast.com.au/mitac/bp-8011.htm mitac bp-8011 battery , http://www.batteryfast.com.au/mitac/bp-8×11.htm mitac bp-8×11 battery , http://www.batteryfast.com.au/mitac/black-bp-8011.htm mitac black bp-8011 battery , http://www.batteryfast.com.au/mitac/bp-8×99.htm mitac bp-8×99 battery , http://www.batteryfast.com.au/mitac/bp-8599.htm mitac bp-8599 battery , http://www.batteryfast.com.au/nec/op-570-75303.htm nec op-570-75303 battery , http://www.batteryfast.com.au/nec/pc-vp-wp25.htm nec pc-vp-wp25 battery , http://www.batteryfast.com.au/nec/pc-vp-wp44.htm nec pc-vp-wp44 battery , http://www.batteryfast.com.au/nec/op-570-75901.htm nec op-570-75901 battery , http://www.batteryfast.com.au/nec/m300.htm nec m300 battery , http://www.batteryfast.com.au/nec/m500.htm nec m500 battery , http://www.batteryfast.com.au/sony/pcga-bp2sa.htm sony pcga-bp2sa battery , http://www.batteryfast.com.au/sony/pcga-bp2s.htm sony pcga-bp2s battery , http://www.batteryfast.com.au/sony/pcga-bp2t.htm sony pcga-bp2t battery , http://www.batteryfast.com.au/sony/pcga-bp3t.htm sony pcga-bp3t battery , http://www.batteryfast.com.au/sony/pcg-tr3.htm sony pcg-tr3 battery , http://www.batteryfast.com.au/sony/pcg-tr2.htm sony pcg-tr2 battery , http://www.batteryfast.com.au/sony/pcg-tr1.htm sony pcg-tr1 battery ,

  8. Unknown says:

    Serena Williams and the season of her contentwow gold,world of warcraft gold,buy wow gold,wow power leveling,cheap wow gold,world of warcraft power
    leveling,world of warcraft gold,buy wow
    gold,ffxi gil,buy
    wow gold,wow power
    leveling,ffxi gil,world
    of warcraft power leveling,sell wow gold,wow power
    level,wow gold for
    sale,power leveling,wow
    power level,wow power level,power leveling,wow gold for
    sale,buy cheap wow gold.Indian brides confront gold bears, again

  9. Unknown says:

    qswd030 qswd00 wow gold wow power leveling wow gold wow power leveling brogame brogame buy worhammer gold buy worhammer gold 大金空调 大金空调 空调 空调 格力空调 格力空调 美的空调 美的空调 东方医院 东方医院 油泵 油泵 真空泵 真空泵 胶体磨 胶体磨 中央空调 中央空调 商用中央空调 商用中央空调 螺杆泵 螺杆泵 brogame brogame brogame brogame brogame brogame brogame wow gold wow gold

Comments are closed.