By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Records: 221 Duplicates: 0 Warnings: 0
Records: 18 Duplicates: 0 Warnings: 0
id | category_id |
---|---|
1 | 2 |
2 | 6 |
3 | 10 |
4 | 14 |
5 | 2 |
6 | 4 |
7 | 8 |
8 | 12 |
9 | 16 |
10 | 2 |
11 | 6 |
12 | 10 |
13 | 14 |
14 | 2 |
15 | 4 |
16 | 8 |
17 | 12 |
18 | 16 |
19 | 2 |
20 | 6 |
21 | 10 |
22 | 14 |
23 | 2 |
24 | 4 |
25 | 8 |
26 | 12 |
27 | 16 |
28 | 2 |
29 | 6 |
30 | 10 |
31 | 14 |
32 | 2 |
33 | 4 |
34 | 8 |
35 | 12 |
36 | 16 |
37 | 2 |
38 | 6 |
39 | 10 |
40 | 14 |
41 | 2 |
42 | 4 |
43 | 8 |
44 | 12 |
45 | 16 |
46 | 2 |
47 | 6 |
48 | 10 |
49 | 14 |
50 | 2 |
51 | 4 |
52 | 8 |
53 | 12 |
54 | 16 |
55 | 2 |
56 | 6 |
57 | 10 |
58 | 14 |
59 | 2 |
60 | 4 |
61 | 8 |
62 | 12 |
63 | 16 |
64 | 2 |
65 | 6 |
66 | 10 |
67 | 14 |
68 | 2 |
69 | 4 |
70 | 8 |
71 | 12 |
72 | 16 |
73 | 2 |
74 | 6 |
75 | 10 |
76 | 14 |
77 | 2 |
78 | 4 |
79 | 8 |
80 | 12 |
81 | 16 |
82 | 2 |
83 | 6 |
84 | 10 |
85 | 14 |
86 | 2 |
87 | 4 |
88 | 8 |
89 | 12 |
90 | 16 |
91 | 2 |
92 | 6 |
93 | 10 |
94 | 14 |
95 | 2 |
96 | 4 |
97 | 8 |
98 | 12 |
99 | 16 |
100 | 2 |
101 | 6 |
102 | 10 |
103 | 14 |
104 | 2 |
105 | 4 |
106 | 8 |
107 | 12 |
108 | 16 |
109 | 2 |
110 | 6 |
111 | 10 |
112 | 14 |
113 | 2 |
114 | 4 |
115 | 8 |
116 | 12 |
117 | 16 |
118 | 2 |
119 | 6 |
120 | 10 |
121 | 14 |
122 | 2 |
123 | 4 |
124 | 8 |
125 | 12 |
126 | 16 |
127 | 2 |
128 | 6 |
129 | 10 |
130 | 14 |
131 | 2 |
132 | 4 |
133 | 8 |
134 | 12 |
135 | 16 |
136 | 2 |
137 | 6 |
138 | 10 |
139 | 14 |
140 | 2 |
141 | 4 |
142 | 8 |
143 | 12 |
144 | 16 |
145 | 2 |
146 | 6 |
147 | 10 |
148 | 14 |
149 | 2 |
150 | 4 |
151 | 8 |
152 | 12 |
153 | 16 |
154 | 2 |
155 | 6 |
156 | 10 |
157 | 14 |
158 | 2 |
159 | 4 |
160 | 8 |
161 | 12 |
162 | 16 |
163 | 2 |
164 | 6 |
165 | 10 |
166 | 14 |
167 | 2 |
168 | 4 |
169 | 8 |
170 | 12 |
171 | 16 |
172 | 2 |
173 | 6 |
174 | 10 |
175 | 14 |
176 | 2 |
177 | 4 |
178 | 8 |
179 | 12 |
180 | 16 |
181 | 2 |
182 | 6 |
183 | 10 |
184 | 14 |
185 | 2 |
186 | 4 |
187 | 8 |
188 | 12 |
189 | 16 |
190 | 2 |
191 | 6 |
192 | 10 |
193 | 14 |
194 | 2 |
195 | 4 |
196 | 8 |
197 | 12 |
198 | 16 |
199 | 2 |
200 | 6 |
201 | 10 |
202 | 14 |
203 | 2 |
204 | 4 |
205 | 8 |
206 | 12 |
207 | 16 |
208 | 2 |
209 | 6 |
210 | 10 |
211 | 14 |
212 | 2 |
213 | 4 |
214 | 8 |
215 | 12 |
216 | 16 |
217 | 2 |
218 | 6 |
219 | 10 |
220 | 14 |
221 | 18 |
id | num_of_products |
---|---|
1 | 0 |
2 | 0 |
3 | 0 |
4 | 0 |
5 | 0 |
6 | 0 |
7 | 0 |
8 | 0 |
9 | 0 |
10 | 0 |
11 | 0 |
12 | 0 |
13 | 0 |
14 | 0 |
15 | 0 |
16 | 0 |
17 | 0 |
18 | 0 |
id | COUNT(p.id) |
---|---|
2 | 49 |
6 | 25 |
10 | 25 |
14 | 25 |
4 | 24 |
8 | 24 |
12 | 24 |
16 | 24 |
18 | 1 |
Rows matched: 9 Changed: 9 Warnings: 0
id | num_of_products |
---|---|
1 | 0 |
2 | 49 |
3 | 0 |
4 | 24 |
5 | 0 |
6 | 25 |
7 | 0 |
8 | 24 |
9 | 0 |
10 | 25 |
11 | 0 |
12 | 24 |
13 | 0 |
14 | 25 |
15 | 0 |
16 | 24 |
17 | 0 |
18 | 1 |