Summary

• Page properties (1 modified, 0 added, 0 removed)

Details

Page properties

Content

...	...	@@ -75,7 +75,7 @@
75	75
76	76	**LEFT JOIN **brands b
77	77
78		- **ON** pg.brand_id = b.id
	78	+ **ON** pg.brand_id = b.id
79	79
80	80	**LEFT JOIN** product_codes pc
81	81
...	...	@@ -83,11 +83,11 @@
83	83
84	84	**LEFT JOIN** codes c
85	85
86		- **ON** pc.code_id = c.id
	86	+ **ON** pc.code_id = c.id
87	87
88	88	**LEFT JOIN** oem_mark om
89	89
90		- **ON** pc.oem_mark_id = om.id
	90	+ **ON** pc.oem_mark_id = om.id
91	91
92	92	**WHERE** 1 = 1
93	93
...	...	@@ -137,23 +137,23 @@
137	137
138	138	**LEFT JOIN** product_group pg
139	139
140		- **ON** p.group_id = pg.id
	140	+ **ON** p.group_id = pg.id
141	141
142	142	**LEFT JOIN** brands b
143	143
144		- **ON** pg.brand_id = b.id
	144	+ **ON** pg.brand_id = b.id
145	145
146	146	**LEFT JOIN** product_oem po
147	147
148		- **ON** p.id = po.product_id
	148	+ **ON** p.id = po.product_id
149	149
150	150	**LEFT JOIN** oem_codes oc
151	151
152		- ** ON** po.oem_id = oc.id
	152	+ **ON **po.oem_id = oc.id
153	153
154	154	**LEFT JOIN** oem_mark om
155	155
156		- ** ON** oc.oemmarkId = om.id
	156	+ **ON **oc.oemmarkId = om.id
157	157
158	158	**WHERE** 1 = 1
159	159
...	...	@@ -161,7 +161,7 @@
161	161
162	162	**AND** oc.code **IS NOT** NULL
163	163
164		- ** AND** om.name **IS NOT** NULL
	164	+**~ AND **om.name **IS NOT** NULL
165	165
166	166	**AND** p.code **IS NOT** NULL
167	167