задачка для детсада))
(рубрика: мозхолом)Решите задачку для детского сада.
8809 = 6
7111 = 0
2172 = 0
6666 = 4
1111 = 0
3213 = 0
7662 = 2
9312 = 1
0000 = 4
2222 = 0
3333 = 0
5555 = 0
8193 = 3
8096 = 5
7777 = 0
9999 = 4
7756 = 1
6855 = 3
9881 = 5
5531 = 0
2581 = ?
Коменнтарии:
SQL Error: Column 'data_public' in order clause is ambiguous at /home/liveblogs/smarty/plugins/function.comments.php line 42Array
(
[code] => 1052
[message] => Column 'data_public' in order clause is ambiguous
[query] =>
SELECT
c.ID as ID,
c.content as comm_content,
c.data_public as comm_data_public,
c.data_redact as comm_data_redact,
b1.login as comm_autor,
b2.login as comm_redactor,
p.catID as catID,
c.autor_ID as comm_autor_ID
FROM gp_comments as c
LEFT JOIN gp_base_regs as b1
ON b1.ID=c.autor_ID
LEFT JOIN gp_base_regs as b2
ON b2.ID=c.redactor_ID
LEFT JOIN gp_public as p
ON c.comment_obj=p.ID
WHERE c.comment_obj=939 order by data_public
[context] => /home/liveblogs/smarty/plugins/function.comments.php line 42
)
