07/07/2023 08:21:02 am >> SELECT document_num FROM ps_document WHERE document_num = '74/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-07-07') 07/07/2023 08:21:02 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 ( '24' , '74/A' , '2023-07-07' , 'A' , '2379' , '0' , '4671437' , 'R.NE PESCARA 84025 EBOLI' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '508.20' , '508.20' , NOW() , NOW() ) 07/07/2023 08:21:02 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 = '86668' 07/07/2023 08:21:02 am >> DELETE FROM ps_document_detail WHERE id_document = '86668' 07/07/2023 08:21:02 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 ( '86668' , '8510' , 'PRIMI PASSI CON GESÙ - ANNO B' , '30' , '-30' , '4' , '3.40' , '3.4' , '0' , '20' , '81.60' ) 07/07/2023 08:21:02 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 ( '86668' , '8598' , 'IO SONO CON VOI 1 - MAGNIFICAT' , '50' , '-50' , '4' , '3.00' , '3' , '0' , '10' , '135.00' ) 07/07/2023 08:21:02 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 ( '86668' , '8599' , 'IO SONO CON VOI 2 - MAGNIFICAT' , '50' , '-50' , '4' , '3.00' , '3' , '0' , '10' , '135.00' ) 07/07/2023 08:21:02 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 ( '86668' , '8602' , 'VENITE CON ME 1 - MAGNIFICAT' , '46' , '-46' , '4' , '3.00' , '3' , '0' , '10' , '124.20' ) 07/07/2023 08:21:02 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 ( '86668' , '8603' , 'VENITE CON ME 2 - MAGNIFICAT' , '6' , '-6' , '4' , '3.00' , '3' , '0' , '10' , '16.20' ) 07/07/2023 08:21:02 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 ( '86668' , '8601' , 'SARETE MIEI TESTIMONI 2 - MAGNIFICAT' , '6' , '-6' , '4' , '3.00' , '3' , '0' , '10' , '16.20' ) 07/07/2023 10:04:59 am >> SELECT document_num FROM ps_document WHERE document_num = '33/E' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-07-07') 07/07/2023 10:04:59 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 ( '23' , '33/E' , '2023-07-07' , 'E' , '2379' , '0' , '4671437' , 'R.NE PESCARA 84025 EBOLI' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '508.20' , '508.20' , NOW() , NOW() ) 07/07/2023 10:04:59 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 = '86669' 07/07/2023 10:04:59 am >> DELETE FROM ps_document_detail WHERE id_document = '86669' 07/07/2023 10:04:59 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 ( '86669' , '8510' , 'PRIMI PASSI CON GESÙ - ANNO B' , '30' , '-30' , '4' , '3.4000' , '3.4' , '0' , '20' , '81.60' ) 07/07/2023 10:04:59 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 ( '86669' , '8598' , 'IO SONO CON VOI 1 - MAGNIFICAT' , '50' , '-50' , '4' , '3.0000' , '3' , '0' , '10' , '135.00' ) 07/07/2023 10:04:59 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 ( '86669' , '8599' , 'IO SONO CON VOI 2 - MAGNIFICAT' , '50' , '-50' , '4' , '3.0000' , '3' , '0' , '10' , '135.00' ) 07/07/2023 10:04:59 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 ( '86669' , '8602' , 'VENITE CON ME 1 - MAGNIFICAT' , '46' , '-46' , '4' , '3.0000' , '3' , '0' , '10' , '124.20' ) 07/07/2023 10:04:59 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 ( '86669' , '8603' , 'VENITE CON ME 2 - MAGNIFICAT' , '6' , '-6' , '4' , '3.0000' , '3' , '0' , '10' , '16.20' ) 07/07/2023 10:04:59 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 ( '86669' , '8601' , 'SARETE MIEI TESTIMONI 2 - MAGNIFICAT' , '6' , '-6' , '4' , '3.0000' , '3' , '0' , '10' , '16.20' ) 07/07/2023 10:05:18 am >> DELETE FROM ps_document WHERE id_document = '86668' 07/07/2023 10:05:18 am >> DELETE FROM ps_document_detail WHERE id_document = '86668' 07/07/2023 10:18:02 am >> SELECT document_num FROM ps_document WHERE document_num = '2150' AND id_document != '86459' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-21') 07/07/2023 10:18:02 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2150', document_date = '2023-06-21', 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 = '6.70', price_tax_excluded = '5.49', date_upd = NOW() WHERE id_document = '86459' 07/07/2023 10:18:02 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 = '86459' 07/07/2023 10:18:03 am >> DELETE FROM ps_document_detail WHERE id_document = '86459' 07/07/2023 10:18:03 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 ( '86459' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '2' , '-2' , '1' , '1.10' , '0.9016393442623' , '22' , '0' , '2.20' ) 07/07/2023 10:18:03 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 ( '86459' , '18215' , 'BRACCIALE DECINA VARI COL. - BC752' , '2' , '-2' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '2.00' ) 07/07/2023 10:18:03 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 ( '86459' , '16986' , 'QUADRETTO SMUSSATO 7X10 SACRO CUORE' , '1' , '-1' , '1' , '2.5000' , '2.0491803278689' , '22' , '0' , '2.50' ) 07/07/2023 10:18:40 am >> SELECT document_num FROM ps_document WHERE document_num = '1524' AND id_document != '84165' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-05') 07/07/2023 10:18:40 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1524', document_date = '2023-05-05', 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 = '40.00', price_tax_excluded = '32.79', date_upd = NOW() WHERE id_document = '84165' 07/07/2023 10:18: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 = '84165' 07/07/2023 10:18:40 am >> DELETE FROM ps_document_detail WHERE id_document = '84165' 07/07/2023 10:18: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 ( '84165' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '10' , '-10' , '1' , '1' , '0.81967213114754' , '22' , '0' , '10.00' ) 07/07/2023 10:18: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 ( '84165' , '1350' , 'BRACCIALETTO CON CROCE - 29002 03' , '2' , '-2' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '6.00' ) 07/07/2023 10:18: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 ( '84165' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '12' , '-12' , '1' , '0.2500' , '0.20491803278689' , '22' , '0' , '3.00' ) 07/07/2023 10:18: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 ( '84165' , '14064' , 'STELLARIO PLEX CM 16' , '1' , '-1' , '1' , '13.5000' , '11.065573770492' , '22' , '0' , '13.50' ) 07/07/2023 10:18: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 ( '84165' , '8311' , 'PREGHIERA PER GLI ANZIANI - 15' , '50' , '-50' , '1' , '0.1500' , '0.12295081967213' , '22' , '0' , '7.50' ) 07/07/2023 10:50:11 am >> SELECT document_num FROM ps_document WHERE document_num = '2320' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-07-07') 07/07/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 ( '11' , '2320' , '2023-07-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.40' , '1.40' , NOW() , NOW() ) 07/07/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 = '86670' 07/07/2023 10:50:11 am >> DELETE FROM ps_document_detail WHERE id_document = '86670' 07/07/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 ( '86670' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '2' , '-2' , '4' , '0.70' , '0.7' , '0' , '0' , '1.40' ) 07/07/2023 11:05:40 am >> SELECT document_num FROM ps_document WHERE document_num = '2321' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-07-07') 07/07/2023 11:05: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' , '2321' , '2023-07-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.50' , '7.87' , NOW() , NOW() ) 07/07/2023 11:05: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 = '86671' 07/07/2023 11:05:40 am >> DELETE FROM ps_document_detail WHERE id_document = '86671' 07/07/2023 11:05: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 ( '86671' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '5' , '-5' , '4' , '0.70' , '0.7' , '0' , '0' , '3.50' ) 07/07/2023 11:05: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 ( '86671' , '21196' , 'CALENDARIO LITURGICO 2024' , '3' , '-3' , '4' , '0.50' , '0.5' , '0' , '0' , '1.50' ) 07/07/2023 11:05: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 ( '86671' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '1' , '-1' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '3.50' ) 07/07/2023 11:29:35 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 ( '32' , '6223726319' , '2023-06-30' , '' , '0' , '177' , '4679057' , 'VIA G. VERDI 8 20057 ASSAGO' , '' , '' , '0.49' , '4' , '0' , '0' , '0' , '' , '11' , '0' , '223.90' , '223.90' , NOW() , NOW() ) 07/07/2023 11:29:35 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 = '86672' 07/07/2023 11:29:35 am >> DELETE FROM ps_document_detail WHERE id_document = '86672' 07/07/2023 11:29:35 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 ( '86672' , '21248' , 'La banda degli dei' , '1' , '0' , '4' , '9.27' , '9.27' , '0' , '0' , '9.2700' ) 07/07/2023 11:29:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '21248' AND id_supplier = '177' 07/07/2023 11:29:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21248' , '177' , '1' ) 07/07/2023 11:29:35 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 ( '86672' , '21345' , 'buio oltre la siepe - h. lee' , '1' , '0' , '4' , '9.65' , '9.65' , '0' , '0' , '9.6500' ) 07/07/2023 11:29:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '21345' AND id_supplier = '177' 07/07/2023 11:29:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21345' , '177' , '1' ) 07/07/2023 11:29:35 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 ( '86672' , '21255' , 'Come le cicale' , '1' , '0' , '4' , '8.17' , '8.17' , '0' , '0' , '8.1700' ) 07/07/2023 11:29:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '21255' AND id_supplier = '177' 07/07/2023 11:29:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21255' , '177' , '1' ) 07/07/2023 11:29:35 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 ( '86672' , '21244' , 'Contro natura. Dagli OGM al «bio», falsi allarmi e verità nascoste del cibo ' , '1' , '0' , '4' , '8.9' , '8.9' , '0' , '0' , '8.9000' ) 07/07/2023 11:29:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '21244' AND id_supplier = '177' 07/07/2023 11:29:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21244' , '177' , '1' ) 07/07/2023 11:29:35 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 ( '86672' , '21207' , 'DANTE: LE MUSE LETTRICI' , '1' , '0' , '4' , '8.9' , '8.9' , '0' , '0' , '8.9000' ) 07/07/2023 11:29:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '21207' AND id_supplier = '177' 07/07/2023 11:29:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21207' , '177' , '1' ) 07/07/2023 11:29:35 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 ( '86672' , '21246' , 'Diana. La vera storia dalle sue parole' , '1' , '0' , '4' , '11.87' , '11.87' , '0' , '0' , '11.8700' ) 07/07/2023 11:29:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '21246' AND id_supplier = '177' 07/07/2023 11:29:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21246' , '177' , '1' ) 07/07/2023 11:29:35 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 ( '86672' , '21210' , 'DONNE SUL FILO DELLA MEMORIA' , '1' , '0' , '4' , '11.13' , '11.13' , '0' , '0' , '11.1300' ) 07/07/2023 11:29:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '21210' AND id_supplier = '177' 07/07/2023 11:29:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21210' , '177' , '1' ) 07/07/2023 11:29:36 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 ( '86672' , '21245' , 'E poi ci sono io' , '1' , '0' , '4' , '8.9' , '8.9' , '0' , '0' , '8.9000' ) 07/07/2023 11:29:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '21245' AND id_supplier = '177' 07/07/2023 11:29:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21245' , '177' , '1' ) 07/07/2023 11:29:36 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 ( '86672' , '21256' , 'L estate che ho dentro' , '1' , '0' , '4' , '8.9' , '8.9' , '0' , '0' , '8.9000' ) 07/07/2023 11:29:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '21256' AND id_supplier = '177' 07/07/2023 11:29:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21256' , '177' , '1' ) 07/07/2023 11:29:36 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 ( '86672' , '21247' , 'Impara a volare' , '1' , '0' , '4' , '8.9' , '8.9' , '0' , '0' , '8.9000' ) 07/07/2023 11:29:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '21247' AND id_supplier = '177' 07/07/2023 11:29:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21247' , '177' , '1' ) 07/07/2023 11:29:36 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 ( '86672' , '21254' , 'I ladri di New York' , '1' , '0' , '4' , '8.9' , '8.9' , '0' , '0' , '8.9000' ) 07/07/2023 11:29:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '21254' AND id_supplier = '177' 07/07/2023 11:29:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21254' , '177' , '1' ) 07/07/2023 11:29:36 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 ( '86672' , '21346' , 'LETTERE VOL. 2' , '1' , '0' , '4' , '13.69' , '13.69' , '0' , '0' , '13.6900' ) 07/07/2023 11:29:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '21346' AND id_supplier = '177' 07/07/2023 11:29:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21346' , '177' , '1' ) 07/07/2023 11:29:36 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 ( '86672' , '21208' , 'NASCERE, RINASCERE. STORIE DI DONNE' , '1' , '0' , '4' , '14.77' , '14.77' , '0' , '0' , '14.7700' ) 07/07/2023 11:29:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '21208' AND id_supplier = '177' 07/07/2023 11:29:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21208' , '177' , '1' ) 07/07/2023 11:29:36 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 ( '86672' , '21251' , 'P.S. Ti amo ancora' , '1' , '0' , '4' , '8.9' , '8.9' , '0' , '0' , '8.9000' ) 07/07/2023 11:29:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '21251' AND id_supplier = '177' 07/07/2023 11:29:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21251' , '177' , '1' ) 07/07/2023 11:29:36 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 ( '86672' , '21258' , 'Per questo mi chiamo GiovannI.' , '1' , '0' , '4' , '8.9' , '8.9' , '0' , '0' , '8.9000' ) 07/07/2023 11:29:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '21258' AND id_supplier = '177' 07/07/2023 11:29:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21258' , '177' , '1' ) 07/07/2023 11:29:36 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 ( '86672' , '21257' , 'più grande' , '1' , '0' , '4' , '12.61' , '12.61' , '0' , '0' , '12.6100' ) 07/07/2023 11:29:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '21257' AND id_supplier = '177' 07/07/2023 11:29:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21257' , '177' , '1' ) 07/07/2023 11:29:36 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 ( '86672' , '21249' , 'Play again. La saga di Game over' , '1' , '0' , '4' , '11.3' , '11.3' , '0' , '0' , '11.3000' ) 07/07/2023 11:29:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '21249' AND id_supplier = '177' 07/07/2023 11:29:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21249' , '177' , '1' ) 07/07/2023 11:29:36 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 ( '86672' , '21347' , 'SCAPOLARE VERDE E I SUOI PRODIGI' , '1' , '0' , '4' , '7.8' , '7.8' , '0' , '0' , '7.8000' ) 07/07/2023 11:29:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '21347' AND id_supplier = '177' 07/07/2023 11:29:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21347' , '177' , '1' ) 07/07/2023 11:29:36 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 ( '86672' , '19588' , 'SCELTA DI ENEA - L. EPICOCO' , '1' , '0' , '4' , '11.87' , '11.87' , '0' , '0' , '11.8700' ) 07/07/2023 11:29:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '19588' AND id_supplier = '177' 07/07/2023 11:29:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19588' , '177' , '1' ) 07/07/2023 11:29:36 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 ( '86672' , '18750' , 'SONO STATA ALLE PORTE DEL CIELO E DELLINFERNO - G. POLO' , '2' , '0' , '4' , '1.505' , '1.505' , '0' , '0' , '3.0100' ) 07/07/2023 11:29:37 am >> DELETE FROM ps_product_supplier WHERE id_product = '18750' AND id_supplier = '177' 07/07/2023 11:29:37 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18750' , '177' , '1' ) 07/07/2023 11:29:37 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 ( '86672' , '21250' , 'Terrore nella foresta dei grandi sauri. Arex e Vastatore, dinosauri detective. Ediz. a colori' , '1' , '0' , '4' , '8.9' , '8.9' , '0' , '0' , '8.9000' ) 07/07/2023 11:29:37 am >> DELETE FROM ps_product_supplier WHERE id_product = '21250' AND id_supplier = '177' 07/07/2023 11:29:37 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21250' , '177' , '1' ) 07/07/2023 11:29:37 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 ( '86672' , '21252' , 'Tua per sempre, Lara Jean' , '1' , '0' , '4' , '8.9' , '8.9' , '0' , '0' , '8.9000' ) 07/07/2023 11:29:37 am >> DELETE FROM ps_product_supplier WHERE id_product = '21252' AND id_supplier = '177' 07/07/2023 11:29:37 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21252' , '177' , '1' ) 07/07/2023 11:29:37 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 ( '86672' , '21253' , 'Tutte le volte che ho scritto ti amo' , '1' , '0' , '4' , '9.27' , '9.27' , '0' , '0' , '9.2700' ) 07/07/2023 11:29:37 am >> DELETE FROM ps_product_supplier WHERE id_product = '21253' AND id_supplier = '177' 07/07/2023 11:29:37 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21253' , '177' , '1' ) 07/07/2023 11:34:08 am >> SELECT document_num FROM ps_document WHERE document_num = '2322' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-07-07') 07/07/2023 11:34:08 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' , '2322' , '2023-07-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '35.00' , '28.69' , NOW() , NOW() ) 07/07/2023 11:34:08 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 = '86673' 07/07/2023 11:34:08 am >> DELETE FROM ps_document_detail WHERE id_document = '86673' 07/07/2023 11:34:08 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 ( '86673' , '12202' , 'VETRO ANTIVENTO PER F. CAND. DIAM. 4 - 73/40' , '2' , '-2' , '1' , '17.5' , '14.344262295082' , '22' , '0' , '35.00' ) 07/07/2023 11:35:23 am >> SELECT document_num FROM ps_document WHERE document_num = '2323' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-07-07') 07/07/2023 11:35:23 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' , '2323' , '2023-07-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.00' , '9.02' , NOW() , NOW() ) 07/07/2023 11:35:23 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 = '86674' 07/07/2023 11:35:23 am >> DELETE FROM ps_document_detail WHERE id_document = '86674' 07/07/2023 11:35:23 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 ( '86674' , '9691' , 'SCAPOLARE DEL CARMELO - PICCOLO - 1215/ITA' , '10' , '-10' , '1' , '1.10' , '0.9016393442623' , '22' , '0' , '11.00' ) 07/07/2023 11:51:13 am >> SELECT document_num FROM ps_document WHERE document_num = '2324' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-07-07') 07/07/2023 11:51:13 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' , '2324' , '2023-07-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '120.00' , '98.36' , NOW() , NOW() ) 07/07/2023 11:51:13 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 = '86675' 07/07/2023 11:51:13 am >> DELETE FROM ps_document_detail WHERE id_document = '86675' 07/07/2023 11:51: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 ( '86675' , '15733' , 'CASULA SPIGHE UVA - 95' , '1' , '-1' , '1' , '120' , '98.360655737705' , '22' , '0' , '120.00' ) 07/07/2023 12:50:25 pm >> SELECT document_num FROM ps_document WHERE document_num = '2312' AND id_document != '86656' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-07-06') 07/07/2023 12:50:25 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2312', document_date = '2023-07-06', 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 = '120.00', price_tax_excluded = '98.36', date_upd = NOW() WHERE id_document = '86656' 07/07/2023 12:50:25 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 = '86656' 07/07/2023 12:50:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '86656' 07/07/2023 12:50:25 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 ( '86656' , '21290' , 'ROSARIO ADDOLORATA' , '30' , '-30' , '1' , '4' , '3.2786885245902' , '22' , '0' , '120.00' ) 07/07/2023 01:03:09 pm >> SELECT document_num FROM ps_document WHERE document_num = '2325' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-07-07') 07/07/2023 01:03:09 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2325' , '2023-07-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.00' , '7.69' , NOW() , NOW() ) 07/07/2023 01:03: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 = '86676' 07/07/2023 01:03:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '86676' 07/07/2023 01:03: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 ( '86676' , '7311' , 'OSTIA SOTTILE 74MM' , '4' , '-4' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '8.00' ) 07/07/2023 02:18:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '2310' AND id_document != '86654' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-07-06') 07/07/2023 02:18:11 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2310', document_date = '2023-07-06', 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 = '247.60', price_tax_excluded = '202.95', date_upd = NOW() WHERE id_document = '86654' 07/07/2023 02:18:11 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86654' 07/07/2023 02:18:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '86654' 07/07/2023 02:18:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86654' , '6058' , 'MADONNA DEL CARMINE - 117 BIS ' , '2' , '-2' , '1' , '3.8000' , '3.1147540983607' , '22' , '0' , '7.60' ) 07/07/2023 02:18:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86654' , '21290' , 'ROSARIO ADDOLORATA' , '60' , '-60' , '1' , '4' , '3.2786885245902' , '22' , '0' , '240.00' ) 07/07/2023 02:20:32 pm >> SELECT document_num FROM ps_document WHERE document_num = '2040' AND id_document != '85815' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-12') 07/07/2023 02:20:32 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2040', document_date = '2023-06-12', 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 = '287.40', price_tax_excluded = '236.01', date_upd = NOW() WHERE id_document = '85815' 07/07/2023 02:20: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 = '85815' 07/07/2023 02:20:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '85815' 07/07/2023 02:20: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 ( '85815' , '15019' , 'PREGHIAMO CON MARIA' , '3' , '-3' , '4' , '0.8000' , '0.8' , '0' , '0' , '2.40' ) 07/07/2023 02:20: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 ( '85815' , '19855' , 'STOLA ROMANA S/MOIRE - 7606S' , '1' , '-1' , '1' , '285' , '233.60655737705' , '22' , '0' , '285.00' ) 07/07/2023 02:21:09 pm >> SELECT document_num FROM ps_document WHERE document_num = '2314' AND id_document != '86660' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-07-06') 07/07/2023 02:21:09 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2314', document_date = '2023-07-06', 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 = '390.00', price_tax_excluded = '319.67', date_upd = NOW() WHERE id_document = '86660' 07/07/2023 02:21: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 = '86660' 07/07/2023 02:21:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '86660' 07/07/2023 02:21: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 ( '86660' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '390' , '319.67213114754' , '22' , '0' , '390.00' ) 07/07/2023 02:22:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '2314' AND id_document != '86660' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-07-06') 07/07/2023 02:22:04 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2314', document_date = '2023-07-06', 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 = '390.00', price_tax_excluded = '319.67', date_upd = NOW() WHERE id_document = '86660' 07/07/2023 02:22: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 = '86660' 07/07/2023 02:22:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '86660' 07/07/2023 02:22: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 ( '86660' , '21290' , 'ROSARIO ADDOLORATA' , '100' , '-100' , '1' , '3.9' , '3.1967213114754' , '22' , '0' , '390.00' ) 07/07/2023 02:23:45 pm >> SELECT document_num FROM ps_document WHERE document_num = '938' AND id_document != '82424' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-23') 07/07/2023 02:23:45 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '938', document_date = '2023-03-23', 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 = '135.00', price_tax_excluded = '110.66', date_upd = NOW() WHERE id_document = '82424' 07/07/2023 02:23:45 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82424' 07/07/2023 02:23:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '82424' 07/07/2023 02:23:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82424' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '65' , '53.27868852459' , '22' , '0' , '65.00' ) 07/07/2023 02:23:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82424' , '19395' , 'CLERGY MISTO COTONE ML - C01' , '2' , '-2' , '1' , '35' , '28.688524590164' , '22' , '0' , '70.00' ) 07/07/2023 02:26:28 pm >> SELECT document_num FROM ps_document WHERE document_num = '938' AND id_document != '82424' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-23') 07/07/2023 02:26:28 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '938', document_date = '2023-03-23', 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 = '135.00', price_tax_excluded = '110.66', date_upd = NOW() WHERE id_document = '82424' 07/07/2023 02:26: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 = '82424' 07/07/2023 02:26:28 pm >> DELETE FROM ps_document_detail WHERE id_document = '82424' 07/07/2023 02:26: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 ( '82424' , '17160' , 'CARBONCINI ROSSI - CARRO' , '3' , '-3' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '30.00' ) 07/07/2023 02:26: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 ( '82424' , '19395' , 'CLERGY MISTO COTONE ML - C01' , '3' , '-3' , '1' , '35.0000' , '28.688524590164' , '22' , '0' , '105.00' ) 07/07/2023 02:28:47 pm >> SELECT document_num FROM ps_document WHERE document_num = '960' AND id_document != '82451' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-24') 07/07/2023 02:28:47 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '960', document_date = '2023-03-24', 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 = '200.00', price_tax_excluded = '164.62', date_upd = NOW() WHERE id_document = '82451' 07/07/2023 02:28:47 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82451' 07/07/2023 02:28:47 pm >> DELETE FROM ps_document_detail WHERE id_document = '82451' 07/07/2023 02:28:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82451' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '50' , '40.983606557377' , '22' , '0' , '50.00' ) 07/07/2023 02:28:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82451' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '2' , '-2' , '1' , '22.0000' , '18.032786885246' , '22' , '0' , '44.00' ) 07/07/2023 02:28:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82451' , '19147' , 'CANDELINE NON GOCCIOLANTI GRECHE' , '1' , '-1' , '1' , '17.2000' , '14.098360655738' , '22' , '0' , '17.20' ) 07/07/2023 02:28:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82451' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '4' , '-4' , '4' , '1.0000' , '1' , '0' , '5' , '3.80' ) 07/07/2023 02:28:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82451' , '18682' , 'CLERGY ROMANO ML - C17' , '1' , '-1' , '1' , '45' , '36.885245901639' , '22' , '0' , '45.00' ) 07/07/2023 02:28:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82451' , '19397' , 'CLERGY COTONE 100% ML - C02' , '1' , '-1' , '1' , '40.00' , '32.786885245902' , '22' , '0' , '40.00' ) 07/07/2023 03:20:05 pm >> SELECT document_num FROM ps_document WHERE document_num = '2326' AND id_document != '' AND id_document_type LIKE '14' AND YEAR(document_date) = YEAR('2023-07-07') 07/07/2023 03:20:05 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' , '2326' , '2023-07-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '20.00' , '19.23' , NOW() , NOW() ) 07/07/2023 03:20:05 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 = '86677' 07/07/2023 03:20:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '86677' 07/07/2023 03:20:05 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 ( '86677' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '4' , '-4' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '14.00' ) 07/07/2023 03:20:05 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 ( '86677' , '16689' , 'OSTIA PAN DI CENA mm80' , '3' , '-3' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '6.00' ) 07/07/2023 03:20:37 pm >> SELECT document_num FROM ps_document WHERE document_num = '2327' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-07-07') 07/07/2023 03:20:37 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' , '2327' , '2023-07-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.84' , '14.84' , NOW() , NOW() ) 07/07/2023 03:20: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 = '86678' 07/07/2023 03:20:37 pm >> DELETE FROM ps_document_detail WHERE id_document = '86678' 07/07/2023 03:20: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 ( '86678' , '21199' , 'AMEN - OTT 2023' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 07/07/2023 03:20: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 ( '86678' , '21067' , 'AMEN - AGO 23' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 07/07/2023 03:20: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 ( '86678' , '21198' , 'AMEN - SET 2023' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 07/07/2023 03:20: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 ( '86678' , '20999' , 'AMEN - LUG 23' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 07/07/2023 06:11:22 pm >> SELECT document_num FROM ps_document WHERE document_num = '2328' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-07-07') 07/07/2023 06:11:22 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' , '2328' , '2023-07-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.00' , '7.38' , NOW() , NOW() ) 07/07/2023 06:11:22 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 = '86679' 07/07/2023 06:11:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '86679' 07/07/2023 06:11:22 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 ( '86679' , '9205' , 'S. ANTONIO BABY 023 SAT/9 BB' , '1' , '-1' , '1' , '9.00' , '7.3770491803279' , '22' , '0' , '9.00' )