|
Конечно, при применении такого запроса
select a.adres, p1.data, p1.pokaz, p2.data, p2.pokaz, p3.data, p3.pokaz, p4.data, p4.pokaz, p5.data, p5.pokaz, p6.data, p6.pokaz, p7.data, p7.pokaz, p8.data, p8.pokaz, p9.data, p9.pokaz, p10.data, p10.pokaz, p11.data, p11.pokaz, p12.data, p12.pokaz, p13.data, p13.pokaz, p14.data, p14.pokaz, p15.data, p15.pokaz, p16.data, p16.pokaz, p17.data, p17.pokaz, p18.data, p18.pokaz, p19.data, p19.pokaz, p20.data, p20.pokaz, p21.data, p21.pokaz, p22.data, p22.pokaz, p23.data, p23.pokaz, p24.data, p24.pokaz, p25.data, p25.pokaz, p26.data, p26.pokaz, p27.data, p27.pokaz, p28.data, p28.pokaz, p29.data, p29.pokaz, p30.data, p30.pokaz
from probabon as p1
left join adresprobabon as a on a.uniq=p1.touniq
left join probabon as p2 on p2.touniq=p1.touniq and date_format(p2.data, '%d')=2
left join probabon as p3 on p3.touniq=p1.touniq and date_format(p3.data, '%d')=3
left join probabon as p4 on p4.touniq=p1.touniq and date_format(p4.data, '%d')=4
left join probabon as p5 on p5.touniq=p1.touniq and date_format(p5.data, '%d')=5
left join probabon as p6 on p6.touniq=p1.touniq and date_format(p6.data, '%d')=6
left join probabon as p7 on p7.touniq=p1.touniq and date_format(p7.data, '%d')=7
left join probabon as p8 on p8.touniq=p1.touniq and date_format(p8.data, '%d')=8
left join probabon as p9 on p9.touniq=p1.touniq and date_format(p9.data, '%d')=9
left join probabon as p10 on p10.touniq=p1.touniq and date_format(p10.data, '%d')=10
left join probabon as p11 on p11.touniq=p1.touniq and date_format(p11.data, '%d')=11
left join probabon as p12 on p12.touniq=p1.touniq and date_format(p12.data, '%d')=12
left join probabon as p13 on p13.touniq=p1.touniq and date_format(p2.data, '%d')=13
left join probabon as p14 on p14.touniq=p1.touniq and date_format(p3.data, '%d')=14
left join probabon as p15 on p15.touniq=p1.touniq and date_format(p4.data, '%d')=15
left join probabon as p16 on p16.touniq=p1.touniq and date_format(p5.data, '%d')=16
left join probabon as p17 on p17.touniq=p1.touniq and date_format(p6.data, '%d')=17
left join probabon as p18 on p18.touniq=p1.touniq and date_format(p7.data, '%d')=18
left join probabon as p19 on p19.touniq=p1.touniq and date_format(p8.data, '%d')=19
left join probabon as p20 on p20.touniq=p1.touniq and date_format(p9.data, '%d')=20
left join probabon as p21 on p21.touniq=p1.touniq and date_format(p10.data, '%d')=21
left join probabon as p22 on p22.touniq=p1.touniq and date_format(p11.data, '%d')=22
left join probabon as p23 on p23.touniq=p1.touniq and date_format(p12.data, '%d')=23
left join probabon as p24 on p24.touniq=p1.touniq and date_format(p10.data, '%d')=24
left join probabon as p25 on p25.touniq=p1.touniq and date_format(p11.data, '%d')=25
left join probabon as p26 on p26.touniq=p1.touniq and date_format(p12.data, '%d')=26
left join probabon as p27 on p27.touniq=p1.touniq and date_format(p10.data, '%d')=27
left join probabon as p28 on p28.touniq=p1.touniq and date_format(p11.data, '%d')=28
left join probabon as p29 on p29.touniq=p1.touniq and date_format(p12.data, '%d')=29
left join probabon as p30 on p30.touniq=p1.touniq and date_format(p10.data, '%d')=30
where date_format(p1.data, '%d')=1
работает, если же добавляю еще одну таблицу в запрос, выдает что превышен предел в 31 таблицу.
|
