SELECT h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module, h.`live_edit`
FROM `ps_module` m
INNER JOIN ps_module_shop module_shop
ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1 AND module_shop.enable_device & 1)
INNER JOIN `ps_module_shop` ms ON ms.`id_module` = m.`id_module`
INNER JOIN `ps_hook_module` hm ON hm.`id_module` = m.`id_module`
INNER JOIN `ps_hook` h ON hm.`id_hook` = h.`id_hook`
LEFT JOIN `ps_module_group` `mg` ON mg.`id_module` = m.`id_module`
WHERE (h.name != "displayPayment") AND (hm.id_shop = 1) AND (mg.id_shop = 1 AND mg.`id_group` IN (1))
GROUP BY hm.id_hook, hm.id_module
ORDER BY hm.`position`
SELECT id_shop
FROM `ps_lang_shop`
WHERE `id_lang` = 2
AND id_shop = 1 LIMIT 1
SELECT `id_country`
FROM `ps_country`
WHERE `iso_code` = 'EE' LIMIT 1
SELECT *
FROM `ps_currency` a
LEFT JOIN `ps_currency_shop` `c` ON a.id_currency = c.id_currency AND c.id_shop = 1
WHERE (a.id_currency = 1)
LIMIT 1
SELECT id_shop
FROM `ps_currency_shop`
WHERE `id_currency` = 1
AND id_shop = 1 LIMIT 1
SELECT *
FROM `ps_group` a
LEFT JOIN `ps_group_shop` `c` ON a.id_group = c.id_group AND c.id_shop = 1
WHERE (a.id_group = 1)
LIMIT 1
SELECT * FROM `ps_group_lang`
WHERE `id_group` = 1
SELECT id_shop
FROM `ps_group_shop`
WHERE `id_group` = 1
AND id_shop = 1 LIMIT 1
SELECT *
FROM ps_meta m
LEFT JOIN ps_meta_lang ml ON m.id_meta = ml.id_meta
WHERE (
m.page = "order-opc"
OR m.page = "orderopc"
)
AND ml.id_lang = 2
AND ml.id_shop = 1 LIMIT 1
SELECT *
FROM `ps_currency` c
INNER JOIN ps_currency_shop currency_shop
ON (currency_shop.id_currency = c.id_currency AND currency_shop.id_shop = 1) WHERE `deleted` = 0 AND c.`active` = 1 ORDER BY `name` ASC
SELECT `id_country`
FROM `ps_country`
WHERE `iso_code` = 'EE' LIMIT 1
SELECT *
FROM `ps_country` a
LEFT JOIN `ps_country_shop` `c` ON a.id_country = c.id_country AND c.id_shop = 1
WHERE (a.id_country = 86)
LIMIT 1
SELECT * FROM `ps_country_lang`
WHERE `id_country` = 86
SELECT gs.*, s.*, gs.name AS group_name, s.name AS shop_name, s.active, su.domain, su.domain_ssl, su.physical_uri, su.virtual_uri
FROM ps_shop_group gs
LEFT JOIN ps_shop s
ON s.id_shop_group = gs.id_shop_group
LEFT JOIN ps_shop_url su
ON s.id_shop = su.id_shop AND su.main = 1
WHERE s.deleted = 0
AND gs.deleted = 0
ORDER BY gs.name, s.name
SELECT c.id_country, c.iso_code, cl.name as name
FROM `ps_country` c
INNER JOIN `ps_country_shop` cs ON (cs.`id_country`= c.`id_country` AND cs.id_shop = 1)
INNER JOIN `ps_country_lang` cl ON (c.`id_country` = cl.`id_country` AND cl.`id_lang` = 2)
WHERE c.active = 1
ORDER BY cl.name ASC
SELECT `iso_code`
FROM `ps_country`
WHERE `id_country` = 86 LIMIT 1
SELECT c.id_country, c.iso_code, cl.name as name
FROM `ps_country` c
INNER JOIN `ps_country_shop` cs ON (cs.`id_country`= c.`id_country` AND cs.id_shop = 4)
INNER JOIN `ps_country_lang` cl ON (c.`id_country` = cl.`id_country` AND cl.`id_lang` = 2)
WHERE c.active = 1
ORDER BY cl.name ASC
SELECT `iso_code`
FROM `ps_country`
WHERE `id_country` = 125 LIMIT 1
SELECT h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module, h.`live_edit`
FROM `ps_module` m
INNER JOIN ps_module_shop module_shop
ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1 AND module_shop.enable_device & 1)
INNER JOIN `ps_module_shop` ms ON ms.`id_module` = m.`id_module`
INNER JOIN `ps_hook_module` hm ON hm.`id_module` = m.`id_module`
INNER JOIN `ps_hook` h ON hm.`id_hook` = h.`id_hook`
LEFT JOIN `ps_module_group` `mg` ON mg.`id_module` = m.`id_module`
WHERE (h.name != "displayPayment") AND (hm.id_shop = 1) AND (mg.id_shop = 1 AND mg.`id_group` IN (1))
GROUP BY hm.id_hook, hm.id_module
ORDER BY hm.`position`
SELECT `id_hook`, `name`
FROM `ps_hook`
UNION
SELECT `id_hook`, ha.`alias` as name
FROM `ps_hook_alias` ha
INNER JOIN `ps_hook` h ON ha.name = h.name
SELECT m.`id_module`, m.`name`, (
SELECT id_module
FROM `ps_module_shop` ms
WHERE m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
LIMIT 1
) as mshop
FROM `ps_module` m
SELECT * FROM `ps_hook_module_exceptions`
WHERE `id_shop` IN (1)
SELECT *
FROM `ps_themeconfigurator`
WHERE id_shop = 1 AND id_lang = 2
AND hook = 'home' AND active = 1
ORDER BY item_order ASC
SELECT r.`id_textwidget`, r.`id_shop`, rl.`text`, rl.`title`
FROM `ps_textwidget` r
LEFT JOIN `ps_textwidget_lang` rl ON (r.`id_textwidget` = rl.`id_textwidget`)
WHERE `id_lang` = 2
SELECT h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module, h.`live_edit`
FROM `ps_module` m
INNER JOIN ps_module_shop module_shop
ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1 AND module_shop.enable_device & 1)
INNER JOIN `ps_module_shop` ms ON ms.`id_module` = m.`id_module`
INNER JOIN `ps_hook_module` hm ON hm.`id_module` = m.`id_module`
INNER JOIN `ps_hook` h ON hm.`id_hook` = h.`id_hook`
LEFT JOIN `ps_module_group` `mg` ON mg.`id_module` = m.`id_module`
WHERE (h.name != "displayPayment") AND (hm.id_shop = 1) AND (mg.id_shop = 1 AND mg.`id_group` IN (1))
GROUP BY hm.id_hook, hm.id_module
ORDER BY hm.`position`
SELECT h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module, h.`live_edit`
FROM `ps_module` m
INNER JOIN ps_module_shop module_shop
ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1 AND module_shop.enable_device & 1)
INNER JOIN `ps_module_shop` ms ON ms.`id_module` = m.`id_module`
INNER JOIN `ps_hook_module` hm ON hm.`id_module` = m.`id_module`
INNER JOIN `ps_hook` h ON hm.`id_hook` = h.`id_hook`
LEFT JOIN `ps_module_group` `mg` ON mg.`id_module` = m.`id_module`
WHERE (h.name != "displayPayment") AND (hm.id_shop = 1) AND (mg.id_shop = 1 AND mg.`id_group` IN (1))
GROUP BY hm.id_hook, hm.id_module
ORDER BY hm.`position`
SELECT id_required_field, object_name, field_name
FROM ps_required_field
INSERT INTO `ps_cart` (`id_shop_group`, `id_shop`, `id_address_delivery`, `id_address_invoice`, `id_carrier`, `id_currency`, `id_customer`, `id_guest`, `id_lang`, `recyclable`, `gift`, `gift_message`, `mobile_theme`, `delivery_option`, `secure_key`, `allow_seperated_package`, `date_add`, `date_upd`, `insurance`, `client_email`, `handling_fee_no_tax`, `handling_fee`, `abandoned_status`, `id_seller`, `id_pos`, `is_price_offer`, `priceoffer_email`, `priceoffer_employee`, `priceoffer_employee_type`, `priceoffer_customer`, `priceoffer_comment`, `priceoffer_subject`, `priceoffer_pdf_name`, `priceoffer_pdf_address`, `priceoffer_save_prices`, `priceoffer_lattu`, `ga_id`, `ga_session_id`) VALUES ('1', '1', '0', '0', '0', '1', '0', '0', '2', '0', '0', '', '0', '', '', '0', '2025-01-08 23:43:22', '2025-01-08 23:43:22', '0', '', '0', '0', '0', '0', '0', '0', '', '0', '', '', '', '', '', '', '0', '0', '', '')
SELECT h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module, h.`live_edit`
FROM `ps_module` m
INNER JOIN ps_module_shop module_shop
ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1 AND module_shop.enable_device & 1)
INNER JOIN `ps_module_shop` ms ON ms.`id_module` = m.`id_module`
INNER JOIN `ps_hook_module` hm ON hm.`id_module` = m.`id_module`
INNER JOIN `ps_hook` h ON hm.`id_hook` = h.`id_hook`
LEFT JOIN `ps_module_group` `mg` ON mg.`id_module` = m.`id_module`
WHERE (h.name != "displayPayment") AND (hm.id_shop = 1) AND (mg.id_shop = 1 AND mg.`id_group` IN (1))
GROUP BY hm.id_hook, hm.id_module
ORDER BY hm.`position`
SELECT h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module, h.`live_edit`
FROM `ps_module` m
INNER JOIN ps_module_shop module_shop
ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1 AND module_shop.enable_device & 1)
INNER JOIN `ps_module_shop` ms ON ms.`id_module` = m.`id_module`
INNER JOIN `ps_hook_module` hm ON hm.`id_module` = m.`id_module`
INNER JOIN `ps_hook` h ON hm.`id_hook` = h.`id_hook`
LEFT JOIN `ps_module_group` `mg` ON mg.`id_module` = m.`id_module`
WHERE (h.name != "displayPayment") AND (hm.id_shop = 1) AND (mg.id_shop = 1 AND mg.`id_group` IN (1))
GROUP BY hm.id_hook, hm.id_module
ORDER BY hm.`position`
SELECT `name` FROM `ps_hook_alias` WHERE `alias` = 'actionObjectCartAddAfter' LIMIT 1
SELECT c.`id_condition`
FROM `ps_condition` c
LEFT JOIN `ps_condition_badge` cb ON cb.`id_condition` = c.`id_condition`
WHERE (c.`calculation_type` = 'hook') AND (c.`calculation_detail` = 'actionObjectCartAddAfter') AND (c.`validated` = 0) AND (cb.`id_badge` IN (SELECT id_badge
FROM `ps_badge` b
WHERE (b.`validated` = 0)
GROUP BY b.`id_group`
))
GROUP BY c.`id_condition`
SELECT c.`id_condition`
FROM `ps_condition` c
LEFT JOIN `ps_condition_advice` ca ON ca.`id_condition` = c.`id_condition`
WHERE (c.`calculation_type` = 'hook') AND (c.`calculation_detail` = 'actionObjectCartAddAfter') AND (c.`validated` = 0) AND (ca.`id_advice` IN (SELECT id_advice
FROM `ps_advice` a
))
GROUP BY c.`id_condition`
SELECT h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module, h.`live_edit`
FROM `ps_module` m
INNER JOIN ps_module_shop module_shop
ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1 AND module_shop.enable_device & 1)
INNER JOIN `ps_module_shop` ms ON ms.`id_module` = m.`id_module`
INNER JOIN `ps_hook_module` hm ON hm.`id_module` = m.`id_module`
INNER JOIN `ps_hook` h ON hm.`id_hook` = h.`id_hook`
LEFT JOIN `ps_module_group` `mg` ON mg.`id_module` = m.`id_module`
WHERE (h.name != "displayPayment") AND (hm.id_shop = 1) AND (mg.id_shop = 1 AND mg.`id_group` IN (1))
GROUP BY hm.id_hook, hm.id_module
ORDER BY hm.`position`
SELECT count(distinct id_address_delivery)
FROM `ps_cart_product` cp
WHERE (id_cart = 6213298)
LIMIT 1
SELECT * FROM ps_textwidget_lang WHERE id_textwidget IN(8,9,10,11) AND id_lang = 2
SELECT SUM(`quantity`)
FROM `ps_cart_product`
WHERE `id_cart` = 6213298 LIMIT 1
SELECT h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module, h.`live_edit`
FROM `ps_module` m
INNER JOIN ps_module_shop module_shop
ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1 AND module_shop.enable_device & 1)
INNER JOIN `ps_module_shop` ms ON ms.`id_module` = m.`id_module`
INNER JOIN `ps_hook_module` hm ON hm.`id_module` = m.`id_module`
INNER JOIN `ps_hook` h ON hm.`id_hook` = h.`id_hook`
LEFT JOIN `ps_module_group` `mg` ON mg.`id_module` = m.`id_module`
WHERE (h.name != "displayPayment") AND (hm.id_shop = 1) AND (mg.id_shop = 1 AND mg.`id_group` IN (1))
GROUP BY hm.id_hook, hm.id_module
ORDER BY hm.`position`
SELECT cp.`id_product_attribute`, cp.`id_product`, cp.`quantity` AS cart_quantity, cp.id_shop, pl.`name`, p.`is_virtual`, p.`buum_name`, p.`last_purchase_price`, p.`moq`,
pl.`description_short`, pl.`available_now`, pl.`available_later`, product_shop.`id_category_default`, p.`id_supplier`,
p.`id_manufacturer`, product_shop.`on_sale`, product_shop.`ecotax`, product_shop.status, product_shop.`additional_shipping_cost`,
product_shop.`available_for_order`, product_shop.`price`, product_shop.`active`, product_shop.`unity`, product_shop.net_price, product_shop.`unit_price_ratio`,
stock.`quantity` AS quantity_available, p.`width`, p.`height`, p.`depth`, stock.`out_of_stock`, p.`weight`,
p.`date_add`, p.`date_upd`, IFNULL(stock.quantity, 0) as quantity, pl.`link_rewrite`, cl.`link_rewrite` AS category,
CONCAT(LPAD(cp.`id_product`, 10, 0), LPAD(IFNULL(cp.`id_product_attribute`, 0), 10, 0), IFNULL(cp.`id_address_delivery`, 0)) AS unique_id, cp.id_address_delivery,
product_shop.`wholesale_price`, product_shop.advanced_stock_management, ps.product_supplier_reference supplier_reference,
NULL AS customization_quantity, NULL AS id_customization,
product_attribute_shop.`price` AS price_attribute, product_attribute_shop.`ecotax` AS ecotax_attr,
IF (IFNULL(pa.`reference`, '') = '', p.`reference`, pa.`reference`) AS reference,
(p.`weight`+ pa.`weight`) weight_attribute,
IF (IFNULL(pa.`ean13`, '') = '', p.`ean13`, pa.`ean13`) AS ean13,
IF (IFNULL(pa.`upc`, '') = '', p.`upc`, pa.`upc`) AS upc,
pai.`id_image` as pai_id_image, il.`legend` as pai_legend,
IFNULL(product_attribute_shop.`minimal_quantity`, product_shop.`minimal_quantity`) as minimal_quantity
FROM `ps_cart_product` cp
LEFT JOIN `ps_product` `p` ON p.`id_product` = cp.`id_product`
INNER JOIN `ps_product_shop` product_shop ON (product_shop.`id_shop` = cp.`id_shop` AND product_shop.`id_product` = p.`id_product`)
LEFT JOIN `ps_product_lang` `pl` ON
p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 2 AND pl.id_shop = cp.id_shop
LEFT JOIN `ps_category_lang` `cl` ON
product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 2 AND cl.id_shop = cp.id_shop
LEFT JOIN `ps_product_supplier` `ps` ON ps.`id_product` = cp.`id_product` AND ps.`id_product_attribute` = cp.`id_product_attribute` AND ps.`id_supplier` = p.`id_supplier`
LEFT
JOIN ps_stock_available stock
ON (stock.id_product = cp.id_product AND stock.id_product_attribute = IFNULL(`cp`.id_product_attribute, 0) AND stock.id_shop = 1 AND stock.id_shop_group = 0 )
LEFT JOIN `ps_product_attribute` `pa` ON pa.`id_product_attribute` = cp.`id_product_attribute`
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.`id_shop` = cp.`id_shop` AND product_attribute_shop.`id_product_attribute` = pa.`id_product_attribute`)
LEFT JOIN `ps_product_attribute_image` `pai` ON pai.`id_product_attribute` = pa.`id_product_attribute`
LEFT JOIN `ps_image_lang` `il` ON il.`id_image` = pai.`id_image` AND il.`id_lang` = 2
WHERE (cp.`id_cart` = 6213298) AND (p.`id_product` IS NOT NULL)
GROUP BY unique_id
ORDER BY cp.`date_add` ASC
SELECT h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module, h.`live_edit`
FROM `ps_module` m
INNER JOIN ps_module_shop module_shop
ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1 AND module_shop.enable_device & 1)
INNER JOIN `ps_module_shop` ms ON ms.`id_module` = m.`id_module`
INNER JOIN `ps_hook_module` hm ON hm.`id_module` = m.`id_module`
INNER JOIN `ps_hook` h ON hm.`id_hook` = h.`id_hook`
LEFT JOIN `ps_module_group` `mg` ON mg.`id_module` = m.`id_module`
WHERE (h.name != "displayPayment") AND (hm.id_shop = 1) AND (mg.id_shop = 1 AND mg.`id_group` IN (1))
GROUP BY hm.id_hook, hm.id_module
ORDER BY hm.`position`
SELECT *
FROM `ps_cart_cart_rule` cd
LEFT JOIN `ps_cart_rule` cr ON cd.`id_cart_rule` = cr.`id_cart_rule`
LEFT JOIN `ps_cart_rule_lang` crl ON (
cd.`id_cart_rule` = crl.`id_cart_rule`
AND crl.id_lang = 2
)
WHERE `id_cart` = 6213298
ORDER by cr.priority ASC
SELECT h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module, h.`live_edit`
FROM `ps_module` m
INNER JOIN ps_module_shop module_shop
ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1 AND module_shop.enable_device & 1)
INNER JOIN `ps_module_shop` ms ON ms.`id_module` = m.`id_module`
INNER JOIN `ps_hook_module` hm ON hm.`id_module` = m.`id_module`
INNER JOIN `ps_hook` h ON hm.`id_hook` = h.`id_hook`
LEFT JOIN `ps_module_group` `mg` ON mg.`id_module` = m.`id_module`
WHERE (h.name != "displayPayment") AND (hm.id_shop = 1) AND (mg.id_shop = 1 AND mg.`id_group` IN (1))
GROUP BY hm.id_hook, hm.id_module
ORDER BY hm.`position`
SELECT h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module, h.`live_edit`
FROM `ps_module` m
INNER JOIN ps_module_shop module_shop
ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1 AND module_shop.enable_device & 1)
INNER JOIN `ps_module_shop` ms ON ms.`id_module` = m.`id_module`
INNER JOIN `ps_hook_module` hm ON hm.`id_module` = m.`id_module`
INNER JOIN `ps_hook` h ON hm.`id_hook` = h.`id_hook`
LEFT JOIN `ps_module_group` `mg` ON mg.`id_module` = m.`id_module`
WHERE (h.name != "displayPayment") AND (hm.id_shop = 1) AND (mg.id_shop = 1 AND mg.`id_group` IN (1))
GROUP BY hm.id_hook, hm.id_module
ORDER BY hm.`position`
UPDATE `ps_cart` SET `id_cart` = '6213298',`id_shop_group` = '1',`id_shop` = '1',`id_address_delivery` = '0',`id_address_invoice` = '0',`id_carrier` = '0',`id_currency` = '1',`id_customer` = '0',`id_guest` = '0',`id_lang` = '2',`recyclable` = '0',`gift` = '0',`gift_message` = '',`mobile_theme` = '0',`delivery_option` = '',`secure_key` = '',`allow_seperated_package` = '0',`date_add` = '2025-01-08 23:43:22',`date_upd` = '2025-01-08 23:43:22',`insurance` = '0',`client_email` = '',`handling_fee_no_tax` = '0',`handling_fee` = '0',`abandoned_status` = '0',`id_seller` = '0',`id_pos` = '0',`is_price_offer` = '0',`priceoffer_email` = '',`priceoffer_employee` = '0',`priceoffer_employee_type` = '',`priceoffer_customer` = '',`priceoffer_comment` = '',`priceoffer_subject` = '',`priceoffer_pdf_name` = '',`priceoffer_pdf_address` = '',`priceoffer_save_prices` = '0',`priceoffer_lattu` = '0',`ga_id` = '',`ga_session_id` = '' WHERE `id_cart` = 6213298
SELECT h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module, h.`live_edit`
FROM `ps_module` m
INNER JOIN ps_module_shop module_shop
ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1 AND module_shop.enable_device & 1)
INNER JOIN `ps_module_shop` ms ON ms.`id_module` = m.`id_module`
INNER JOIN `ps_hook_module` hm ON hm.`id_module` = m.`id_module`
INNER JOIN `ps_hook` h ON hm.`id_hook` = h.`id_hook`
LEFT JOIN `ps_module_group` `mg` ON mg.`id_module` = m.`id_module`
WHERE (h.name != "displayPayment") AND (hm.id_shop = 1) AND (mg.id_shop = 1 AND mg.`id_group` IN (1))
GROUP BY hm.id_hook, hm.id_module
ORDER BY hm.`position`
SELECT h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module, h.`live_edit`
FROM `ps_module` m
INNER JOIN ps_module_shop module_shop
ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1 AND module_shop.enable_device & 1)
INNER JOIN `ps_module_shop` ms ON ms.`id_module` = m.`id_module`
INNER JOIN `ps_hook_module` hm ON hm.`id_module` = m.`id_module`
INNER JOIN `ps_hook` h ON hm.`id_hook` = h.`id_hook`
LEFT JOIN `ps_module_group` `mg` ON mg.`id_module` = m.`id_module`
WHERE (h.name != "displayPayment") AND (hm.id_shop = 1) AND (mg.id_shop = 1 AND mg.`id_group` IN (1))
GROUP BY hm.id_hook, hm.id_module
ORDER BY hm.`position`
SELECT id_campaign FROM ps_campaign WHERE (campaign_start < '2025-01-08 23:43:22' AND campaign_end > '2025-01-08 23:43:22') AND only_logged_in_users = 0
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 1
WHERE (a.id_campaign = 494)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 494
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 494
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 1
WHERE (a.id_campaign = 515)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 515
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 515
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 1
WHERE (a.id_campaign = 516)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 516
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 516
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 1
WHERE (a.id_campaign = 579)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 579
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 579
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 1
WHERE (a.id_campaign = 581)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 581
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 581
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 1
WHERE (a.id_campaign = 585)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 585
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 585
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 1
WHERE (a.id_campaign = 608)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 608
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 608
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 1
WHERE (a.id_campaign = 632)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 632
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 632
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 1
WHERE (a.id_campaign = 637)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 637
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 637
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 1
WHERE (a.id_campaign = 639)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 639
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 639
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 1
WHERE (a.id_campaign = 652)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 652
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 652
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 1
WHERE (a.id_campaign = 653)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 653
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 653
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 1
WHERE (a.id_campaign = 669)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 669
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 669
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 1
WHERE (a.id_campaign = 712)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 712
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 712
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 1
WHERE (a.id_campaign = 715)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 715
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 715
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 1
WHERE (a.id_campaign = 731)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 731
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 731
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 1
WHERE (a.id_campaign = 733)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 733
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 733
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 1
WHERE (a.id_campaign = 737)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 737
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 737
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 1
WHERE (a.id_campaign = 741)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 741
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 741
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 1
WHERE (a.id_campaign = 753)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 753
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 753
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 1
WHERE (a.id_campaign = 802)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 802
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 802
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 1
WHERE (a.id_campaign = 809)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 809
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 809
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 1
WHERE (a.id_campaign = 827)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 827
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 827
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 1
WHERE (a.id_campaign = 835)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 835
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 835
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 1
WHERE (a.id_campaign = 836)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 836
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 836
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 1
WHERE (a.id_campaign = 838)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 838
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 838
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 1
WHERE (a.id_campaign = 520)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 520
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 520
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 1
WHERE (a.id_campaign = 231)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 231
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 231
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 1
WHERE (a.id_campaign = 710)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 710
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 710
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 1
WHERE (a.id_campaign = 824)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 824
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 824
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 1
WHERE (a.id_campaign = 841)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 841
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 841
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 1
WHERE (a.id_campaign = 433)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 433
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 433
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 1
WHERE (a.id_campaign = 559)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 559
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 559
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 1
WHERE (a.id_campaign = 625)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 625
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 625
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 1
WHERE (a.id_campaign = 304)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 304
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 304
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 1
WHERE (a.id_campaign = 326)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 326
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 326
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 1
WHERE (a.id_campaign = 412)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 412
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 412
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 1
WHERE (a.id_campaign = 435)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 435
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 435
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 1
WHERE (a.id_campaign = 564)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 564
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 564
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 1
WHERE (a.id_campaign = 617)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 617
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 617
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 1
WHERE (a.id_campaign = 634)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 634
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 634
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 1
WHERE (a.id_campaign = 662)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 662
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 662
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 1
WHERE (a.id_campaign = 672)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 672
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 672
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 1
WHERE (a.id_campaign = 673)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 673
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 673
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 1
WHERE (a.id_campaign = 682)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 682
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 682
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 1
WHERE (a.id_campaign = 683)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 683
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 683
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 1
WHERE (a.id_campaign = 690)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 690
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 690
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 1
WHERE (a.id_campaign = 703)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 703
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 703
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 1
WHERE (a.id_campaign = 704)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 704
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 704
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 1
WHERE (a.id_campaign = 706)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 706
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 706
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 1
WHERE (a.id_campaign = 716)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 716
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 716
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 1
WHERE (a.id_campaign = 718)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 718
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 718
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 1
WHERE (a.id_campaign = 759)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 759
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 759
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 1
WHERE (a.id_campaign = 760)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 760
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 760
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 1
WHERE (a.id_campaign = 761)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 761
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 761
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 1
WHERE (a.id_campaign = 768)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 768
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 768
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 1
WHERE (a.id_campaign = 778)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 778
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 778
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 1
WHERE (a.id_campaign = 779)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 779
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 779
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 1
WHERE (a.id_campaign = 784)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 784
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 784
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 1
WHERE (a.id_campaign = 794)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 794
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 794
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 1
WHERE (a.id_campaign = 801)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 801
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 801
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 1
WHERE (a.id_campaign = 803)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 803
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 803
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 1
WHERE (a.id_campaign = 804)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 804
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 804
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 1
WHERE (a.id_campaign = 811)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 811
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 811
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 1
WHERE (a.id_campaign = 819)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 819
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 819
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 1
WHERE (a.id_campaign = 839)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 839
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 839
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 1
WHERE (a.id_campaign = 656)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 656
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 656
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 1
WHERE (a.id_campaign = 45)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 45
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 45
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 1
WHERE (a.id_campaign = 46)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 46
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 46
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 1
WHERE (a.id_campaign = 199)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 199
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 199
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 1
WHERE (a.id_campaign = 43)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 43
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 43
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 1
WHERE (a.id_campaign = 44)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 44
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 44
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 1
WHERE (a.id_campaign = 71)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 71
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 71
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 1
WHERE (a.id_campaign = 74)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 74
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 74
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 1
WHERE (a.id_campaign = 75)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 75
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 75
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 1
WHERE (a.id_campaign = 168)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 168
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 168
SELECT *
FROM `ps_campaign` a
LEFT JOIN `ps_campaign_shop` `c` ON a.id_campaign = c.id_campaign AND c.id_shop = 1
WHERE (a.id_campaign = 185)
LIMIT 1
SELECT * FROM `ps_campaign_lang`
WHERE `id_campaign` = 185
SELECT id_shop FROM ps_campaign_shop WHERE id_campaign = 185
SELECT cr.*
FROM ps_cart_rule cr
LEFT JOIN ps_cart_rule_shop crs ON cr.id_cart_rule = crs.id_cart_rule
LEFT JOIN ps_cart_rule_carrier crca ON cr.id_cart_rule = crca.id_cart_rule
LEFT JOIN ps_cart_rule_country crco ON cr.id_cart_rule = crco.id_cart_rule
WHERE cr.active = 1
AND cr.code = ""
AND cr.quantity > 0
AND ((cr.date_from < "2025-01-08 23:43:23")
AND (cr.date_to > "2025-01-08 23:43:23") )
AND (
cr.id_customer = 0
)
AND (
cr.`carrier_restriction` = 0
)
AND (
cr.`shop_restriction` = 0
OR crs.id_shop = 1
)
AND (
cr.`group_restriction` = 0
)
AND (
cr.`reduction_product` <= 0
OR cr.`reduction_product` IN (
SELECT `id_product`
FROM `ps_cart_product`
WHERE `id_cart` = 6213298
)
)
ORDER BY priority
SELECT format
FROM `ps_address_format`
WHERE `id_country` = 0 LIMIT 1
SELECT cp.`id_product_attribute`, cp.`id_product`, cp.`quantity` AS cart_quantity, cp.id_shop, pl.`name`, p.`is_virtual`, p.`buum_name`, p.`last_purchase_price`, p.`moq`,
pl.`description_short`, pl.`available_now`, pl.`available_later`, product_shop.`id_category_default`, p.`id_supplier`,
p.`id_manufacturer`, product_shop.`on_sale`, product_shop.`ecotax`, product_shop.status, product_shop.`additional_shipping_cost`,
product_shop.`available_for_order`, product_shop.`price`, product_shop.`active`, product_shop.`unity`, product_shop.net_price, product_shop.`unit_price_ratio`,
stock.`quantity` AS quantity_available, p.`width`, p.`height`, p.`depth`, stock.`out_of_stock`, p.`weight`,
p.`date_add`, p.`date_upd`, IFNULL(stock.quantity, 0) as quantity, pl.`link_rewrite`, cl.`link_rewrite` AS category,
CONCAT(LPAD(cp.`id_product`, 10, 0), LPAD(IFNULL(cp.`id_product_attribute`, 0), 10, 0), IFNULL(cp.`id_address_delivery`, 0)) AS unique_id, cp.id_address_delivery,
product_shop.`wholesale_price`, product_shop.advanced_stock_management, ps.product_supplier_reference supplier_reference,
NULL AS customization_quantity, NULL AS id_customization,
product_attribute_shop.`price` AS price_attribute, product_attribute_shop.`ecotax` AS ecotax_attr,
IF (IFNULL(pa.`reference`, '') = '', p.`reference`, pa.`reference`) AS reference,
(p.`weight`+ pa.`weight`) weight_attribute,
IF (IFNULL(pa.`ean13`, '') = '', p.`ean13`, pa.`ean13`) AS ean13,
IF (IFNULL(pa.`upc`, '') = '', p.`upc`, pa.`upc`) AS upc,
pai.`id_image` as pai_id_image, il.`legend` as pai_legend,
IFNULL(product_attribute_shop.`minimal_quantity`, product_shop.`minimal_quantity`) as minimal_quantity
FROM `ps_cart_product` cp
LEFT JOIN `ps_product` `p` ON p.`id_product` = cp.`id_product`
INNER JOIN `ps_product_shop` product_shop ON (product_shop.`id_shop` = cp.`id_shop` AND product_shop.`id_product` = p.`id_product`)
LEFT JOIN `ps_product_lang` `pl` ON
p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 2 AND pl.id_shop = cp.id_shop
LEFT JOIN `ps_category_lang` `cl` ON
product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 2 AND cl.id_shop = cp.id_shop
LEFT JOIN `ps_product_supplier` `ps` ON ps.`id_product` = cp.`id_product` AND ps.`id_product_attribute` = cp.`id_product_attribute` AND ps.`id_supplier` = p.`id_supplier`
LEFT
JOIN ps_stock_available stock
ON (stock.id_product = cp.id_product AND stock.id_product_attribute = IFNULL(`cp`.id_product_attribute, 0) AND stock.id_shop = 1 AND stock.id_shop_group = 0 )
LEFT JOIN `ps_product_attribute` `pa` ON pa.`id_product_attribute` = cp.`id_product_attribute`
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.`id_shop` = cp.`id_shop` AND product_attribute_shop.`id_product_attribute` = pa.`id_product_attribute`)
LEFT JOIN `ps_product_attribute_image` `pai` ON pai.`id_product_attribute` = pa.`id_product_attribute`
LEFT JOIN `ps_image_lang` `il` ON il.`id_image` = pai.`id_image` AND il.`id_lang` = 2
WHERE (cp.`id_cart` = 6213298) AND (p.`id_product` IS NOT NULL)
GROUP BY unique_id
ORDER BY cp.`date_add` ASC
SELECT SUM(`quantity`)
FROM `ps_cart_product`
WHERE `id_cart` = 6213298 LIMIT 1
SELECT * FROM ps_cart_product_insurance WHERE id_cart = 6213298
SELECT * FROM ps_cart_product_insurance WHERE id_cart = 6213298
SELECT * FROM ps_cart_product_insurance WHERE id_cart = 6213298
SELECT *
FROM `ps_cart` a
WHERE (a.id_cart = 6213298)
LIMIT 1
SELECT cp.`id_product_attribute`, cp.`id_product`, cp.`quantity` AS cart_quantity, cp.id_shop, pl.`name`, p.`is_virtual`, p.`buum_name`, p.`last_purchase_price`, p.`moq`,
pl.`description_short`, pl.`available_now`, pl.`available_later`, product_shop.`id_category_default`, p.`id_supplier`,
p.`id_manufacturer`, product_shop.`on_sale`, product_shop.`ecotax`, product_shop.status, product_shop.`additional_shipping_cost`,
product_shop.`available_for_order`, product_shop.`price`, product_shop.`active`, product_shop.`unity`, product_shop.net_price, product_shop.`unit_price_ratio`,
stock.`quantity` AS quantity_available, p.`width`, p.`height`, p.`depth`, stock.`out_of_stock`, p.`weight`,
p.`date_add`, p.`date_upd`, IFNULL(stock.quantity, 0) as quantity, pl.`link_rewrite`, cl.`link_rewrite` AS category,
CONCAT(LPAD(cp.`id_product`, 10, 0), LPAD(IFNULL(cp.`id_product_attribute`, 0), 10, 0), IFNULL(cp.`id_address_delivery`, 0)) AS unique_id, cp.id_address_delivery,
product_shop.`wholesale_price`, product_shop.advanced_stock_management, ps.product_supplier_reference supplier_reference,
NULL AS customization_quantity, NULL AS id_customization,
product_attribute_shop.`price` AS price_attribute, product_attribute_shop.`ecotax` AS ecotax_attr,
IF (IFNULL(pa.`reference`, '') = '', p.`reference`, pa.`reference`) AS reference,
(p.`weight`+ pa.`weight`) weight_attribute,
IF (IFNULL(pa.`ean13`, '') = '', p.`ean13`, pa.`ean13`) AS ean13,
IF (IFNULL(pa.`upc`, '') = '', p.`upc`, pa.`upc`) AS upc,
pai.`id_image` as pai_id_image, il.`legend` as pai_legend,
IFNULL(product_attribute_shop.`minimal_quantity`, product_shop.`minimal_quantity`) as minimal_quantity
FROM `ps_cart_product` cp
LEFT JOIN `ps_product` `p` ON p.`id_product` = cp.`id_product`
INNER JOIN `ps_product_shop` product_shop ON (product_shop.`id_shop` = cp.`id_shop` AND product_shop.`id_product` = p.`id_product`)
LEFT JOIN `ps_product_lang` `pl` ON
p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 2 AND pl.id_shop = cp.id_shop
LEFT JOIN `ps_category_lang` `cl` ON
product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 2 AND cl.id_shop = cp.id_shop
LEFT JOIN `ps_product_supplier` `ps` ON ps.`id_product` = cp.`id_product` AND ps.`id_product_attribute` = cp.`id_product_attribute` AND ps.`id_supplier` = p.`id_supplier`
LEFT
JOIN ps_stock_available stock
ON (stock.id_product = cp.id_product AND stock.id_product_attribute = IFNULL(`cp`.id_product_attribute, 0) AND stock.id_shop = 1 AND stock.id_shop_group = 0 )
LEFT JOIN `ps_product_attribute` `pa` ON pa.`id_product_attribute` = cp.`id_product_attribute`
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.`id_shop` = cp.`id_shop` AND product_attribute_shop.`id_product_attribute` = pa.`id_product_attribute`)
LEFT JOIN `ps_product_attribute_image` `pai` ON pai.`id_product_attribute` = pa.`id_product_attribute`
LEFT JOIN `ps_image_lang` `il` ON il.`id_image` = pai.`id_image` AND il.`id_lang` = 2
WHERE (cp.`id_cart` = 6213298) AND (p.`id_product` IS NOT NULL)
GROUP BY unique_id
ORDER BY cp.`date_add` ASC
SELECT * FROM ps_cart_product_insurance WHERE id_cart = 6213298
SELECT `id_product`, `id_product_attribute`, id_shop
FROM `ps_cart_product`
WHERE `id_cart` = 6213298
ORDER BY `date_add` DESC LIMIT 1
SELECT `id_image_type`, `name`, `width`, `height`, `products`, `categories`, `manufacturers`, `suppliers`, `scenes`
FROM `ps_image_type`
WHERE
`name` LIKE 'small_photopoint' LIMIT 1
SELECT `id_image_type`, `name`, `width`, `height`, `products`, `categories`, `manufacturers`, `suppliers`, `scenes`
FROM `ps_image_type`
WHERE
`name` LIKE 'photopoint_small' LIMIT 1
SELECT `width`, `height`
FROM ps_image_type
WHERE `name` = 'small_default'
LIMIT 1
SELECT h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module, h.`live_edit`
FROM `ps_module` m
INNER JOIN ps_module_shop module_shop
ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1 AND module_shop.enable_device & 1)
INNER JOIN `ps_module_shop` ms ON ms.`id_module` = m.`id_module`
INNER JOIN `ps_hook_module` hm ON hm.`id_module` = m.`id_module`
INNER JOIN `ps_hook` h ON hm.`id_hook` = h.`id_hook`
LEFT JOIN `ps_module_group` `mg` ON mg.`id_module` = m.`id_module`
WHERE (h.name != "displayPayment") AND (hm.id_shop = 1) AND (mg.id_shop = 1 AND mg.`id_group` IN (1))
GROUP BY hm.id_hook, hm.id_module
ORDER BY hm.`position`
SELECT h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module, h.`live_edit`
FROM `ps_module` m
INNER JOIN ps_module_shop module_shop
ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1 AND module_shop.enable_device & 1)
INNER JOIN `ps_module_shop` ms ON ms.`id_module` = m.`id_module`
INNER JOIN `ps_hook_module` hm ON hm.`id_module` = m.`id_module`
INNER JOIN `ps_hook` h ON hm.`id_hook` = h.`id_hook`
LEFT JOIN `ps_module_group` `mg` ON mg.`id_module` = m.`id_module`
WHERE (h.name != "displayPayment") AND (hm.id_shop = 1) AND (mg.id_shop = 1 AND mg.`id_group` IN (1))
GROUP BY hm.id_hook, hm.id_module
ORDER BY hm.`position`
SELECT DISTINCT `id_address_delivery`
FROM `ps_cart_product`
WHERE id_cart = 6213298
SELECT s.*
FROM `ps_state` s
ORDER BY s.`name` ASC
SELECT cl.*,c.*, cl.`name` AS country, zz.`name` AS zone
FROM `ps_country` c INNER JOIN ps_country_shop country_shop
ON (country_shop.id_country = c.id_country AND country_shop.id_shop = 1)
LEFT JOIN `ps_country_lang` cl ON (c.`id_country` = cl.`id_country` AND cl.`id_lang` = 2)
INNER JOIN (`ps_carrier_zone` cz INNER JOIN `ps_carrier` cr ON ( cr.id_carrier = cz.id_carrier AND cr.deleted = 0 AND cr.active = 1)
LEFT JOIN `ps_zone` zz ON cz.id_zone = zz.id_zone) ON zz.`id_zone` = c.`id_zone`
WHERE 1
AND c.active = 1
ORDER BY cl.name ASC
SELECT h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module, h.`live_edit`
FROM `ps_module` m
INNER JOIN ps_module_shop module_shop
ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1 AND module_shop.enable_device & 1)
INNER JOIN `ps_module_shop` ms ON ms.`id_module` = m.`id_module`
INNER JOIN `ps_hook_module` hm ON hm.`id_module` = m.`id_module`
INNER JOIN `ps_hook` h ON hm.`id_hook` = h.`id_hook`
LEFT JOIN `ps_module_group` `mg` ON mg.`id_module` = m.`id_module`
WHERE (h.name != "displayPayment") AND (hm.id_shop = 1) AND (mg.id_shop = 1 AND mg.`id_group` IN (1))
GROUP BY hm.id_hook, hm.id_module
ORDER BY hm.`position`
SELECT h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module, h.`live_edit`
FROM `ps_module` m
INNER JOIN ps_module_shop module_shop
ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1 AND module_shop.enable_device & 1)
INNER JOIN `ps_module_shop` ms ON ms.`id_module` = m.`id_module`
INNER JOIN `ps_hook_module` hm ON hm.`id_module` = m.`id_module`
INNER JOIN `ps_hook` h ON hm.`id_hook` = h.`id_hook`
LEFT JOIN `ps_module_group` `mg` ON mg.`id_module` = m.`id_module`
WHERE (h.name != "displayPayment") AND (hm.id_shop = 1) AND (mg.id_shop = 1 AND mg.`id_group` IN (1))
GROUP BY hm.id_hook, hm.id_module
ORDER BY hm.`position`
SELECT h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module, h.`live_edit`
FROM `ps_module` m
INNER JOIN ps_module_shop module_shop
ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1 AND module_shop.enable_device & 1)
INNER JOIN `ps_module_shop` ms ON ms.`id_module` = m.`id_module`
INNER JOIN `ps_hook_module` hm ON hm.`id_module` = m.`id_module`
INNER JOIN `ps_hook` h ON hm.`id_hook` = h.`id_hook`
LEFT JOIN `ps_module_group` `mg` ON mg.`id_module` = m.`id_module`
WHERE (h.name != "displayPayment") AND (hm.id_shop = 1) AND (mg.id_shop = 1 AND mg.`id_group` IN (1))
GROUP BY hm.id_hook, hm.id_module
ORDER BY hm.`position`
SELECT h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module, h.`live_edit`
FROM `ps_module` m
INNER JOIN ps_module_shop module_shop
ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1 AND module_shop.enable_device & 1)
INNER JOIN `ps_module_shop` ms ON ms.`id_module` = m.`id_module`
INNER JOIN `ps_hook_module` hm ON hm.`id_module` = m.`id_module`
INNER JOIN `ps_hook` h ON hm.`id_hook` = h.`id_hook`
LEFT JOIN `ps_module_group` `mg` ON mg.`id_module` = m.`id_module`
WHERE (h.name != "displayPayment") AND (hm.id_shop = 1) AND (mg.id_shop = 1 AND mg.`id_group` IN (1))
GROUP BY hm.id_hook, hm.id_module
ORDER BY hm.`position`
SELECT id_carrier FROM ps_carrier WHERE external_module_name = 'post24' AND deleted = 0 LIMIT 1
SELECT *, COUNT(group_name) as group_count
FROM ps_transport_location
WHERE
module = 'post24' AND (country = 0 OR country = 86)
GROUP BY group_name
ORDER BY FIELD(group_name, 'Tartu', 'Tallinn', 'Harjumaa', 'Tartumaa', 'Tallinn/Harjumaa') DESC, group_name,group_count DESC
SELECT * FROM ps_transport_location WHERE group_name IN () AND module = 'post24' AND active = 1 AND (country = 0 OR country = 86) ORDER BY name ASC
SELECT id_transport_location FROM ps_transport_location_selected WHERE id_cart = 6213298 AND id_carrier = 71 LIMIT 1
SELECT id_carrier FROM ps_carrier WHERE external_module_name = 'dpdpakipood' AND deleted = 0 LIMIT 1
SELECT *, COUNT(group_name) as group_count
FROM ps_transport_location
WHERE
module = 'dpdpakipood' AND (country = 0 OR country = 86)
GROUP BY group_name
ORDER BY FIELD(group_name, 'Tartu', 'Tallinn', 'Harjumaa', 'Tartumaa', 'Tallinn/Harjumaa') DESC, group_name,group_count DESC
SELECT * FROM ps_transport_location WHERE group_name IN () AND module = 'dpdpakipood' AND active = 1 AND (country = 0 OR country = 86) ORDER BY name ASC
SELECT id_transport_location FROM ps_transport_location_selected WHERE id_cart = 6213298 AND id_carrier = 94 LIMIT 1
SELECT id_carrier FROM ps_carrier WHERE external_module_name = 'smartpost' AND deleted = 0 LIMIT 1
SELECT *, COUNT(group_name) as group_count
FROM ps_transport_location
WHERE
module = 'smartpost' AND (country = 0 OR country = 86)
GROUP BY group_name
ORDER BY FIELD(group_name, 'Tartu', 'Tallinn', 'Harjumaa', 'Tartumaa', 'Tallinn/Harjumaa') DESC, group_name,group_count DESC
SELECT * FROM ps_transport_location WHERE group_name IN () AND module = 'smartpost' AND active = 1 AND (country = 0 OR country = 86) ORDER BY name ASC
SELECT id_transport_location FROM ps_transport_location_selected WHERE id_cart = 6213298 AND id_carrier = 72 LIMIT 1
SELECT id_carrier FROM ps_carrier WHERE external_module_name = 'smartpostfinland' AND deleted = 0 LIMIT 1
SELECT *, COUNT(group_name) as group_count
FROM ps_transport_location
WHERE
module = 'smartpostfinland' AND (country = 0 OR country = 86)
GROUP BY group_name
ORDER BY FIELD(group_name, 'Tartu', 'Tallinn', 'Harjumaa', 'Tartumaa', 'Tallinn/Harjumaa') DESC, group_name,group_count DESC
SELECT * FROM ps_transport_location WHERE group_name IN () AND module = 'smartpostfinland' AND active = 1 AND (country = 0 OR country = 86) ORDER BY name ASC
SELECT id_transport_location FROM ps_transport_location_selected WHERE id_cart = 6213298 AND id_carrier = 77 LIMIT 1
SELECT id_carrier FROM ps_carrier WHERE external_module_name = 'kuller' AND deleted = 0 LIMIT 1
SELECT id_carrier FROM ps_carrier WHERE external_module_name = 'photopointstores' AND deleted = 0 LIMIT 1
SELECT *, COUNT(group_name) as group_count
FROM ps_transport_location
WHERE
module = 'photopointstores' AND (country = 0 OR country = 86)
GROUP BY group_name
ORDER BY FIELD(group_name, 'Tartu', 'Tallinn', 'Harjumaa', 'Tartumaa', 'Tallinn/Harjumaa') DESC, group_name,group_count DESC
SELECT * FROM ps_transport_location WHERE group_name IN () AND module = 'photopointstores' AND active = 1 AND (country = 0 OR country = 86) ORDER BY name ASC
SELECT id_transport_location FROM ps_transport_location_selected WHERE id_cart = 6213298 AND id_carrier = 89 LIMIT 1
SELECT id_carrier FROM ps_carrier WHERE external_module_name = 'matkahuolto' AND deleted = 0 LIMIT 1
SELECT *, COUNT(group_name) as group_count
FROM ps_transport_location
WHERE
module = 'matkahuolto' AND (country = 0 OR country = 86)
GROUP BY group_name
ORDER BY FIELD(group_name, 'Tartu', 'Tallinn', 'Harjumaa', 'Tartumaa', 'Tallinn/Harjumaa') DESC, group_name,group_count DESC
SELECT * FROM ps_transport_location WHERE group_name IN () AND module = 'matkahuolto' AND active = 1 AND (country = 0 OR country = 86) ORDER BY name ASC
SELECT id_transport_location FROM ps_transport_location_selected WHERE id_cart = 6213298 AND id_carrier = 90 LIMIT 1
SELECT id_carrier FROM ps_carrier WHERE external_module_name = 'venipaklocker' AND deleted = 0 LIMIT 1
SELECT *, COUNT(group_name) as group_count
FROM ps_transport_location
WHERE
module = 'venipaklocker' AND (country = 0 OR country = 86)
GROUP BY group_name
ORDER BY FIELD(group_name, 'Tartu', 'Tallinn', 'Harjumaa', 'Tartumaa', 'Tallinn/Harjumaa') DESC, group_name,group_count DESC
SELECT * FROM ps_transport_location WHERE group_name IN () AND module = 'venipaklocker' AND active = 1 AND (country = 0 OR country = 86) ORDER BY name ASC
SELECT id_transport_location FROM ps_transport_location_selected WHERE id_cart = 6213298 AND id_carrier = 96 LIMIT 1
SELECT count(*) FROM `ps_orders` WHERE `id_cart` = 6213298 LIMIT 1
SELECT h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module, h.`live_edit`
FROM `ps_module` m
INNER JOIN ps_module_shop module_shop
ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1 AND module_shop.enable_device & 1)
INNER JOIN `ps_module_shop` ms ON ms.`id_module` = m.`id_module`
INNER JOIN `ps_hook_module` hm ON hm.`id_module` = m.`id_module`
INNER JOIN `ps_hook` h ON hm.`id_hook` = h.`id_hook`
LEFT JOIN `ps_module_group` `mg` ON mg.`id_module` = m.`id_module`
WHERE (h.name != "displayPayment") AND (hm.id_shop = 1) AND (mg.id_shop = 1 AND mg.`id_group` IN (1))
GROUP BY hm.id_hook, hm.id_module
ORDER BY hm.`position`
SELECT h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module, h.`live_edit`
FROM `ps_module` m
INNER JOIN ps_module_shop module_shop
ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1 AND module_shop.enable_device & 1)
INNER JOIN `ps_module_shop` ms ON ms.`id_module` = m.`id_module`
INNER JOIN `ps_hook_module` hm ON hm.`id_module` = m.`id_module`
INNER JOIN `ps_hook` h ON hm.`id_hook` = h.`id_hook`
LEFT JOIN `ps_module_group` `mg` ON mg.`id_module` = m.`id_module`
WHERE (h.name != "displayPayment") AND (hm.id_shop = 1) AND (mg.id_shop = 1 AND mg.`id_group` IN (1))
GROUP BY hm.id_hook, hm.id_module
ORDER BY hm.`position`
SELECT *
FROM `ps_themeconfigurator`
WHERE id_shop = 1 AND id_lang = 2
AND hook = 'footer' AND active = 1
ORDER BY item_order ASC