Vánoční stromeček bez vánočních koulí? To přece nejde! Zdobení vánočního stromečku...
Milujete, když vánoční stromeček hýři všemi barvami? Chcete si ho ozdobit tak, aby z něho...
Neodolatelná vůně vánočního františka v mnoha lidech probouzí tu správnou vánoční...
Vytvořit doma kouzelnou atmosféru Vánoc bude se svítícími koulemi DECORATIVE opravdu...
Krásně ozdobený vánoční stromeček je podstatou Vánoc. Většina z nás si dává s jeho...
Váš email bol úspešne pridaný
Chcete vedieť ako prvý o zľavách a novinkách? Zadajte svoj email.
Tento web používa na poskytovanie služieb, personalizáciu reklám a analýze návštevnosti súbory cookie. Používaním tohto webu s tým súhlasíte.
Prevádzkované na systéme ExitShop
SELECT *FROM `currencies`ORDER BY `id` ASC
SELECT *FROM `users2currencies`
SELECT `s`.*, `cc`.*FROM `shops` `s`LEFT JOIN `c_content` `cc` ON `cc`.`id`=`s`.`id`WHERE `s`.`id` = 7449
SELECT `file_name`, `media_type`FROM `media`WHERE `shop_id` = '7449'AND (`media_type` = "logo" OR `media_type` = "favicon")AND `active` = 1
SELECT `u`.`id`, `u`.`block_status`, `u`.`banned`, `u`.`block_emails`, `u`.`block_ips`, `u`.`ultra_block_emails`, `u`.`ultra_block_ips`, `u`.`block_amounts`, `u`.`hash`, `u`.`email`, `up`.`address_id`, `up`.`business_form`, `up`.`tax_sk`, `up`.`tax_hu`, `up`.`tax_de`, `up`.`language`, `up`.`vs_type`, `up`.`vs_prefix`, `up`.`owlcure`, `up`.`order_mail`, `a`.`name`, `a`.`phone` AS `owner_phone`FROM `users` `u`LEFT JOIN `user_profiles` `up` ON `up`.`user_id`=`u`.`id`LEFT JOIN `address` `a` ON `a`.`id`=`up`.`address_id`WHERE `u`.`id` = '816'
SELECT *FROM `sub_cms`WHERE `shop_id` = '7449'AND `type` = 'cms'AND `active` = 1ORDER BY `index` ASC, `date` DESC
SELECT `s`.*, `ssf`.`stock_format`, `ssf`.`stock_format_info_text`, `ssf`.`stock_format_fake`, `ssf`.`stock_format_fake_info_text`FROM `supplier` `s`LEFT JOIN `supplier_stock_format` `ssf` ON `ssf`.`supplier_id` = `s`.`id` AND `ssf`.`country` = 'sk'WHERE `s`.`user_id` IN('816')GROUP BY `s`.`id`
SELECT p.id, p.shop_id, p.name, p.short_name, p.description, p.product_tax, p.type, p.var1, p.var2, p.var3, p.oos_hide_except, p.show_in_upsell, p.variant, p.sold_count AS sold, p.url, p.category_oos_order_last, p.category_new_products_order_first, p.category_indent, p.base_product_show_number, p.show_trigger, p.base_product, p.category_sort_by, p.product_index, p.dropshop_product_id, p.feature_on_homepage, p.variant_auto_configurator, p.default_category, p.thumbnail_id, p.in_cart_count, p2s.pair_price, p2s.pair_discount, p2s.pair_quantity_discount, IF(pp.primary_id IS NOT NULL, 'primary', IF(pp2.primary_id IS NOT NULL, 'secondary', NULL)) AS pos, IF(pp.primary_id IS NOT NULL, pp.primary_id, IF(pp2.primary_id IS NOT NULL, pp2.primary_id, NULL)) AS primary_id, IF(pp.purchase_price IS NOT NULL, pp.purchase_price, IF(pp2.purchase_price IS NOT NULL, pp2.purchase_price, 0)) AS purchase_price, IF(pp.own_id IS NOT NULL, pp.own_id, IF(pp2.own_id IS NOT NULL, pp2.own_id, NULL)) AS own_id, IF(pp.import_code IS NOT NULL, pp.import_code, IF(pp2.import_code IS NOT NULL, pp2.import_code, NULL)) AS import_code, IF(pp.marked IS NOT NULL, pp.marked, IF(pp2.marked IS NOT NULL, pp2.marked, NULL)) AS marked, IF(pp.supplier_id IS NOT NULL, pp.supplier_id, IF(pp2.supplier_id IS NOT NULL, pp2.supplier_id, NULL)) AS supplier_id, IF(pp.primary_id IS NOT NULL, pp.sold_count, IF(pp2.primary_id IS NOT NULL, pp2.sold_count, NULL)) AS primary_sold, IF(p.ean IS NOT NULL, p.ean, IF(pp.barcode IS NULL, IF(pp2.barcode IS NULL, NULL, pp2.barcode), pp.barcode)) AS barcode, IF(p.manufacturer IS NOT NULL AND p.manufacturer != '', p.manufacturer, IF(pp.primary_manufacturer IS NULL, IF(pp2.primary_manufacturer IS NULL, NULL, pp2.primary_manufacturer), pp.primary_manufacturer)) AS manufacturer, IF(pp.length IS NULL, IF(pp2.length IS NULL, NULL, pp2.length), pp.length) AS length, IF(pp.width IS NULL, IF(pp2.width IS NULL, NULL, pp2.width), pp.width) AS width, IF(pp.height IS NULL, IF(pp2.height IS NULL, NULL, pp2.height), pp.height) AS height, IF(pp.weight IS NULL, IF(pp2.weight IS NULL, 0, pp2.weight), pp.weight) AS weight, IF(pp.quantity IS NOT NULL, pp.quantity, IF(pp2.quantity IS NOT NULL, pp2.quantity, p.quantity)) AS quantity, IF(pp.thumbnail IS NOT NULL AND LENGTH(pp.thumbnail) > 0, pp.thumbnail, IF(pp2.thumbnail IS NOT NULL AND p2s.pair_picture=1 AND LENGTH(pp2.thumbnail) > 0, pp2.thumbnail, p.thumbnail)) AS thumbnail, IF(pp.yt_video IS NULL, IF(pp2.yt_video IS NULL, NULL, pp2.yt_video), pp.yt_video) AS yt_video, IF(pp.price IS NOT NULL AND pp.price > 0, pp.price, IF(pp2.price IS NOT NULL AND p2s.pair_price=1, IF(p2s.pair_condition=1,pp2.price,pp2.price_original),p.price)) AS price, IF(pp.price_original IS NOT NULL AND pp.price_original > 0, pp.price_original, IF(pp2.price_original IS NOT NULL AND p2s.pair_price=1, pp2.price_original, p.price)) AS price_original, IF(pp.price_modifier IS NOT NULL, pp.price_modifier, IF(pp2.price_modifier IS NOT NULL, pp2.price_modifier, NULL)) AS price_modifier, IF(pp.price_modifier_fake IS NOT NULL, pp.price_modifier_fake, IF(pp2.price_modifier_fake IS NOT NULL, pp2.price_modifier_fake, NULL)) AS price_modifier_fake, IF(pp.discount_like IS NOT NULL AND pp.discount_like = 1 AND pp.price_modifier < 0, pp.discount_like, IF(pp2.discount_like IS NOT NULL AND p2s.pair_discount = 1 AND pp2.discount_like = 1 AND pp2.price_modifier < 0 AND p2s.pair_price = 1 AND p2s.pair_condition = 1, pp2.discount_like, NULL)) AS discount_like, IF(pp.increase_quantity_value_here IS NOT NULL, pp.increase_quantity_value_here, pp2.increase_quantity_value_here) AS increase_quantity_value_here, IF(pp.quantity_on_road IS NOT NULL, pp.quantity_on_road, pp2.quantity_on_road) AS quantity_on_road, IF(pp.primary_set IS NOT NULL, pp.primary_set, pp2.primary_set) AS primary_set, IF(pp.solo_order IS NOT NULL, pp.solo_order, pp2.solo_order) AS solo_order, IF(pp.immune2vouchers IS NOT NULL, pp.immune2vouchers, IF(pp2.immune2vouchers IS NOT NULL, pp2.immune2vouchers, 0)) AS immune2vouchers, IF(pp.exclude_from_eshop IS NOT NULL, pp.exclude_from_eshop, IF(pp2.exclude_from_eshop IS NOT NULL, pp2.exclude_from_eshop, 0)) AS exclude_from_eshop, IF(pp.upsell_only IS NOT NULL, pp.upsell_only, IF(pp2.upsell_only IS NOT NULL, pp2.upsell_only, 0)) AS upsell_only, ABS(TIMESTAMPDIFF(MINUTE, IF(pp2.primary_id IS NOT NULL AND p2.creation_date NOT LIKE '0000-00-00 00:00:00', p2.creation_date, p.creation_date), NOW())) AS product_minutes_old FROM product p LEFT JOIN primary_product pp ON p.id = pp.primary_id LEFT JOIN primary2secondary p2s ON p2s.secondary_id = p.id LEFT JOIN primary_product pp2 ON p2s.primary_id = pp2.primary_id LEFT JOIN product p2 ON p2s.primary_id = p2.id WHERE p.active = 1 AND p.shop_id = 7449 AND (pp.status = 1 OR pp.status IS NULL) AND (pp2.status = 1 OR pp2.status IS NULL) GROUP BY p.id ORDER BY p.product_index ASC
SELECT IF(pl2c.name IS NULL, `pl`.`name`, pl2c.name) AS name, `p2pl`.`product_id`, `pl`.`color`, `pl`.`background_color`, `pl`.`bold`, `pl`.`id`FROM `product2product_label` `p2pl`JOIN `product_label` `pl` ON `pl`.`id` = `p2pl`.`product_label_id`LEFT JOIN `product_label2country` `pl2c` ON `pl2c`.`product_label_id` = `pl`.`id` AND `pl2c`.`country`='sk'WHERE `p2pl`.`product_id` IN('2185319', '2280371', '3823523', '4094514', '4119964', '2231643', '3875679', '3875680', '3875688', '3875689', '3875690', '3875691', '3875692', '3875754', '3875755', '1974194', '3996805', '1971413', '1971414', '1971415', '1971418', '1971417', '1971416', '1909075', '1909071', '1909076', '1909074', '1909073', '1909072', '1909067', '1909066', '1909069', '1909068', '1909070', '1909065', '905069', '905070', '905071', '905072', '905073', '905074', '1945749', '1945748', '1945747', '1945750', '1945751', '1337176', '1337177', '1337173', '1337174', '1337175', '905002', '905003', '905004', '905005', '905006', '905007', '905008', '905009', '905010', '905011', '905012', '905013', '905014', '905015', '905016', '905017', '905020', '905019', '905018', '905021', '905022', '905023', '905024', '905025', '905026', '1337169', '1337170', '1337172', '1337171', '905030', '905031', '905033', '905035', '905037', '905079', '905076', '905077', '905078', '905075', '905080', '905081', '905039', '905041', '905042', '905043', '905044', '905134', '905132', '905131', '905130', '905129', '905128', '905127', '905126', '905125', '905135', '905136', '905137', '905138', '905139', '905140', '905141', '905027', '905028', '905029', '905049', '905046', '905045', '905048', '905047', '905054', '905050', '905053', '905051', '905052', '905055', '905059', '905058', '905056', '905057', '905142', '905143', '905144', '905146', '905147', '905145', '905149', '905148', '905150', '905151', '905152', '905153', '905060', '905061', '905063', '905065', '905067', '3037949', '3264887', '2852925', '2005302', '2045894', '2050815', '2185753', '2647638', '2975313', '3231935', '3417826', '3417829', '4094943', '4112746', '4112758', '2941815', '2045891', '2045892', '2045893', '2164978', '2166863', '3015460', '2942946', '2442903', '2572058', '2996854', '3030012', '4004824', '2226616', '2033339', '3862997', '3862998', '3862999', '3863000', '3863001', '3858416', '3858417', '3858418', '3858419', '3858420', '3858406', '3858407', '3858408', '3858409', '3858410', '3858431', '3858432', '3858433', '3858401', '3858402', '3858403', '3858404', '3858405', '3858649', '3858650', '3858651', '3858411', '3858412', '3858413', '3858415', '4120283', '4120284', '4120285', '3858421', '3858422', '3858423', '3858424', '3858425', '3858426', '3858427', '3858428', '3858429', '3994388', '3858434', '3858435', '3858436', '3858437', '3858543', '3858544', '3858545', '4120258', '4120259', '4120260', '3855057', '3855058', '4120261', '3858735', '3858737', '4120262', '4120263', '4120264', '4120265', '3855009', '3855010', '3858695', '3858696', '3858697', '4120266', '4120267', '4120268', '4120269', '4120270', '3855051', '3855052', '3858732', '3858733', '3858734', '4120271', '4120272', '4120306', '3855048', '3855049', '3858698', '3858699', '3858700', '4120273', '4120274', '4120275', '4120276', '3855021', '3855022', '3858701', '3858702', '3858703', '3858704', '4120278', '4120279', '4120281', '4120282', '3855015', '3855016', '3858705', '3858706', '3858707', '3858708', '3858714', '3994389', '3855108', '3855109', '3858715', '3858716', '3858717', '4120277', '4120289', '3855103', '3855104', '3858718', '3858719', '3858720', '3858721', '4120280', '3855095', '3855096', '3858722', '3858723', '3858724', '3858725', '3854873', '3854874', '3858726', '3858727', '3858728', '3855019', '3855020', '3858729', '3858730', '3858731', '3855055', '3855056', '3855113', '3855097', '3855098', '3855115', '3855116', '3855017', '3855018', '3855005', '3858742', '3858743', '3858744', '3858745', '3858709', '3858710', '3858711', '3858712', '3858713', '3994387', '4120292', '4120293', '4120294', '4120295', '4120296', '4120297', '4120298', '4120301', '4120302', '4120303', '4120299', '4120300', '4120304', '4120305', '4120307', '4120308', '4120309', '4120310', '4120311', '4120312', '4120313', '4120314', '4120290', '4120291', '4120286', '4120287', '4120288', '3855011', '3855012', '3855027', '3855028', '3855007', '3855008', '3855105', '3855106', '3994376', '3994377', '3945925', '3945926', '3945927', '3945928', '3855039', '3855040', '3855035', '3855038', '3855063', '3855064', '3855065', '3855069', '3855070', '3855071', '3855072', '3855073', '3855074', '3855078', '3855023', '3855024', '3855079', '3855080', '3855081', '3855082', '3855083', '3855084', '4120125', '4120126', '3855088', '3855089', '3855090', '4120127', '4120128', '4120129', '4120130', '4120131', '4120203', '4120204', '4120205', '4120132', '4120206', '4120207', '4120208', '3855075', '3855076', '3855077', '4120133', '4120134', '4120135', '4120136', '3855091', '3855092', '4120137', '3855066', '3855067', '3855068', '4120138', '4120139', '4120140', '4120141', '4120142', '4120143', '4120144', '4120145', '4120146', '4120147', '4120150', '4120151', '4120148', '4120149', '3827469', '3827470', '3827471', '3827472', '3855000', '3855001', '3855002', '3855003', '3855004', '3855006', '3855013', '3855014', '3855025', '3855026', '3855033', '3855034', '3855036', '3855041', '3855037', '3855042', '3855043', '3855044', '3855045', '3855046', '3855047', '3855050', '3855061', '3855062', '3855093', '3855094', '3855099', '3855100', '3855101', '3855102', '3855107', '3855110', '3855053', '3855054', '1030409', '1030410', '1030411', '1030412', '1030413', '1030414', '1030415', '1030416', '1030417', '1030418', '1030419', '1030420', '1030421', '1030422', '1030423', '1030424', '1030425', '1117714', '2083323', '2062834', '1973552', '1979433', '2056675', '2056676', '2056677', '2056678', '2056712', '2056713', '2056714', '2056715', '2004293', '2001666', '3308057', '905062', '905064', '905066', '905068', '905082', '905090', '905091', '2021405', '2021672', '2022213', '2022881', '2023151', '2023152', '2023153', '2058766', '2058778', '2058779', '2058834', '2058931', '2059041', '2164638', '2169592', '2170834', '2186930', '2223541', '3003737', '3027065', '4120060', '4120065', '4120066', '4120067', '4120068', '4120069', '4120070', '4120071', '4120072', '4120073', '4120074', '3945902', '4120053', '4120054', '4120055', '4120056', '3945906', '3945909', '3945910', '3945914', '3945918', '3945915', '3945916', '3945908', '3945913', '3945919', '3855029', '3855030', '3972238', '3972239', '2981977', '3356323', '3855031', '3855032', '3855085', '3855086', '3855087', '3923589', '3923590', '3923808', '3972243', '3972244', '4095302', '4095303', '905032', '905034', '905036', '905038', '905040', '905093', '1955081', '2102480', '2102481', '2974414', '3003746', '3024730', '3033599', '3827001', '3827002', '3827003', '3827004', '3827005', '3827006', '3827007', '3827008', '3827009', '3827010', '3827011', '2056775', '3827012', '3827013', '3827014', '3827015', '2078924', '2088283', '3827016', '3827017', '3827018', '2088362', '3827019', '3827020', '3827021', '3827022', '2088487', '3827023', '3827024', '3827025', '2090405', '2090661', '2092377', '2097804', '2104736', '3827026', '3827027', '3827028', '2105960', '2105961', '2105962', '2105963', '3827029', '3827030', '2105964', '2112413', '2113149', '2130514', '3827031', '3827032', '3827033', '3827034', '3827035', '3827036', '3827037', '3827038', '3827039', '3827040', '2174863', '2180660', '2180933', '3827041', '3827042', '3827043', '3827061', '2181126', '3827062', '3827063', '3827064', '2213929', '3827065', '3827066', '3827067', '3827068', '2230320', '2231056', '3827069', '3827070', '2268535', '2268633', '3827071', '3827072', '3827073', '2405492', '2500983', '3827074', '3827075', '3827076', '3827077', '3827093', '3827094', '2658952', '2659549', '3827095', '3827096', '3827097', '3827098', '3827099', '3827100', '3827101', '2948625', '3827102', '3827103', '3827104', '3827105', '2975421', '3827106', '3827107', '3827117', '2991999', '2992791', '2996729', '3827119', '3827120', '3827137', '3827138', '2996764', '2998038', '3827139', '3827141', '3827142', '3827143', '2998052', '2998061', '2998062', '3827144', '3001279', '3003740', '3003743', '3827145', '3015463', '3021635', '3024695', '3827491', '3827492', '3028957', '3029270', '3031690', '3827493', '3827494', '3827495', '3031691', '3031894', '3827496', '3827499', '3833459', '3833460', '3061472', '3069204', '3073375', '3833463', '3833464', '3833466', '3099240', '3099245', '3115407', '3115410', '3115413', '3115444', '3135428', '3135429', '3135438', '3135439', '3135721', '3231939', '3248308', '3254622', '3265414', '3308008', '3308047', '3308537', '3308538', '3308592', '3356361', '3398547', '3398575', '3401798', '3401801', '3477571', '3477790', '3543031', '3543032', '3547440', '3559758', '3801343', '3801344', '3801345', '3823347', '3827118', '3827140', '3827146', '3827147', '3827148', '3827275', '3827489', '3827490', '3827497', '3827498', '3855059', '3855060', '3858949', '3858956', '3858957', '3862493', '3862494', '3862495', '3862496', '3862497', '3862498', '3862499', '3862500', '3862501', '3862502', '3862503', '3862504', '3862505', '3862523', '3862524', '3862525', '3862526', '3862584', '3862585', '3862633', '3862634', '3862640', '3862641', '3862642', '3862643', '3862644', '3862647', '3862648', '3862657', '3862658', '3862659', '3862660', '3862661', '3862662', '3862663', '3862664', '3862977', '3862978', '3862979', '3862980', '3862981', '3862982', '3862983', '3862984', '3862985', '3862989', '3862990', '3862991', '3863005', '3863006', '3863007', '3863017', '3863018', '3863019', '3863061', '3863097', '3863098', '3863099', '3875678', '3875681', '3875682', '3875683', '3875684', '3875686', '3875687', '3875716', '3875717', '3875718', '3875719', '3875720', '3875721', '3875722', '3875723', '3875724', '3875725', '3875726', '3875727', '3875728', '3875729', '3875730', '3875731', '3875732', '3875733', '3875746', '3875747', '3875748', '3875749', '3875750', '3875751', '3875752', '3875753', '3875756', '3875757', '3887793', '3887794', '3887799', '3887800', '3887801', '3888756', '3887795', '3887796', '3887797', '3887798', '3888755', '3888757', '3888759', '3888760', '3888761', '3888758', '3902798', '3902799', '3902800', '3902801', '3902802', '3902803', '3904539', '3904540', '3904542', '3904541', '3904543', '3904544', '3904545', '3904546', '3904547', '3904549', '3904553', '3907605', '3907609', '3904548', '3904556', '3907606', '3907607', '3907608', '3907610', '3912466', '3912467', '3912469', '3907611', '3907612', '3907613', '3912468', '3912470', '3912471', '3912472', '3912473', '3912474', '3912476', '3912475', '3912477', '3912478', '3912479', '3912480', '3912481', '3913511', '3922563', '3913509', '3913510', '3913512', '3914122', '3923593', '3923594', '3922561', '3922562', '3923591', '3923592', '3923595', '3923596', '3923598', '3945905', '3923597', '3936201', '3936202', '3936203', '3936204', '3936205', '3936206', '3936207', '3936208', '3936209', '3936210', '3936211', '3936212', '3936217', '3936221', '3936222', '3936223', '3936224', '3936225', '3936226', '3936227', '3936231', '3943985', '3943986', '3943988', '3943989', '3943990', '3943992', '3944001', '3944002', '3944003', '3944004', '3944005', '3944006', '3944107', '3944108', '3985349', '3985350', '3944109', '3944110', '3944111', '3944112', '3944113', '3985351', '3985352', '3985353', '3944114', '3944215', '3944216', '3944217', '3944218', '3985354', '3985355', '3985356', '3944219', '3944220', '3944221', '3944222', '3985363', '3985364', '3985365', '3985366', '3944223', '3944224', '3944225', '3944226', '3944227', '3985367', '3991633', '3991746', '3945903', '3945904', '3945907', '3991749', '3991850', '3991851', '3945917', '3945931', '3991852', '3991853', '3993331', '3993332', '3945932', '3946166', '3946167', '3947118', '3947119', '3947120', '3947121', '3947122', '3947123', '3947124', '3947199', '3947200', '3947201', '3947202', '3947203', '3994382', '3994383', '3947204', '3947205', '3947206', '3947207', '3947309', '3967209', '3967210', '3967211', '3967212', '3967213', '3995405', '3995406', '3995407', '3995408', '3995409', '3967409', '3967410', '3967411', '3967412', '3967413', '3995410', '3995411', '3995412', '3995413', '3995414', '3995415', '3967414', '3967415', '3967416', '3967417', '3967418', '3995416', '3995417', '3995418', '4047523', '3967419', '3967420', '3967421', '3967422', '3967423', '4047524', '4047525', '4087224', '3967424', '3967425', '3967426', '3967427', '3967428', '3967429', '3967469', '3967470', '3967471', '3967472', '4120059', '3967474', '3972256', '3972257', '3984981', '3984983', '3985093', '3985094', '3985095', '3985096', '3985097', '3985098', '3985099', '3985100', '3985108', '3985109', '3985110', '3985111', '3985112', '3985113', '3985114', '3989213', '3989214', '3989481', '3989482', '3989483', '3989484', '3989485', '3989486', '3989487', '3989488', '3989489', '3989490', '3989491', '3989492', '3989493', '3991744', '3991745', '3991747', '3991748', '3995447', '3995448', '3995449', '3995450', '3995451', '3995452', '3995453', '3995454', '3995457', '3995458', '3995468', '3995469', '3995470', '3995471', '3995472', '3995473', '3995474', '3995475', '4004283', '4009499', '4012267', '4013452', '4013464', '4014402', '4014406', '4014495', '4014498', '4046179', '4091160', '2722688', '2722689', '2785021', '2785022', '3112230', '2103164', '2103165', '2103166', '2785014', '2785015', '3914532', '3914533', '3913918', '3914534', '4120075', '3989712', '3989713', '3989714', '3989715', '3989716', '3989717', '3989718', '3989719', '905092', '2944737', '2948145', '2991994', '3260178', '3855112', '3855114', '3855111', '2944736', '905122', '905121', '905085', '905084', '905083', '905116', '905115', '905114', '905113', '905118', '905117', '905120', '905119', '905124', '905123', '3972245', '3972246', '3972247', '3972248', '3854875', '3854876', '3855119', '3855120', '4120061', '4120062', '4120063', '4120064', '4120058', '4120057', '4120052', '905086', '905087', '905088', '905089', '905101', '905102', '1292463', '905103', '905104', '905105', '905106', '905107', '905109', '905108', '905110', '905111', '905112', '905094', '905095', '905096', '905097', '905098', '905099', '905100', '3264895', '905155', '905156', '905157', '1417671', '1417672', '1417673', '1417675', '1417677', '1544499', '1544500', '1544501', '1544502', '1544503', '1544504', '1973721', '1982711', '1983237', '2004788', '3112229', '2083324', '2090486', '2164546', '2181012', '3028850', '3854872', '3854999', '3308646', '3855117', '3855118', '3972241', '3972242', '3972250', '3972251', '3945911', '3945912', '3994371', '3994372', '3994373', '3994379', '3972240', '3972249')AND `pl`.`active` = 1
SELECT `pv`.*, `pp`.`primary_manufacturer` AS `manufacturer`, `pp`.`barcode` AS `variant_barcode`, `pp`.`quantity`, `pp`.`increase_quantity_value_here`, `pp`.`supplier_id`, `pp`.`price_modifier`, `pp`.`price`, `pp`.`price_original`, `pp`.`price_modifier_fake`, `pp`.`marked`, `pp`.`thumbnail`, `pp`.`weight`, `pp`.`height`, `pp`.`primary_set`, `pp`.`quantity_on_road`, `pp`.`exclude_from_eshop`, `pp`.`purchase_price`FROM `product_variant` `pv`JOIN `primary_product` `pp` ON `pp`.`primary_id` = `pv`.`primary_id`WHERE `pv`.`product_id` IN('2231643', '2852925', '2941815', '2166863', '2942946', '1030409', '1030410', '1030411', '1030412', '1030413', '1030414', '1030415', '1030416', '1030417', '1030418', '1030419', '1030420', '1030421', '1030422', '1030423', '1030424', '1030425', '1117714', '2974414', '3033599', '2088487', '2090661', '2213929', '2231056', '2405492', '2500983', '3021635', '3265414', '3308008', '3477790', '3875757', '3887793', '3887794', '3887799', '3887800', '3887801', '3888756', '3887795', '3887796', '3887797', '3887798', '3888755', '3888757', '3888759', '3888760', '3888761', '3888758', '3902798', '3902799', '3902800', '3902801', '3902802', '3902803', '3904539', '3904540', '3904542', '3904541', '3904543', '3904544', '3904545', '3904546', '3904547', '3904549', '3904553', '3907605', '3907609', '3904548', '3904556', '3907606', '3907607', '3907608', '3907610', '3912466', '3912467', '3912469', '3907611', '3907612', '3907613', '3912468', '3912470', '3912471', '3912472', '3912473', '3912474', '3912476', '3912475', '3912477', '3912478', '3912479', '3912480', '3912481', '3913511', '3922563', '3913509', '3913510', '3913512', '3914122', '3922561', '3922562', '3991746', '3991749', '3991850', '3991851', '3991852', '3991853', '3947118', '3947119', '3947120', '3947121', '3947122', '3947123', '3947124', '3947199', '3947200', '3947201', '3947202', '3947203', '3994382', '3994383', '3947204', '3947205', '3947206', '3947207', '3947309', '3989481', '3989482', '3989483', '3989484', '3989485', '3989486', '3989487', '3989488', '3989489', '3989490', '3989491', '3989492', '3989493', '3991744', '3991745', '3991747', '3991748', '4004283', '4009499', '4014402', '4046179', '3914532', '3914533', '3913918', '3914534')ORDER BY `pv`.`index`, `pv`.`name`
SELECT `id`FROM `product`WHERE `shop_id` = '7449'AND (`active` = 1 OR `active` = 2)
SELECT `file_name`FROM `media`WHERE `shop_id` = '7449'AND `active` = 1AND `media_type` = 'gallery'ORDER BY `media_index`
SELECT `file_name`, `sub1`, `sub2`, `link`FROM `media`WHERE `shop_id` = '7449'AND `active` = 1AND `media_type` = 'slider'ORDER BY `media_index`
SELECT *FROM `scripts`WHERE `shop_id` = '7449'AND `script_active` = 1
SELECT *FROM `shipping`WHERE `shop_id` = '7449'AND `active` = 1AND `visible` = 0ORDER BY `shipping_index`
SELECT *, IF(LENGTH(short_name) > 0, `short_name`, name) AS display_nameFROM `category`WHERE `shop_id` = '7449'AND `active` = 1ORDER BY `position`
SELECT *FROM `sub_cms`WHERE `shop_id` = '7449'AND `type` = 'blog'AND `active` = 1ORDER BY `index` ASC, `date` DESC
SELECT *FROM `primary_quantity_discount_cached`WHERE `shop_id` = '7449'ORDER BY `quantity`
SELECT IF(pv.product_id IS NULL, op.product_id, pv.product_id) AS pid, COUNT(op.quantity) AS pocet FROM orders o JOIN orders_products op ON o.id = op.order_id JOIN product p ON p.id = op.product_id LEFT JOIN product_variant pv ON pv.primary_id = op.primary_id AND pv.shop_id = 7449 WHERE o.shop_id = 7449 AND o.date >= '2020-01-15 19:59:58' AND o.order_active=1 AND (p.active OR pv.product_id IS NOT NULL) GROUP BY IF(pv.product_id IS NULL, op.product_id, pv.product_id) ORDER BY pocet DESC LIMIT 100
SELECT *FROM `user_invoice_settings`WHERE `user_id` = '816'AND `invoice_address_id` = '305680'AND `status` = 1AND `country` = 'sk'
SELECT *, IF(LENGTH(short_name) > 0, `short_name`, name) AS display_nameFROM `category`WHERE `id` = 57847
SELECT *, IF(LENGTH(short_name) > 0, `short_name`, name) AS display_nameFROM `category`WHERE `parent_id` = 57847AND `active` = 1ORDER BY `position`
SELECT `f`.`id`, IFNULL(f2co.name, f.name) AS name, `f`.`name` AS `internal_name`, `fv`.`id` AS `value_id`, `fv`.`index` as `value_index`, IFNULL(fv2c.value, fv.value) AS valueFROM `feature2category` `f2c`LEFT JOIN `feature` `f` ON `f`.`id` = `f2c`.`feature_id`LEFT JOIN `feature_value` `fv` ON `fv`.`feature_id` = `f2c`.`feature_id`LEFT JOIN `feature2country` `f2co` ON `f2co`.`feature_id` = `f2c`.`feature_id` AND `f2co`.`country` = 'sk'LEFT JOIN `feature_value2country` `fv2c` ON `fv2c`.`feature_value_id` = `fv`.`id` AND `fv2c`.`country` = 'sk'WHERE `f2c`.`category_id` = 57847ORDER BY `fv`.`index`
SELECT `f`.`id`FROM `feature2category` `f2c`JOIN `feature` `f` ON `f`.`id` = `f2c`.`feature_id`WHERE `f2c`.`category_id` = 57847ORDER BY `f`.`index` ASC
SELECT `p2c`.`product_id`FROM `product2category` `p2c`JOIN `product` `p` ON `p`.`id` = `p2c`.`product_id`WHERE `p2c`.`category_id` = 57847ORDER BY `p`.`product_index` ASC
SELECT `p2fv`.*, `f`.`auto_configurator_type`, `f`.`user_id`, `f`.`name` AS `internal_name`, `m`.`file_name` AS `value_image`, `fv`.`value` AS `internal_value_name`, `fv`.`product_label_id`, IFNULL(f2c.name, f.name) AS name, IFNULL(fv2c.value, fv.value) AS valueFROM `primary2feature_value` `p2fv`JOIN `feature` `f` ON `f`.`id` = `p2fv`.`feature_id`JOIN `feature_value` `fv` ON `fv`.`id` = `p2fv`.`feature_value_id`LEFT JOIN `media` `m` ON `fv`.`id` = `m`.`feature_value_id` AND `m`.`active`=1 AND `m`.`media_type`="feature_value"LEFT JOIN `feature2country` `f2c` ON `f`.`id` = `f2c`.`feature_id` AND `f2c`.`country` = 'sk'LEFT JOIN `feature_value2country` `fv2c` ON `fv`.`id` = `fv2c`.`feature_value_id` AND `fv2c`.`country` = 'sk'WHERE p2fv.primary_id IN(3583917, 3583919, 3583907, 3583939, 3583909, 3583925)AND `f`.`show_filtering` = 1ORDER BY `f`.`name` ASC, `fv`.`index` ASC
SELECT IF(pl2c.name IS NULL, `pl`.`name`, pl2c.name) AS name, `pl`.`color`, `pl`.`background_color`, `pl`.`bold`, `pl`.`id`FROM `product_label` `pl`LEFT JOIN `product_label2country` `pl2c` ON `pl2c`.`product_label_id` = `pl`.`id` AND `pl2c`.`country`='sk'WHERE `pl`.`user_id` = '816'AND `pl`.`active` = 1
SELECT *, IF(LENGTH(short_name) > 0, `short_name`, name) AS display_nameFROM `category`WHERE `id` = '57847'
SELECT *, IF(LENGTH(short_name) > 0, `short_name`, name) AS display_nameFROM `category`WHERE `id` = '13726'
SELECT *, IF(LENGTH(short_name) > 0, `short_name`, name) AS display_nameFROM `category`WHERE `id` = '13708'
INSERT INTO visitors_online (time, shop_id, session) VALUES ('2020-01-29 19:59:58', 7449, '35.168.111.191') ON DUPLICATE KEY UPDATE time='2020-01-29 19:59:58'
INSERT INTO visitors (people, date, hour, shop_id) VALUES (1, '2020-01-29', '19', 7449) ON DUPLICATE KEY UPDATE people=people+1
SELECT *FROM `media`WHERE `shop_id` = '7449'AND `media_type` = 'sticky_floating_banner'AND `active` = 1
SELECT *FROM `media`WHERE `shop_id` = '7449'AND `media_type` = 'cart_button_icon'AND `active` = 1
Array ( [cs] => 21 [sk] => 20 [de] => 19 [at] => 20 [pl] => 23 [hu] => 27 [dk] => 25 [fr] => 20 [ro] => 24 [ru] => 18 [hr] => 25 [bg] => 20 [gb] => 20 [ie] => 23 [ww] => 21 )
Array ( [cs] => Česko [sk] => Slovensko [de] => Německo [at] => Rakousko [pl] => Polsko [hu] => Maďarsko [dk] => Dánsko [fr] => Francie [ro] => Rumunsko [ru] => Rusko [hr] => Chorvatsko [bg] => Bulharsko [gb] => Velká Británie [ie] => Irsko [ww] => Celý svět )
Array ( [cs] => cs_CZ [sk] => sk_SK [de] => de_DE [at] => de_AT [pl] => pl_PL [hu] => hu_HU [dk] => da_DK [fr] => fr_FR [ro] => ro_RO [ru] => ru_RU [hr] => hr_HR [bg] => bg_BG [gb] => en_GB [ie] => en_GB [ww] => en_US )
