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] => papira-maisini-ar-plakanu-pamatni
[productsubgroup] =>
[product] => 500
[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] => papira-maisini-ar-plakanu-pamatni
[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] => papira-maisini-ar-plakanu-pamatni
[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] => 500
)
Bind : 1 Ieliecmaisa.lv
