DRUG_ERA Script Issue

[ericaVoss]

https://ohdsi.github.io/CommonDataModel/sqlScripts.html#Drug_Eras
The output of this script doesn't match the DRUG_ERA table.

This script also doesn't calculate gap_days, just asserts it is looking for 30 days out.

@clairblacketer FYI

[ericaVoss]

Associating with Chris' GIST:
https://gist.github.com/chrisknoll/a18c8e15ff66f26fac84

[MaximMoinat]

Has this been solved already? This forum post shows the need of having this fixed (the old query is apparently very slow on some databases). Also, the comments of Chris here on the condition era are relevant.

[clairblacketer]

Potentially need to update - adam black suggested a new way that is more performant.