22/05/2024 09:25:40 am >> SELECT document_num FROM ps_document WHERE document_num = '1699' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-22') 22/05/2024 09:25:40 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1699' , '2024-05-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.20' , '0.98' , NOW() , NOW() ) 22/05/2024 09:25:40 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91933' 22/05/2024 09:25:40 am >> DELETE FROM ps_document_detail WHERE id_document = '91933' 22/05/2024 09:25:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91933' , '20516' , 'CROCE COMUNIONE - 42/08' , '1' , '-1' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '1.20' ) 22/05/2024 09:41:46 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 22/05/2024 09:41:46 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22556' , '1' , '' , 'nuovo-prodotto' ) 22/05/2024 09:41:46 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '22556' , '1' , '1' , '2' , NOW() , NOW() ) 22/05/2024 09:41:46 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '22556' , '0' , '1' , '0' , '0' ) 22/05/2024 09:42:52 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884248169' AND id_product != '22556' AND ean13 != '' 22/05/2024 09:42:53 am >> UPDATE ps_product SET id_supplier = '', reference = '4/1', ean13 = '9788884248169', date_upd = NOW() WHERE id_product = '22556' 22/05/2024 09:42:53 am >> UPDATE ps_product_lang SET name = 'NUMERI DI DIO', description = '' WHERE id_product = '22556' 22/05/2024 09:42:53 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '20' WHERE id_product = '22556' 22/05/2024 09:42:53 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '20', id_tax_rules_group = '4', id_category_default = '83', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22556' 22/05/2024 09:42:53 am >> DELETE FROM ps_specific_price WHERE id_product = '22556' 22/05/2024 09:42:54 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22556' 22/05/2024 09:42:54 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22557' , '1' , '' , 'nuovo-prodotto' ) 22/05/2024 09:42:54 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22557' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22556' 22/05/2024 09:42:54 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22557' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22556' 22/05/2024 09:44:04 am >> SELECT ean13 FROM ps_product WHERE ean13 = '8051739457322' AND id_product != '22557' AND ean13 != '' 22/05/2024 09:44:04 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8051739457322', date_upd = NOW() WHERE id_product = '22557' 22/05/2024 09:44:04 am >> UPDATE ps_product_lang SET name = 'PAROLA E PREGHIERA - AGO 2024', description = '' WHERE id_product = '22557' 22/05/2024 09:44:04 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '2.9' WHERE id_product = '22557' 22/05/2024 09:44:04 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '2.9', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '64', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22557' 22/05/2024 09:44:04 am >> DELETE FROM ps_specific_price WHERE id_product = '22557' 22/05/2024 09:44:05 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22557' 22/05/2024 09:44:05 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22558' , '1' , '' , 'nuovo-prodotto' ) 22/05/2024 09:44:05 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22558' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22557' 22/05/2024 09:44:05 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22558' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22557' 22/05/2024 09:45:52 am >> SELECT document_num FROM ps_document WHERE document_num = '1700' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-22') 22/05/2024 09:45:52 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1700' , '2024-05-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '40.00' , '32.79' , NOW() , NOW() ) 22/05/2024 09:45:52 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91934' 22/05/2024 09:45:52 am >> DELETE FROM ps_document_detail WHERE id_document = '91934' 22/05/2024 09:45:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91934' , '18250' , 'CLERGY JEANS NIDO DAPE MM - XXL' , '1' , '-1' , '1' , '40.00' , '32.786885245902' , '22' , '0' , '40.00' ) 22/05/2024 09:46:34 am >> SELECT document_num FROM ps_document WHERE document_num = '1701' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-22') 22/05/2024 09:46:34 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1701' , '2024-05-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '190.00' , '160.70' , NOW() , NOW() ) 22/05/2024 09:46:34 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91935' 22/05/2024 09:46:34 am >> DELETE FROM ps_document_detail WHERE id_document = '91935' 22/05/2024 09:46:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91935' , '17544' , 'CAMICE BAMBOO' , '1' , '-1' , '1' , '155' , '127.04918032787' , '22' , '0' , '155.00' ) 22/05/2024 09:46:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91935' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '10' , '-10' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '35.00' ) 22/05/2024 10:00:46 am >> SELECT document_num FROM ps_document WHERE document_num = '1702' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-22') 22/05/2024 10:00:46 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1702' , '2024-05-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '190.00' , '155.74' , NOW() , NOW() ) 22/05/2024 10:00:46 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91936' 22/05/2024 10:00:46 am >> DELETE FROM ps_document_detail WHERE id_document = '91936' 22/05/2024 10:00:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91936' , '20264' , 'PIZZO MARIANO - PIZ0M419 - M 3,10' , '1' , '-1' , '1' , '190' , '155.73770491803' , '22' , '0' , '190.00' ) 22/05/2024 10:04:46 am >> SELECT document_num FROM ps_document WHERE document_num = '1703' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-22') 22/05/2024 10:04:46 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1703' , '2024-05-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.50' , '3.69' , NOW() , NOW() ) 22/05/2024 10:04:46 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91937' 22/05/2024 10:04:46 am >> DELETE FROM ps_document_detail WHERE id_document = '91937' 22/05/2024 10:04:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91937' , '10475' , 'TEALIGHTS X 50 ' , '1' , '-1' , '1' , '3.90' , '3.1967213114754' , '22' , '0' , '3.90' ) 22/05/2024 10:04:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91937' , '16796' , 'LUMINO 5F BIANCO' , '2' , '-2' , '1' , '0.30' , '0.24590163934426' , '22' , '0' , '0.60' ) 22/05/2024 10:05:46 am >> SELECT ean13 FROM ps_product WHERE ean13 = '8051739457445' AND id_product != '22558' AND ean13 != '' 22/05/2024 10:05:46 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8051739457445', date_upd = NOW() WHERE id_product = '22558' 22/05/2024 10:05:46 am >> UPDATE ps_product_lang SET name = 'INSIEME NELLA MESSA - AGO 2024', description = '' WHERE id_product = '22558' 22/05/2024 10:05:46 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '1.8' WHERE id_product = '22558' 22/05/2024 10:05:46 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '1.8', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '64', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22558' 22/05/2024 10:05:46 am >> DELETE FROM ps_specific_price WHERE id_product = '22558' 22/05/2024 10:05:47 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22558' 22/05/2024 10:05:47 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22559' , '1' , '' , 'nuovo-prodotto' ) 22/05/2024 10:05:47 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22559' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22558' 22/05/2024 10:05:47 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22559' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22558' 22/05/2024 10:06:37 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791281253902' AND id_product != '22559' AND ean13 != '' 22/05/2024 10:06:37 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9791281253902', date_upd = NOW() WHERE id_product = '22559' 22/05/2024 10:06:37 am >> UPDATE ps_product_lang SET name = 'GIOVANNI PAOLO II - A. COMASTRI', description = '' WHERE id_product = '22559' 22/05/2024 10:06:37 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '5' WHERE id_product = '22559' 22/05/2024 10:06:37 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '5', id_tax_rules_group = '4', id_category_default = '518', id_argoment_default = '71', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22559' 22/05/2024 10:06:37 am >> DELETE FROM ps_specific_price WHERE id_product = '22559' 22/05/2024 10:06:39 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22559' 22/05/2024 10:06:39 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22560' , '1' , '' , 'nuovo-prodotto' ) 22/05/2024 10:06:39 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22560' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22559' 22/05/2024 10:06:39 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22560' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22559' 22/05/2024 10:07:25 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791281253742' AND id_product != '22560' AND ean13 != '' 22/05/2024 10:07:25 am >> UPDATE ps_product SET id_supplier = '', reference = '13/4', ean13 = '9791281253742', date_upd = NOW() WHERE id_product = '22560' 22/05/2024 10:07:25 am >> UPDATE ps_product_lang SET name = 'SACRO CUORE DI GESU\' - G. SACINO', description = '' WHERE id_product = '22560' 22/05/2024 10:07:25 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '5' WHERE id_product = '22560' 22/05/2024 10:07:25 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '5', id_tax_rules_group = '4', id_category_default = '518', id_argoment_default = '28', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22560' 22/05/2024 10:07:25 am >> DELETE FROM ps_specific_price WHERE id_product = '22560' 22/05/2024 10:07:27 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22560' 22/05/2024 10:07:27 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22561' , '1' , '' , 'nuovo-prodotto' ) 22/05/2024 10:07:27 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22561' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22560' 22/05/2024 10:07:27 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22561' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22560' 22/05/2024 10:07:52 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801069068' AND id_product != '22561' AND ean13 != '' 22/05/2024 10:07:52 am >> UPDATE ps_product SET id_supplier = '', reference = '13/4', ean13 = '9788801069068', date_upd = NOW() WHERE id_product = '22561' 22/05/2024 10:07:52 am >> UPDATE ps_product_lang SET name = 'MISTERI DEL ROSARIO', description = '' WHERE id_product = '22561' 22/05/2024 10:07:52 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3' WHERE id_product = '22561' 22/05/2024 10:07:53 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3', id_tax_rules_group = '4', id_category_default = '19', id_argoment_default = '28', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22561' 22/05/2024 10:07:53 am >> DELETE FROM ps_specific_price WHERE id_product = '22561' 22/05/2024 10:07:53 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22561' 22/05/2024 10:07:53 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22562' , '1' , '' , 'nuovo-prodotto' ) 22/05/2024 10:07:53 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22562' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22561' 22/05/2024 10:07:53 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22562' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22561' 22/05/2024 10:08:28 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801069051' AND id_product != '22562' AND ean13 != '' 22/05/2024 10:08:28 am >> UPDATE ps_product SET id_supplier = '', reference = '13/4', ean13 = '9788801069051', date_upd = NOW() WHERE id_product = '22562' 22/05/2024 10:08:28 am >> UPDATE ps_product_lang SET name = 'MISTERI DEL ROSARIO NELLA VITA DI DON BOSCO', description = '' WHERE id_product = '22562' 22/05/2024 10:08:28 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '4' WHERE id_product = '22562' 22/05/2024 10:08:28 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '4', id_tax_rules_group = '4', id_category_default = '19', id_argoment_default = '28', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22562' 22/05/2024 10:08:28 am >> DELETE FROM ps_specific_price WHERE id_product = '22562' 22/05/2024 10:08:29 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22562' 22/05/2024 10:08:29 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22563' , '1' , '' , 'nuovo-prodotto' ) 22/05/2024 10:08:29 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22563' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22562' 22/05/2024 10:08:29 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22563' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22562' 22/05/2024 10:09:04 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801069150' AND id_product != '22563' AND ean13 != '' 22/05/2024 10:09:04 am >> UPDATE ps_product SET id_supplier = '', reference = '2/1', ean13 = '9788801069150', date_upd = NOW() WHERE id_product = '22563' 22/05/2024 10:09:04 am >> UPDATE ps_product_lang SET name = 'BAMBINI CI PARLANO - A. BASSO', description = '' WHERE id_product = '22563' 22/05/2024 10:09:04 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '10' WHERE id_product = '22563' 22/05/2024 10:09:04 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '10', id_tax_rules_group = '4', id_category_default = '19', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22563' 22/05/2024 10:09:04 am >> DELETE FROM ps_specific_price WHERE id_product = '22563' 22/05/2024 10:09:05 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22563' 22/05/2024 10:09:05 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22564' , '1' , '' , 'nuovo-prodotto' ) 22/05/2024 10:09:05 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22564' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22563' 22/05/2024 10:09:05 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22564' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22563' 22/05/2024 10:09:46 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892244702' AND id_product != '22564' AND ean13 != '' 22/05/2024 10:09:46 am >> UPDATE ps_product SET id_supplier = '', reference = '11/4', ean13 = '9788892244702', date_upd = NOW() WHERE id_product = '22564' 22/05/2024 10:09:46 am >> UPDATE ps_product_lang SET name = 'PAOLO E L\'EVANGELO DELLA SPERANZA', description = '' WHERE id_product = '22564' 22/05/2024 10:09:46 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '22' WHERE id_product = '22564' 22/05/2024 10:09:46 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '22', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '20', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22564' 22/05/2024 10:09:46 am >> DELETE FROM ps_specific_price WHERE id_product = '22564' 22/05/2024 10:09:47 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22564' 22/05/2024 10:09:47 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22565' , '1' , '' , 'nuovo-prodotto' ) 22/05/2024 10:09:47 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22565' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22564' 22/05/2024 10:09:47 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22565' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22564' 22/05/2024 10:10:29 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892244627' AND id_product != '22565' AND ean13 != '' 22/05/2024 10:10:29 am >> UPDATE ps_product SET id_supplier = '', reference = '11/4', ean13 = '9788892244627', date_upd = NOW() WHERE id_product = '22565' 22/05/2024 10:10:29 am >> UPDATE ps_product_lang SET name = 'DIFESA E CONFERMA DEL VANGELO - J. ROJAS', description = '' WHERE id_product = '22565' 22/05/2024 10:10:29 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '28' WHERE id_product = '22565' 22/05/2024 10:10:29 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '28', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '20', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22565' 22/05/2024 10:10:29 am >> DELETE FROM ps_specific_price WHERE id_product = '22565' 22/05/2024 10:10:30 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22565' 22/05/2024 10:10:30 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22566' , '1' , '' , 'nuovo-prodotto' ) 22/05/2024 10:10:30 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22566' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22565' 22/05/2024 10:10:30 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22566' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22565' 22/05/2024 10:19:27 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '665352' , '2024-05-20' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '1.44' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '85.02' , '85.02' , NOW() , NOW() ) 22/05/2024 10:19:27 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91938' 22/05/2024 10:19:27 am >> DELETE FROM ps_document_detail WHERE id_document = '91938' 22/05/2024 10:19:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91938' , '22557' , 'PAROLA E PREGHIERA - AGO 2024' , '4' , '4' , '4' , '2.90' , '2.9' , '0' , '33' , '7.7720' ) 22/05/2024 10:19:27 am >> DELETE FROM ps_product_supplier WHERE id_product = '22557' AND id_supplier = '7' 22/05/2024 10:19:27 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22557' , '7' , '1' ) 22/05/2024 10:19:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91938' , '22558' , 'INSIEME NELLA MESSA - AGO 2024' , '1' , '1' , '4' , '1.80' , '1.8' , '0' , '33' , '1.2060' ) 22/05/2024 10:19:27 am >> DELETE FROM ps_product_supplier WHERE id_product = '22558' AND id_supplier = '7' 22/05/2024 10:19:27 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22558' , '7' , '1' ) 22/05/2024 10:19:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91938' , '22565' , 'DIFESA E CONFERMA DEL VANGELO - J. ROJAS' , '1' , '1' , '4' , '28.00' , '28' , '0' , '33' , '18.7600' ) 22/05/2024 10:19:27 am >> DELETE FROM ps_product_supplier WHERE id_product = '22565' AND id_supplier = '7' 22/05/2024 10:19:27 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22565' , '7' , '1' ) 22/05/2024 10:19:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91938' , '22556' , 'NUMERI DI DIO' , '1' , '1' , '4' , '20.00' , '20' , '0' , '30' , '14.0000' ) 22/05/2024 10:19:27 am >> DELETE FROM ps_product_supplier WHERE id_product = '22556' AND id_supplier = '7' 22/05/2024 10:19:28 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22556' , '7' , '1' ) 22/05/2024 10:19:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91938' , '22564' , 'PAOLO E LEVANGELO DELLA SPERANZA' , '1' , '1' , '4' , '22.00' , '22' , '0' , '33' , '14.7400' ) 22/05/2024 10:19:28 am >> DELETE FROM ps_product_supplier WHERE id_product = '22564' AND id_supplier = '7' 22/05/2024 10:19:28 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22564' , '7' , '1' ) 22/05/2024 10:19:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91938' , '22559' , 'GIOVANNI PAOLO II - A. COMASTRI' , '1' , '1' , '4' , '5.00' , '5' , '0' , '30' , '3.5000' ) 22/05/2024 10:19:28 am >> DELETE FROM ps_product_supplier WHERE id_product = '22559' AND id_supplier = '7' 22/05/2024 10:19:28 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22559' , '7' , '1' ) 22/05/2024 10:19:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91938' , '22560' , 'SACRO CUORE DI GESU - G. SACINO' , '2' , '2' , '4' , '5.00' , '5' , '0' , '30' , '7.0000' ) 22/05/2024 10:19:28 am >> DELETE FROM ps_product_supplier WHERE id_product = '22560' AND id_supplier = '7' 22/05/2024 10:19:28 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22560' , '7' , '1' ) 22/05/2024 10:19:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91938' , '22562' , 'MISTERI DEL ROSARIO NELLA VITA DI DON BOSCO' , '2' , '2' , '4' , '4.00' , '4' , '0' , '35' , '5.2000' ) 22/05/2024 10:19:28 am >> DELETE FROM ps_product_supplier WHERE id_product = '22562' AND id_supplier = '7' 22/05/2024 10:19:28 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22562' , '7' , '1' ) 22/05/2024 10:19:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91938' , '22561' , 'MISTERI DEL ROSARIO' , '2' , '2' , '4' , '3.00' , '3' , '0' , '35' , '3.9000' ) 22/05/2024 10:19:28 am >> DELETE FROM ps_product_supplier WHERE id_product = '22561' AND id_supplier = '7' 22/05/2024 10:19:28 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22561' , '7' , '1' ) 22/05/2024 10:19:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91938' , '22563' , 'BAMBINI CI PARLANO - A. BASSO' , '1' , '1' , '4' , '10.00' , '10' , '0' , '25' , '7.5000' ) 22/05/2024 10:19:28 am >> DELETE FROM ps_product_supplier WHERE id_product = '22563' AND id_supplier = '7' 22/05/2024 10:19:28 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22563' , '7' , '1' ) 22/05/2024 10:48:29 am >> SELECT document_num FROM ps_document WHERE document_num = '1704' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-22') 22/05/2024 10:48:29 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1704' , '2024-05-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '98.28' , '83.85' , NOW() , NOW() ) 22/05/2024 10:48:29 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91939' 22/05/2024 10:48:29 am >> DELETE FROM ps_document_detail WHERE id_document = '91939' 22/05/2024 10:48:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91939' , '21096' , 'CROCE REMOVIBILE EFFETTO PIETRA - 3873' , '6' , '-6' , '1' , '11' , '9.016393442623' , '22' , '0' , '66.00' ) 22/05/2024 10:48:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91939' , '17257' , 'IO TI BATTEZZO ' , '4' , '-4' , '4' , '1.6' , '1.6' , '0' , '0' , '6.40' ) 22/05/2024 10:48:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91939' , '22562' , 'MISTERI DEL ROSARIO NELLA VITA DI DON BOSCO' , '1' , '-1' , '4' , '4.00' , '4' , '0' , '5' , '3.80' ) 22/05/2024 10:48:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91939' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '14' , '11.475409836066' , '22' , '0' , '14.00' ) 22/05/2024 10:48:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91939' , '22446' , 'PREGARE CON SANTI E PECCATORI - 4' , '1' , '-1' , '4' , '8.50' , '8.5' , '0' , '5' , '8.08' ) 22/05/2024 11:51:07 am >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'Fp05UgMrz8hbHWvV' , NOW() , NOW() ) 22/05/2024 11:51:07 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '7100' , '1' ) 22/05/2024 11:51:07 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '7100' , '2' ) 22/05/2024 11:51:07 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '7100' , '3' ) 22/05/2024 11:52:35 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '7100' 22/05/2024 11:52:36 am >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '7100' , '10' , '208' , '' , 'CINARDI' , 'GUIDO MARIO' , 'VIA PERELLA 6' , '' , '00123' , 'ROMA' , '' , '' , '3792353098' , '' , '' , NOW() , NOW() ) 22/05/2024 11:52:36 am >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '7100' 22/05/2024 11:54:24 am >> SELECT document_num FROM ps_document WHERE document_num = '24' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-05-22') 22/05/2024 11:54:24 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '24' , '2024-05-22' , '' , '7100' , '0' , '177359032' , 'VIA PERELLA 6 00123 ROMA' , '' , '' , '6.9' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '92.40' , '92.40' , NOW() , NOW() ) 22/05/2024 11:54:24 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '14726' 22/05/2024 11:54:24 am >> DELETE FROM ps_document_detail WHERE id_document = '14726' 22/05/2024 11:54:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14726' , '33' , '100 GIORNI CON LO SPIRITO' , '12' , '-12' , '4' , '7.50' , '7.5' , '0' , '5' , '85.50' ) 22/05/2024 11:55:20 am >> SELECT document_num FROM ps_document WHERE document_num = '24' AND id_document != '14726' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-05-22') 22/05/2024 11:55:20 am >> UPDATE ps_document SET id_document_type = '21', document_num = '24', document_date = '2024-05-22', document_letter = '', id_customer = '7100', id_supplier = '', id_address = '177359032', address1 = 'VIA PERELLA 6 00123 ROMA', address2 = '', note = '', price_shipping = '6.90', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '6', id_causal = '0', price_tax_included = '92.40', price_tax_excluded = '92.40', date_upd = NOW() WHERE id_document = '14726' 22/05/2024 11:55:20 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '14726' 22/05/2024 11:55:20 am >> DELETE FROM ps_document_detail WHERE id_document = '14726' 22/05/2024 11:55:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '14726' , '33' , '100 GIORNI CON LO SPIRITO' , '12' , '-12' , '4' , '7.5000' , '7.5' , '0' , '5' , '85.50' ) 22/05/2024 11:59:05 am >> SELECT document_num FROM ps_document WHERE document_num = '1705' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-22') 22/05/2024 11:59:05 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1705' , '2024-05-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '21.10' , '19.35' , NOW() , NOW() ) 22/05/2024 11:59:05 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91940' 22/05/2024 11:59:05 am >> DELETE FROM ps_document_detail WHERE id_document = '91940' 22/05/2024 11:59:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91940' , '7311' , 'OSTIA SOTTILE 74MM' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 22/05/2024 11:59:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91940' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '3' , '-3' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '10.50' ) 22/05/2024 11:59:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91940' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.60' , '2.9508196721311' , '22' , '0' , '3.60' ) 22/05/2024 11:59:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91940' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '3' , '2.4590163934426' , '22' , '0' , '3.00' ) 22/05/2024 12:08:09 pm >> SELECT document_num FROM ps_document WHERE document_num = '61/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-05-22') 22/05/2024 12:08:09 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '61/A' , '2024-05-22' , 'A' , '2332' , '0' , '4679092' , 'P.ZZA S. ROCCO 84088 SIANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '93.60' , '76.72' , NOW() , NOW() ) 22/05/2024 12:08:09 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91941' 22/05/2024 12:08:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '91941' 22/05/2024 12:08:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91941' , '1425' , 'BUSTA 100 FLAMBEAUX IN CARTA - FLAM' , '2' , '-2' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '20.00' ) 22/05/2024 12:08:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91941' , '1626' , 'CANDELE VOTIVE KG 10 - 13X26 - CIRCA 300 PZ' , '1' , '-1' , '1' , '70.00' , '57.377049180328' , '22' , '0' , '70.00' ) 22/05/2024 12:08:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91941' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.60' , '2.9508196721311' , '22' , '0' , '3.60' ) 22/05/2024 12:09:47 pm >> SELECT document_num FROM ps_document WHERE document_num = '62/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-05-22') 22/05/2024 12:09:47 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '62/A' , '2024-05-22' , 'A' , '2332' , '0' , '4679092' , 'P.ZZA S. ROCCO 84088 SIANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '345.40' , '317.45' , NOW() , NOW() ) 22/05/2024 12:09:47 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91942' 22/05/2024 12:09:47 pm >> DELETE FROM ps_document_detail WHERE id_document = '91942' 22/05/2024 12:09:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91942' , '21103' , 'ROSARIO DECINA GIALLO - R333-32' , '150' , '-150' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '105.00' ) 22/05/2024 12:09:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91942' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '80' , '-80' , '4' , '2.80' , '2.8' , '0' , '15' , '190.40' ) 22/05/2024 12:09:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91942' , '7910' , 'PERGAMENE - 1A COMUNIONE MOD. A' , '100' , '-100' , '1' , '0.5' , '0.40983606557377' , '22' , '0' , '50.00' ) 22/05/2024 12:11:17 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '7100' 22/05/2024 12:11:17 pm >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '7100' , '10' , '208' , '' , 'CINARDI' , 'GUIDO MARIO' , 'VIA PERELLA 6' , '' , '00123' , 'ROMA' , '' , '' , '3792353098' , '' , '' , NOW() , NOW() ) 22/05/2024 12:11:17 pm >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '7100' 22/05/2024 12:13:58 pm >> SELECT document_num FROM ps_document WHERE document_num = '1706' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-22') 22/05/2024 12:13:58 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1706' , '2024-05-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.50' , '10.25' , NOW() , NOW() ) 22/05/2024 12:13:58 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91943' 22/05/2024 12:13:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '91943' 22/05/2024 12:13:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91943' , '13142' , 'CERETTI DIAM 26X350 - 2635' , '5' , '-5' , '1' , '2.50' , '2.0491803278689' , '22' , '0' , '12.50' ) 22/05/2024 12:57:33 pm >> SELECT document_num FROM ps_document WHERE document_num = '1707' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-22') 22/05/2024 12:57:33 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1707' , '2024-05-22' , '' , '0' , '0' , '0' , 'VIA CROCE 1 - FRAZ. SALITTO 84062 OLEVANO SUL TUSCIANO' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '298.00' , '262.70' , NOW() , NOW() ) 22/05/2024 12:57:33 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91944' 22/05/2024 12:57:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '91944' 22/05/2024 12:57:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91944' , '20516' , 'CROCE COMUNIONE - 42/08' , '16' , '-16' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '16.00' ) 22/05/2024 12:57:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91944' , '7916' , 'PERGAMENE - 1A RICONCILIAZIONE MOD. A' , '50' , '-50' , '1' , '0.5000' , '0.40983606557377' , '22' , '0' , '25.00' ) 22/05/2024 12:57:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91944' , '0' , 'suppliche' , '5' , '-5' , '4' , '10.0000' , '10' , '0' , '0' , '50.00' ) 22/05/2024 12:57:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91944' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '2' , '-2' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '7.00' ) 22/05/2024 12:57:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91944' , '18276' , 'CINGOLO CON NODI - 3280' , '7' , '-7' , '1' , '2.50' , '2.0491803278689' , '22' , '0' , '17.50' ) 22/05/2024 12:57:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91944' , '22529' , 'NORME PER PROCEDERE NEL DISCERNIMENTO...' , '1' , '-1' , '4' , '2.80' , '2.8' , '0' , '5' , '2.66' ) 22/05/2024 12:57:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91944' , '22507' , 'SPES NON CONFUNDIT' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 22/05/2024 12:57:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91944' , '22096' , 'CREARE CASA 3 - SUSSIDIO GIOVANI' , '1' , '-1' , '4' , '7.00' , '7' , '0' , '5' , '6.65' ) 22/05/2024 12:57:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91944' , '22094' , 'CREARE CASA 1 - ANIMATORI RAGAZZI' , '1' , '-1' , '4' , '7.00' , '7' , '0' , '5' , '6.65' ) 22/05/2024 12:57:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91944' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '12' , '-12' , '4' , '2.4' , '2.4' , '0' , '0' , '28.80' ) 22/05/2024 12:57:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91944' , '15357' , 'AMPOLLE ABBRACCIO NIKEL - 1512' , '1' , '-1' , '1' , '95.74' , '78.475409836066' , '22' , '0' , '95.74' ) 22/05/2024 12:57:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91944' , '7202' , 'ARTICOLI RELIGIOSI - TUNICA' , '1' , '-1' , '1' , '40' , '32.786885245902' , '22' , '0' , '40.00' ) 22/05/2024 02:31:15 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002277' AND id_product != '22566' AND ean13 != '' 22/05/2024 02:31:15 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002277', date_upd = NOW() WHERE id_product = '22566' 22/05/2024 02:31:15 pm >> UPDATE ps_product_lang SET name = 'POLO SIMIL SCOZIA MM - M03', description = '' WHERE id_product = '22566' 22/05/2024 02:31:15 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '45.08196721311476' WHERE id_product = '22566' 22/05/2024 02:31:15 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '45.08196721311476', id_tax_rules_group = '1', id_category_default = '462', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22566' 22/05/2024 02:31:15 pm >> DELETE FROM ps_specific_price WHERE id_product = '22566' 22/05/2024 02:34:41 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '126' , '2024-05-21' , '' , '0' , '137' , '4670816' , 'VIA G. BATTISTA VICO 73 80010 VILLARICCA' , '' , '' , '8' , '1' , '0' , '0' , '0' , '' , '9' , '0' , '273.31' , '224.03' , NOW() , NOW() ) 22/05/2024 02:34:41 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91945' 22/05/2024 02:34:41 pm >> DELETE FROM ps_document_detail WHERE id_document = '91945' 22/05/2024 02:34:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91945' , '19396' , 'CLERGY MISTO COTONE MM - C01' , '6' , '6' , '1' , '17.2' , '14.098360655738' , '22' , '8' , '115.8317' ) 22/05/2024 02:34:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19396' AND id_supplier = '137' 22/05/2024 02:34:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19396' , '137' , '1' ) 22/05/2024 02:34:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91945' , '19398' , 'CLERGY COTONE 100% MM - C02' , '2' , '2' , '1' , '18.9' , '15.491803278689' , '22' , '8' , '42.4267' ) 22/05/2024 02:34:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19398' AND id_supplier = '137' 22/05/2024 02:34:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19398' , '137' , '1' ) 22/05/2024 02:34:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91945' , '22566' , 'POLO SIMIL SCOZIA MM - M03' , '1' , '1' , '1' , '26.5' , '21.72131147541' , '22' , '5' , '30.7135' ) 22/05/2024 02:34:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22566' AND id_supplier = '137' 22/05/2024 02:34:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22566' , '137' , '1' ) 22/05/2024 02:34:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91945' , '21133' , 'SAIO SEMPLICE' , '1' , '1' , '1' , '19.8' , '16.229508196721' , '22' , '0' , '24.1560' ) 22/05/2024 02:34:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21133' AND id_supplier = '137' 22/05/2024 02:34:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21133' , '137' , '1' ) 22/05/2024 02:34:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91945' , '21133' , 'SAIO SEMPLICE' , '1' , '1' , '1' , '26.4' , '21.639344262295' , '22' , '0' , '32.2080' ) 22/05/2024 02:34:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21133' AND id_supplier = '137' 22/05/2024 02:34:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21133' , '137' , '1' ) 22/05/2024 02:34:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91945' , '22286' , 'COLLETTO DOPPIO MISTO LINO - CD01/C' , '1' , '1' , '1' , '7.9' , '6.4754098360656' , '22' , '10' , '8.6742' ) 22/05/2024 02:34:42 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22286' AND id_supplier = '137' 22/05/2024 02:34:42 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22286' , '137' , '1' ) 22/05/2024 02:34:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91945' , '22286' , 'COLLETTO DOPPIO MISTO LINO - CD01/C' , '1' , '1' , '1' , '8.69' , '7.1229508196721' , '22' , '10' , '9.5416' ) 22/05/2024 02:34:42 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22286' AND id_supplier = '137' 22/05/2024 02:34:42 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22286' , '137' , '1' ) 22/05/2024 03:37:45 pm >> SELECT document_num FROM ps_document WHERE document_num = '1/A' AND id_document != '89846' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-01-08') 22/05/2024 03:37:46 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '1/A', document_date = '2024-01-08', document_letter = 'A', id_customer = '206', id_supplier = '', id_address = '4671015', address1 = 'VIA N. BUONSERVIZI, 25 84135 SALERNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '49.80', price_tax_excluded = '49.80', date_upd = NOW() WHERE id_document = '89846' 22/05/2024 03:37:46 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89846' 22/05/2024 03:37:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '89846' 22/05/2024 03:37:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89846' , '22474' , 'PAROLA E PREGHIERA - LUG 2024' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '0' , '2.90' ) 22/05/2024 03:37:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89846' , '19892' , 'SALVE, REGINA - S. HAHN' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 22/05/2024 03:37:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89846' , '22414' , 'SULLA TUA PAROLA - LUG/AGO 2024' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '0' , '5.00' ) 22/05/2024 03:37:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89846' , '22214' , 'VIE DI MARIA - F. DE CRISTOFARO' , '1' , '-1' , '4' , '13.0000' , '13' , '0' , '0' , '13.00' ) 22/05/2024 03:37:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89846' , '19512' , 'SGUARDO DI GESU - F. CRISTOFARO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 22/05/2024 03:37:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89846' , '22557' , 'PAROLA E PREGHIERA - AGO 2024' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '0' , '2.90' ) 22/05/2024 03:48:15 pm >> DELETE FROM ps_document WHERE id_document = '91587' 22/05/2024 03:48:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '91587' 22/05/2024 04:20:13 pm >> SELECT document_num FROM ps_document WHERE document_num = '1708' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-22') 22/05/2024 04:20:13 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1708' , '2024-05-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.80' , '2.30' , NOW() , NOW() ) 22/05/2024 04:20:13 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91946' 22/05/2024 04:20:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '91946' 22/05/2024 04:20:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91946' , '19309' , 'CROCE ULIVO PRIMA COMUNIONE - 1328' , '1' , '-1' , '1' , '2.80' , '2.2950819672131' , '22' , '0' , '2.80' ) 22/05/2024 04:44:30 pm >> SELECT document_num FROM ps_document WHERE document_num = '1709' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-22') 22/05/2024 04:44:30 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1709' , '2024-05-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.00' , '8.20' , NOW() , NOW() ) 22/05/2024 04:44:30 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91947' 22/05/2024 04:44:30 pm >> DELETE FROM ps_document_detail WHERE id_document = '91947' 22/05/2024 04:44:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91947' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 22/05/2024 04:49:45 pm >> SELECT document_num FROM ps_document WHERE document_num = '1710' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-22') 22/05/2024 04:49:45 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1710' , '2024-05-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.00' , '10.58' , NOW() , NOW() ) 22/05/2024 04:49:45 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91948' 22/05/2024 04:49:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '91948' 22/05/2024 04:49:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91948' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 22/05/2024 04:49:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91948' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '2' , '-2' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '7.00' ) 22/05/2024 05:37:12 pm >> SELECT document_num FROM ps_document WHERE document_num = '1711' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-22') 22/05/2024 05:37:12 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1711' , '2024-05-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '44.00' , '36.07' , NOW() , NOW() ) 22/05/2024 05:37:12 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91949' 22/05/2024 05:37:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '91949' 22/05/2024 05:37:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91949' , '13805' , 'QUADRETTO 10X10 ALBERO DELLA VITA - 2974/F0024' , '4' , '-4' , '1' , '11' , '9.016393442623' , '22' , '0' , '44.00' ) 22/05/2024 06:12:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '1712' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-22') 22/05/2024 06:12:39 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1712' , '2024-05-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '90.00' , '73.77' , NOW() , NOW() ) 22/05/2024 06:12:39 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91950' 22/05/2024 06:12:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '91950' 22/05/2024 06:12:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91950' , '22530' , 'ANGELO ALI TORTORA - 4232' , '9' , '-9' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '90.00' ) 22/05/2024 06:30:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '1713' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-22') 22/05/2024 06:30:11 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1713' , '2024-05-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.70' , '3.03' , NOW() , NOW() ) 22/05/2024 06:30:11 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91951' 22/05/2024 06:30:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '91951' 22/05/2024 06:30:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91951' , '20516' , 'CROCE COMUNIONE - 42/08' , '1' , '-1' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '1.20' ) 22/05/2024 06:30:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91951' , '18276' , 'CINGOLO CON NODI - 3280' , '1' , '-1' , '1' , '2.50' , '2.0491803278689' , '22' , '0' , '2.50' )