С нами с 08.03.06
Сообщения: 158
Рейтинг: 167
|
Добавлено: 21/04/10 в 20:23 |
Time Exec. time Message Mysql error
2010-04-21 00:32:02 0.0006 sec SELECT st_galleries.note, st_galleries.insDate, st_galleries_1.link1, st_galleries_1.link2, st_categories.name, st_categories.description, st_categories.overlay_text, st_sponsors.name as sponsor_name, st_galleries.ID, st_galleries.crc, st_galleries.ext, st_galleries.subdir, st_galleries.url, st_galleries.width, st_galleries.height, st_galleries.text_description, st_galleries.text_alt, st_galleries.thumbs, st_galleries.movies, st_galleries_1.lastclicks_period, st_galleries.groupid, st_galleries.category, (st_galleries_1.totalclicks/st_galleries_1.casts) as gallery_average, st_galleries_1.use_db_skim, st_galleries_1.skim, st_galleries_1.rating*rand() as poradi, st_galleries.family_id as family_id, st_galleries.spot_status FROM st_galleries left join st_sponsors on st_galleries.sponsorID=st_sponsors.id inner join st_categories on st_galleries.category=st_categories.id inner join st_galleries_1 on st_galleries.ID=st_galleries_1.ID where FIND_IN_SET(1,st_sponsors.enabled) AND FIND_IN_SET(1,st_categories.enabled) and st_galleries.ID=st_galleries_1.ID and st_galleries_1.enabled=1 and st_galleries_1.temp_disabled=0 and st_galleries.text=0 and st_galleries.`delete`=0 and (st_galleries.auto_crop=0 or (st_galleries.auto_crop=4 and to_montage=0)) and st_galleries_1.spot_type<>1 and st_galleries_1.spot_type<>3 and st_galleries.groupid=1 order by st_galleries_1.`force` desc, st_galleries_1.lastclicks_period desc, st_galleries_1.rating desc limit 107,-29 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-29' at line 1
кто знает куда смотреть?
|