· 8 years ago · Jan 16, 2018, 10:54 AM
1SELECT ap.id_user, (SELECT title FROM shini WHERE id=ap.id_pos) as title FROM adv_posup ap WHERE ap.id_user=38 ORDER BY type
2
3
4--
5-- Структура таблицы `shini`
6--
7
8CREATE TABLE IF NOT EXISTS `shini` (
9 `id` int(11) NOT NULL AUTO_INCREMENT,
10 `id_user` int(11) NOT NULL,
11 `date_add` int(11) NOT NULL,
12 `title` varchar(255) NOT NULL,
13 KEY `uk_2` (`uk`)
14) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=111653 ;
15
16--
17-- Дамп данных таблицы `shini`
18--
19
20INSERT INTO `shini` (`id`, `id_user`, `title`, `date_add`) VALUES
21(111139, 38, 'Шины Bridgestone Blizzak DM-V2', 1511434507),
22(111140, 38, '', 1511434507),
23(111141, 38, '', 1511434507),
24(111142, 38, '', 1511434507),
25(111143, 38, '', 1511434507),
26(111144, 38, '', 1511434507),
27(111145, 38, '', 1511434507),
28(111146, 38, 'Bridgestone Dueler A/T 694 215/65/16 бу', 1511434507),
29(111147, 38, 'Bridgestone Dueler A/T 694 235/60/16 бу', 1511434507),
30(111148, 38, 'Bridgestone Dueler A/T 694 245/65/17 бу', 1511434507),
31(111149, 38, 'Bridgestone Dueler A/T 694 265/65/17 бу', 1511434507),
32(111150, 38, 'Bridgestone Dueler A/T 694 275/65/17 бу', 1511434507),
33(111151, 38, 'Bridgestone Dueler A/T 695 235/65/17 бу', 1511434507),
34(111152, 38, 'Bridgestone Dueler A/T 695 245/65/17 бу', 1511434507),
35(111153, 38, 'Bridgestone Dueler A/T 695 255/65/17 бу', 1511434507),
36(111154, 38, 'Bridgestone Dueler A/T 695 265/65/17 бу', 1511434507),
37(111155, 38, 'Bridgestone Dueler A/T 695 265/60/18 бу', 1511434507),
38(111156, 38, 'Bridgestone Dueler A/T 695 275/65/18 бу', 1511434507),
39(111157, 38, 'Bridgestone Dueler A/T 695 275/60/20 бу', 1511434507),
40(111158, 38, 'Bridgestone Dueler A/T 697 215/65/16 бу', 1511434507),
41(111159, 38, 'Bridgestone Dueler A/T 697 235/60/16 бу', 1511434507),
42(111160, 38, 'Bridgestone Dueler A/T 697 265/65/17 бу', 1511434507),
43(111161, 38, 'Bridgestone Dueler A/T 697 275/65/17 бу', 1511434507),
44(111162, 38, 'Bridgestone Dueler H/L 400 255/65/17 бу', 1511434507),
45(111163, 38, 'Bridgestone Dueler H/L 400 235/60/18 бу', 1511434507),
46(111164, 38, 'Bridgestone Dueler H/L 400 255/55/18 бу', 1511434507),
47(111165, 38, 'Bridgestone Dueler H/L 400 235/55/19 бу', 1511434507),
48(111166, 38, 'Bridgestone Dueler H/L 400 245/55/19 бу', 1511434507),
49(111167, 38, 'Bridgestone Dueler H/L 400 255/50/19 бу', 1511434507),
50(111168, 38, 'Bridgestone Dueler H/L 400 245/50/20 бу', 1511434507),
51(111169, 38, 'Bridgestone Dueler H/L 400 265/45/21 бу', 1511434507),
52(111170, 38, 'Bridgestone Dueler H/L 683 245/65/17 бу', 1511434507),
53(111171, 38, 'Bridgestone Dueler H/L 683 265/65/18 бу', 1511434507),
54(111172, 38, 'Bridgestone Dueler H/L Alenza 275/65/18 бу', 1511434507),
55(111173, 38, 'Bridgestone Dueler H/L Alenza 255/60/19 бу', 1511434507),
56(111174, 38, 'Bridgestone Dueler H/L Alenza 255/55/20 бу', 1511434507),
57(111175, 38, 'Bridgestone Dueler H/L Alenza 275/55/20 бу', 1511434507),
58(111176, 38, 'Bridgestone Dueler H/L Alenza 275/60/20 бу', 1511434507),
59(111177, 38, 'Bridgestone Dueler H/P 680 235/65/17 бу', 1511434507),
60(111178, 38, 'Bridgestone Dueler H/P 680 235/50/18 бу', 1511434507),
61(111179, 38, 'Bridgestone Dueler H/P 680 255/55/18 бу', 1511434507),
62(111180, 38, 'Bridgestone Dueler H/P 680 265/60/18 бу', 1511434507),
63(111181, 38, 'Bridgestone Dueler H/P 680 285/50/18 бу', 1511434507),
64(111182, 38, 'Bridgestone Dueler H/P 680 285/60/18 бу', 1511434507),
65(111183, 38, 'Bridgestone Dueler H/P 680 255/50/19 бу', 1511434507),
66(111184, 38, 'Bridgestone Dueler H/P 92A 265/60/18 бу', 1511434507),
67(111185, 38, 'Bridgestone Dueler H/P 92A 265/50/20 бу', 1511434507),
68(111186, 38, 'Bridgestone Dueler H/P Sport 205/60/16 бу', 1511434507),
69(111187, 38, 'Bridgestone Dueler H/P Sport 215/65/16 бу', 1511434507),
70(111188, 38, 'Bridgestone Dueler H/P Sport 235/60/16 бу', 1511434507),
71(111189, 38, 'Bridgestone Dueler H/P Sport 255/65/16 бу', 1511434507),
72(111190, 38, 'Bridgestone Dueler H/P Sport 215/60/17 бу', 1511434507),
73(111191, 38, 'Bridgestone Dueler H/P Sport 225/50/17 бу', 1511434507),
74(111192, 38, 'Bridgestone Dueler H/P Sport 225/55/17 бу', 1511434507),
75(111193, 38, 'Bridgestone Dueler H/P Sport 225/60/17 бу', 1511434507),
76(111194, 38, 'Bridgestone Dueler H/P Sport 225/65/17 бу', 1511434507),
77(111195, 38, 'Bridgestone Dueler H/P Sport 235/55/17 бу', 1511434507),
78(111196, 38, 'Bridgestone Dueler H/P Sport 235/65/17 бу', 1511434507),
79(111197, 38, 'Bridgestone Dueler H/P Sport 255/60/17 бу', 1511434507),
80(111198, 38, 'Bridgestone Dueler H/P Sport 275/55/17 бу', 1511434507),
81(111199, 38, 'Bridgestone Dueler H/P Sport 275/60/17 бу', 1511434507),
82(111200, 38, 'Bridgestone Dueler H/P Sport 225/45/18 бу', 1511434507),
83(111201, 38, 'Bridgestone Dueler H/P Sport 225/55/18 бу', 1511434507),
84(111202, 38, 'Bridgestone Dueler H/P Sport 235/55/18 бу', 1511434507),
85(111203, 38, 'Bridgestone Dueler H/P Sport 235/60/18 бу', 1511434507),
86(111204, 38, 'Bridgestone Dueler H/P Sport 235/65/18 бу', 1511434507),
87(111205, 38, 'Bridgestone Dueler H/P Sport 255/55/18 бу', 1511434507),
88(111206, 38, 'Bridgestone Dueler H/P Sport 255/60/18 бу', 1511434507),
89(111207, 38, 'Bridgestone Dueler H/P Sport 265/60/18 бу', 1511434507),
90(111208, 38, 'Bridgestone Dueler H/P Sport 275/60/18 бу', 1511434507),
91(111209, 38, 'Bridgestone Dueler H/P Sport 285/50/18 бу', 1511434507),
92(111210, 38, 'Bridgestone Dueler H/P Sport 285/55/18 бу', 1511434507),
93(111211, 38, 'Bridgestone Dueler H/P Sport 285/60/18 бу', 1511434507),
94(111212, 38, 'Bridgestone Dueler H/P Sport 235/50/19 бу', 1511434507),
95(111213, 38, 'Bridgestone Dueler H/P Sport 235/55/19 бу', 1511434507),
96(111214, 38, 'Bridgestone Dueler H/P Sport 255/45/19 бу', 1511434507),
97(111215, 38, 'Bridgestone Dueler H/P Sport 255/50/19 бу', 1511434507),
98(111216, 38, 'Bridgestone Dueler H/P Sport 265/50/19 бу', 1511434507),
99(111217, 38, 'Bridgestone Dueler H/P Sport 275/45/19 бу', 1511434507),
100(111218, 38, 'Bridgestone Dueler H/P Sport 285/45/19 бу', 1511434507),
101(111219, 38, 'Bridgestone Dueler H/P Sport 235/45/20 бу', 1511434507),
102(111220, 38, 'Bridgestone Dueler H/P Sport 255/40/20 бу', 1511434507),
103(111221, 38, 'Bridgestone Dueler H/P Sport 255/45/20 бу', 1511434507),
104(111222, 38, 'Bridgestone Dueler H/P Sport 255/50/20 бу', 1511434507),
105(111223, 38, 'Bridgestone Dueler H/P Sport 265/50/20 бу', 1511434507),
106(111224, 38, 'Bridgestone Dueler H/P Sport 275/40/20 бу', 1511434507),
107(111225, 38, 'Bridgestone Dueler H/P Sport 275/45/20 бу', 1511434507),
108(111226, 38, 'Bridgestone Dueler H/P Sport 315/35/20 бу', 1511434507),
109(111227, 38, 'Bridgestone Dueler H/T 684 205/65/16 бу', 1511434507),
110(111228, 38, 'Bridgestone Dueler H/T 684 265/65/17 бу', 1511434507),
111(111229, 38, 'Bridgestone Dueler H/T 684 285/60/18 бу', 1511434507),
112(111230, 38, 'Bridgestone Dueler H/T 684 II 235/60/16 бу', 1511434507),
113(111231, 38, 'Bridgestone Dueler H/T 684 II 235/65/16 бу', 1511434507),
114(111232, 38, 'Bridgestone Dueler H/T 684 II 235/60/17 бу', 1511434507),
115(111233, 38, 'Bridgestone Dueler H/T 684 II 245/65/17 бу', 1511434507),
116(111234, 38, 'Bridgestone Dueler H/T 684 II 255/65/17 бу', 1511434507),
117(111235, 38, 'Bridgestone Dueler H/T 684 II 265/65/17 бу', 1511434507),
118(111236, 38, 'Bridgestone Dueler H/T 684 II 235/60/18 бу', 1511434507),
119(111237, 38, 'Bridgestone Dueler H/T 684 II 235/65/18 бу', 1511434507),
120(111238, 38, 'Bridgestone Dueler H/T 684 II 255/60/18 бу', 1511434507);
121
122
123
124--
125-- Структура таблицы `adv_posup`
126--
127
128CREATE TABLE IF NOT EXISTS `adv_posup` (
129 `id` int(11) NOT NULL AUTO_INCREMENT,
130 `id_user` int(11) NOT NULL,
131 `type` enum('shini','motoshini','gruzshini','diski') NOT NULL,
132 `id_pos` int(11) NOT NULL,
133 PRIMARY KEY (`id`)
134) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=607 ;
135
136--
137-- Дамп данных таблицы `adv_posup`
138--
139
140INSERT INTO `adv_posup` (`id`, `id_user`, `type`, `id_pos`) VALUES
141(606, 38, 'shini', 111634),
142(605, 38, 'shini', 111631),
143(604, 38, 'shini', 111630),
144(603, 38, 'shini', 111612),
145(602, 38, 'shini', 111610),
146(601, 38, 'shini', 111600),
147(600, 38, 'shini', 111594),
148(599, 38, 'shini', 111591),
149(598, 38, 'shini', 111585),
150(597, 38, 'shini', 111584),
151(596, 38, 'shini', 111583),
152(595, 38, 'shini', 111581),
153(594, 38, 'shini', 111579),
154(593, 38, 'shini', 111578),
155(592, 38, 'shini', 111576),
156(591, 38, 'shini', 111568),
157(590, 38, 'shini', 111559),
158(589, 38, 'shini', 111558),
159(588, 38, 'shini', 111557),
160(587, 38, 'shini', 111553),
161(586, 38, 'shini', 111547),
162(585, 38, 'shini', 111538),
163(584, 38, 'shini', 111537),
164(583, 38, 'shini', 111532),
165(582, 38, 'shini', 111521),
166(581, 38, 'shini', 111514),
167(580, 38, 'shini', 111505),
168(579, 38, 'shini', 111504),
169(578, 38, 'shini', 111503),
170(577, 38, 'shini', 111501),
171(576, 38, 'shini', 111498),
172(575, 38, 'shini', 111497),
173(574, 38, 'shini', 111496),
174(573, 38, 'shini', 111495),
175(572, 38, 'shini', 111486),
176(571, 38, 'shini', 111478),
177(570, 38, 'shini', 111454),
178(569, 38, 'shini', 111443),
179(568, 38, 'shini', 111442),
180(567, 38, 'shini', 111436),
181(566, 38, 'shini', 111432),
182(565, 38, 'shini', 111431),
183(564, 38, 'shini', 111416),
184(563, 38, 'shini', 111415),
185(562, 38, 'shini', 111412),
186(561, 38, 'shini', 111406),
187(560, 38, 'shini', 111396),
188(559, 38, 'shini', 111394),
189(558, 38, 'shini', 111388),
190(557, 38, 'shini', 111387),
191(556, 38, 'shini', 111384),
192(555, 38, 'shini', 111378),
193(554, 38, 'shini', 111377),
194(553, 38, 'shini', 111373),
195(552, 38, 'shini', 111368),
196(551, 38, 'shini', 111367),
197(550, 38, 'shini', 111358),
198(549, 38, 'shini', 111357),
199(548, 38, 'shini', 111355),
200(547, 38, 'shini', 111353),
201(546, 38, 'shini', 111348),
202(545, 38, 'shini', 111344),
203(544, 38, 'shini', 111343),
204(543, 38, 'shini', 111338),
205(542, 38, 'shini', 111331),
206(541, 38, 'shini', 111321),
207(540, 38, 'shini', 111318),
208(539, 38, 'shini', 111312),
209(538, 38, 'shini', 111308),
210(537, 38, 'shini', 111295),
211(536, 38, 'shini', 111294),
212(535, 38, 'shini', 111293),
213(534, 38, 'shini', 111292),
214(533, 38, 'shini', 111290),
215(532, 38, 'shini', 111282),
216(531, 38, 'shini', 111280),
217(530, 38, 'shini', 111278),
218(529, 38, 'shini', 111264),
219(528, 38, 'shini', 111242),
220(527, 38, 'shini', 111240),
221(526, 38, 'shini', 111235),
222(525, 38, 'shini', 111233),
223(524, 38, 'shini', 111231),
224(523, 38, 'shini', 111226),
225(522, 38, 'shini', 111219),
226(521, 38, 'shini', 111218),
227(520, 38, 'shini', 111217),
228(519, 38, 'shini', 111214),
229(518, 38, 'shini', 111207),
230(517, 38, 'shini', 111199),
231(516, 38, 'shini', 111172),
232(515, 38, 'shini', 111169),
233(514, 38, 'shini', 111168),
234(513, 38, 'shini', 111163),
235(512, 38, 'shini', 111160),
236(511, 38, 'shini', 111159),
237(510, 38, 'shini', 111150),
238(509, 38, 'shini', 111147),
239(508, 38, 'shini', 111144),
240(507, 38, 'shini', 111140);