error:Prepared statement needs to be re-prepared
SQL original:

SELECT title, url AS uid, 1 AS level,
(
SELECT count(p.id)
FROM products p, product_categories pc
WHERE pc.category_id =
(
SELECT id
FROM category
WHERE url = :productgroup AND lang = :lang
LIMIT 1
)
AND p.lang = :lang
AND p.pub = 'Yes'
AND p.id = pc.product_id
) AS pcount FROM category WHERE url = :productgroup AND lang = :lang
UNION
SELECT title, url AS uid, 2 AS level, -1 AS pcount FROM category WHERE url = :productsubgroup AND lang = :lang
UNION
SELECT title, id AS uid, 3 AS level, -1 AS pcount FROM products WHERE id = :product AND lang = :lang

SQL :
SELECT title, url AS uid, 1 AS level, ( SELECT count(p.id) FROM products p, product_categories pc WHERE pc.category_id = ( SELECT id FROM category WHERE url = ? AND lang = ? LIMIT 1 ) AND p.lang = ? AND p.pub = 'Yes' AND p.id = pc.product_id ) AS pcount FROM category WHERE url = ? AND lang = ? UNION SELECT title, url AS uid, 2 AS level, -1 AS pcount FROM category WHERE url = ? AND lang = ? UNION SELECT title, id AS uid, 3 AS level, -1 AS pcount FROM products WHERE id = ? AND lang = ?
Array ( [productgroup] => jaunumi_2022 [productsubgroup] => [product] => 8145 [lang] => lv ) Bind :
1
error:Prepared statement needs to be re-prepared
SQL original:

SELECT
c0.*,
CASE
WHEN c0.pid = 0 THEN CONCAT(LPAD(c0.order, 4, '0'), '0000')
ELSE CONCAT(LPAD((SELECT c1.order FROM category c1 WHERE c1.id = c0.pid AND c1.lang = :lang), 4, '0'), LPAD(c0.order, 4, '0'))
END AS o1
FROM category c0
WHERE c0.lang = :lang
AND c0.pub = 'Yes'
ORDER BY o1 ASC

SQL :
SELECT c0.*, CASE WHEN c0.pid = 0 THEN CONCAT(LPAD(c0.order, 4, '0'), '0000') ELSE CONCAT(LPAD((SELECT c1.order FROM category c1 WHERE c1.id = c0.pid AND c1.lang = ?), 4, '0'), LPAD(c0.order, 4, '0')) END AS o1 FROM category c0 WHERE c0.lang = ? AND c0.pub = 'Yes' ORDER BY o1 ASC
Array ( [lang] => lv ) Bind :
1
error:Prepared statement needs to be re-prepared
SQL original:

SELECT *,
(SELECT title FROM category WHERE url = :productgroup AND lang = :lang LIMIT 1) AS title0,
(SELECT photos FROM category WHERE url = :productgroup AND lang = :lang LIMIT 1) AS photos0,
(SELECT id FROM category WHERE url = :productgroup AND lang = :lang LIMIT 1) AS id0
FROM category
WHERE pid = (SELECT id FROM category WHERE url = :productgroup AND lang = :lang LIMIT 1)
AND lang = :lang
AND pub = 'Yes'
ORDER BY `category`.`order` ASC

SQL :
SELECT *, (SELECT title FROM category WHERE url = ? AND lang = ? LIMIT 1) AS title0, (SELECT photos FROM category WHERE url = ? AND lang = ? LIMIT 1) AS photos0, (SELECT id FROM category WHERE url = ? AND lang = ? LIMIT 1) AS id0 FROM category WHERE pid = (SELECT id FROM category WHERE url = ? AND lang = ? LIMIT 1) AND lang = ? AND pub = 'Yes' ORDER BY `category`.`order` ASC
Array ( [productgroup] => jaunumi_2022 [lang] => lv ) Bind :
1
error:Prepared statement needs to be re-prepared
SQL original:

SELECT *
FROM category
WHERE url = :productgroup
AND lang = :lang
AND pub = 'Yes'
LIMIT 1

SQL :
SELECT * FROM category WHERE url = ? AND lang = ? AND pub = 'Yes' LIMIT 1
Array ( [productgroup] => jaunumi_2022 [lang] => lv ) Bind :
1
error:Prepared statement needs to be re-prepared
SQL original:

SELECT p.*,
p.*,
(SELECT SUM(pb.amount) FROM products_balance pb WHERE p.id = pb.product_id) AS balance
FROM products p
WHERE id = :id
AND lang = :lang

SQL :
SELECT p.*, p.*, (SELECT SUM(pb.amount) FROM products_balance pb WHERE p.id = pb.product_id) AS balance FROM products p WHERE id = ? AND lang = ?
Array ( [lang] => lv [id] => 8145 ) Bind :
1
Ieliecmaisa.lv

Kā mūs atrast:

Izpārdots

  • Izmērs:
  • Preces kods:
  • Min. daudz:

Cena norādīta par

€ 0.00

Kopā:

0.00

Izpārdots

  • Izmērs:
  • Preces kods:
  • Min. daudz:

Cena norādīta par

€ 0.00





Kopā: 0.00 



Jautā mums!

E-pasta pielikums
Ar * apzīmētie lauki ir obligāti aizpildāmi.

Produkts veiksmīgi ievietots iepirkumu maisā!

Reģistrētiem lietotājiem

Jauniem lietotājiem

IM_vector