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 Ostukorv - Photopoint
Sinu ostukorv on hetkel täiesti tühi. Lisa siia mõned tooted ja elu läheb kohe huvitavamaks :)
Avalehele ostlema