Kāpēc tad pagājušo otrdien nebija nekas labs sakaxorots un/vai atsaite nebija līdz pods.lv atnākusi? Te jau viens kaut kad senāk komentāros solīja, ka būšot pārsteigumi katru otrdienu.
Cilvēki savā būtībā ir ļoti vienkārši un priekš pilnas laimes viņiem daudz nevajag…
Aber biji tu tas vai nebiji… vai tad tas kādu interesē… kāds kaut ko ieņems galvā… atradīs tevi… “parunāsies” un jutīsies laimīgs… un nedomāju, ka viņu(-s) interesēs tavi argumenti…
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 ‘1’ AND c.`published`=’1′
ORDER BY top.`added`
)
‘ at line 67
(SELECT
m.`id`, ” AS friend_url,” AS friend_url2, ”AS friend_url3, m.`name`, m.`description`
FROM `zm_menu` AS m
WHERE
(LOWER(m.`name`) LIKE LOWER(‘%’%’) OR LOWER(m.`description`) LIKE LOWER(‘%’%’))
AND m.`published`=’1′ AND m.`component`=’self’
ORDER BY
m.`ordering`)
UNION
(SELECT
m.`id`, t.`friend_url` AS friend_url, ” AS friend_url2, ”AS friend_url3, t.`name`, t.`intro` AS description
FROM
`zm_menu` AS m
LEFT JOIN `zm_text` AS t ON t.`cat_id`=m.`id`
WHERE
(LOWER(t.`name`) LIKE LOWER(‘%’%’) OR LOWER(t.`author`) LIKE LOWER(‘%’%’) OR LOWER(t.`intro`) LIKE LOWER(‘%’%’) OR LOWER(t.`full`) LIKE LOWER(‘%’%’))
AND m.`published`=’1′ AND t.`published`=’1′ AND m.`component`=’news’
ORDER BY t.`added`
)
UNION
(SELECT
m.`id`, c.`friend_url` AS friend_url, ” AS friend_url2, ”AS friend_url3, l.`name`, CONCAT_WS(‘;’,l.`target`,l.`added` , l.`link`) AS description
FROM
`zm_menu` AS m
LEFT JOIN `zm_link` AS l ON l.`target`=m.`component_id`
LEFT JOIN `zm_category` AS c ON c.`id`=l.`cat_id`
WHERE
(
LOWER(l.`link`) LIKE LOWER(‘%’%’) OR LOWER(l.`name`) LIKE LOWER(‘%’%’)
)
AND m.`published`=’1′ AND l.`published`=’1′ AND m.`component`=’reader’ AND c.`published`=’1′
ORDER BY l.`ordering`
)
UNION
(SELECT
m.`id`, CONCAT_WS(”,’#’, t.`friend_url`) AS friend_url, ” AS friend_url2, ”AS friend_url3, t.`name`, t.`intro` AS description
FROM
`zm_menu` AS m
LEFT JOIN `zm_text` AS t ON t.`cat_id`=m.`id`
WHERE
(LOWER(t.`name`) LIKE LOWER(‘%’%’) OR LOWER(t.`author`) LIKE LOWER(‘%’%’) OR LOWER(t.`intro`) LIKE LOWER(‘%’%’) OR LOWER(t.`full`) LIKE LOWER(‘%’%’))
AND m.`published`=’1′ AND t.`published`=’1′ AND m.`component`=’text’
ORDER BY t.`added`
)
UNION
(SELECT
‘4’ AS id, c.`friend_url` AS friend_url, top.`friend_url` AS friend_url2, ”AS friend_url3, c.`name`, top.`question` AS description
FROM
`zm_f_topics` AS top
LEFT JOIN `zm_category` AS c ON c.`id`=top.`cat_id`
WHERE
(LOWER(top.`name`) LIKE LOWER(‘%’%’) OR LOWER(top.`author_name`) LIKE LOWER(‘%’%’) OR LOWER(top.`question`) LIKE LOWER(‘%’%’) OR LOWER(top.`answer`) LIKE LOWER(‘%’%’)
OR LOWER(top.`email`) LIKE LOWER(‘%’%’)
)
AND top.`published`=’1′ AND c.`published`=’1′
ORDER BY top.`added`
)
UNION
(SELECT
‘4’ AS id, c.`friend_url` AS friend_url, top.`friend_url` AS friend_url2, CONCAT_WS(”, ‘#c’, mes.`id`) AS friend_url3, top.`question` AS name, mes.`messege` AS description
FROM
`zm_f_topics` AS top
LEFT JOIN `zm_f_messeges` AS mes ON mes.`topic_id`=top.`id`
LEFT JOIN `zm_category` AS c ON c.`id`=top.`cat_id`
WHERE
(LOWER(mes.`messege`) LIKE LOWER(‘%’%’) OR LOWER(mes.`author_name`) LIKE LOWER(‘%’%’)
)
AND top.`published`=’1′ AND c.`published`=’1′ AND mes.`published`=’1′
ORDER BY mes.`added`
)
nu vnk ģeniāli! 😀
Kāpēc tad pagājušo otrdien nebija nekas labs sakaxorots un/vai atsaite nebija līdz pods.lv atnākusi? Te jau viens kaut kad senāk komentāros solīja, ka būšot pārsteigumi katru otrdienu.
tas nav smiekliigi —McB–riebj–taa tava dir….
nabags nepaardziivo nejau katru pirmdienu cilveeks var dzert.
McB, mēs jau nākam gaidi ciemos 🙂
P.S. kāds var ieteikt betonam lētu zobu protēžu klīniku Liepājā? 🙂
zeeni atlaiz
ir –jau kliininika ar porcelaana zobiishiem Ventspileee-personiigaa-hi-ha
😀
Rekā te! Trakā kaimiņu Anna uzhako mājaslapu bet es vainīgs! 😀 KO NU!?
P.S. Tie zaļās mājas veči nejoko. Paskat, re ku šiem 1 no expertiem ir Žoriks Vartanofs no Piķigorskas! Tas jau ir nopietni…
Betons. Kurš gan cits…
Beton, te nu varētu but problēma…
Cilvēki savā būtībā ir ļoti vienkārši un priekš pilnas laimes viņiem daudz nevajag…
Aber biji tu tas vai nebiji… vai tad tas kādu interesē… kāds kaut ko ieņems galvā… atradīs tevi… “parunāsies” un jutīsies laimīgs… un nedomāju, ka viņu(-s) interesēs tavi argumenti…
“Sad But True” ©
Vajag e-baznīcu.lv nodedzināt!
Tajā meklētājā vajag ierakstīt kādu ‘ (apostrofs) vai * un tad jau viss kļūst skaidrs.
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 ‘1’ AND c.`published`=’1′
ORDER BY top.`added`
)
‘ at line 67
(SELECT
m.`id`, ” AS friend_url,” AS friend_url2, ”AS friend_url3, m.`name`, m.`description`
FROM `zm_menu` AS m
WHERE
(LOWER(m.`name`) LIKE LOWER(‘%’%’) OR LOWER(m.`description`) LIKE LOWER(‘%’%’))
AND m.`published`=’1′ AND m.`component`=’self’
ORDER BY
m.`ordering`)
UNION
(SELECT
m.`id`, t.`friend_url` AS friend_url, ” AS friend_url2, ”AS friend_url3, t.`name`, t.`intro` AS description
FROM
`zm_menu` AS m
LEFT JOIN `zm_text` AS t ON t.`cat_id`=m.`id`
WHERE
(LOWER(t.`name`) LIKE LOWER(‘%’%’) OR LOWER(t.`author`) LIKE LOWER(‘%’%’) OR LOWER(t.`intro`) LIKE LOWER(‘%’%’) OR LOWER(t.`full`) LIKE LOWER(‘%’%’))
AND m.`published`=’1′ AND t.`published`=’1′ AND m.`component`=’news’
ORDER BY t.`added`
)
UNION
(SELECT
m.`id`, c.`friend_url` AS friend_url, ” AS friend_url2, ”AS friend_url3, l.`name`, CONCAT_WS(‘;’,l.`target`,l.`added` , l.`link`) AS description
FROM
`zm_menu` AS m
LEFT JOIN `zm_link` AS l ON l.`target`=m.`component_id`
LEFT JOIN `zm_category` AS c ON c.`id`=l.`cat_id`
WHERE
(
LOWER(l.`link`) LIKE LOWER(‘%’%’) OR LOWER(l.`name`) LIKE LOWER(‘%’%’)
)
AND m.`published`=’1′ AND l.`published`=’1′ AND m.`component`=’reader’ AND c.`published`=’1′
ORDER BY l.`ordering`
)
UNION
(SELECT
m.`id`, CONCAT_WS(”,’#’, t.`friend_url`) AS friend_url, ” AS friend_url2, ”AS friend_url3, t.`name`, t.`intro` AS description
FROM
`zm_menu` AS m
LEFT JOIN `zm_text` AS t ON t.`cat_id`=m.`id`
WHERE
(LOWER(t.`name`) LIKE LOWER(‘%’%’) OR LOWER(t.`author`) LIKE LOWER(‘%’%’) OR LOWER(t.`intro`) LIKE LOWER(‘%’%’) OR LOWER(t.`full`) LIKE LOWER(‘%’%’))
AND m.`published`=’1′ AND t.`published`=’1′ AND m.`component`=’text’
ORDER BY t.`added`
)
UNION
(SELECT
‘4’ AS id, c.`friend_url` AS friend_url, top.`friend_url` AS friend_url2, ”AS friend_url3, c.`name`, top.`question` AS description
FROM
`zm_f_topics` AS top
LEFT JOIN `zm_category` AS c ON c.`id`=top.`cat_id`
WHERE
(LOWER(top.`name`) LIKE LOWER(‘%’%’) OR LOWER(top.`author_name`) LIKE LOWER(‘%’%’) OR LOWER(top.`question`) LIKE LOWER(‘%’%’) OR LOWER(top.`answer`) LIKE LOWER(‘%’%’)
OR LOWER(top.`email`) LIKE LOWER(‘%’%’)
)
AND top.`published`=’1′ AND c.`published`=’1′
ORDER BY top.`added`
)
UNION
(SELECT
‘4’ AS id, c.`friend_url` AS friend_url, top.`friend_url` AS friend_url2, CONCAT_WS(”, ‘#c’, mes.`id`) AS friend_url3, top.`question` AS name, mes.`messege` AS description
FROM
`zm_f_topics` AS top
LEFT JOIN `zm_f_messeges` AS mes ON mes.`topic_id`=top.`id`
LEFT JOIN `zm_category` AS c ON c.`id`=top.`cat_id`
WHERE
(LOWER(mes.`messege`) LIKE LOWER(‘%’%’) OR LOWER(mes.`author_name`) LIKE LOWER(‘%’%’)
)
AND top.`published`=’1′ AND c.`published`=’1′ AND mes.`published`=’1′
ORDER BY mes.`added`
)