boogerlad/mj - Change 72DUSPYXB64ECTFQWWD7XSY4YJUNRCFZT22AS4BDRIIUZP33CZGAC

when producer is the brand, brand should be '' instead of null(which means unknown). makes filtering easier play with volatile / stable / immutable function labels filter by multiple species, effects, strains, types, producers, brands simultaneously filter by genetics, frequency of use fix text search order backwards sort by genetics, "top" effects. todo: sort by frequency of use. propose beginners thc2tc asc, avg(thc) asc oops duplicate: replace canopy producer with canopy growth

Created by boogerlad on March 31, 2020

72DUSPYXB64ECTFQWWD7XSY4YJUNRCFZT22AS4BDRIIUZP33CZGAC

Dependencies

In channels

main

Change contents

Replacement in initialize.sql at line 110 [11.17]

B:BD[10.195] → [10.195:243]

	brand text,--null means producer is the brand

[10.195]

[12.183]

	brand text not null,--'' means producer is the brand

Replacement in initialize.sql at line 120 [11.17]

B:BD[13.7012] → [3.0:53]

	check (brand is not null or producer is not null),

[13.7012]

[3.53]

	check (brand != '' or producer is not null),

Replacement in initialize.sql at line 123 [11.17]

B:BD[11.2612] → [14.968:1297]

create unique index upi_product_3p on product (producer, joined_name, type) where brand is null;
create unique index upi_product_3b on product (brand, joined_name, type) where producer is null;
create unique index upi_product_4 on product (producer, brand, joined_name, type) where brand is not null and producer is not null;

[11.2612]

[13.7013]

create unique index upi_product_3 on product (brand, joined_name, type) where producer is null;
create unique index upi_product_4 on product (producer, brand, joined_name, type) where producer is not null;

Replacement in initialize.sql at line 454 [11.17]
B:BD[15.620] → [15.620:642]
```
$$ language plpgsql;
```
[15.620]
[16.472]
```
$$ language plpgsql volatile;
```
Replacement in initialize.sql at line 462 [11.17]
B:BD[7.52] → [7.52:95]
```
			(brand = _brand or _brand is null) and
```
[7.52]
[17.91]
```
			brand = _brand and
```
Replacement in initialize.sql at line 497 [11.17]
B:BD[15.1712] → [15.1712:1734]
```
$$ language plpgsql;
```
[15.1712]
[6.0]
```
$$ language plpgsql volatile;
```
Replacement in initialize.sql at line 530 [11.17]
B:BD[15.2494] → [15.2494:2516]
```
$$ language plpgsql;
```
[15.2494]
[16.850]
```
$$ language plpgsql volatile;
```

Replacement in initialize.sql at line 568 [11.17]

B:BD[16.1705] → [18.48:262]

∅:D[18.262] → [16.1705:1723]

B:BD[16.1705] → [16.1705:1723]

$$ language sql;
create or replace function thc2tc(thc numrange, cbd numrange) returns numeric as $$
	select ((lower(thc) + upper(thc)) / 2) / (((lower(thc) + upper(thc)) / 2) + ((lower(cbd) + upper(cbd)) / 2))
$$ language sql;

[16.1705]

[16.1723]

$$ language sql stable;
create or replace function avg_range(numrange) returns numeric as $$
	select (lower($1) + upper($1)) / 2
$$ language sql immutable;--idk if immutable actually helps or makes sense(documentation is a little unclear. is argument a value or a reference to a row's column??)
create or replace function thc2tc(thc numrange, cbd numrange) returns numeric as $$--how does nested inlining work?? stackoverflow.com/q/53040170. time to raise notice or case when pg_sleep(.01) is null then 2 else actual end.... yay fun. constant folding? can't explain analyze functions, so leave as separate exercise dba.stackexchange.com/q/84414
	select avg_range(thc) / (avg_range(thc) + avg_range(cbd))
$$ language sql immutable;

Replacement in initialize.sql at line 576 [11.17]

B:BD[16.1765] → [16.1765:1793]

B:BD[16.1793] → [9.42:140]

∅:D[9.140] → [19.27:56]

B:BD[19.27] → [19.27:56]

B:BD[19.56] → [18.263:292]

B:BD[18.292] → [9.141:168]

	_store_id integer = null,
	--_user_id integer = null,
	_species species = null,
	_effect effect = null,--not working yet
	_strain_id integer = null,
	_type product_type = null,
	in_stock boolean = null,

[16.1765]

[9.168]

	_store_id integer = null,--soon to be array? for geolocation sort
	_species species[] = null,--how about default to empty array?
	_effects effect[] = null,
	_strain_ids integer[] = null,
	_types product_type[] = null,
	frequency text = 'daily',
	in_stock boolean = null,--true in stock only. false oos only. null everything

Replacement in initialize.sql at line 584 [11.17]

B:BD[9.242] → [9.242:330]

	sort_thc boolean = null,--not working yet
	sort_cbd boolean = null,--not working yet

[9.242]

[9.330]

	sort_thc boolean = null,--in frontend, warn user that the sort does not make sense if types from more than one method of consumption(inhalation, sublingual, ingestion) are included in filter
	sort_cbd boolean = null,--ditto

Replacement in initialize.sql at line 587 [11.17]

B:BD[9.381] → [9.381:402]

	search text = null

[9.381]

[16.1819]

	search text = null,
	--_user_id integer = null, cte vs plpgsql variable?. will replace below parameters once user stuff is done
	akt1 akt1 = null,
	comt comt = null,
	cyp2c19_2 cyp2c19_2 = null,
	cyp2c19_3 cyp2c19_3 = null,
	cyp2c19_17 cyp2c19_17 = null,
	cyp2c9 cyp2c9 = null

Replacement in initialize.sql at line 657 [11.17]

B:BD[19.104] → [19.104:158]

B:BD[19.158] → [9.478:561]

		(strain_id = _strain_id or _strain_id is null) and
		(type = _type or _type is null) and
		(species = _species or _species is null)

[19.104]

[9.561]

		(strain_id = any(_strain_ids) or _strain_ids is null) and
		(type = any(_types) or _types is null) and
		(species = any(_species) or _species is null) and case
			when akt1 in ('C/T', 'C/C') then thc2tc(thc, cbd) < .6
			else true
		end and case
			when comt in ('Val/Val', 'Val/Met') then
				thc2tc(thc, cbd) < .75 or
				terpenes[1] ilike '%pinene' or
				terpenes[2] ilike '%pinene'
			else true
		end and case--cbd
			when--slow
				(cyp2c19_17 = '*1/*1' or cyp2c19_17 = '*1/*17') and
				((cyp2c19_2 = '*1/*1' and cyp2c19_3 = '*1/*3') or (cyp2c19_2 = '*1/*2' and cyp2c19_3 = '*1/*1'))
			then
				type in ('flower', 'preroll', 'cartridge', 'disposable') or
				thc2tc(thc, cbd) > .3 or
				avg_range(thc) < case--76. need to fix
					when type = 'oil' then 20
					when type = 'spray' then 2
					when type in ('capsule', 'tea', 'gummy', 'mint', 'chocolate', 'baked') then 5 / first
				end
			when--very slow
				cyp2c19_17 = '*1/*1' and (
					cyp2c19_2 = '*1/*1' and cyp2c19_3 = '*3/*3' or
					cyp2c19_2 = '*1/*2' and cyp2c19_3 = '*1/*3' or
					cyp2c19_2 = '*2/*2' and cyp2c19_3 = '*1/*1'
				)
			then
				type in ('flower', 'preroll', 'cartridge', 'disposable') or
				thc2tc(thc, cbd) > .3 or
				avg_range(thc) < case--20. need to fix
					when type = 'oil' then 20
					when type = 'spray' then 2
					when type in ('capsule', 'tea', 'gummy', 'mint', 'chocolate', 'baked') then 5 / first
				end
			else true
		end and case
			when (frequency = 'daily' and (cyp2c9 is null or cyp2c9 in ('inconclusive', '*1/*1'))) or type in ('oil', 'spray') then true
			else avg_range(thc) < case
				when type in ('flower', 'preroll') then case
					when frequency = 'daily' then case
						when cyp2c9 = '*1/*3' then 240
						when cyp2c9 = '*3/*3' then 200
					end
					when frequency = 'weekly' then case
						when cyp2c9 = '*1/*3' then 215
						when cyp2c9 = '*3/*3' then 165
						else 365
					end
					when frequency = 'monthly' then case
						when cyp2c9 = '*1/*3' then 70
						when cyp2c9 = '*3/*3' then 40
						else 130
					end
					else case--'rarely'
						when cyp2c9 = '*1/*3' then 50
						when cyp2c9 = '*3/*3' then 25
						else 100
					end
				end
				when type in ('cartridge', 'disposable') then case
					when frequency = 'daily' then case
						when cyp2c9 = '*1/*3' then 240--fixme
						when cyp2c9 = '*3/*3' then 200--fixme
					end
					when frequency = 'weekly' then case
						when cyp2c9 = '*1/*3' then 215--fixme
						when cyp2c9 = '*3/*3' then 165--fixme
						else 365
					end
					when frequency = 'monthly' then case
						when cyp2c9 = '*1/*3' then 70--fixme
						when cyp2c9 = '*3/*3' then 40--fixme
						else 130
					end
					else case--'rarely'
						when cyp2c9 = '*1/*3' then 50--fixme
						when cyp2c9 = '*3/*3' then 25--fixme
						else 100
					end
				end
				when type in ('capsule', 'tea', 'gummy', 'mint', 'chocolate', 'baked') then case
					when frequency = 'daily' then case--need to divide by first, but capsule breaks it...
						when cyp2c9 = '*1/*3' then 7.5
						when cyp2c9 = '*3/*3' then 5
					end
					when frequency = 'weekly' then case
						when cyp2c9 = '*1/*3' then 5
						when cyp2c9 = '*3/*3' then 3
						else 7.5
					end
					when frequency = 'monthly' then case
						when cyp2c9 = '*1/*3' then 3
						when cyp2c9 = '*3/*3' then 2
						else 5
					end
					else case--'rarely'
						when cyp2c9 = '*1/*3' then 2.4
						when cyp2c9 = '*3/*3' then 1.2
						else 3
					end
				end
			end
		end and
		coalesce((select bool_or(case
			when x = 'sleep' then species = 'indica' and thc2tc(thc, cbd) >= .1
			when x = 'calm' then species in ('indica', 'hybrid', 'blend') and thc2tc(thc, cbd) <= .6
			when x = 'pain' then thc2tc(thc, cbd) between .1 and .8
			when x = 'happy' then species = 'sativa' or species = 'hybrid' and thc2tc(thc, cbd) >= .35
			when x = 'energetic' then species = 'sativa' and thc2tc(thc, cbd) >= .1
			when x = 'focused' then species = 'hybrid' and thc2tc(thc, cbd) between .25 and .7 or species = 'sativa' and avg_range(thc) <= case
				when type in ('flower', 'preroll') then 100
				when type in ('disposable', 'cartridge') then 550
				when type = 'oil' then 20
				when type = 'spray' then 2
				when type in ('capsule', 'tea', 'gummy', 'mint', 'chocolate', 'baked') then 5 / first
			end
		end) from unnest(_effects) as t(x)), true)-- and
		--(search is null or word_similarity(concat_ws(' ', producer, brand, product.display_name), lower(search)) > 0.5)--0.5 is too high... maybe limit instead if present?

Replacement in initialize.sql at line 779 [11.17]

B:BD[9.572] → [9.572:662]

		word_similarity(concat_ws(' ', producer, brand, product.display_name), lower(search)),

[9.572]

[9.662]

		case when search is not null then word_similarity(concat_ws(' ', producer, brand, product.display_name), lower(search)) end desc nulls last,

Replacement in initialize.sql at line 781 [11.17]

B:BD[9.704] → [9.704:750]

∅:D[9.750] → [18.485:503]

B:BD[16.3227] → [18.485:503]

		case when not sort_price then min end desc
$$ language sql;

[9.704]

[18.503]

		case when not sort_price then min end desc,
		case
			when cyp2c9 in ('*1/*3', '*3/*3') then case
				when type in ('flower', 'preroll', 'cartridge', 'disposable') then 1
				when type in ('oil', 'spray') then 2
				when type in ('capsule', 'tea', 'gummy', 'mint', 'chocolate', 'baked') then 3
			end
		end,
		case
			when
				'sleep' = any(_effects) and terpenes[1] ilike '%myrcene' or
				'calm' = any(_effects) and terpenes[1] ilike '%limonene' or
				'pain' = any(_effects) and terpenes[1] ilike '%caryo%lene' and terpenes[2] ilike '%humulene' or
				'focused' = any(_effects) and terpenes[1] ilike '%pinene' or
				'energetic' = any(_effects) and terpenes[1] ilike '%terpinolene' or
				'happy' = any(_effects) and terpenes[1] ilike '%linalool'
			then 1
			when
				'sleep' = any(_effects) and terpenes[2] ilike '%myrcene' or
				'calm' = any(_effects) and terpenes[1] ilike '%caryo%lene' or
				'pain' = any(_effects) and terpenes[1] ilike '%caryo%lene' or
				'focused' = any(_effects) and terpenes[2] ilike '%pinene' or
				'energetic' = any(_effects) and terpenes[2] ilike '%terpinolene' or
				'happy' = any(_effects) and terpenes[2] ilike '%linalool'
			then 2
			when
				'calm' = any(_effects) and terpenes[2] ilike '%limonene' or
				'pain' = any(_effects) and terpenes[2] ilike '%caryo%lene'
			then 3
			when
				'calm' = any(_effects) and terpenes[2] ilike '%caryo%lene'
			then 4
			when strain.effect = any(_effects) then 10
			else 11
		end
$$ language sql stable;

Replacement in initialize.sql at line 908 [11.17]

B:BD[18.3252] → [18.3252:3556]

		round(@ ((lower(thc) + upper(thc)) / 2) - (select ((lower(thc) + upper(thc)) / 2) from p), -1) asc nulls last--this is wrong thc_mg, but temporary(take into account user pref for flower, recommend at variant level) but maybe doesn't matter since same type? need to fix if type becomes optional though

[18.3252]

[18.3556]

		round(@ avg_range(thc) - (select avg_range(thc) from p), -1) asc nulls last--this is wrong thc_mg, but temporary(take into account user pref for flower, recommend at variant level) but maybe doesn't matter since same type? need to fix if type becomes optional though

Replacement in initialize.sql at line 912 [11.17]
∅:D[18.3627] → [16.3227:3245]
B:BD[16.3227] → [16.3227:3245]
```
$$ language sql;
```
[18.3627]
[16.3245]
```
$$ language sql stable;
```
Replacement in initialize.sql at line 951 [11.17]
B:BD[16.4380] → [8.0:18]
```
$$ language sql;
```
[16.4380]
[8.18]
```
$$ language sql stable;
```
Replacement in initialize.sql at line 986 [11.17]
∅:D[8.1032] → [16.4380:4398]
B:BD[16.4380] → [16.4380:4398]
```
$$ language sql;
```
[8.1032]
[8.1033]
```
$$ language sql stable;
```
Replacement in initialize.sql at line 1009 [11.17]
B:BD[8.1405] → [8.1405:1423]
```
$$ language sql;
```
[8.1405]
[8.1423]
```
$$ language sql stable;
```
Replacement in initialize.sql at line 1074 [11.17]
B:BD[8.2784] → [8.2784:2802]
```
$$ language sql;
```
[8.2784]
[13.18338]
```
$$ language sql stable;
```
Replacement in scrape/common.js at line 232 [20.4897]
B:BD[4.147] → [4.147:166]
```
				brand = null;
```
[4.147]
[4.166]
```
				brand = '';
```
Replacement in scrape/common.js at line 241 [20.4897]
∅:D[21.760] → [22.3498:3524]
B:BD[22.3498] → [22.3498:3524]
```
				if(brand !== null) {
```
[21.760]
[22.3524]
```
				if(brand === null) {
					brand = '';
				} else {
```
Replacement in scrape/common.js at line 263 [20.4897]
B:BD[22.4172] → [22.4172:4191]
```
				brand = null;
```
[22.4172]
[21.933]
```
				brand = '';
```
Replacement in scrape/common.js at line 267 [20.4897]
B:BD[22.4308] → [22.4308:4327]
```
				brand = null;
```
[22.4308]
[2.245]
```
				brand = '';
```
Replacement in scrape/common.js at line 276 [20.4897]
B:BD[22.4597] → [22.4597:4616]
```
				brand = null;
```
[22.4597]
[22.4616]
```
				brand = '';
```
Replacement in scrape/common.js at line 283 [20.4897]
B:BD[22.4798] → [22.4798:4818]
```
					brand = null;
```
[22.4798]
[22.4818]
```
					brand = '';
```
Replacement in scrape/common.js at line 287 [20.4897]
B:BD[22.4895] → [22.4895:4914]
```
				brand = null;
```
[22.4895]
[22.4914]
```
				brand = '';
```
Replacement in scrape/common.js at line 290 [20.4897]
B:BD[22.4980] → [22.4980:4999]
```
				brand = null;
```
[22.4980]
[22.4999]
```
				brand = '';
```
Replacement in scrape/common.js at line 326 [20.4897]
B:BD[22.6148] → [2.287:306]
```
				brand = null;
```
[22.6148]
[22.6169]
```
				brand = '';
```
Replacement in scrape/common.js at line 341 [20.4897]
B:BD[22.6616] → [22.6616:6635]
```
				brand = null;
```
[22.6616]
[22.6635]
```
				brand = '';
```
Replacement in scrape/common.js at line 359 [20.4897]
B:BD[22.7163] → [22.7163:7182]
```
				brand = null;
```
[22.7163]
[22.7182]
```
				brand = '';
```
Replacement in scrape/common.js at line 398 [20.4897]
B:BD[22.8408] → [22.8408:8427]
```
				brand = null;
```
[22.8408]
[22.8427]
```
				brand = '';
```
Replacement in scrape/common.js at line 410 [20.4897]
B:BD[22.8834] → [22.8834:8853]
```
				brand = null;
```
[22.8834]
[21.1021]
```
				brand = '';
```
Replacement in scrape/common.js at line 431 [20.4897]
B:BD[22.9544] → [22.9544:9563]
```
				brand = null;
```
[22.9544]
[2.348]
```
				brand = '';
```
Replacement in scrape/common.js at line 467 [20.4897]
B:BD[22.10680] → [22.10680:10699]
```
				brand = null;
```
[22.10680]
[22.10699]
```
				brand = '';
```
Replacement in scrape/common.js at line 473 [20.4897]
B:BD[22.10904] → [22.10904:10923]
```
				brand = null;
```
[22.10904]
[22.10923]
```
				brand = '';
```
Replacement in scrape/common.js at line 475 [20.4897]
B:BD[22.10968] → [22.10968:10994]
```
				producer = 'CANOPY';
```
[22.10968]
[22.10994]
```
				producer = 'CANOPY GROWTH';
```
Replacement in scrape/common.js at line 487 [20.4897]
B:BD[22.11348] → [22.11348:11374]
```
				producer = 'CANOPY';
```
[22.11348]
[22.11374]
```
				producer = 'CANOPY GROWTH';
```

Replacement in scrape/ocs.ca.js at line 176 [20.11674]

B:BD[20.17036] → [5.138:224]

			let w = dup.get(coalesce(producer) + coalesce(brand) + join_name + e[i][0].type);

[20.17036]

[5.224]

			let w = dup.get(coalesce(producer) + brand + join_name + e[i][0].type);

Replacement in scrape/ocs.ca.js at line 178 [20.11674]

B:BD[5.250] → [5.250:356]

				dup.set(coalesce(producer) + coalesce(brand) + join_name + e[i][0].type, new Set([e[i][0].handle]));

[5.250]

[5.356]

				dup.set(coalesce(producer) + brand + join_name + e[i][0].type, new Set([e[i][0].handle]));

Replacement in server.js at line 546 [23.590]

B:BD[9.875] → [9.875:926]

				const [strains, pgenum] = await Promise.all([

[9.875]

[9.926]

				const [strains, idk, pgenum] = await Promise.all([

Insertion in server.js at line 548 [23.590]

[9.1022]

					pool.query('select producer, array_agg(distinct brand) as brands from product group by producer').then(x => x.rows),//takes in a store / set of stores and has number of items per producer / brand in brackets? (10)

Replacement in server.js at line 563 [23.590]
B:BD[9.1696] → [9.1696:1729]
```
					data: {strains, ...pgenum}
```
[9.1696]
[9.1729]
```
					data: {strains, idk, ...pgenum}
```
Insertion in server.js at line 569 [23.590]
[19.425]
[24.0]
```
				let wack = '';
```

Replacement in server.js at line 571 [23.590]

B:BD[24.22] → [24.22:143]

					let s = Number(parameters.store);
					if(Number.isInteger(s)) {
						qs += `_store_id => $${params.push(s)},`;

[24.22]

[24.143]

					if((parameters.store = Number(parameters.store)) && Number.isInteger(parameters.store)) {
						qs += `_store_id => $${params.push(parameters.store)},`;

Replacement in server.js at line 574 [23.590]

B:BD[24.151] → [24.151:280]

					let st = Number(parameters.strain_id);
					if(Number.isInteger(st)) {
						qs += `_strain_id => $${params.push(st)},`;

[24.151]

[24.280]

					if(Array.isArray(parameters.strain_ids) && (parameters.strain_ids = parameters.strain_ids.map(Number)).every(Number.isInteger)) {
						qs += `_strain_ids => $${params.push(parameters.strain_ids)},`;

Replacement in server.js at line 577 [23.590]

B:BD[24.288] → [24.288:395]

					if(typeof parameters.type === 'string') {
						qs += `_type => $${params.push(parameters.type)},`;

[24.288]

[9.1752]

					if(Array.isArray(parameters.types) && parameters.types.every(s => typeof s === 'string')) {
						qs += `_types => $${params.push(parameters.types)},`;

Replacement in server.js at line 580 [23.590]

B:BD[9.1760] → [9.1760:1811]

					if(typeof parameters.species === 'string') {

[9.1760]

[9.1811]

					if(Array.isArray(parameters.species) && parameters.species.every(s => typeof s === 'string')) {

Insertion in server.js at line 582 [23.590]

[9.1876]

					}
					if(Array.isArray(parameters.effects) && parameters.effects.every(s => typeof s === 'string')) {
						qs += `_effects => $${params.push(parameters.effects)},`;

Insertion in server.js at line 589 [23.590]

[18.3636]

					if(typeof parameters.frequency === 'string') {
						qs += `frequency => $${params.push(parameters.frequency)},`;
					}
					if(typeof parameters.akt1 === 'string') {
						qs += `akt1 => $${params.push(parameters.akt1)},`;
					}
					if(typeof parameters.comt === 'string') {
						qs += `comt => $${params.push(parameters.comt)},`;
					}
					if(typeof parameters.cyp2c9 === 'string') {
						qs += `cyp2c9 => $${params.push(parameters.cyp2c9)},`;
					}
					if(typeof parameters.cyp2c19_2 === 'string') {
						qs += `cyp2c19_2 => $${params.push(parameters.cyp2c19_2)},`;
					}
					if(typeof parameters.cyp2c19_3 === 'string') {
						qs += `cyp2c19_3 => $${params.push(parameters.cyp2c19_3)},`;
					}
					if(typeof parameters.cyp2c19_17 === 'string') {
						qs += `cyp2c19_17 => $${params.push(parameters.cyp2c19_17)},`;
					}

Insertion in server.js at line 615 [23.590]

[9.2196]

[24.395]

					}
					if(Array.isArray(parameters.producers) && parameters.producers.every(p => typeof p === 'object' && typeof p.producer === 'string' && (Array.isArray(p.brands) || p.brands === undefined))) {
						wack = ` where ${parameters.producers.map(p => `producer = $${params.push(p.producer)}${Array.isArray(p.brands) ? ` and brand = any($${params.push(p.brands)})`: ''}`).join(' or ')}`;

Replacement in server.js at line 623 [23.590]

B:BD[19.900] → [19.900:995]

						data: (await pool.query(`select * from get_products(${qs.slice(0, -1)})`, params)).rows

[19.900]

[19.995]

						data: (await pool.query(`select * from get_products(${qs.slice(0, -1)})${wack}`, params)).rows

Dependencies

In channels

Change contents

Replacement in initialize.sql at line 110 [11.17]

Replacement in initialize.sql at line 120 [11.17]

Replacement in initialize.sql at line 123 [11.17]

Replacement in initialize.sql at line 454 [11.17]

Replacement in initialize.sql at line 462 [11.17]

Replacement in initialize.sql at line 497 [11.17]

Replacement in initialize.sql at line 530 [11.17]

Replacement in initialize.sql at line 568 [11.17]

Replacement in initialize.sql at line 576 [11.17]

Replacement in initialize.sql at line 584 [11.17]

Replacement in initialize.sql at line 587 [11.17]

Replacement in initialize.sql at line 657 [11.17]

Replacement in initialize.sql at line 779 [11.17]

Replacement in initialize.sql at line 781 [11.17]

Replacement in initialize.sql at line 908 [11.17]

Replacement in initialize.sql at line 912 [11.17]

Replacement in initialize.sql at line 951 [11.17]

Replacement in initialize.sql at line 986 [11.17]

Replacement in initialize.sql at line 1009 [11.17]

Replacement in initialize.sql at line 1074 [11.17]

Replacement in scrape/common.js at line 232 [20.4897]

Replacement in scrape/common.js at line 241 [20.4897]

Replacement in scrape/common.js at line 263 [20.4897]

Replacement in scrape/common.js at line 267 [20.4897]

Replacement in scrape/common.js at line 276 [20.4897]

Replacement in scrape/common.js at line 283 [20.4897]

Replacement in scrape/common.js at line 287 [20.4897]

Replacement in scrape/common.js at line 290 [20.4897]

Replacement in scrape/common.js at line 326 [20.4897]

Replacement in scrape/common.js at line 341 [20.4897]

Replacement in scrape/common.js at line 359 [20.4897]

Replacement in scrape/common.js at line 398 [20.4897]

Replacement in scrape/common.js at line 410 [20.4897]

Replacement in scrape/common.js at line 431 [20.4897]

Replacement in scrape/common.js at line 467 [20.4897]

Replacement in scrape/common.js at line 473 [20.4897]

Replacement in scrape/common.js at line 475 [20.4897]

Replacement in scrape/common.js at line 487 [20.4897]