14 thoughts on “Diršana zaļā pļavā

  1. hmmmmm

    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.

    Atbildēt
  2. Andron Mc

    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…

    Atbildēt
  3. Bibo

    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” ©

    Atbildēt
  4. CooLynX Raksta autors

    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`
    )

    Atbildēt

Atbildēt uz komentāru Arnolds Atcelt atbildi

Tava e-pasta adrese netiks publicēta. Obligātie lauki ir atzīmēti kā *