boogerlad/mj - Change KRP35NGEHSKKLQP522S7LNZN37U7Z23Q7CDTWQMRKS2NHSA6CKXQC

update queries to work with new schema and real data

Created by boogerlad on February 10, 2020

KRP35NGEHSKKLQP522S7LNZN37U7Z23Q7CDTWQMRKS2NHSA6CKXQC

Dependencies

In channels

main

Change contents

Replacement in server.js at line 540 [4.590]
B:BD[3.5243] → [3.5243:5273]
```
							display_name as name,
```
[3.5243]
[3.5273]
```
							product.display_name as name,
```

Replacement in server.js at line 542 [4.590]

B:BD[3.5289] → [5.174:219]

							strain_family.name as strain_family,

[3.5289]

[2.371]

							strain_family.display_name as strain_family,

Replacement in server.js at line 545 [4.590]

B:BD[3.5526] → [3.5526:5551]

							measurement_unit

[3.5526]

[3.5551]

							measurement_unit,
							product_image.destination

Insertion in server.js at line 551 [4.590]

[3.5743]

							left outer join product_image on (product.id = product_image.product)--and product-image.featured = true

Replacement in server.js at line 556 [4.590]

B:BD[3.5812] → [5.305:330]

							strain_family.id

[3.5812]

[5.330]

							strain_family.id,
							product_image.id
						--order by
							--product_image.rank

Insertion in server.js at line 586 [4.590]

[6.1815]

						//todo: show terpenes, flavor. deal with online store being link.

Replacement in server.js at line 593 [4.590]
B:BD[2.1037] → [2.1037:1068]
```
								display_name as name,
```
[2.1037]
[2.1068]
```
								product.display_name as name,
```

Replacement in server.js at line 595 [4.590]

B:BD[2.1085] → [2.1085:1131]

								strain_family.name as strain_family,

[2.1085]

[2.1131]

								strain_family.display_name as strain_family,

Insertion in server.js at line 602 [4.590]

[2.1343]

								json_agg(product_image.destination) as images,

Insertion in server.js at line 610 [4.590]

[2.2027]

[6.3730]

								left outer join product_image on (product.id = product_image.product)--and product-image.featured = true

Replacement in server.js at line 615 [4.590]

B:BD[2.2081] → [2.2081:2108]

								strain_family.id;

[2.2081]

[2.2108]

								strain_family.id
							--order by
								--product_image.rank