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] => ee
)
Bind : 1 error:Prepared statement needs to be re-prepared SQL original:
SELECT *
FROM category
WHERE pid = 0
AND lang = :lang
AND pub = 'Yes'
ORDER BY `category`.`order` ASC
SQL : SELECT * FROM category WHERE pid = 0 AND lang = ? AND pub = 'Yes' ORDER BY `category`.`order` ASC Array
(
[lang] => ee
)
Bind : 1 error:Prepared statement needs to be re-prepared SQL original:
SELECT
p.*,
(SELECT SUM(pb.amount) FROM products_balance pb WHERE p.id = pb.product_id) AS balance
FROM products p, product_categories pc
WHERE (pc.category_id = (SELECT id FROM category WHERE url = :productsubgroup AND lang = :lang LIMIT 1) OR 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
GROUP BY p.id
ORDER BY `pc`.`sorder`
SQL : SELECT p.*, (SELECT SUM(pb.amount) FROM products_balance pb WHERE p.id = pb.product_id) AS balance FROM products p, product_categories pc WHERE (pc.category_id = (SELECT id FROM category WHERE url = ? AND lang = ? LIMIT 1) OR 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 GROUP BY p.id ORDER BY `pc`.`sorder` Array
(
[productsubgroup] =>
[productgroup] =>
[lang] => ee
)
Bind : 1 error:Prepared statement needs to be re-prepared SQL original:
SELECT *
FROM `slides`
WHERE `lang` = :lang
AND `site_country` = 'ee'
AND `pub` = 'No'
ORDER BY `order`
SQL : SELECT * FROM `slides` WHERE `lang` = ? AND `site_country` = 'ee' AND `pub` = 'No' ORDER BY `order` Array
(
[lang] => ee
)
Bind : 1 latpak.ee
