15/11/2023 08:42:09 am >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'zXjKYbcBNXHqdD0S' , NOW() , NOW() ) 15/11/2023 08:42:09 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4055' , '1' ) 15/11/2023 08:42:09 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4055' , '2' ) 15/11/2023 08:42:09 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4055' , '3' ) 15/11/2023 08:45:33 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4055' 15/11/2023 08:45:33 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 ( '4055' , '10' , '145' , 'PARR. SS. ANNUNZIATA' , 'LUCCA' , 'DON VALERIO' , 'VIA ANNUNZIATA 56' , '' , '81046' , 'GRAZZANISE' , 'ORDINE E SPEDIZIONE: : Palazzo Angelica, via Cesare Battisti, 65 cap.81046 Grazzanise Ce\r\nTEL. 3381678325 EMAIL angelicapalazzo@virgilio.it' , '' , '' , '' , '93011810616' , NOW() , NOW() ) 15/11/2023 08:45:33 am >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4055' 15/11/2023 08:47:12 am >> SELECT document_num FROM ps_document WHERE document_num = '268' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-11-15') 15/11/2023 08:47:12 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' , '268' , '2023-11-15' , '' , '4055' , '0' , '4679189' , 'VIA ANNUNZIATA 56 81046 GRAZZANISE' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '81.95' , '81.95' , NOW() , NOW() ) 15/11/2023 08:47:12 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 = '88961' 15/11/2023 08:47:12 am >> DELETE FROM ps_document_detail WHERE id_document = '88961' 15/11/2023 08:47:12 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 ( '88961' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '18' , '-18' , '4' , '3.50' , '3.5' , '0' , '15' , '53.55' ) 15/11/2023 08:47:12 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 ( '88961' , '4393' , 'GESÙ CI CHIAMA 1 - GUIDA' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '15' , '8.50' ) 15/11/2023 08:47:12 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 ( '88961' , '4396' , 'GESÙ CI RIVELA IL PADRE 2 - GUIDA' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '15' , '8.50' ) 15/11/2023 08:47:12 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 ( '88961' , '4494' , 'GESÙ RESTA CON NOI 3 - GUIDA' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '15' , '8.50' ) 15/11/2023 08:47:12 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 ( '88961' , '' , 'SPESE DI CONTRASEGNO' , '1' , '-1' , '4' , '2.9' , '2.9' , '0' , '0' , '2.90' ) 15/11/2023 09:35:16 am >> SELECT document_num FROM ps_document WHERE document_num = '3611' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-15') 15/11/2023 09:35:16 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' , '3611' , '2023-11-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.00' , '15.57' , NOW() , NOW() ) 15/11/2023 09:35:16 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 = '88962' 15/11/2023 09:35:16 am >> DELETE FROM ps_document_detail WHERE id_document = '88962' 15/11/2023 09:35:16 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 ( '88962' , '17617' , 'IMMAGINI ISONZO X 100' , '5' , '-5' , '1' , '3.80' , '3.1147540983607' , '22' , '0' , '19.00' ) 15/11/2023 10:18:59 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 15/11/2023 10:18:59 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21827' , '1' , '' , 'nuovo-prodotto' ) 15/11/2023 10:18:59 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '21827' , '1' , '1' , '2' , NOW() , NOW() ) 15/11/2023 10:18:59 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '21827' , '0' , '1' , '0' , '0' ) 15/11/2023 10:24:11 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788868946616' AND id_product != '21827' AND ean13 != '' 15/11/2023 10:24:11 am >> UPDATE ps_product SET id_supplier = '', reference = '7/6', ean13 = '9788868946616', date_upd = NOW() WHERE id_product = '21827' 15/11/2023 10:24:11 am >> UPDATE ps_product_lang SET name = 'GIOIA DEL CUORE - C. STERCAL', description = '' WHERE id_product = '21827' 15/11/2023 10:24:11 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '10' WHERE id_product = '21827' 15/11/2023 10:24:11 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '10', id_tax_rules_group = '4', id_category_default = '103', id_argoment_default = '23', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21827' 15/11/2023 10:24:11 am >> DELETE FROM ps_specific_price WHERE id_product = '21827' 15/11/2023 10:24:13 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 = '21827' 15/11/2023 10:24:13 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21828' , '1' , '' , 'nuovo-prodotto' ) 15/11/2023 10:24:13 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 '21828' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21827' 15/11/2023 10:24:13 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21828' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21827' 15/11/2023 10:25:35 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788886833059' AND id_product != '21828' AND ean13 != '' 15/11/2023 10:25:35 am >> UPDATE ps_product SET id_supplier = '', reference = '11/3', ean13 = '9788886833059', date_upd = NOW() WHERE id_product = '21828' 15/11/2023 10:25:35 am >> UPDATE ps_product_lang SET name = 'VANGELO DI GESU\' ', description = '' WHERE id_product = '21828' 15/11/2023 10:25:35 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3.1' WHERE id_product = '21828' 15/11/2023 10:25:35 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3.1', id_tax_rules_group = '4', id_category_default = '246', id_argoment_default = '170', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21828' 15/11/2023 10:25:35 am >> DELETE FROM ps_specific_price WHERE id_product = '21828' 15/11/2023 10:33:36 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 = '21828' 15/11/2023 10:33:36 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21829' , '1' , '' , 'nuovo-prodotto' ) 15/11/2023 10:33:36 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 '21829' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21828' 15/11/2023 10:33:36 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21829' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21828' 15/11/2023 10:34:21 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788821595400' AND id_product != '21829' AND ean13 != '' 15/11/2023 10:34:21 am >> UPDATE ps_product SET id_supplier = '', reference = '6/2', ean13 = '9788821595400', date_upd = NOW() WHERE id_product = '21829' 15/11/2023 10:34:21 am >> UPDATE ps_product_lang SET name = 'ANIMA DI OGNI APOSTOLATO - D. CHAUTARD', description = '' WHERE id_product = '21829' 15/11/2023 10:34:21 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '9.9' WHERE id_product = '21829' 15/11/2023 10:34:21 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '9.9', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '74', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21829' 15/11/2023 10:34:21 am >> DELETE FROM ps_specific_price WHERE id_product = '21829' 15/11/2023 10:37: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 = '21829' 15/11/2023 10:37:29 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21830' , '1' , '' , 'nuovo-prodotto' ) 15/11/2023 10:37: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 '21830' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21829' 15/11/2023 10:37:29 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21830' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21829' 15/11/2023 10:38:15 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788839912749' AND id_product != '21830' AND ean13 != '' 15/11/2023 10:38:15 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788839912749', date_upd = NOW() WHERE id_product = '21830' 15/11/2023 10:38:15 am >> UPDATE ps_product_lang SET name = 'GESU\' VIA ALLA LIBERTA\' - A. GRUN', description = '' WHERE id_product = '21830' 15/11/2023 10:38:15 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '11' WHERE id_product = '21830' 15/11/2023 10:38:15 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '11', id_tax_rules_group = '4', id_category_default = '111', 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 = '21830' 15/11/2023 10:38:15 am >> DELETE FROM ps_specific_price WHERE id_product = '21830' 15/11/2023 10:38:40 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 = '21830' 15/11/2023 10:38:40 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21831' , '1' , '' , 'nuovo-prodotto' ) 15/11/2023 10:38:40 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 '21831' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21830' 15/11/2023 10:38:40 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21831' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21830' 15/11/2023 10:39:14 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788839928337' AND id_product != '21831' AND ean13 != '' 15/11/2023 10:39:14 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788839928337', date_upd = NOW() WHERE id_product = '21831' 15/11/2023 10:39:14 am >> UPDATE ps_product_lang SET name = 'GUIDA PER L\'AVVENTO - A. GRUN', description = '' WHERE id_product = '21831' 15/11/2023 10:39:14 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '17' WHERE id_product = '21831' 15/11/2023 10:39:14 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '17', id_tax_rules_group = '4', id_category_default = '111', id_argoment_default = '39', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21831' 15/11/2023 10:39:14 am >> DELETE FROM ps_specific_price WHERE id_product = '21831' 15/11/2023 10:39:33 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 = '21831' 15/11/2023 10:39:33 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21832' , '1' , '' , 'nuovo-prodotto' ) 15/11/2023 10:39:33 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 '21832' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21831' 15/11/2023 10:39:33 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21832' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21831' 15/11/2023 10:42:40 am >> SELECT document_num FROM ps_document WHERE document_num = '3612' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-15') 15/11/2023 10:42: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' , '3612' , '2023-11-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '50.80' , '41.64' , NOW() , NOW() ) 15/11/2023 10:42: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 = '88963' 15/11/2023 10:42:40 am >> DELETE FROM ps_document_detail WHERE id_document = '88963' 15/11/2023 10:42: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 ( '88963' , '21137' , 'MOCCOLO 70X200' , '5' , '-5' , '1' , '7' , '5.7377049180328' , '22' , '0' , '35.00' ) 15/11/2023 10:42: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 ( '88963' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '2' , '-2' , '1' , '7.90' , '6.4754098360656' , '22' , '0' , '15.80' ) 15/11/2023 10:43:44 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892243231' AND id_product != '21832' AND ean13 != '' 15/11/2023 10:43:44 am >> UPDATE ps_product SET id_supplier = '', reference = '7/6', ean13 = '9788892243231', date_upd = NOW() WHERE id_product = '21832' 15/11/2023 10:43:44 am >> UPDATE ps_product_lang SET name = 'PICCOLO LIBRO DELLA PREGHIERA DI QUIETE - P. DYCKHOFF', description = '' WHERE id_product = '21832' 15/11/2023 10:43:44 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '15' WHERE id_product = '21832' 15/11/2023 10:43:44 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '15', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '23', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21832' 15/11/2023 10:43:44 am >> DELETE FROM ps_specific_price WHERE id_product = '21832' 15/11/2023 10:44: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 = '21832' 15/11/2023 10:44:47 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21833' , '1' , '' , 'nuovo-prodotto' ) 15/11/2023 10:44: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 '21833' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21832' 15/11/2023 10:44:48 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21833' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21832' 15/11/2023 10:45:21 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801068573' AND id_product != '21833' AND ean13 != '' 15/11/2023 10:45:21 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788801068573', date_upd = NOW() WHERE id_product = '21833' 15/11/2023 10:45:21 am >> UPDATE ps_product_lang SET name = '5 CIOTTOLI DI DAVIDE ', description = '' WHERE id_product = '21833' 15/11/2023 10:45:21 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '7.9' WHERE id_product = '21833' 15/11/2023 10:45:21 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '7.9', id_tax_rules_group = '4', id_category_default = '19', id_argoment_default = '23', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21833' 15/11/2023 10:45:21 am >> DELETE FROM ps_specific_price WHERE id_product = '21833' 15/11/2023 10:45:46 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 = '21833' 15/11/2023 10:45:46 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21834' , '1' , '' , 'nuovo-prodotto' ) 15/11/2023 10:45: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 '21834' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21833' 15/11/2023 10:45:47 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21834' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21833' 15/11/2023 10:46:24 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788886242431' AND id_product != '21834' AND ean13 != '' 15/11/2023 10:46:24 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788886242431', date_upd = NOW() WHERE id_product = '21834' 15/11/2023 10:46:24 am >> UPDATE ps_product_lang SET name = 'PAPIA ', description = '' WHERE id_product = '21834' 15/11/2023 10:46:24 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '7.8' WHERE id_product = '21834' 15/11/2023 10:46:24 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '7.8', id_tax_rules_group = '4', id_category_default = '83', id_argoment_default = '23', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21834' 15/11/2023 10:46:24 am >> DELETE FROM ps_specific_price WHERE id_product = '21834' 15/11/2023 10:47:01 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788886242431' AND id_product != '21834' AND ean13 != '' 15/11/2023 10:47:01 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788886242431', date_upd = NOW() WHERE id_product = '21834' 15/11/2023 10:47:01 am >> UPDATE ps_product_lang SET name = 'PAPIA ', description = '' WHERE id_product = '21834' 15/11/2023 10:47:01 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '7.8' WHERE id_product = '21834' 15/11/2023 10:47:01 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '7.8', id_tax_rules_group = '4', id_category_default = '83', id_argoment_default = '23', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21834' 15/11/2023 10:47:01 am >> DELETE FROM ps_specific_price WHERE id_product = '21834' 15/11/2023 10:47:04 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 = '21834' 15/11/2023 10:47:04 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21835' , '1' , '' , 'nuovo-prodotto' ) 15/11/2023 10:47:04 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 '21835' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21834' 15/11/2023 10:47:04 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21835' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21834' 15/11/2023 10:47:47 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831522854' AND id_product != '21835' AND ean13 != '' 15/11/2023 10:47:47 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788831522854', date_upd = NOW() WHERE id_product = '21835' 15/11/2023 10:47:47 am >> UPDATE ps_product_lang SET name = 'DIDACHE\' ', description = '' WHERE id_product = '21835' 15/11/2023 10:47:47 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '7.5' WHERE id_product = '21835' 15/11/2023 10:47:47 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '7.5', id_tax_rules_group = '4', id_category_default = '27', id_argoment_default = '23', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21835' 15/11/2023 10:47:47 am >> DELETE FROM ps_specific_price WHERE id_product = '21835' 15/11/2023 10:48:09 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 = '21835' 15/11/2023 10:48:09 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21836' , '1' , '' , 'nuovo-prodotto' ) 15/11/2023 10:48:09 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 '21836' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21835' 15/11/2023 10:48:09 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21836' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21835' 15/11/2023 10:48:56 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788868946326' AND id_product != '21836' AND ean13 != '' 15/11/2023 10:48:56 am >> UPDATE ps_product SET id_supplier = '', reference = '13/4', ean13 = '9788868946326', date_upd = NOW() WHERE id_product = '21836' 15/11/2023 10:48:57 am >> UPDATE ps_product_lang SET name = 'DONO PER TUTTI', description = '' WHERE id_product = '21836' 15/11/2023 10:48:57 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '2.7' WHERE id_product = '21836' 15/11/2023 10:48:57 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '2.7', id_tax_rules_group = '4', id_category_default = '103', id_argoment_default = '39', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21836' 15/11/2023 10:48:57 am >> DELETE FROM ps_specific_price WHERE id_product = '21836' 15/11/2023 10:50:11 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' , '648385' , '2023-11-13' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '19.22' , '4' , '0' , '0' , '0' , '' , '11' , '0' , '638.63' , '635.44' , NOW() , NOW() ) 15/11/2023 10:50:11 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 = '88964' 15/11/2023 10:50:11 am >> DELETE FROM ps_document_detail WHERE id_document = '88964' 15/11/2023 10:50:11 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 ( '88964' , '21827' , 'GIOIA DEL CUORE - C. STERCAL' , '1' , '1' , '4' , '10.00' , '10' , '0' , '30' , '7.0000' ) 15/11/2023 10:50:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '21827' AND id_supplier = '7' 15/11/2023 10:50:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21827' , '7' , '1' ) 15/11/2023 10:50:11 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 ( '88964' , '21828' , 'VANGELO DI GESU ' , '9' , '9' , '4' , '3.10' , '3.1' , '0' , '30' , '19.5300' ) 15/11/2023 10:50:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '21828' AND id_supplier = '7' 15/11/2023 10:50:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21828' , '7' , '1' ) 15/11/2023 10:50:11 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 ( '88964' , '21569' , 'DOMENICHE DA COLORARE - ANNO B ' , '1' , '1' , '4' , '9.90' , '9.9' , '0' , '30' , '6.9300' ) 15/11/2023 10:50:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '21569' AND id_supplier = '7' 15/11/2023 10:50:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21569' , '7' , '1' ) 15/11/2023 10:50:11 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 ( '88964' , '18703' , 'IN_SEGUENDO GESU A CAFARNAO' , '65' , '65' , '4' , '5.00' , '5' , '0' , '33+7' , '202.5075' ) 15/11/2023 10:50:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '18703' AND id_supplier = '7' 15/11/2023 10:50:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18703' , '7' , '1' ) 15/11/2023 10:50:11 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 ( '88964' , '19805' , 'DESIDERIO DESIDERAVI' , '40' , '40' , '4' , '2.00' , '2' , '0' , '33+7' , '49.8480' ) 15/11/2023 10:50:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '19805' AND id_supplier = '7' 15/11/2023 10:50:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19805' , '7' , '1' ) 15/11/2023 10:50:11 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 ( '88964' , '10751' , 'TU MI PERDONI' , '13' , '13' , '4' , '6.90' , '6.9' , '0' , '30+7' , '58.3947' ) 15/11/2023 10:50:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '10751' AND id_supplier = '7' 15/11/2023 10:50:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10751' , '7' , '1' ) 15/11/2023 10:50:11 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 ( '88964' , '9680' , 'SARETE MIEI TESTIMONI - GUIDA 1 - MAGNIFICAT' , '2' , '2' , '4' , '12.00' , '12' , '0' , '35+7' , '14.5080' ) 15/11/2023 10:50:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '9680' AND id_supplier = '7' 15/11/2023 10:50:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9680' , '7' , '1' ) 15/11/2023 10:50:11 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 ( '88964' , '11187' , 'VENITE CON ME - GUIDA 1 - MAGNIFICAT' , '2' , '2' , '4' , '12.00' , '12' , '0' , '35+7' , '14.5080' ) 15/11/2023 10:50:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '11187' AND id_supplier = '7' 15/11/2023 10:50:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11187' , '7' , '1' ) 15/11/2023 10:50:11 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 ( '88964' , '21003' , 'FARE CATECHESI OGGI - U. MONTISCI' , '1' , '1' , '4' , '38.00' , '38' , '0' , '33+7' , '23.6778' ) 15/11/2023 10:50:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '21003' AND id_supplier = '7' 15/11/2023 10:50:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21003' , '7' , '1' ) 15/11/2023 10:50:11 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 ( '88964' , '21751' , 'MESSALINO QUOTIDIANO - FEB-MAR-APR 2024' , '8' , '8' , '4' , '6.00' , '6' , '0' , '30+7' , '31.2480' ) 15/11/2023 10:50:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '21751' AND id_supplier = '7' 15/11/2023 10:50:11 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21751' , '7' , '1' ) 15/11/2023 10:50:11 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 ( '88964' , '21629' , 'MANUALE DI AMMINISTRAZIONE DELLE PARROCCHIE' , '1' , '1' , '4' , '25.00' , '25' , '0' , '33+7' , '15.5775' ) 15/11/2023 10:50:11 am >> DELETE FROM ps_product_supplier WHERE id_product = '21629' AND id_supplier = '7' 15/11/2023 10:50:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21629' , '7' , '1' ) 15/11/2023 10:50:12 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 ( '88964' , '21829' , 'ANIMA DI OGNI APOSTOLATO - D. CHAUTARD' , '1' , '1' , '4' , '9.90' , '9.9' , '0' , '33+7' , '6.1687' ) 15/11/2023 10:50:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '21829' AND id_supplier = '7' 15/11/2023 10:50:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21829' , '7' , '1' ) 15/11/2023 10:50:12 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 ( '88964' , '18692' , 'IN_SEGUENDO GESU - GUIDA' , '1' , '1' , '4' , '12.00' , '12' , '0' , '33+7' , '7.4772' ) 15/11/2023 10:50:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '18692' AND id_supplier = '7' 15/11/2023 10:50:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18692' , '7' , '1' ) 15/11/2023 10:50:12 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 ( '88964' , '21410' , 'IO E CARLO - M. PAPPALARDO' , '3' , '3' , '4' , '11.90' , '11.9' , '0' , '35+7' , '21.5806' ) 15/11/2023 10:50:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '21410' AND id_supplier = '7' 15/11/2023 10:50:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21410' , '7' , '1' ) 15/11/2023 10:50:12 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 ( '88964' , '21563' , 'AGENDA SAN PAOLO 2024' , '3' , '3' , '1' , '4.83' , '3.9590163934426' , '22' , '0' , '17.6778' ) 15/11/2023 10:50:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '21563' AND id_supplier = '7' 15/11/2023 10:50:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21563' , '7' , '1' ) 15/11/2023 10:50:12 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 ( '88964' , '21755' , 'PAROLA DI DIO OGNI GIORNO 2024 - V. PAGLIA' , '1' , '1' , '4' , '22.00' , '22' , '0' , '33' , '14.7400' ) 15/11/2023 10:50:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '21755' AND id_supplier = '7' 15/11/2023 10:50:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21755' , '7' , '1' ) 15/11/2023 10:50:12 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 ( '88964' , '21830' , 'GESU VIA ALLA LIBERTA - A. GRUN' , '1' , '1' , '4' , '11.00' , '11' , '0' , '30' , '7.7000' ) 15/11/2023 10:50:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '21830' AND id_supplier = '7' 15/11/2023 10:50:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21830' , '7' , '1' ) 15/11/2023 10:50:12 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 ( '88964' , '21831' , 'GUIDA PER LAVVENTO - A. GRUN' , '1' , '1' , '4' , '17.00' , '17' , '0' , '30' , '11.9000' ) 15/11/2023 10:50:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '21831' AND id_supplier = '7' 15/11/2023 10:50:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21831' , '7' , '1' ) 15/11/2023 10:50:12 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 ( '88964' , '21832' , 'PICCOLO LIBRO DELLA PREGHIERA DI QUIETE - P. DYCKHOFF' , '1' , '1' , '4' , '15.00' , '15' , '0' , '33' , '10.0500' ) 15/11/2023 10:50:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '21832' AND id_supplier = '7' 15/11/2023 10:50:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21832' , '7' , '1' ) 15/11/2023 10:50:12 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 ( '88964' , '21798' , 'ENCICLICA DEI BAMBINI - FORTUNATO / CAGNOLI' , '1' , '1' , '4' , '9.90' , '9.9' , '0' , '35' , '6.4350' ) 15/11/2023 10:50:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '21798' AND id_supplier = '7' 15/11/2023 10:50:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21798' , '7' , '1' ) 15/11/2023 10:50:12 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 ( '88964' , '19550' , 'PAROLA AI GIOVANI - L. AMENDOLAGINE' , '1' , '1' , '4' , '16.00' , '16' , '0' , '35' , '10.4000' ) 15/11/2023 10:50:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '19550' AND id_supplier = '7' 15/11/2023 10:50:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19550' , '7' , '1' ) 15/11/2023 10:50:12 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 ( '88964' , '21833' , '5 CIOTTOLI DI DAVIDE ' , '1' , '1' , '4' , '7.90' , '7.9' , '0' , '35' , '5.1350' ) 15/11/2023 10:50:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '21833' AND id_supplier = '7' 15/11/2023 10:50:12 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21833' , '7' , '1' ) 15/11/2023 10:50:12 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 ( '88964' , '21834' , 'PAPIA ' , '4' , '4' , '4' , '7.80' , '7.8' , '0' , '30' , '21.8400' ) 15/11/2023 10:50:12 am >> DELETE FROM ps_product_supplier WHERE id_product = '21834' AND id_supplier = '7' 15/11/2023 10:50:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21834' , '7' , '1' ) 15/11/2023 10:50:13 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 ( '88964' , '21835' , 'DIDACHE ' , '5' , '5' , '4' , '7.50' , '7.5' , '0' , '33' , '25.1250' ) 15/11/2023 10:50:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '21835' AND id_supplier = '7' 15/11/2023 10:50:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21835' , '7' , '1' ) 15/11/2023 10:50:13 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 ( '88964' , '21836' , 'DONO PER TUTTI' , '5' , '5' , '4' , '2.70' , '2.7' , '0' , '30' , '9.4500' ) 15/11/2023 10:50:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '21836' AND id_supplier = '7' 15/11/2023 10:50:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21836' , '7' , '1' ) 15/11/2023 11:01:49 am >> SELECT document_num FROM ps_document WHERE document_num = '3613' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-15') 15/11/2023 11:01:49 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' , '3613' , '2023-11-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '42.75' , '42.75' , NOW() , NOW() ) 15/11/2023 11:01:49 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 = '88965' 15/11/2023 11:01:49 am >> DELETE FROM ps_document_detail WHERE id_document = '88965' 15/11/2023 11:01:49 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 ( '88965' , '21778' , 'SULLA TUA PAROLA - GEN/FEB 2024' , '9' , '-9' , '4' , '5.00' , '5' , '0' , '5' , '42.75' ) 15/11/2023 11:28:46 am >> SELECT document_num FROM ps_document WHERE document_num = '269' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-11-15') 15/11/2023 11:28: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 ( '21' , '269' , '2023-11-15' , '' , '1138' , '0' , '4672220' , 'P. ZZA AMENDOLA - LANZARA 84083 CASTEL SAN GIORGIO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '363.38' , '363.38' , NOW() , NOW() ) 15/11/2023 11:28: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 = '88966' 15/11/2023 11:28:46 am >> DELETE FROM ps_document_detail WHERE id_document = '88966' 15/11/2023 11:28: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 ( '88966' , '2679' , 'CONOSCERE GESU\'' , '42' , '-42' , '4' , '3.50' , '3.5' , '0' , '15' , '124.95' ) 15/11/2023 11:28: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 ( '88966' , '8514' , 'PRIMI PASSI CON GESÙ ANNO B - GUIDA' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '15' , '4.25' ) 15/11/2023 11:28: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 ( '88966' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '38' , '-38' , '4' , '3.50' , '3.5' , '0' , '15' , '113.05' ) 15/11/2023 11:28: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 ( '88966' , '4393' , 'GESÙ CI CHIAMA 1 - GUIDA' , '2' , '-2' , '4' , '10.00' , '10' , '0' , '15' , '17.00' ) 15/11/2023 11:28: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 ( '88966' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '35' , '-35' , '4' , '3.50' , '3.5' , '0' , '15' , '104.13' ) 15/11/2023 11:36:41 am >> SELECT document_num FROM ps_document WHERE document_num = '3614' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-15') 15/11/2023 11:36:41 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' , '3614' , '2023-11-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '299.73' , '299.73' , NOW() , NOW() ) 15/11/2023 11:36:41 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 = '88967' 15/11/2023 11:36:41 am >> DELETE FROM ps_document_detail WHERE id_document = '88967' 15/11/2023 11:36:41 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 ( '88967' , '19805' , 'DESIDERIO DESIDERAVI' , '30' , '-30' , '4' , '2.00' , '2' , '0' , '5' , '57.00' ) 15/11/2023 11:36:41 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 ( '88967' , '21826' , 'NATALE DI FRANCESCO A GRECCIO - A. CACCIOTTI' , '1' , '-1' , '4' , '26.00' , '26' , '0' , '5' , '24.70' ) 15/11/2023 11:36:42 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 ( '88967' , '18703' , 'IN_SEGUENDO GESU A CAFARNAO' , '40' , '-40' , '4' , '5.00' , '5' , '0' , '5' , '190.00' ) 15/11/2023 11:36:42 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 ( '88967' , '21626' , 'MISSIONE NATALE' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '5' , '2.38' ) 15/11/2023 11:36:42 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 ( '88967' , '21817' , 'SI RITIRO A PREGARE - A. GRAPPONE' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 15/11/2023 11:36:42 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 ( '88967' , '21467' , 'ADOLESCENTI INAFFERRABILI - BOTTA / LONARDO' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 15/11/2023 11:42:50 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 15/11/2023 11:42:50 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21837' , '1' , '' , 'nuovo-prodotto' ) 15/11/2023 11:42:50 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '21837' , '1' , '1' , '2' , NOW() , NOW() ) 15/11/2023 11:42:50 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '21837' , '0' , '1' , '0' , '0' ) 15/11/2023 11:44:19 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884048646' AND id_product != '21837' AND ean13 != '' 15/11/2023 11:44:19 am >> UPDATE ps_product SET id_supplier = '', reference = 'ESPOSITORE SHALOM', ean13 = '9788884048646', date_upd = NOW() WHERE id_product = '21837' 15/11/2023 11:44:19 am >> UPDATE ps_product_lang SET name = 'CAMMINO DELLA PREGHIERA - P. SCIADINI - 8484', description = '' WHERE id_product = '21837' 15/11/2023 11:44:19 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '7' WHERE id_product = '21837' 15/11/2023 11:44:19 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '7', id_tax_rules_group = '4', id_category_default = '106', id_argoment_default = '41', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21837' 15/11/2023 11:44:19 am >> DELETE FROM ps_specific_price WHERE id_product = '21837' 15/11/2023 11:46:21 am >> SELECT document_num FROM ps_document WHERE document_num = '3615' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-15') 15/11/2023 11:46:21 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' , '3615' , '2023-11-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '24.50' , '20.08' , NOW() , NOW() ) 15/11/2023 11:46:21 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 = '88968' 15/11/2023 11:46:21 am >> DELETE FROM ps_document_detail WHERE id_document = '88968' 15/11/2023 11:46:21 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 ( '88968' , '9257' , 'SACRA FAMIGLIA' , '1' , '-1' , '1' , '3.5' , '2.8688524590164' , '22' , '0' , '3.50' ) 15/11/2023 11:46:21 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 ( '88968' , '17617' , 'IMMAGINI ISONZO X 100' , '6' , '-6' , '1' , '3.5' , '2.8688524590164' , '22' , '0' , '21.00' ) 15/11/2023 11:50:52 am >> SELECT document_num FROM ps_document WHERE document_num = '269' AND id_document != '88966' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-11-15') 15/11/2023 11:50:52 am >> UPDATE ps_document SET id_document_type = '21', document_num = '269', document_date = '2023-11-15', document_letter = '', id_customer = '1138', id_supplier = '', id_address = '4672220', address1 = 'P. ZZA AMENDOLA - LANZARA 84083 CASTEL SAN GIORGIO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '554.97', price_tax_excluded = '554.97', date_upd = NOW() WHERE id_document = '88966' 15/11/2023 11:50: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 = '88966' 15/11/2023 11:50:52 am >> DELETE FROM ps_document_detail WHERE id_document = '88966' 15/11/2023 11:50: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 ( '88966' , '2679' , 'CONOSCERE GESU\'' , '42' , '-42' , '4' , '3.5000' , '3.5' , '0' , '15' , '124.95' ) 15/11/2023 11:50: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 ( '88966' , '8514' , 'PRIMI PASSI CON GESÙ ANNO B - GUIDA' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '15' , '4.25' ) 15/11/2023 11:50: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 ( '88966' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '38' , '-38' , '4' , '3.5000' , '3.5' , '0' , '15' , '113.05' ) 15/11/2023 11:50: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 ( '88966' , '4393' , 'GESÙ CI CHIAMA 1 - GUIDA' , '2' , '-2' , '4' , '10.0000' , '10' , '0' , '15' , '17.00' ) 15/11/2023 11:50: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 ( '88966' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '35' , '-35' , '4' , '3.5000' , '3.5' , '0' , '15' , '104.13' ) 15/11/2023 11:50: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 ( '88966' , '8510' , 'PRIMI PASSI CON GESÙ - ANNO B' , '35' , '-35' , '4' , '3.40' , '3.4' , '0' , '15' , '101.15' ) 15/11/2023 11:50: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 ( '88966' , '4396' , 'GESÙ CI RIVELA IL PADRE 2 - GUIDA' , '4' , '-4' , '4' , '10.00' , '10' , '0' , '15' , '34.00' ) 15/11/2023 11:50: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 ( '88966' , '5457' , 'IO SONO CON VOI 1 PARTE' , '18' , '-18' , '4' , '2.80' , '2.8' , '0' , '15' , '42.84' ) 15/11/2023 11:50: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 ( '88966' , '5446' , 'IO SONO CON VOI - GUIDA' , '2' , '-2' , '4' , '8.00' , '8' , '0' , '15' , '13.60' ) 15/11/2023 12:17:53 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 15/11/2023 12:17:53 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21838' , '1' , '' , 'nuovo-prodotto' ) 15/11/2023 12:17:53 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '21838' , '1' , '1' , '2' , NOW() , NOW() ) 15/11/2023 12:17:53 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '21838' , '0' , '1' , '0' , '0' ) 15/11/2023 12:19:42 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8024823232839' AND id_product != '21838' AND ean13 != '' 15/11/2023 12:19:42 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8024823232839', date_upd = NOW() WHERE id_product = '21838' 15/11/2023 12:19:42 pm >> UPDATE ps_product_lang SET name = 'CARTOLINA CARLO ACUTIS', description = '' WHERE id_product = '21838' 15/11/2023 12:19:42 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '0.12295081967213115' WHERE id_product = '21838' 15/11/2023 12:19:42 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '0.12295081967213115', id_tax_rules_group = '1', id_category_default = '106', id_argoment_default = '234', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21838' 15/11/2023 12:19:42 pm >> DELETE FROM ps_specific_price WHERE id_product = '21838' 15/11/2023 12:22: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 ( '31' , '18254' , '2023-11-13' , '' , '0' , '38' , '2633' , 'VIA GALVANI, 1 60020 CAMERATA PICENA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '123.31' , '119.03' , NOW() , NOW() ) 15/11/2023 12:22: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 = '88969' 15/11/2023 12:22:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '88969' 15/11/2023 12:22: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 ( '88969' , '21519' , 'SULLA TUA PAROLA - NOV/DIC 23' , '2' , '2' , '4' , '5.00' , '5' , '0' , '40' , '6.0000' ) 15/11/2023 12:22:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21519' AND id_supplier = '38' 15/11/2023 12:22:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21519' , '38' , '1' ) 15/11/2023 12:22: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 ( '88969' , '21778' , 'SULLA TUA PAROLA - GEN/FEB 2024' , '10' , '10' , '4' , '5.00' , '5' , '0' , '40' , '30.0000' ) 15/11/2023 12:22:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21778' AND id_supplier = '38' 15/11/2023 12:22:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21778' , '38' , '1' ) 15/11/2023 12:22: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 ( '88969' , '8250' , 'PREGATE, PREGATE, PREGATE - 8001' , '1' , '1' , '4' , '19.00' , '19' , '0' , '40' , '11.4000' ) 15/11/2023 12:22:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8250' AND id_supplier = '38' 15/11/2023 12:22:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8250' , '38' , '1' ) 15/11/2023 12:22: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 ( '88969' , '8247' , 'PREGATE, PREGATE, PREGATE - 8100' , '3' , '3' , '4' , '10.00' , '10' , '0' , '40' , '18.0000' ) 15/11/2023 12:22:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8247' AND id_supplier = '38' 15/11/2023 12:22:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8247' , '38' , '1' ) 15/11/2023 12:22: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 ( '88969' , '8383' , 'PREGHIERE PER LADORAZIONE EUCARISTICA - 8141' , '1' , '1' , '4' , '12.00' , '12' , '0' , '40' , '7.2000' ) 15/11/2023 12:22:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8383' AND id_supplier = '38' 15/11/2023 12:22:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8383' , '38' , '1' ) 15/11/2023 12:22: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 ( '88969' , '10299' , 'STORIA DI UNANIMA - 8203' , '1' , '1' , '4' , '10.00' , '10' , '0' , '40' , '6.0000' ) 15/11/2023 12:22:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '10299' AND id_supplier = '38' 15/11/2023 12:22:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10299' , '38' , '1' ) 15/11/2023 12:22: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 ( '88969' , '4310' , 'FRATICELLO CHE GIOCAVA CON DIO - S. GERARDO - 8328' , '1' , '1' , '4' , '7.00' , '7' , '0' , '40' , '4.2000' ) 15/11/2023 12:22:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4310' AND id_supplier = '38' 15/11/2023 12:22:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4310' , '38' , '1' ) 15/11/2023 12:22:34 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 ( '88969' , '8219' , 'PRATICA DI AMAR GESÙ CRISTO - 8464' , '1' , '1' , '4' , '9.00' , '9' , '0' , '40' , '5.4000' ) 15/11/2023 12:22:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8219' AND id_supplier = '38' 15/11/2023 12:22:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8219' , '38' , '1' ) 15/11/2023 12:22:34 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 ( '88969' , '21837' , 'CAMMINO DELLA PREGHIERA - P. SCIADINI - 8484' , '1' , '1' , '4' , '7.00' , '7' , '0' , '40' , '4.2000' ) 15/11/2023 12:22:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21837' AND id_supplier = '38' 15/11/2023 12:22:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21837' , '38' , '1' ) 15/11/2023 12:22:34 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 ( '88969' , '11223' , 'VERGINE DI GUADALUPE - 8590' , '1' , '1' , '4' , '12.00' , '12' , '0' , '40' , '7.2000' ) 15/11/2023 12:22:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11223' AND id_supplier = '38' 15/11/2023 12:22:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11223' , '38' , '1' ) 15/11/2023 12:22:34 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 ( '88969' , '21838' , 'CARTOLINA CARLO ACUTIS' , '50' , '50' , '1' , '0.12295' , '0.10077868852459' , '22' , '40' , '4.5000' ) 15/11/2023 12:22:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21838' AND id_supplier = '38' 15/11/2023 12:22:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21838' , '38' , '1' ) 15/11/2023 12:22:34 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 ( '88969' , '21652' , 'AGENDA LITURGICO PASTORALE 2024' , '1' , '1' , '1' , '9.84' , '8.0655737704918' , '22' , '40' , '7.2029' ) 15/11/2023 12:22:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21652' AND id_supplier = '38' 15/11/2023 12:22:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21652' , '38' , '1' ) 15/11/2023 12:22:34 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 ( '88969' , '21653' , 'AGENDA DEVOZIONALE 2024' , '2' , '2' , '1' , '8.2' , '6.7213114754098' , '22' , '40' , '12.0048' ) 15/11/2023 12:22:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21653' AND id_supplier = '38' 15/11/2023 12:22:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21653' , '38' , '1' ) 15/11/2023 12:23:37 pm >> SELECT document_num FROM ps_document WHERE document_num = '52/E' AND id_document != '88683' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-11-02') 15/11/2023 12:23:37 pm >> UPDATE ps_document SET id_document_type = '23', document_num = '52/E', document_date = '2023-11-02', document_letter = 'E', id_customer = '189', id_supplier = '', id_address = '4679063', address1 = 'VIA NAZIONALE APPIA, 128 81022 CASAGIOVE', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '98.00', price_tax_excluded = '98.00', date_upd = NOW() WHERE id_document = '88683' 15/11/2023 12:23:37 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 = '88683' 15/11/2023 12:23:37 pm >> DELETE FROM ps_document_detail WHERE id_document = '88683' 15/11/2023 12:23:37 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 ( '88683' , '8408' , 'PRENDETE E MANGIATE' , '50' , '-50' , '4' , '3.0000' , '3' , '0' , '38' , '93.00' ) 15/11/2023 12:23:37 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 ( '88683' , '10133' , 'SPESE DI TRASPORTO' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '0' , '5.00' ) 15/11/2023 12:41:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '90/A' AND id_document != '87306' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-09-15') 15/11/2023 12:41:04 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '90/A', document_date = '2023-09-15', document_letter = 'A', id_customer = '371', id_supplier = '', id_address = '4670910', address1 = 'VIA PIAVE, 4 84080 CASTEL SAN GIORGIO', 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 = '142.00', price_tax_excluded = '126.22', date_upd = NOW() WHERE id_document = '87306' 15/11/2023 12:41:04 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 = '87306' 15/11/2023 12:41:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '87306' 15/11/2023 12:41:04 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 ( '87306' , '941' , 'BAMBINO CM 5 - CARNE - PX' , '250' , '-250' , '1' , '0.3500' , '0.28688524590164' , '22' , '0' , '87.50' ) 15/11/2023 12:41:04 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 ( '87306' , '17229' , 'FELICI SUI PASSI DI GESU - 5 - SUSSIDIO' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 15/11/2023 12:41:04 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 ( '87306' , '18564' , 'CONNESSI CON GESU’ - AGENDUM 2' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 15/11/2023 12:41:04 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 ( '87306' , '18565' , 'CONNESSI CON GESU - GUIDA 6' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '5' , '14.25' ) 15/11/2023 12:41:04 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 ( '87306' , '4120' , 'FEDE NELLO ZAINETTO' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '5' , '5.70' ) 15/11/2023 12:41:04 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 ( '87306' , '17230' , 'FELICI SUI PASSI DI GESU - 5 - GUIDA' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '5' , '14.25' ) 15/11/2023 12:41:04 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 ( '87306' , '8601' , 'SARETE MIEI TESTIMONI 2 - MAGNIFICAT' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '5' , '2.85' ) 15/11/2023 12:41:04 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 ( '87306' , '8600' , 'SARETE MIEI TESTIMONI 1 - MAGNIFICAT' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '5' , '2.85' ) 15/11/2023 12:41:04 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 ( '87306' , '2680' , 'CONOSCERE GESU\' - GUIDA' , '1' , '-1' , '4' , '6.00' , '6' , '0' , '15' , '5.10' ) 15/11/2023 12:41:57 pm >> SELECT document_num FROM ps_document WHERE document_num = '90/A' AND id_document != '87306' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-09-15') 15/11/2023 12:41:58 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '90/A', document_date = '2023-09-15', document_letter = 'A', id_customer = '371', id_supplier = '', id_address = '4670910', address1 = 'VIA PIAVE, 4 84080 CASTEL SAN GIORGIO', 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 = '145.50', price_tax_excluded = '129.72', date_upd = NOW() WHERE id_document = '87306' 15/11/2023 12:41: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 = '87306' 15/11/2023 12:41:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '87306' 15/11/2023 12:41: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 ( '87306' , '941' , 'BAMBINO CM 5 - CARNE - PX' , '250' , '-250' , '1' , '0.3500' , '0.28688524590164' , '22' , '0' , '87.50' ) 15/11/2023 12:41: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 ( '87306' , '17229' , 'FELICI SUI PASSI DI GESU - 5 - SUSSIDIO' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '' , '5.00' ) 15/11/2023 12:41: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 ( '87306' , '18564' , 'CONNESSI CON GESU’ - AGENDUM 2' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '' , '5.00' ) 15/11/2023 12:41: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 ( '87306' , '18565' , 'CONNESSI CON GESU - GUIDA 6' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '' , '15.00' ) 15/11/2023 12:41: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 ( '87306' , '4120' , 'FEDE NELLO ZAINETTO' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '' , '6.00' ) 15/11/2023 12:41: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 ( '87306' , '17230' , 'FELICI SUI PASSI DI GESU - 5 - GUIDA' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '' , '15.00' ) 15/11/2023 12:41: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 ( '87306' , '8601' , 'SARETE MIEI TESTIMONI 2 - MAGNIFICAT' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '' , '3.00' ) 15/11/2023 12:41: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 ( '87306' , '8600' , 'SARETE MIEI TESTIMONI 1 - MAGNIFICAT' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '' , '3.00' ) 15/11/2023 12:41: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 ( '87306' , '2680' , 'CONOSCERE GESU\' - GUIDA' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '' , '6.00' ) 15/11/2023 12:46:43 pm >> DELETE FROM ps_document WHERE id_document = '87306' 15/11/2023 12:46:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '87306' 15/11/2023 12:47:38 pm >> SELECT document_num FROM ps_document WHERE document_num = '3580' AND id_document != '88918' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-13') 15/11/2023 12:47:38 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3580', document_date = '2023-11-13', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', 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 = '172.65', price_tax_excluded = '145.89', date_upd = NOW() WHERE id_document = '88918' 15/11/2023 12:47:38 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 = '88918' 15/11/2023 12:47:38 pm >> DELETE FROM ps_document_detail WHERE id_document = '88918' 15/11/2023 12:47:38 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 ( '88918' , '12527' , 'LAMPADA A SFERA VIOLA' , '2' , '-2' , '1' , '20.0000' , '16.393442622951' , '22' , '0' , '40.00' ) 15/11/2023 12:47:38 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 ( '88918' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '65.9000' , '54.016393442623' , '22' , '0' , '65.90' ) 15/11/2023 12:47:38 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 ( '88918' , '19107' , 'INCENSO GRANI 3A - BUSTA' , '1' , '-1' , '1' , '30.0000' , '24.590163934426' , '22' , '0' , '30.00' ) 15/11/2023 12:47:38 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 ( '88918' , '21467' , 'ADOLESCENTI INAFFERRABILI - BOTTA / LONARDO' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '5' , '14.25' ) 15/11/2023 12:47:38 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 ( '88918' , '16243' , 'QUADRO 10X10' , '1' , '-1' , '1' , '12.5000' , '10.245901639344' , '22' , '0' , '12.50' ) 15/11/2023 12:47:38 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 ( '88918' , '17229' , 'FELICI SUI PASSI DI GESU - 5 - SUSSIDIO' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '0' , '5.00' ) 15/11/2023 12:47:38 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 ( '88918' , '18564' , 'CONNESSI CON GESU’ - AGENDUM 2' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '0' , '5.00' ) 15/11/2023 12:48:10 pm >> SELECT document_num FROM ps_document WHERE document_num = '3569' AND id_document != '88904' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-11') 15/11/2023 12:48:10 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3569', document_date = '2023-11-11', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', 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 = '15.00', price_tax_excluded = '15.00', date_upd = NOW() WHERE id_document = '88904' 15/11/2023 12:48:10 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 = '88904' 15/11/2023 12:48:10 pm >> DELETE FROM ps_document_detail WHERE id_document = '88904' 15/11/2023 12:48:10 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 ( '88904' , '18565' , 'CONNESSI CON GESU - GUIDA 6' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '0' , '15.00' ) 15/11/2023 12:49:13 pm >> SELECT document_num FROM ps_document WHERE document_num = '3603' AND id_document != '88948' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-14') 15/11/2023 12:49:13 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3603', document_date = '2023-11-14', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', 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 = '54.00', price_tax_excluded = '47.51', date_upd = NOW() WHERE id_document = '88948' 15/11/2023 12:49: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 = '88948' 15/11/2023 12:49:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '88948' 15/11/2023 12:49: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 ( '88948' , '12202' , 'VETRO ANTIVENTO PER F. CAND. DIAM. 4 - 73/40' , '2' , '-2' , '1' , '18.0000' , '14.754098360656' , '22' , '0' , '36.00' ) 15/11/2023 12:49: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 ( '88948' , '8601' , 'SARETE MIEI TESTIMONI 2 - MAGNIFICAT' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '0' , '3.00' ) 15/11/2023 12:49: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 ( '88948' , '17230' , 'FELICI SUI PASSI DI GESU - 5 - GUIDA' , '1' , '-1' , '4' , '15' , '15' , '0' , '0' , '15.00' ) 15/11/2023 12:49:32 pm >> SELECT document_num FROM ps_document WHERE document_num = '3523' AND id_document != '88843' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-09') 15/11/2023 12:49:33 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3523', document_date = '2023-11-09', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', 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 = '2.00', price_tax_excluded = '2.00', date_upd = NOW() WHERE id_document = '88843' 15/11/2023 12:49: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 = '88843' 15/11/2023 12:49:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '88843' 15/11/2023 12:49: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 ( '88843' , '8600' , 'SARETE MIEI TESTIMONI 1 - MAGNIFICAT' , '1' , '-1' , '4' , '2' , '2' , '0' , '0' , '2.00' ) 15/11/2023 12:50:16 pm >> SELECT document_num FROM ps_document WHERE document_num = '3407' AND id_document != '88652' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-31') 15/11/2023 12:50:16 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3407', document_date = '2023-10-31', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', 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 = '271.00', price_tax_excluded = '222.13', date_upd = NOW() WHERE id_document = '88652' 15/11/2023 12:50:16 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 = '88652' 15/11/2023 12:50:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '88652' 15/11/2023 12:50:16 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 ( '88652' , '19602' , 'QUADRETTO EFFETTO PIETRA - SACRA FAMIGLIA - 2952' , '2' , '-2' , '1' , '4.0000' , '3.2786885245902' , '22' , '0' , '8.00' ) 15/11/2023 12:50:16 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 ( '88652' , '922' , 'BALZA RICAMATA CM 9,6 - VERDE - KOM/030 - OGGETTI' , '3' , '-3' , '1' , '20.0000' , '16.393442622951' , '22' , '0' , '60.00' ) 15/11/2023 12:50:16 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 ( '88652' , '20466' , 'PIZZO MACRAME CM 10 - P529' , '6' , '-6' , '1' , '30.0000' , '24.590163934426' , '22' , '0' , '171.00' ) 15/11/2023 12:50:16 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 ( '88652' , '941' , 'BAMBINO CM 5 - CARNE - PX' , '100' , '-100' , '1' , '0.32' , '0.26229508196721' , '22' , '0' , '32.00' ) 15/11/2023 12:50:58 pm >> SELECT document_num FROM ps_document WHERE document_num = '3170' AND id_document != '88297' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-14') 15/11/2023 12:50:58 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3170', document_date = '2023-10-14', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', 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.00', price_tax_excluded = '40.16', date_upd = NOW() WHERE id_document = '88297' 15/11/2023 12:50: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 = '88297' 15/11/2023 12:50:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '88297' 15/11/2023 12:50:59 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 ( '88297' , '941' , 'BAMBINO CM 5 - CARNE - PX' , '140' , '-140' , '1' , '0.3500' , '0.28688524590164' , '22' , '0' , '49.00' ) 15/11/2023 12:52:16 pm >> SELECT document_num FROM ps_document WHERE document_num = '3534' AND id_document != '88855' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-09') 15/11/2023 12:52:16 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3534', document_date = '2023-11-09', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', 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 = '132.65', price_tax_excluded = '131.28', date_upd = NOW() WHERE id_document = '88855' 15/11/2023 12:52:16 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 = '88855' 15/11/2023 12:52:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '88855' 15/11/2023 12:52:16 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 ( '88855' , '10965' , 'UNZIONE DEGLI INFERMI E IL VIATICO' , '2' , '-2' , '4' , '2.5000' , '2.5' , '0' , '5' , '4.76' ) 15/11/2023 12:52:16 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 ( '88855' , '12819' , 'REGISTRO DEL CATECHISTA ' , '8' , '-8' , '1' , '1.0000' , '0.81967213114754' , '22' , '5' , '7.60' ) 15/11/2023 12:52:16 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 ( '88855' , '8602' , 'VENITE CON ME 1 - MAGNIFICAT' , '3' , '-3' , '4' , '3.0000' , '3' , '0' , '5' , '8.55' ) 15/11/2023 12:52:16 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 ( '88855' , '8603' , 'VENITE CON ME 2 - MAGNIFICAT' , '10' , '-10' , '4' , '3.0000' , '3' , '0' , '5' , '28.50' ) 15/11/2023 12:52:16 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 ( '88855' , '9680' , 'SARETE MIEI TESTIMONI - GUIDA 1 - MAGNIFICAT' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '5' , '11.40' ) 15/11/2023 12:52:16 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 ( '88855' , '9681' , 'SARETE MIEI TESTIMONI - GUIDA 2 - MAGNIFICAT' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '5' , '11.40' ) 15/11/2023 12:52:16 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 ( '88855' , '5451' , 'IO SONO CON VOI - GUIDA 2 - MAGNIFICAT' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '5' , '11.40' ) 15/11/2023 12:52:16 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 ( '88855' , '5450' , 'IO SONO CON VOI - GUIDA 1 - MAGNIFICAT' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '5' , '11.40' ) 15/11/2023 12:52:16 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 ( '88855' , '11188' , 'VENITE CON ME - GUIDA 2 - MAGNIFICAT' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '5' , '11.40' ) 15/11/2023 12:52:16 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 ( '88855' , '11187' , 'VENITE CON ME - GUIDA 1 - MAGNIFICAT' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '5' , '11.40' ) 15/11/2023 12:52:16 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 ( '88855' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '3.44' , '3.44' , '0' , '0' , '3.44' ) 15/11/2023 12:52:16 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 ( '88855' , '11281' , 'VI PARLO DI ME - S. GEMMA GALGANI - 8581' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 15/11/2023 03:18:11 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 15/11/2023 03:18:11 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21839' , '1' , '' , 'nuovo-prodotto' ) 15/11/2023 03:18:12 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '21839' , '1' , '1' , '2' , NOW() , NOW() ) 15/11/2023 03:18:12 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '21839' , '0' , '1' , '0' , '0' ) 15/11/2023 03:21:22 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002004' AND id_product != '21839' AND ean13 != '' 15/11/2023 03:21:41 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002204' AND id_product != '21839' AND ean13 != '' 15/11/2023 03:21:41 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002204', date_upd = NOW() WHERE id_product = '21839' 15/11/2023 03:21:41 pm >> UPDATE ps_product_lang SET name = 'NATIVITA\' IN RESINA CM 8 - P725', description = '' WHERE id_product = '21839' 15/11/2023 03:21:41 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3.8524590163934427' WHERE id_product = '21839' 15/11/2023 03:21:41 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3.8524590163934427', id_tax_rules_group = '1', id_category_default = '95', 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 = '21839' 15/11/2023 03:21:41 pm >> DELETE FROM ps_specific_price WHERE id_product = '21839' 15/11/2023 03:22:23 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002204' AND id_product != '21839' AND ean13 != '' 15/11/2023 03:22:23 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002204', date_upd = NOW() WHERE id_product = '21839' 15/11/2023 03:22:23 pm >> UPDATE ps_product_lang SET name = 'NATIVITA\' IN RESINA CM 8 - P725', description = '' WHERE id_product = '21839' 15/11/2023 03:22:23 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3.8524590163934427' WHERE id_product = '21839' 15/11/2023 03:22:23 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3.8524590163934427', id_tax_rules_group = '1', id_category_default = '95', 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 = '21839' 15/11/2023 03:22:23 pm >> DELETE FROM ps_specific_price WHERE id_product = '21839' 15/11/2023 03:23:45 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 15/11/2023 03:23:45 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21840' , '1' , '' , 'nuovo-prodotto' ) 15/11/2023 03:23:45 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '21840' , '1' , '1' , '2' , NOW() , NOW() ) 15/11/2023 03:23:45 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '21840' , '0' , '1' , '0' , '0' ) 15/11/2023 03:27:18 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002205' AND id_product != '21840' AND ean13 != '' 15/11/2023 03:27:18 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002205', date_upd = NOW() WHERE id_product = '21840' 15/11/2023 03:27:18 pm >> UPDATE ps_product_lang SET name = 'TAVOLA IN LEGNO 20X25 - 1223', description = '' WHERE id_product = '21840' 15/11/2023 03:27:18 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '10.655737704918034' WHERE id_product = '21840' 15/11/2023 03:27:18 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '10.655737704918034', id_tax_rules_group = '1', id_category_default = '2', id_argoment_default = '', id_internal_category = '', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21840' 15/11/2023 03:27:18 pm >> DELETE FROM ps_specific_price WHERE id_product = '21840' 15/11/2023 03:27:30 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002205' AND id_product != '21840' AND ean13 != '' 15/11/2023 03:27:30 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002205', date_upd = NOW() WHERE id_product = '21840' 15/11/2023 03:27:30 pm >> UPDATE ps_product_lang SET name = 'TAVOLA IN LEGNO 20X25 - 1223', description = '' WHERE id_product = '21840' 15/11/2023 03:27:30 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '10.655737704918034' WHERE id_product = '21840' 15/11/2023 03:27:30 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '10.655737704918034', id_tax_rules_group = '1', id_category_default = '95', 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 = '21840' 15/11/2023 03:27:30 pm >> DELETE FROM ps_specific_price WHERE id_product = '21840' 15/11/2023 03:27:35 pm >> 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 = '21840' 15/11/2023 03:27:35 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21841' , '1' , '' , 'nuovo-prodotto' ) 15/11/2023 03:27:35 pm >> 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 '21841' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21840' 15/11/2023 03:27:35 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21841' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21840' 15/11/2023 03:28:29 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '202206' AND id_product != '4889' AND ean13 != '' 15/11/2023 03:28:29 pm >> UPDATE ps_product SET id_supplier = '28', reference = '2014', ean13 = '202206', date_upd = NOW() WHERE id_product = '4889' 15/11/2023 03:28:29 pm >> UPDATE ps_product_lang SET name = 'ICONA LEGNO 30X40 - 1224', description = '' WHERE id_product = '4889' 15/11/2023 03:28:29 pm >> UPDATE ps_product SET wholesale_price = '9.19', on_sale = '0', price = '22.13114754098361' WHERE id_product = '4889' 15/11/2023 03:28:29 pm >> UPDATE ps_product_shop SET wholesale_price = '9.19', price = '22.13114754098361', id_tax_rules_group = '1', id_category_default = '95', 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 = '4889' 15/11/2023 03:28:29 pm >> DELETE FROM ps_specific_price WHERE id_product = '4889' 15/11/2023 03:36:52 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000623' AND id_product != '4887' AND ean13 != '' 15/11/2023 03:36:52 pm >> UPDATE ps_product SET id_supplier = '', reference = '2014', ean13 = '000623', date_upd = NOW() WHERE id_product = '4887' 15/11/2023 03:36:52 pm >> UPDATE ps_product_lang SET name = 'ICONA LEGNO 10X15 - 1222 ', description = '' WHERE id_product = '4887' 15/11/2023 03:36:52 pm >> UPDATE ps_product SET wholesale_price = '1.40', on_sale = '0', price = '2.8689' WHERE id_product = '4887' 15/11/2023 03:36:52 pm >> UPDATE ps_product_shop SET wholesale_price = '1.40', price = '2.8689', id_tax_rules_group = '1', id_category_default = '95', 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 = '4887' 15/11/2023 03:36:52 pm >> DELETE FROM ps_specific_price WHERE id_product = '4887' 15/11/2023 03:42:20 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002207' AND id_product != '21841' AND ean13 != '' 15/11/2023 03:42:20 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002207', date_upd = NOW() WHERE id_product = '21841' 15/11/2023 03:42:20 pm >> UPDATE ps_product_lang SET name = 'QUADRETTO SMUSSATO - 1269', description = '' WHERE id_product = '21841' 15/11/2023 03:42:20 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '2.0491803278688523' WHERE id_product = '21841' 15/11/2023 03:42:20 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '2.0491803278688523', id_tax_rules_group = '1', id_category_default = '95', 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 = '21841' 15/11/2023 03:42:20 pm >> DELETE FROM ps_specific_price WHERE id_product = '21841' 15/11/2023 03:42:21 pm >> 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 = '21841' 15/11/2023 03:42:21 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21842' , '1' , '' , 'nuovo-prodotto' ) 15/11/2023 03:42:21 pm >> 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 '21842' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21841' 15/11/2023 03:42:21 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21842' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21841' 15/11/2023 03:42: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' , 'A4493' , '2023-11-15' , '' , '0' , '28' , '2623' , 'VIA DEI MILLE 59 80121 NAPOLI' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '517.56' , '424.23' , NOW() , NOW() ) 15/11/2023 03:42: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 = '88970' 15/11/2023 03:42:41 pm >> DELETE FROM ps_document_detail WHERE id_document = '88970' 15/11/2023 03:42: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 ( '88970' , '19602' , 'QUADRETTO EFFETTO PIETRA - SACRA FAMIGLIA - 2952' , '10' , '10' , '1' , '1.61' , '1.3196721311475' , '22' , '0' , '19.6420' ) 15/11/2023 03:42:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19602' AND id_supplier = '28' 15/11/2023 03:42:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19602' , '28' , '1' ) 15/11/2023 03:42: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 ( '88970' , '4889' , 'ICONA LEGNO 30X40 - 1224' , '1' , '1' , '1' , '9.65' , '7.9098360655738' , '22' , '0' , '11.7730' ) 15/11/2023 03:42:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4889' AND id_supplier = '28' 15/11/2023 03:42:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4889' , '28' , '1' ) 15/11/2023 03:42: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 ( '88970' , '21840' , 'TAVOLA IN LEGNO 20X25 - 1223' , '4' , '4' , '1' , '4.77' , '3.9098360655738' , '22' , '0' , '23.2776' ) 15/11/2023 03:42:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21840' AND id_supplier = '28' 15/11/2023 03:42:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21840' , '28' , '1' ) 15/11/2023 03:42: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 ( '88970' , '939' , 'BAMBINO CM 4 - CARNE - P1' , '1000' , '1000' , '1' , '0.12' , '0.098360655737705' , '22' , '0' , '146.4000' ) 15/11/2023 03:42:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '939' AND id_supplier = '28' 15/11/2023 03:42:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '939' , '28' , '1' ) 15/11/2023 03:42: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 ( '88970' , '940' , 'BAMBINO CM 4 - FOSFORO - P1' , '500' , '500' , '1' , '0.12' , '0.098360655737705' , '22' , '0' , '73.2000' ) 15/11/2023 03:42:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '940' AND id_supplier = '28' 15/11/2023 03:42:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '940' , '28' , '1' ) 15/11/2023 03:42: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 ( '88970' , '941' , 'BAMBINO CM 5 - CARNE - PX' , '300' , '300' , '1' , '0.17' , '0.13934426229508' , '22' , '0' , '62.2200' ) 15/11/2023 03:42:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '941' AND id_supplier = '28' 15/11/2023 03:42:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '941' , '28' , '1' ) 15/11/2023 03:42: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 ( '88970' , '21558' , 'ANELLO DECINA ARG - M043' , '3' , '3' , '1' , '4.55' , '3.7295081967213' , '22' , '0' , '16.6530' ) 15/11/2023 03:42:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21558' AND id_supplier = '28' 15/11/2023 03:42:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21558' , '28' , '1' ) 15/11/2023 03:42: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 ( '88970' , '21839' , 'NATIVITA\' IN RESINA CM 8 - P725' , '60' , '60' , '1' , '1.73' , '1.4180327868852' , '22' , '0' , '126.6360' ) 15/11/2023 03:42:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21839' AND id_supplier = '28' 15/11/2023 03:42:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21839' , '28' , '1' ) 15/11/2023 03:42: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 ( '88970' , '4887' , 'ICONA LEGNO 10X15 - 1222 ' , '5' , '5' , '1' , '1.59' , '1.3032786885246' , '22' , '0' , '9.6990' ) 15/11/2023 03:42:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4887' AND id_supplier = '28' 15/11/2023 03:42:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4887' , '28' , '1' ) 15/11/2023 03:42: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 ( '88970' , '21841' , 'QUADRETTO SMUSSATO - 1269' , '25' , '25' , '1' , '0.92' , '0.75409836065574' , '22' , '0' , '28.0600' ) 15/11/2023 03:42:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21841' AND id_supplier = '28' 15/11/2023 03:42:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21841' , '28' , '1' ) 15/11/2023 04:34:40 pm >> SELECT document_num FROM ps_document WHERE document_num = '48' AND id_document != '' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2023-11-15') 15/11/2023 04:34:40 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' , '48' , '2023-11-15' , '' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , 'EDIZIONI' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3465.00' , '3465.00' , NOW() , NOW() ) 15/11/2023 04:34:40 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 = '88971' 15/11/2023 04:34:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '88971' 15/11/2023 04:34:40 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 ( '88971' , '2679' , 'CONOSCERE GESU\'' , '640' , '-640' , '4' , '3.50' , '3.5' , '0' , '0' , '2240.00' ) 15/11/2023 04:34:40 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 ( '88971' , '12842' , 'RICEVI IL SIGILLO DELLO SPIRITO SANTO' , '50' , '-50' , '4' , '6.00' , '6' , '0' , '0' , '300.00' ) 15/11/2023 04:34:40 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 ( '88971' , '21417' , 'VIENI, NON TARDARE SIGNORE, NOSTRA PACE!' , '175' , '-175' , '4' , '2.50' , '2.5' , '0' , '0' , '437.50' ) 15/11/2023 04:34:40 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 ( '88971' , '21418' , 'CRISTO NOSTRA PACE - V. SALVORDI' , '75' , '-75' , '4' , '2.50' , '2.5' , '0' , '0' , '187.50' ) 15/11/2023 04:34:40 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 ( '88971' , '5644' , 'LEGGERE,... LA PAROLA - ANNO B' , '30' , '-30' , '4' , '10.00' , '10' , '0' , '0' , '300.00' ) 15/11/2023 04:35:29 pm >> SELECT document_num FROM ps_document WHERE document_num = '19' AND id_document != '' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2023-11-15') 15/11/2023 04:35:29 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' , '19' , '2023-11-15' , '' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1460.00' , '1460.00' , NOW() , NOW() ) 15/11/2023 04:35:29 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 = '13240' 15/11/2023 04:35:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '13240' 15/11/2023 04:35:29 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 ( '13240' , '138' , 'LA NASCITA DI GESU\'' , '200' , '-200' , '4' , '2.50' , '2.5' , '0' , '0' , '500.00' ) 15/11/2023 04:35:29 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 ( '13240' , '17' , 'LA FEDE NELLO ZAINETTO' , '160' , '-160' , '4' , '6.00' , '6' , '0' , '0' , '960.00' ) 15/11/2023 04:36:32 pm >> SELECT document_num FROM ps_document WHERE document_num = '49' AND id_document != '' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2023-11-15') 15/11/2023 04:36:32 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' , '49' , '2023-11-15' , '' , '540' , '0' , '4673023' , 'CORSO GARIBALDI, 6 84025 EBOLI' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '580.00' , '475.41' , NOW() , NOW() ) 15/11/2023 04:36:32 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 = '88972' 15/11/2023 04:36:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '88972' 15/11/2023 04:36:32 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 ( '88972' , '20481' , 'NATIVITA\' 50CM - PB8940 + PB8942' , '1' , '-1' , '1' , '580' , '475.40983606557' , '22' , '0' , '580.00' ) 15/11/2023 04:38:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '49' AND id_document != '88972' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2023-11-15') 15/11/2023 04:38:15 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '49', document_date = '2023-11-15', document_letter = '', id_customer = '540', id_supplier = '', id_address = '4673023', address1 = 'CORSO GARIBALDI, 6 84025 EBOLI', 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 = '550.00', price_tax_excluded = '450.82', date_upd = NOW() WHERE id_document = '88972' 15/11/2023 04:38:15 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 = '88972' 15/11/2023 04:38:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '88972' 15/11/2023 04:38:15 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 ( '88972' , '20481' , 'NATIVITA\' 50CM - PB8940 + PB8942' , '1' , '-1' , '1' , '550' , '450.81967213115' , '22' , '0' , '550.00' ) 15/11/2023 04:42:13 pm >> SELECT document_num FROM ps_document WHERE document_num = '3616' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-15') 15/11/2023 04:42: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' , '3616' , '2023-11-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '20.00' , '19.23' , NOW() , NOW() ) 15/11/2023 04:42: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 = '88973' 15/11/2023 04:42:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '88973' 15/11/2023 04:42: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 ( '88973' , '20429' , 'OSTIA SENZA TOSTATURA MORREALE - OS25' , '10' , '-10' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '20.00' ) 15/11/2023 04:46:05 pm >> SELECT ean13 FROM ps_product WHERE ean13 = 'PB8942' AND id_product != '21842' AND ean13 != '' 15/11/2023 04:46:06 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = 'PB8942', date_upd = NOW() WHERE id_product = '21842' 15/11/2023 04:46:06 pm >> UPDATE ps_product_lang SET name = 'NATIVITA\' CM 50', description = '' WHERE id_product = '21842' 15/11/2023 04:46:06 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '244.2622950819672' WHERE id_product = '21842' 15/11/2023 04:46:06 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '244.2622950819672', id_tax_rules_group = '1', id_category_default = '458', 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 = '21842' 15/11/2023 04:46:06 pm >> DELETE FROM ps_specific_price WHERE id_product = '21842' 15/11/2023 04:46:51 pm >> UPDATE ps_document SET id_document_type = '31', document_num = '5961', document_date = '2022-11-29', document_letter = '', id_customer = '0', id_supplier = '', id_address = '4670785', address1 = 'VIA ROMA 44 00053 CIVITAVECCHIA', address2 = '', note = '', price_shipping = '22.87', id_tax_shipping_rules = '1', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '9', id_causal = '0', price_tax_included = '958.13', price_tax_excluded = '785.35', date_upd = NOW() WHERE id_document = '75513' 15/11/2023 04:46:51 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 = '75513' 15/11/2023 04:46:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '75513' 15/11/2023 04:46:51 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 ( '75513' , '20481' , 'NATIVITA 50CM - PB8940 + PB8942' , '1' , '1' , '1' , '149' , '122.13114754098' , '22' , '20+5' , '138.1528' ) 15/11/2023 04:46:51 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 ( '75513' , '20482' , 'NATIVITA 56CM - PB13874 + PB13875' , '1' , '1' , '1' , '273.0000' , '223.77049180328' , '22' , '20+5' , '253.13' ) 15/11/2023 04:46:51 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 ( '75513' , '20483' , 'NATIVITA 43CM - 11 PEZZI - PB0494' , '1' , '1' , '1' , '248.0000' , '203.27868852459' , '22' , '20+5' , '229.95' ) 15/11/2023 04:46:51 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 ( '75513' , '20484' , 'PRESEPE GROTTA - PB18540' , '2' , '2' , '1' , '78.5000' , '64.344262295082' , '22' , '20+5' , '145.57' ) 15/11/2023 04:46:51 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 ( '75513' , '20485' , 'NATIVITA MADONNA SDRAIATA - PB18139' , '1' , '1' , '1' , '21.8000' , '17.868852459016' , '22' , '5' , '25.27' ) 15/11/2023 04:46:52 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 ( '75513' , '21842' , 'NATIVITA CM 50' , '1' , '1' , '1' , '149' , '122.13114754098' , '22' , '20+5' , '138.1528' ) 15/11/2023 04:47:17 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002077' AND id_product != '20481' AND ean13 != '' 15/11/2023 04:47:17 pm >> UPDATE ps_product SET id_supplier = '134', reference = '', ean13 = '002077', date_upd = NOW() WHERE id_product = '20481' 15/11/2023 04:47:17 pm >> UPDATE ps_product_lang SET name = 'NATIVITA\' 50CM - PB8940 + PB8942', description = '
DA ORDINARE PB8941 BUE ASINO
' WHERE id_product = '20481' 15/11/2023 04:47:17 pm >> UPDATE ps_product SET wholesale_price = '238.40', on_sale = '0', price = '245.9016393442623' WHERE id_product = '20481' 15/11/2023 04:47:17 pm >> UPDATE ps_product_shop SET wholesale_price = '238.40', price = '245.9016393442623', id_tax_rules_group = '1', id_category_default = '458', 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 = '20481' 15/11/2023 04:47:17 pm >> DELETE FROM ps_specific_price WHERE id_product = '20481' 15/11/2023 04:47:54 pm >> SELECT document_num FROM ps_document WHERE document_num = '2336' AND id_document != '86689' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-07-08') 15/11/2023 04:47:54 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2336', document_date = '2023-07-08', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', 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 = '298.00', price_tax_excluded = '245.70', date_upd = NOW() WHERE id_document = '86689' 15/11/2023 04:47:54 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 = '86689' 15/11/2023 04:47:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '86689' 15/11/2023 04:47:54 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 ( '86689' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '1' , '-1' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '3.50' ) 15/11/2023 04:47:54 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 ( '86689' , '20429' , 'OSTIA SENZA TOSTATURA MORREALE - OS25' , '3' , '-3' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '6.00' ) 15/11/2023 04:47:54 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 ( '86689' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '8.0000' , '6.5573770491803' , '22' , '0' , '48.00' ) 15/11/2023 04:47:54 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 ( '86689' , '21196' , 'CALENDARIO LITURGICO 2024' , '1' , '-1' , '4' , '0.5000' , '0.5' , '0' , '0' , '0.50' ) 15/11/2023 04:47:54 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 ( '86689' , '20481' , 'NATIVITA\' 50CM - PB8940 + PB8942' , '1' , '-1' , '1' , '240' , '196.72131147541' , '22' , '0' , '240.00' ) 15/11/2023 04:48:48 pm >> SELECT document_num FROM ps_document WHERE document_num = '2108' AND id_document != '86416' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-19') 15/11/2023 04:48:48 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2108', document_date = '2023-06-19', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', 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 = '197.08', price_tax_excluded = '166.42', date_upd = NOW() WHERE id_document = '86416' 15/11/2023 04:48:48 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 = '86416' 15/11/2023 04:48:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '86416' 15/11/2023 04:48:48 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 ( '86416' , '15746' , 'ADORIAMO IL SS SACRAMENTO - VOL 1 - 8958' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '5' , '2.85' ) 15/11/2023 04:48:48 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 ( '86416' , '17626' , 'ADORIAMO IL SS SACRAMENTO - QUARESIMA - 8202' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '5' , '2.85' ) 15/11/2023 04:48:48 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 ( '86416' , '17629' , 'ADORIAMO IL SS SACRAMENTO - PASQUA - 8207' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '5' , '2.85' ) 15/11/2023 04:48:48 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 ( '86416' , '17624' , 'ADORIAMO IL SS SACRAMENTO - AVVENTO E NATALE' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '5' , '2.85' ) 15/11/2023 04:48:48 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 ( '86416' , '8383' , 'PREGHIERE PER LADORAZIONE EUCARISTICA - 8141' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '5' , '11.40' ) 15/11/2023 04:48:48 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 ( '86416' , '5251' , 'INCONTRI EUCARISTICI' , '1' , '-1' , '4' , '4.5000' , '4.5' , '0' , '5' , '4.28' ) 15/11/2023 04:48:48 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 ( '86416' , '21842' , 'NATIVITA CM 50' , '1' , '-1' , '1' , '170' , '139.34426229508' , '22' , '0' , '170.00' ) 15/11/2023 04:49:00 pm >> DELETE FROM ps_document WHERE id_document = '88972' 15/11/2023 04:49:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '88972' 15/11/2023 05:06:04 pm >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'SYPdzlgspua1hK7L' , NOW() , NOW() ) 15/11/2023 05:06:04 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4056' , '1' ) 15/11/2023 05:06:04 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4056' , '2' ) 15/11/2023 05:06:04 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4056' , '3' ) 15/11/2023 05:07:15 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4056' 15/11/2023 05:07:15 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 ( '4056' , '10' , '139' , '' , 'LANDRINI' , 'GLISENTE' , 'VIA ROMA 8' , '' , '25050' , 'PASPARDO' , '' , '' , '' , '' , '' , NOW() , NOW() ) 15/11/2023 05:07:15 pm >> UPDATE ps_customer SET email = 'glisente@glisente.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4056' 15/11/2023 05:08:08 pm >> SELECT document_num FROM ps_document WHERE document_num = '270' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-11-15') 15/11/2023 05:08:08 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 ( '21' , '270' , '2023-11-15' , '' , '4056' , '0' , '4679190' , 'VIA ROMA 8 25050 PASPARDO' , '' , '' , '5' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '54.88' , '54.88' , NOW() , NOW() ) 15/11/2023 05:08:08 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 = '88974' 15/11/2023 05:08:08 pm >> DELETE FROM ps_document_detail WHERE id_document = '88974' 15/11/2023 05:08:08 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 ( '88974' , '2679' , 'CONOSCERE GESU\'' , '15' , '-15' , '4' , '3.5' , '3.5' , '0' , '5' , '49.88' ) 15/11/2023 05:19:59 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 ( '33' , '235' , '2023-11-15' , '' , '0' , '126' , '4669995' , 'VIA DELLE INDUSTRIE, 75 06083 BASTIA UMBRA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '390.00' , '319.67' , NOW() , NOW() ) 15/11/2023 05:19:59 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 = '88975' 15/11/2023 05:19:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '88975' 15/11/2023 05:19:59 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 ( '88975' , '21424' , 'STOLA ROMANA S. MOIRE - 7248S' , '1' , '1' , '1' , '390.00' , '319.67213114754' , '22' , '0' , '390.00' ) 15/11/2023 05:19:59 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21424' AND id_supplier = '126' 15/11/2023 05:19:59 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21424' , '126' , '1' ) 15/11/2023 05:34:44 pm >> SELECT document_num FROM ps_document WHERE document_num = '3617' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-15') 15/11/2023 05:34:44 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' , '3617' , '2023-11-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '65.00' , '65.00' , NOW() , NOW() ) 15/11/2023 05:34:44 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 = '88976' 15/11/2023 05:34:44 pm >> DELETE FROM ps_document_detail WHERE id_document = '88976' 15/11/2023 05:34:44 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 ( '88976' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '65' , '65' , '0' , '0' , '65.00' ) 15/11/2023 05:46:06 pm >> SELECT document_num FROM ps_document WHERE document_num = '128/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-11-15') 15/11/2023 05:46:06 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' , '128/A' , '2023-11-15' , 'A' , '3544' , '0' , '4674054' , 'VIA SAN MARCO 53 - FRAZ. MONTICELLI 84062 OLEVANO SUL TUSCIANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '68.00' , '68.00' , NOW() , NOW() ) 15/11/2023 05:46:06 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 = '88977' 15/11/2023 05:46:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '88977' 15/11/2023 05:46:06 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 ( '88977' , '17617' , 'IMMAGINI ISONZO X 100' , '4' , '-4' , '0' , '3.5' , '3.5' , '' , '0' , '14.00' ) 15/11/2023 05:46:06 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 ( '88977' , '21838' , 'CARTOLINA CARLO ACUTIS' , '30' , '-30' , '0' , '0.15' , '0.15' , '' , '0' , '4.50' ) 15/11/2023 05:46:06 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 ( '88977' , '20512' , 'ROSARIO BEATO CARLO ACUTIS - 195/51' , '11' , '-11' , '0' , '4.50' , '4.5' , '' , '0' , '49.50' ) 15/11/2023 05:53:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '3618' AND id_document != '' AND id_document_type LIKE '14' AND YEAR(document_date) = YEAR('2023-11-15') 15/11/2023 05:53:15 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' , '3618' , '2023-11-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '260.00' , '213.11' , NOW() , NOW() ) 15/11/2023 05:53:15 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 = '88978' 15/11/2023 05:53:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '88978' 15/11/2023 05:53:15 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 ( '88978' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '260' , '213.11475409836' , '22' , '0' , '260.00' ) 15/11/2023 06:01:42 pm >> SELECT document_num FROM ps_document WHERE document_num = '3619' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-15') 15/11/2023 06:01:42 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' , '3619' , '2023-11-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '38.90' , '35.30' , NOW() , NOW() ) 15/11/2023 06:01:42 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 = '88979' 15/11/2023 06:01:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '88979' 15/11/2023 06:01: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 ( '88979' , '21653' , 'AGENDA DEVOZIONALE 2024' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '5' , '9.50' ) 15/11/2023 06:01: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 ( '88979' , '21778' , 'SULLA TUA PAROLA - GEN/FEB 2024' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 15/11/2023 06:01: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 ( '88979' , '21519' , 'SULLA TUA PAROLA - NOV/DIC 23' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 15/11/2023 06:01: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 ( '88979' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 15/11/2023 06:01: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 ( '88979' , '17711' , 'OSTIA MAGNA CM 18 - OM 180' , '1' , '-1' , '3' , '8.50' , '8.1730769230769' , '4' , '0' , '8.50' ) 15/11/2023 06:01: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 ( '88979' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '1' , '-1' , '1' , '7.90' , '6.4754098360656' , '22' , '0' , '7.90' ) 15/11/2023 06:27:35 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788886616683' AND id_product != '8391' AND ean13 != '' 15/11/2023 06:27:35 pm >> UPDATE ps_product SET id_supplier = '38', reference = 'ESPOSITORE SHALOM', ean13 = '9788886616683', date_upd = NOW() WHERE id_product = '8391' 15/11/2023 06:27:35 pm >> UPDATE ps_product_lang SET name = 'PREGHIERE GUARIGIONE LIBERAZIONE CONSOLAZIONE - 8169', description = '' WHERE id_product = '8391' 15/11/2023 06:27:35 pm >> UPDATE ps_product SET wholesale_price = '6.00', on_sale = '0', price = '12' WHERE id_product = '8391' 15/11/2023 06:27:35 pm >> UPDATE ps_product_shop SET wholesale_price = '6.00', price = '12', id_tax_rules_group = '4', id_category_default = '106', 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 = '8391' 15/11/2023 06:27:35 pm >> DELETE FROM ps_specific_price WHERE id_product = '8391' 15/11/2023 06:35:30 pm >> SELECT document_num FROM ps_document WHERE document_num = '129/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-11-15') 15/11/2023 06:35: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 ( '24' , '129/A' , '2023-11-15' , 'A' , '2757' , '0' , '4671725' , 'VIA CIRILLO 84085 MERCATO SAN SEVERINO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '63.46' , '63.46' , NOW() , NOW() ) 15/11/2023 06:35: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 = '88980' 15/11/2023 06:35:30 pm >> DELETE FROM ps_document_detail WHERE id_document = '88980' 15/11/2023 06:35: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 ( '88980' , '18704' , 'IN_SEGUENDO GESU A NAZARET' , '6' , '-6' , '4' , '5.00' , '5' , '0' , '5' , '28.50' ) 15/11/2023 06:35: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 ( '88980' , '18691' , 'IN_SEGUENDO GESU a emmaus - QUADERNO' , '6' , '-6' , '4' , '5.00' , '5' , '0' , '5' , '28.50' ) 15/11/2023 06:35: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 ( '88980' , '8510' , 'PRIMI PASSI CON GESÙ - ANNO B' , '2' , '-2' , '4' , '3.40' , '3.4' , '0' , '5' , '6.46' ) 15/11/2023 06:51:28 pm >> SELECT document_num FROM ps_document WHERE document_num = '3620' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-15') 15/11/2023 06:51:28 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' , '3620' , '2023-11-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.00' , '8.20' , NOW() , NOW() ) 15/11/2023 06:51:28 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 = '88981' 15/11/2023 06:51:28 pm >> DELETE FROM ps_document_detail WHERE id_document = '88981' 15/11/2023 06:51:28 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 ( '88981' , '15007' , 'PRESEPE LEGNO CON LUCI CM 20 - 31130' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 15/11/2023 07:53:51 pm >> SELECT document_num FROM ps_document WHERE document_num = '3621' AND id_document != '' AND id_document_type LIKE '12' AND YEAR(document_date) = YEAR('2023-11-15') 15/11/2023 07:53:51 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' , '3621' , '2023-11-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '53.00' , '50.96' , NOW() , NOW() ) 15/11/2023 07:53:51 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 = '88982' 15/11/2023 07:53:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '88982' 15/11/2023 07:53:51 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 ( '88982' , '20431' , 'PARTICOLA TAGLIO CHIUSO 35MM - W500' , '10' , '-10' , '3' , '3.30' , '3.1730769230769' , '4' , '0' , '33.00' ) 15/11/2023 07:53:51 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 ( '88982' , '7311' , 'OSTIA SOTTILE 74MM' , '10' , '-10' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '20.00' ) 15/11/2023 07:56:09 pm >> SELECT document_num FROM ps_document WHERE document_num = '3182' AND id_document != '88321' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-16') 15/11/2023 07:56:09 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3182', document_date = '2023-10-16', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', 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 = '11.00', price_tax_excluded = '9.38', date_upd = NOW() WHERE id_document = '88321' 15/11/2023 07:56: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 = '88321' 15/11/2023 07:56:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '88321' 15/11/2023 07:56: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 ( '88321' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '0' , '2.00' ) 15/11/2023 07:56: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 ( '88321' , '9113' , 'ROSARIO FRANCESCANO DA COLLO - 2516' , '2' , '-2' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '7.00' ) 15/11/2023 07:56: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 ( '88321' , '14772' , 'BRACCIALE SAN BENEDETTO 4 COLORI - 0818/3' , '1' , '-1' , '1' , '2' , '1.6393442622951' , '22' , '0' , '2.00' ) 15/11/2023 07:56:26 pm >> SELECT document_num FROM ps_document WHERE document_num = '3333' AND id_document != '88544' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-26') 15/11/2023 07:56:26 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3333', document_date = '2023-10-26', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', 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 = '132.80', price_tax_excluded = '123.42', date_upd = NOW() WHERE id_document = '88544' 15/11/2023 07:56:26 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 = '88544' 15/11/2023 07:56:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '88544' 15/11/2023 07:56:26 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 ( '88544' , '9113' , 'ROSARIO FRANCESCANO DA COLLO - 2516' , '1' , '-1' , '1' , '2.3' , '1.8852459016393' , '22' , '0' , '2.30' ) 15/11/2023 07:56:26 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 ( '88544' , '21196' , 'CALENDARIO LITURGICO 2024' , '2' , '-2' , '4' , '0.5000' , '0.5' , '0' , '0' , '1.00' ) 15/11/2023 07:56:26 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 ( '88544' , '21682' , 'ORDO VIRGINUM' , '6' , '-6' , '4' , '14.0000' , '14' , '0' , '5' , '79.80' ) 15/11/2023 07:56:26 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 ( '88544' , '21763' , 'BUSSOLOTTO OTTONE - 161' , '2' , '-2' , '1' , '17.5000' , '14.344262295082' , '22' , '0' , '35.00' ) 15/11/2023 07:56:26 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 ( '88544' , '1914' , 'CERA DELLA LITURGIA' , '3' , '-3' , '1' , '4.9000' , '4.016393442623' , '22' , '0' , '14.70' )