08/07/2024 10:16:35 am >> SELECT document_num FROM ps_document WHERE document_num = '2214' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-08') 08/07/2024 10:16: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 ( '11' , '2214' , '2024-07-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '130.00' , '106.56' , NOW() , NOW() ) 08/07/2024 10:16: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 = '92560' 08/07/2024 10:16:35 am >> DELETE FROM ps_document_detail WHERE id_document = '92560' 08/07/2024 10:16: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 ( '92560' , '16864' , 'CROCIFISSO SAGOMATO 40X25 - 104062' , '1' , '-1' , '1' , '130' , '106.55737704918' , '22' , '0' , '130.00' ) 08/07/2024 10:56:03 am >> SELECT document_num FROM ps_document WHERE document_num = '14/L' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-07-08') 08/07/2024 10:56:03 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' , '14/L' , '2024-07-08' , 'L' , '2379' , '0' , '4671437' , 'R.NE PESCARA 84025 EBOLI' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '617.90' , '617.90' , NOW() , NOW() ) 08/07/2024 10:56:03 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 = '92561' 08/07/2024 10:56:03 am >> DELETE FROM ps_document_detail WHERE id_document = '92561' 08/07/2024 10:56: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 ( '92561' , '8511' , 'PRIMI PASSI CON GESÙ - ANNO C' , '30' , '-30' , '4' , '3.40' , '3.4' , '0' , '20' , '81.60' ) 08/07/2024 10:56: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 ( '92561' , '8515' , 'PRIMI PASSI CON GESÙ ANNO C - GUIDA' , '2' , '-2' , '4' , '5.00' , '5' , '0' , '20' , '8.00' ) 08/07/2024 10:56: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 ( '92561' , '8598' , 'IO SONO CON VOI 1 - MAGNIFICAT' , '30' , '-30' , '4' , '3.00' , '3' , '0' , '10' , '81.00' ) 08/07/2024 10:56: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 ( '92561' , '8599' , 'IO SONO CON VOI 2 - MAGNIFICAT' , '40' , '-40' , '4' , '3.00' , '3' , '0' , '10' , '108.00' ) 08/07/2024 10:56: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 ( '92561' , '8602' , 'VENITE CON ME 1 - MAGNIFICAT' , '30' , '-30' , '4' , '3.00' , '3' , '0' , '10' , '81.00' ) 08/07/2024 10:56: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 ( '92561' , '8603' , 'VENITE CON ME 2 - MAGNIFICAT' , '40' , '-40' , '4' , '3.00' , '3' , '0' , '10' , '108.00' ) 08/07/2024 10:56: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 ( '92561' , '8600' , 'SARETE MIEI TESTIMONI 1 - MAGNIFICAT' , '20' , '-20' , '4' , '3.00' , '3' , '0' , '10' , '54.00' ) 08/07/2024 10:56: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 ( '92561' , '8601' , 'SARETE MIEI TESTIMONI 2 - MAGNIFICAT' , '14' , '-14' , '4' , '3.00' , '3' , '0' , '10' , '37.80' ) 08/07/2024 10:56: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 ( '92561' , '10740' , 'TROPPO FORTE - 1/ IL DECOLLO' , '10' , '-10' , '4' , '5.00' , '5' , '0' , '10' , '45.00' ) 08/07/2024 10:56: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 ( '92561' , '10741' , 'TROPPO FORTE - 2/ LA DIREZIONE' , '3' , '-3' , '4' , '5.00' , '5' , '0' , '10' , '13.50' ) 08/07/2024 11:05:33 am >> SELECT document_num FROM ps_document WHERE document_num = '1698' AND id_document != '91932' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-21') 08/07/2024 11:05:33 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1698', document_date = '2024-05-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 = '45.00', price_tax_excluded = '36.89', date_upd = NOW() WHERE id_document = '91932' 08/07/2024 11:05:33 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 = '91932' 08/07/2024 11:05:33 am >> DELETE FROM ps_document_detail WHERE id_document = '91932' 08/07/2024 11:05:33 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 ( '91932' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '10' , '8.1967213114754' , '22' , '0' , '10.00' ) 08/07/2024 11:05:33 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 ( '91932' , '22441' , 'ROSARIO ARGENTO/CRISTALLO - 7693/50' , '1' , '-1' , '1' , '35' , '28.688524590164' , '22' , '0' , '35.00' ) 08/07/2024 11:24:33 am >> SELECT document_num FROM ps_document WHERE document_num = '2215' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-08') 08/07/2024 11:24:33 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' , '2215' , '2024-07-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '23.75' , '23.75' , NOW() , NOW() ) 08/07/2024 11:24:33 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 = '92562' 08/07/2024 11:24:33 am >> DELETE FROM ps_document_detail WHERE id_document = '92562' 08/07/2024 11:24:33 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 ( '92562' , '22414' , 'SULLA TUA PAROLA - LUG/AGO 2024' , '5' , '-5' , '4' , '5.00' , '5' , '0' , '5' , '23.75' ) 08/07/2024 11:34:20 am >> SELECT document_num FROM ps_document WHERE document_num = '2216' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-08') 08/07/2024 11:34:20 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' , '2216' , '2024-07-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '222.70' , '200.64' , NOW() , NOW() ) 08/07/2024 11:34:20 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92563' 08/07/2024 11:34:20 am >> DELETE FROM ps_document_detail WHERE id_document = '92563' 08/07/2024 11:34:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92563' , '17617' , 'IMMAGINI ISONZO X 100' , '2' , '-2' , '1' , '3' , '2.4590163934426' , '22' , '0' , '6.00' ) 08/07/2024 11:34:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92563' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '4' , '3.2786885245902' , '22' , '0' , '4.00' ) 08/07/2024 11:34:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92563' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '1' , '-1' , '1' , '7.90' , '6.4754098360656' , '22' , '0' , '7.90' ) 08/07/2024 11:34:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92563' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 08/07/2024 11:34:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92563' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '3' , '-3' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '10.50' ) 08/07/2024 11:34:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92563' , '20428' , 'OSTIA TAGLIO CHIUSO 72MM - OTC25' , '3' , '-3' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '6.00' ) 08/07/2024 11:34:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92563' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.30' , '4.1346153846154' , '4' , '0' , '4.30' ) 08/07/2024 11:34:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92563' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3' , '2.4590163934426' , '22' , '0' , '90.00' ) 08/07/2024 11:34:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92563' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '120' , '-120' , '4' , '0.70' , '0.7' , '0' , '0' , '84.00' ) 08/07/2024 11:35:57 am >> SELECT document_num FROM ps_document WHERE document_num = '2217' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-08') 08/07/2024 11:35:57 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' , '2217' , '2024-07-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '76.00' , '76.00' , NOW() , NOW() ) 08/07/2024 11:35:57 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 = '92564' 08/07/2024 11:35:57 am >> DELETE FROM ps_document_detail WHERE id_document = '92564' 08/07/2024 11:35:57 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 ( '92564' , '22414' , 'SULLA TUA PAROLA - LUG/AGO 2024' , '16' , '-16' , '4' , '5.00' , '5' , '0' , '5' , '76.00' ) 08/07/2024 11:36:02 am >> DELETE FROM ps_document WHERE id_document = '92480' 08/07/2024 11:36:02 am >> DELETE FROM ps_document_detail WHERE id_document = '92480' 08/07/2024 12:18:48 pm >> SELECT document_num FROM ps_document WHERE document_num = '2218' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-08') 08/07/2024 12:18:48 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' , '2218' , '2024-07-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '13.50' , '11.07' , NOW() , NOW() ) 08/07/2024 12:18: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 = '92565' 08/07/2024 12:18:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '92565' 08/07/2024 12:18: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 ( '92565' , '12040' , 'MEDAGLIA MIRACOLOSA GRANDE IN ARGENTO - M058' , '1' , '-1' , '1' , '13.50' , '11.065573770492' , '22' , '0' , '13.50' ) 08/07/2024 12:23:36 pm >> SELECT document_num FROM ps_document WHERE document_num = '2219' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-08') 08/07/2024 12:23:36 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' , '2219' , '2024-07-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '95.00' , '77.87' , NOW() , NOW() ) 08/07/2024 12:23:36 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 = '92566' 08/07/2024 12:23:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '92566' 08/07/2024 12:23:36 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 ( '92566' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '95' , '77.868852459016' , '22' , '0' , '95.00' ) 08/07/2024 12:26:33 pm >> SELECT document_num FROM ps_document WHERE document_num = '2220' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-08') 08/07/2024 12:26:33 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2220' , '2024-07-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.00' , '3.00' , NOW() , NOW() ) 08/07/2024 12:26: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 = '92567' 08/07/2024 12:26:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '92567' 08/07/2024 12:26: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 ( '92567' , '19587' , 'GESU BAMBINO DI PRaGA - 8079' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '0' , '3.00' ) 08/07/2024 12:27:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '2221' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-08') 08/07/2024 12:27:43 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' , '2221' , '2024-07-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '50.00' , '40.98' , NOW() , NOW() ) 08/07/2024 12:27:43 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 = '92568' 08/07/2024 12:27:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '92568' 08/07/2024 12:27:43 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 ( '92568' , '16958' , 'SERVIZIO MESSA M/LINO MARIANO - 6990' , '1' , '-1' , '1' , '50' , '40.983606557377' , '22' , '0' , '50.00' ) 08/07/2024 01:03:47 pm >> SELECT document_num FROM ps_document WHERE document_num = '81/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-07-08') 08/07/2024 01:03:47 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '81/A' , '2024-07-08' , 'A' , '1203' , '0' , '4669427' , 'P.ZZA MUNICIPIO 83020 S. AGATA IRPINA-SOLOFRA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '46.00' , '40.54' , NOW() , NOW() ) 08/07/2024 01:03: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 = '92569' 08/07/2024 01:03:47 pm >> DELETE FROM ps_document_detail WHERE id_document = '92569' 08/07/2024 01:03: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 ( '92569' , '20428' , 'OSTIA TAGLIO CHIUSO 72MM - OTC25' , '10' , '-10' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '20.00' ) 08/07/2024 01:03: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 ( '92569' , '1710' , 'CARBONCINI PER TURIBOLO BIANCHI - PZ 120' , '2' , '-2' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '26.00' ) 08/07/2024 03:02:04 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 08/07/2024 03:02:04 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22733' , '1' , '' , 'nuovo-prodotto' ) 08/07/2024 03:02:04 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '22733' , '1' , '1' , '2' , NOW() , NOW() ) 08/07/2024 03:02:04 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '22733' , '0' , '1' , '0' , '0' ) 08/07/2024 03:04:12 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002287' AND id_product != '22733' AND ean13 != '' 08/07/2024 03:04:12 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002287', date_upd = NOW() WHERE id_product = '22733' 08/07/2024 03:04:12 pm >> UPDATE ps_product_lang SET name = 'BRACCIALE ELASTICO - RL 436/435', description = '' WHERE id_product = '22733' 08/07/2024 03:04:13 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '1.8032786885245904' WHERE id_product = '22733' 08/07/2024 03:04:13 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '1.8032786885245904', id_tax_rules_group = '1', id_category_default = '151', 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 = '22733' 08/07/2024 03:04:13 pm >> DELETE FROM ps_specific_price WHERE id_product = '22733' 08/07/2024 03:04:14 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 = '22733' 08/07/2024 03:04:14 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22734' , '1' , '' , 'nuovo-prodotto' ) 08/07/2024 03:04:14 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 '22734' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22733' 08/07/2024 03:04:14 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22734' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22733' 08/07/2024 03:07:41 pm >> SELECT ean13 FROM ps_product WHERE ean13 = 'PC240' AND id_product != '21848' AND ean13 != '' 08/07/2024 03:07:41 pm >> UPDATE ps_product SET id_supplier = '43', reference = '', ean13 = 'PC240', date_upd = NOW() WHERE id_product = '21848' 08/07/2024 03:07:41 pm >> UPDATE ps_product_lang SET name = 'PORTACHIAVI ACUTIS - PC240', description = '' WHERE id_product = '21848' 08/07/2024 03:07:41 pm >> UPDATE ps_product SET wholesale_price = '0.78', on_sale = '0', price = '1.639344262295082' WHERE id_product = '21848' 08/07/2024 03:07:41 pm >> UPDATE ps_product_shop SET wholesale_price = '0.78', price = '1.639344262295082', id_tax_rules_group = '1', id_category_default = '151', 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 = '21848' 08/07/2024 03:07:41 pm >> DELETE FROM ps_specific_price WHERE id_product = '21848' 08/07/2024 03:09:12 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8027846279614' AND id_product != '22734' AND ean13 != '' 08/07/2024 03:09:12 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8027846279614', date_upd = NOW() WHERE id_product = '22734' 08/07/2024 03:09:12 pm >> UPDATE ps_product_lang SET name = 'CROCE SAN BENEDETTO - PG680BR', description = '' WHERE id_product = '22734' 08/07/2024 03:09:12 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '13.114754098360656' WHERE id_product = '22734' 08/07/2024 03:09:12 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '13.114754098360656', id_tax_rules_group = '1', id_category_default = '151', 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 = '22734' 08/07/2024 03:09:12 pm >> DELETE FROM ps_specific_price WHERE id_product = '22734' 08/07/2024 03:09:38 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8027846279614' AND id_product != '22734' AND ean13 != '' 08/07/2024 03:09:38 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8027846279614', date_upd = NOW() WHERE id_product = '22734' 08/07/2024 03:09:38 pm >> UPDATE ps_product_lang SET name = 'CROCE SAN BENEDETTO - PG680BR', description = '' WHERE id_product = '22734' 08/07/2024 03:09:38 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '13.114754098360656' WHERE id_product = '22734' 08/07/2024 03:09:38 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '13.114754098360656', id_tax_rules_group = '1', id_category_default = '151', 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 = '22734' 08/07/2024 03:09:38 pm >> DELETE FROM ps_specific_price WHERE id_product = '22734' 08/07/2024 03:09:39 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 = '22734' 08/07/2024 03:09:39 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22735' , '1' , '' , 'nuovo-prodotto' ) 08/07/2024 03:09:39 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 '22735' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22734' 08/07/2024 03:09:39 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22735' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22734' 08/07/2024 03:11:36 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8027846164811' AND id_product != '17607' AND ean13 != '' 08/07/2024 03:11:36 pm >> UPDATE ps_product SET id_supplier = '43', reference = '', ean13 = '8027846164811', date_upd = NOW() WHERE id_product = '17607' 08/07/2024 03:11:36 pm >> UPDATE ps_product_lang SET name = 'BRACCIALE BICOLORE ARG.- SL095', description = '' WHERE id_product = '17607' 08/07/2024 03:11:36 pm >> UPDATE ps_product SET wholesale_price = '11.12', on_sale = '0', price = '26.229508196721312' WHERE id_product = '17607' 08/07/2024 03:11:36 pm >> UPDATE ps_product_shop SET wholesale_price = '11.12', price = '26.229508196721312', id_tax_rules_group = '1', id_category_default = '151', 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 = '17607' 08/07/2024 03:11:36 pm >> DELETE FROM ps_specific_price WHERE id_product = '17607' 08/07/2024 03:16:44 pm >> SELECT ean13 FROM ps_product WHERE ean13 = 'G022-25' AND id_product != '22735' AND ean13 != '' 08/07/2024 03:16:44 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = 'G022-25', date_upd = NOW() WHERE id_product = '22735' 08/07/2024 03:16:44 pm >> UPDATE ps_product_lang SET name = 'MEDAGLIA SANT\'ANTONIO - G022-25', description = '' WHERE id_product = '22735' 08/07/2024 03:16:44 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '0.20491803278688525' WHERE id_product = '22735' 08/07/2024 03:16:44 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '0.20491803278688525', id_tax_rules_group = '1', id_category_default = '151', 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 = '22735' 08/07/2024 03:16:44 pm >> DELETE FROM ps_specific_price WHERE id_product = '22735' 08/07/2024 03:16:45 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 = '22735' 08/07/2024 03:16:45 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22736' , '1' , '' , 'nuovo-prodotto' ) 08/07/2024 03:16:45 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 '22736' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22735' 08/07/2024 03:16:45 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22736' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22735' 08/07/2024 03:17:47 pm >> SELECT ean13 FROM ps_product WHERE ean13 = 'G474-OX' AND id_product != '22736' AND ean13 != '' 08/07/2024 03:17:47 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = 'G474-OX', date_upd = NOW() WHERE id_product = '22736' 08/07/2024 03:17:47 pm >> UPDATE ps_product_lang SET name = 'MEDAGLIA CARLO ACUTIS SMALTATA - G474-OX', description = '' WHERE id_product = '22736' 08/07/2024 03:17:47 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '0.5737704918032787' WHERE id_product = '22736' 08/07/2024 03:17:47 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '0.5737704918032787', id_tax_rules_group = '1', id_category_default = '151', 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 = '22736' 08/07/2024 03:17:47 pm >> DELETE FROM ps_specific_price WHERE id_product = '22736' 08/07/2024 03:20:15 pm >> SELECT ean13 FROM ps_product WHERE ean13 = 'G474-OX' AND id_product != '22736' AND ean13 != '' 08/07/2024 03:20:15 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = 'G474-OX', date_upd = NOW() WHERE id_product = '22736' 08/07/2024 03:20:15 pm >> UPDATE ps_product_lang SET name = 'MEDAGLIA CARLO ACUTIS SMALTATA - G474-OX', description = '' WHERE id_product = '22736' 08/07/2024 03:20:15 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '0.5737704918032787' WHERE id_product = '22736' 08/07/2024 03:20:15 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '0.5737704918032787', id_tax_rules_group = '1', id_category_default = '151', 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 = '22736' 08/07/2024 03:20:15 pm >> DELETE FROM ps_specific_price WHERE id_product = '22736' 08/07/2024 03:21:15 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8027846277559' AND id_product != '20964' AND ean13 != '' 08/07/2024 03:21:15 pm >> UPDATE ps_product SET id_supplier = '43', reference = '', ean13 = '8027846277559', date_upd = NOW() WHERE id_product = '20964' 08/07/2024 03:21:15 pm >> UPDATE ps_product_lang SET name = 'STATUA SAN MICHELE - ST322-SM', description = '' WHERE id_product = '20964' 08/07/2024 03:21:15 pm >> UPDATE ps_product SET wholesale_price = '4.77', on_sale = '0', price = '11.475409836065573' WHERE id_product = '20964' 08/07/2024 03:21:15 pm >> UPDATE ps_product_shop SET wholesale_price = '4.77', price = '11.475409836065573', id_tax_rules_group = '1', id_category_default = '151', 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 = '20964' 08/07/2024 03:21:15 pm >> DELETE FROM ps_specific_price WHERE id_product = '20964' 08/07/2024 03:23:14 pm >> SELECT document_num FROM ps_document WHERE document_num = '2222' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-08') 08/07/2024 03:23:14 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' , '2222' , '2024-07-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '85.00' , '69.67' , NOW() , NOW() ) 08/07/2024 03:23:14 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 = '92570' 08/07/2024 03:23:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '92570' 08/07/2024 03:23:14 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 ( '92570' , '18947' , 'CLERGY COMODA MISTO - ML' , '2' , '-2' , '1' , '42.5' , '34.83606557377' , '22' , '0' , '85.00' ) 08/07/2024 03:29:43 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002287' AND id_product != '22733' AND ean13 != '' 08/07/2024 03:29:43 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002287', date_upd = NOW() WHERE id_product = '22733' 08/07/2024 03:29:43 pm >> UPDATE ps_product_lang SET name = 'BRACCIALE ELASTICO - RL436/435', description = '' WHERE id_product = '22733' 08/07/2024 03:29:43 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '1.8033' WHERE id_product = '22733' 08/07/2024 03:29:43 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '1.8033', id_tax_rules_group = '1', id_category_default = '151', 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 = '22733' 08/07/2024 03:29:43 pm >> DELETE FROM ps_specific_price WHERE id_product = '22733' 08/07/2024 03:32:00 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 08/07/2024 03:32:00 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22737' , '1' , '' , 'nuovo-prodotto' ) 08/07/2024 03:32:00 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '22737' , '1' , '1' , '2' , NOW() , NOW() ) 08/07/2024 03:32:00 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '22737' , '0' , '1' , '0' , '0' ) 08/07/2024 03:33:08 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8027846182228' AND id_product != '22737' AND ean13 != '' 08/07/2024 03:33:08 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8027846182228', date_upd = NOW() WHERE id_product = '22737' 08/07/2024 03:33:08 pm >> UPDATE ps_product_lang SET name = 'MEDAGLIA SAN BENEDETTO ARG - RA812', description = '' WHERE id_product = '22737' 08/07/2024 03:33:08 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '16.39344262295082' WHERE id_product = '22737' 08/07/2024 03:33:08 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '16.39344262295082', id_tax_rules_group = '1', id_category_default = '151', 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 = '22737' 08/07/2024 03:33:08 pm >> DELETE FROM ps_specific_price WHERE id_product = '22737' 08/07/2024 03:33:10 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 = '22737' 08/07/2024 03:33:10 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22738' , '1' , '' , 'nuovo-prodotto' ) 08/07/2024 03:33:10 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 '22738' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22737' 08/07/2024 03:33:10 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22738' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22737' 08/07/2024 03:35:46 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002131' AND id_product != '17784' AND ean13 != '' 08/07/2024 03:35:46 pm >> UPDATE ps_product SET id_supplier = '43', reference = '', ean13 = '002131', date_upd = NOW() WHERE id_product = '17784' 08/07/2024 03:35:47 pm >> UPDATE ps_product_lang SET name = 'MEDAGLIA S. BENEDETTO MET. OX - Q1010-OX', description = '' WHERE id_product = '17784' 08/07/2024 03:35:47 pm >> UPDATE ps_product SET wholesale_price = '7.93', on_sale = '0', price = '16.3934' WHERE id_product = '17784' 08/07/2024 03:35:47 pm >> UPDATE ps_product_shop SET wholesale_price = '7.93', price = '16.3934', id_tax_rules_group = '1', id_category_default = '151', 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 = '17784' 08/07/2024 03:35:47 pm >> DELETE FROM ps_specific_price WHERE id_product = '17784' 08/07/2024 03:36:10 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' , '1786' , '2024-07-05' , '' , '0' , '43' , '2638' , 'VIA COSTABIANCA, 43 60025 LORETO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '215.61' , '176.73' , NOW() , NOW() ) 08/07/2024 03:36: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 = '92571' 08/07/2024 03:36:10 pm >> DELETE FROM ps_document_detail WHERE id_document = '92571' 08/07/2024 03:36: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 ( '92571' , '22736' , 'MEDAGLIA CARLO ACUTIS SMALTATA - G474-OX' , '100' , '100' , '1' , '0.29' , '0.23770491803279' , '22' , '10' , '31.8420' ) 08/07/2024 03:36:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22736' AND id_supplier = '43' 08/07/2024 03:36:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22736' , '43' , '1' ) 08/07/2024 03:36: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 ( '92571' , '20964' , 'STATUA SAN MICHELE - ST322-SM' , '1' , '1' , '1' , '5.57' , '4.5655737704918' , '22' , '10' , '6.1159' ) 08/07/2024 03:36:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20964' AND id_supplier = '43' 08/07/2024 03:36:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20964' , '43' , '1' ) 08/07/2024 03:36: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 ( '92571' , '19231' , 'CARD CARLO ACUTIS - RN93' , '100' , '100' , '1' , '0.42' , '0.34426229508197' , '22' , '10' , '46.1160' ) 08/07/2024 03:36:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19231' AND id_supplier = '43' 08/07/2024 03:36:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19231' , '43' , '1' ) 08/07/2024 03:36: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 ( '92571' , '22733' , 'BRACCIALE ELASTICO - RL436/435' , '48' , '48' , '1' , '0.92' , '0.75409836065574' , '22' , '10' , '48.4877' ) 08/07/2024 03:36:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22733' AND id_supplier = '43' 08/07/2024 03:36:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22733' , '43' , '1' ) 08/07/2024 03:36: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 ( '92571' , '22737' , 'MEDAGLIA SAN BENEDETTO ARG - RA812' , '1' , '1' , '1' , '8.6' , '7.0491803278689' , '22' , '10' , '9.4428' ) 08/07/2024 03:36:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22737' AND id_supplier = '43' 08/07/2024 03:36:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22737' , '43' , '1' ) 08/07/2024 03:36: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 ( '92571' , '17607' , 'BRACCIALE BICOLORE ARG.- SL095' , '1' , '1' , '1' , '13.52' , '11.081967213115' , '22' , '10' , '14.8450' ) 08/07/2024 03:36:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17607' AND id_supplier = '43' 08/07/2024 03:36:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17607' , '43' , '1' ) 08/07/2024 03:36: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 ( '92571' , '22735' , 'MEDAGLIA SANTANTONIO - G022-25' , '100' , '100' , '1' , '0.1014' , '0.083114754098361' , '22' , '0' , '12.3708' ) 08/07/2024 03:36:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22735' AND id_supplier = '43' 08/07/2024 03:36:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22735' , '43' , '1' ) 08/07/2024 03:36: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 ( '92571' , '20970' , 'CROCE LEGNO S. BENEDETTO - PG681' , '2' , '2' , '1' , '13.5' , '11.065573770492' , '22' , '10' , '29.6460' ) 08/07/2024 03:36:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20970' AND id_supplier = '43' 08/07/2024 03:36:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20970' , '43' , '1' ) 08/07/2024 03:36: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 ( '92571' , '22734' , 'CROCE SAN BENEDETTO - PG680BR' , '1' , '1' , '1' , '6.9' , '5.655737704918' , '22' , '10' , '7.5762' ) 08/07/2024 03:36:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22734' AND id_supplier = '43' 08/07/2024 03:36:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22734' , '43' , '1' ) 08/07/2024 03:36: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 ( '92571' , '17784' , 'MEDAGLIA S. BENEDETTO MET. OX - Q1010-OX' , '1' , '1' , '1' , '8.35' , '6.844262295082' , '22' , '10' , '9.1683' ) 08/07/2024 03:36:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17784' AND id_supplier = '43' 08/07/2024 03:36:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17784' , '43' , '1' ) 08/07/2024 05:16:20 pm >> SELECT document_num FROM ps_document WHERE document_num = '2223' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-08') 08/07/2024 05:16:20 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' , '2223' , '2024-07-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '55.00' , '45.08' , NOW() , NOW() ) 08/07/2024 05:16:20 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 = '92572' 08/07/2024 05:16:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '92572' 08/07/2024 05:16:20 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 ( '92572' , '14088' , 'CAMICE IN MICROFIBRA - 429/PMA' , '1' , '-1' , '1' , '55' , '45.081967213115' , '22' , '0' , '55.00' ) 08/07/2024 05:53:54 pm >> SELECT document_num FROM ps_document WHERE document_num = '12/A' AND id_document != '90071' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-01-24') 08/07/2024 05:53:54 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '12/A', document_date = '2024-01-24', document_letter = 'A', id_customer = '31', id_supplier = '', id_address = '4670717', address1 = 'VIA LOURDES, 21 14015 SAN DAMIANO D\\\'ASTI', 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 = '1814.40', price_tax_excluded = '1562.95', date_upd = NOW() WHERE id_document = '90071' 08/07/2024 05:53: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 = '90071' 08/07/2024 05:53:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '90071' 08/07/2024 05:53:55 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 ( '90071' , '1041' , 'BENEDIZIONI' , '500' , '-500' , '1' , '0.1800' , '0.14754098360656' , '22' , '40' , '54.00' ) 08/07/2024 05:53:55 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 ( '90071' , '0' , 'spediti il 21/03/2023' , '0' , '0' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 08/07/2024 05:53:55 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 ( '90071' , '12816' , 'LIBRO DEI DEFUNTI' , '2' , '-2' , '1' , '40.0000' , '32.786885245902' , '22' , '40' , '48.00' ) 08/07/2024 05:53:55 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 ( '90071' , '12815' , 'LIBRO DEI CRESIMATI' , '4' , '-4' , '1' , '40.0000' , '32.786885245902' , '22' , '40' , '96.00' ) 08/07/2024 05:53:55 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 ( '90071' , '12818' , 'LIBRO DELLE PRIME COMUNIONI' , '4' , '-4' , '1' , '40.0000' , '32.786885245902' , '22' , '40' , '96.00' ) 08/07/2024 05:53:55 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 ( '90071' , '12849' , 'LIBRO DELLE SS. MESSE' , '6' , '-6' , '1' , '20.0000' , '16.393442622951' , '22' , '40' , '72.00' ) 08/07/2024 05:53:55 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 ( '90071' , '12814' , 'LIBRO DEI BATTEZZATI' , '2' , '-2' , '1' , '40.0000' , '32.786885245902' , '22' , '40' , '48.00' ) 08/07/2024 05:53:55 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 ( '90071' , '0' , 'spedito il 05/04/2023' , '0' , '0' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 08/07/2024 05:53:55 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 ( '90071' , '11105' , 'VANGELO E ATTI DEGLI APOSTOLI PER OCCASIONI' , '200' , '-200' , '4' , '3.5000' , '3.5' , '0' , '40' , '420.00' ) 08/07/2024 05:53:55 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 ( '90071' , '0' , 'spedito 1/6/23' , '0' , '0' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 08/07/2024 05:53:55 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 ( '90071' , '12849' , 'LIBRO DELLE SS. MESSE' , '6' , '-6' , '1' , '20.0000' , '16.393442622951' , '22' , '40' , '72.00' ) 08/07/2024 05:53:55 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 ( '90071' , '0' , 'spedito 2/11/23' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 08/07/2024 05:53:55 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 ( '90071' , '12849' , 'LIBRO DELLE SS. MESSE' , '6' , '-6' , '1' , '20.0000' , '16.393442622951' , '22' , '40' , '72.00' ) 08/07/2024 05:53:55 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 ( '90071' , '12817' , 'LIBRO DEI MATRIMONI' , '3' , '-3' , '1' , '40.0000' , '32.786885245902' , '22' , '40' , '72.00' ) 08/07/2024 05:53:55 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 ( '90071' , '16603' , 'LIBRO INTENZIONI SANTE MESSE' , '2' , '-2' , '1' , '12.0000' , '9.8360655737705' , '22' , '40' , '14.40' ) 08/07/2024 05:53:55 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 ( '90071' , '0' , 'spediti 24/01/2024' , '0' , '0' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 08/07/2024 05:53:55 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 ( '90071' , '12814' , 'LIBRO DEI BATTEZZATI' , '4' , '-4' , '1' , '40.0000' , '32.786885245902' , '22' , '40' , '96.00' ) 08/07/2024 05:53:55 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 ( '90071' , '12816' , 'LIBRO DEI DEFUNTI' , '4' , '-4' , '1' , '40.0000' , '32.786885245902' , '22' , '40' , '96.00' ) 08/07/2024 05:53:55 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 ( '90071' , '12815' , 'LIBRO DEI CRESIMATI' , '4' , '-4' , '1' , '40.0000' , '32.786885245902' , '22' , '40' , '96.00' ) 08/07/2024 05:53:55 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 ( '90071' , '0' , '08/02/2024' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 08/07/2024 05:53:55 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 ( '90071' , '12849' , 'LIBRO DELLE SS. MESSE' , '6' , '-6' , '1' , '20.0000' , '16.393442622951' , '22' , '40' , '72.00' ) 08/07/2024 05:53:55 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 ( '90071' , '0' , '12/04/24' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 08/07/2024 05:53:55 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 ( '90071' , '12849' , 'LIBRO DELLE SS. MESSE' , '6' , '-6' , '1' , '20.0000' , '16.393442622951' , '22' , '40' , '72.00' ) 08/07/2024 05:53:55 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 ( '90071' , '0' , '18/04/2024' , '0' , '0' , '1' , '0.0000' , '0' , '22' , '0' , '0.00' ) 08/07/2024 05:53:55 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 ( '90071' , '13504' , 'SACRAMENTO DELLA RICONCILIAZIONE RAGAZZI' , '100' , '-100' , '1' , '0.3000' , '0.24590163934426' , '22' , '40' , '18.00' ) 08/07/2024 05:53:55 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 ( '90071' , '0' , '03/06/2024' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 08/07/2024 05:53:55 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 ( '90071' , '12849' , 'LIBRO DELLE SS. MESSE' , '5' , '-5' , '1' , '20.0000' , '16.393442622951' , '22' , '40' , '60.00' ) 08/07/2024 05:53:55 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 ( '90071' , '12818' , 'LIBRO DELLE PRIME COMUNIONI' , '3' , '-3' , '1' , '40.0000' , '32.786885245902' , '22' , '40' , '72.00' ) 08/07/2024 05:53:55 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 ( '90071' , '' , 'spediti 09/07/2024' , '0' , '0' , '0' , '0' , '0' , '' , '0' , '0.00' ) 08/07/2024 05:53:55 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 ( '90071' , '12815' , 'LIBRO DEI CRESIMATI' , '2' , '-2' , '1' , '40.00' , '32.786885245902' , '22' , '40' , '48.00' ) 08/07/2024 05:53:55 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 ( '90071' , '12817' , 'LIBRO DEI MATRIMONI' , '2' , '-2' , '1' , '40.00' , '32.786885245902' , '22' , '40' , '48.00' ) 08/07/2024 05:53:55 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 ( '90071' , '12849' , 'LIBRO DELLE SS. MESSE' , '6' , '-6' , '1' , '20.00' , '16.393442622951' , '22' , '40' , '72.00' ) 08/07/2024 06:00:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '2224' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-08') 08/07/2024 06:00:19 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' , '2224' , '2024-07-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 08/07/2024 06:00:19 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 = '92573' 08/07/2024 06:00:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '92573' 08/07/2024 06:00:19 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 ( '92573' , '22414' , 'SULLA TUA PAROLA - LUG/AGO 2024' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' )