22/11/2024 09:05:58 am >> SELECT document_num FROM ps_document WHERE document_num = '3595' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-22') 22/11/2024 09:05:58 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' , '3595' , '2024-11-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '53.00' , '46.14' , NOW() , NOW() ) 22/11/2024 09:05:58 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 = '94420' 22/11/2024 09:05:58 am >> DELETE FROM ps_document_detail WHERE id_document = '94420' 22/11/2024 09:05:58 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 ( '94420' , '19150' , 'MOCCOLO 70X200' , '4' , '-4' , '1' , '8.50' , '6.9672131147541' , '22' , '0' , '34.00' ) 22/11/2024 09:05:58 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 ( '94420' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '3' , '-3' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '10.50' ) 22/11/2024 09:05:58 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 ( '94420' , '18749' , 'OSTIA MAGNA 200mm - OM 200' , '1' , '-1' , '3' , '8.50' , '8.1730769230769' , '4' , '0' , '8.50' ) 22/11/2024 09:22:49 am >> SELECT document_num FROM ps_document WHERE document_num = '3596' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-22') 22/11/2024 09:22:49 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3596' , '2024-11-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '144.50' , '139.83' , NOW() , NOW() ) 22/11/2024 09:22:49 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94421' 22/11/2024 09:22:49 am >> DELETE FROM ps_document_detail WHERE id_document = '94421' 22/11/2024 09:22:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94421' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '2' , '-2' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '7.00' ) 22/11/2024 09:22:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94421' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.30' , '4.1346153846154' , '4' , '0' , '4.30' ) 22/11/2024 09:22:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94421' , '5894' , 'LITURGIA DELLE ORE IV - FRANCESCANA' , '1' , '-1' , '4' , '38.00' , '38' , '0' , '5' , '36.10' ) 22/11/2024 09:22:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94421' , '5893' , 'LITURGIA DELLE ORE III - FRANCESCANA' , '1' , '-1' , '4' , '38.00' , '38' , '0' , '5' , '36.10' ) 22/11/2024 09:22:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94421' , '5892' , 'LITURGIA DELLE ORE II - FRANCESCANA' , '1' , '-1' , '4' , '38.00' , '38' , '0' , '5' , '36.10' ) 22/11/2024 09:22:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94421' , '23169' , 'DILEXIT NOS ' , '1' , '-1' , '4' , '2.20' , '2.2' , '0' , '0' , '2.20' ) 22/11/2024 09:22:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94421' , '23120' , 'AMEN - GEN 25' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '0' , '3.90' ) 22/11/2024 09:22:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94421' , '22698' , 'CALENDARIO LITURGICO 2025' , '1' , '-1' , '4' , '0.80' , '0.8' , '0' , '0' , '0.80' ) 22/11/2024 09:22:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94421' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '18' , '14.754098360656' , '22' , '0' , '18.00' ) 22/11/2024 09:35:59 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884041944' AND id_product != '3388' AND ean13 != '' 22/11/2024 09:35:59 am >> UPDATE ps_product SET id_supplier = '38', reference = 'ESPOSITORE SHALOM', ean13 = '9788884041944', date_upd = NOW() WHERE id_product = '3388' 22/11/2024 09:35:59 am >> UPDATE ps_product_lang SET name = 'DEVOZIONE AL SANTO VOLTO DI GESÙ - 8426', description = '' WHERE id_product = '3388' 22/11/2024 09:35:59 am >> UPDATE ps_product SET wholesale_price = '2.40', on_sale = '0', price = '5' WHERE id_product = '3388' 22/11/2024 09:35:59 am >> UPDATE ps_product_shop SET wholesale_price = '2.40', price = '5', id_tax_rules_group = '4', id_category_default = '106', id_argoment_default = '28', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '3388' 22/11/2024 09:35:59 am >> DELETE FROM ps_specific_price WHERE id_product = '3388' 22/11/2024 09:36:51 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884049766' AND id_product != '22669' AND ean13 != '' 22/11/2024 09:36:51 am >> UPDATE ps_product SET id_supplier = '38', reference = 'ESPOSITORE SHALOM', ean13 = '9788884049766', date_upd = NOW() WHERE id_product = '22669' 22/11/2024 09:36:51 am >> UPDATE ps_product_lang SET name = 'ABBI CURA - 8669', description = '' WHERE id_product = '22669' 22/11/2024 09:36:51 am >> UPDATE ps_product SET wholesale_price = '0.90', on_sale = '0', price = '1.5000' WHERE id_product = '22669' 22/11/2024 09:36:51 am >> UPDATE ps_product_shop SET wholesale_price = '0.90', price = '1.5000', id_tax_rules_group = '4', id_category_default = '106', id_argoment_default = '28', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22669' 22/11/2024 09:36:51 am >> DELETE FROM ps_specific_price WHERE id_product = '22669' 22/11/2024 09:37:36 am >> SELECT document_num FROM ps_document WHERE document_num = '3291' AND id_document != '93988' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-31') 22/11/2024 09:37:36 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3291', document_date = '2024-10-31', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '94.70', price_tax_excluded = '93.84', date_upd = NOW() WHERE id_document = '93988' 22/11/2024 09:37:36 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 = '93988' 22/11/2024 09:37:36 am >> DELETE FROM ps_document_detail WHERE id_document = '93988' 22/11/2024 09:37: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 ( '93988' , '22845' , 'SULLA TUA PAROLA - NOV/DIC 24' , '17' , '-17' , '4' , '5.0000' , '5' , '0' , '5' , '80.75' ) 22/11/2024 09:37: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 ( '93988' , '20428' , 'OSTIA TAGLIO CHIUSO 72MM - OTC25' , '1' , '-1' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '2.00' ) 22/11/2024 09:37: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 ( '93988' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '1' , '-1' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '3.50' ) 22/11/2024 09:37: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 ( '93988' , '17274' , 'VENITE BENEDETTI DEL PADRE MIO' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '5' , '2.85' ) 22/11/2024 09:37: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 ( '93988' , '2448' , 'COLUI IN CUI CREDO' , '1' , '-1' , '4' , '2' , '2' , '0' , '0' , '2.00' ) 22/11/2024 09:37: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 ( '93988' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.6000' , '2.9508196721311' , '22' , '0' , '3.60' ) 22/11/2024 09:38:23 am >> SELECT document_num FROM ps_document WHERE document_num = '3592' AND id_document != '94417' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-21') 22/11/2024 09:38:23 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3592', document_date = '2024-11-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 = '48.92', price_tax_excluded = '48.92', date_upd = NOW() WHERE id_document = '94417' 22/11/2024 09:38: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 = '94417' 22/11/2024 09:38:23 am >> DELETE FROM ps_document_detail WHERE id_document = '94417' 22/11/2024 09:38: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 ( '94417' , '3388' , 'DEVOZIONE AL SANTO VOLTO DI GESÙ - 8426' , '2' , '-2' , '4' , '4.0000' , '4' , '0' , '5' , '7.60' ) 22/11/2024 09:38: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 ( '94417' , '22118' , 'PIEGHEVOLE LA MEDAGLIA MIRACOLOSA' , '1' , '-1' , '4' , '0.8000' , '0.8' , '0' , '0' , '0.80' ) 22/11/2024 09:38: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 ( '94417' , '7109' , 'NOVENA ALLIMMACOLATA CONCEZIONE - 8520' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '5' , '2.85' ) 22/11/2024 09:38: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 ( '94417' , '7108' , 'NOVENA AL SANTO NATALE - 8521' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '5' , '1.90' ) 22/11/2024 09:38: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 ( '94417' , '20719' , 'CORONA DELL’ADDOLORATA' , '1' , '-1' , '4' , '1.8000' , '1.8' , '0' , '5' , '1.71' ) 22/11/2024 09:38: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 ( '94417' , '22669' , 'ABBI CURA - 8669' , '1' , '-1' , '4' , '1.5000' , '1.5' , '0' , '5' , '1.43' ) 22/11/2024 09:38: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 ( '94417' , '1829' , 'CATECHISMO PRIMARIO DEI SACRAMENTI' , '1' , '-1' , '4' , '1.9' , '1.9' , '0' , '0' , '1.90' ) 22/11/2024 09:38: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 ( '94417' , '6629' , 'MIA PREGHIERA' , '1' , '-1' , '4' , '0.9000' , '0.9' , '0' , '0' , '0.90' ) 22/11/2024 09:38: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 ( '94417' , '7098' , 'NOVENA A MARIA CHE SCIOGLIE I NODI - 8558' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '5' , '2.85' ) 22/11/2024 09:38: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 ( '94417' , '7111' , 'NOVENA ALLA MADONNA CHE SCIOGLIE I NODI' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '5' , '2.85' ) 22/11/2024 09:38: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 ( '94417' , '15020' , 'PREGARE OGNI GIORNO' , '1' , '-1' , '4' , '1.0000' , '1' , '0' , '0' , '1.00' ) 22/11/2024 09:38: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 ( '94417' , '15019' , 'PREGHIAMO CON MARIA' , '1' , '-1' , '4' , '0.8000' , '0.8' , '0' , '0' , '0.80' ) 22/11/2024 09:38:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94417' , '17124' , '100 PREGHIERE N.E. - A. COMASTRI' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '5' , '9.50' ) 22/11/2024 09:38:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94417' , '16175' , 'MALATTIA, SOFFERENZA E UNZIONE DEGLI INFERMI - PAPA FRANCESCO' , '1' , '-1' , '4' , '8.5000' , '8.5' , '0' , '5' , '8.08' ) 22/11/2024 09:38:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94417' , '16220' , 'GUARISCIMI LIBERAMI CONSOLAMI' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 22/11/2024 09:40:00 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788872982471' AND id_product != '17124' AND ean13 != '' 22/11/2024 09:40:00 am >> UPDATE ps_product SET id_supplier = '7', reference = '13/4', ean13 = '9788872982471', date_upd = NOW() WHERE id_product = '17124' 22/11/2024 09:40:00 am >> UPDATE ps_product_lang SET name = '100 PREGHIERE N.E. - A. COMASTRI', description = '' WHERE id_product = '17124' 22/11/2024 09:40:00 am >> UPDATE ps_product SET wholesale_price = '7.00', on_sale = '0', price = '10.0000' WHERE id_product = '17124' 22/11/2024 09:40:00 am >> UPDATE ps_product_shop SET wholesale_price = '7.00', price = '10.0000', id_tax_rules_group = '4', id_category_default = '518', id_argoment_default = '28', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '17124' 22/11/2024 09:40:00 am >> DELETE FROM ps_specific_price WHERE id_product = '17124' 22/11/2024 10:03:33 am >> SELECT document_num FROM ps_document WHERE document_num = '3494' AND id_document != '94283' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-15') 22/11/2024 10:03:33 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3494', document_date = '2024-11-15', 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 = '43.50', price_tax_excluded = '35.66', date_upd = NOW() WHERE id_document = '94283' 22/11/2024 10:03: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 = '94283' 22/11/2024 10:03:33 am >> DELETE FROM ps_document_detail WHERE id_document = '94283' 22/11/2024 10:03: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 ( '94283' , '19819' , 'INCENSO NATURALE 1 ST GRADE - KG 1' , '1' , '-1' , '1' , '27.0000' , '22.131147540984' , '22' , '0' , '27.00' ) 22/11/2024 10:03: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 ( '94283' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '16.5' , '13.524590163934' , '22' , '0' , '16.50' ) 22/11/2024 10:04:19 am >> SELECT document_num FROM ps_document WHERE document_num = '3597' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-22') 22/11/2024 10:04:19 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' , '3597' , '2024-11-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.10' , '15.10' , NOW() , NOW() ) 22/11/2024 10:04:19 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 = '94422' 22/11/2024 10:04:19 am >> DELETE FROM ps_document_detail WHERE id_document = '94422' 22/11/2024 10:04:19 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 ( '94422' , '23219' , 'ORDO MISSAE' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 22/11/2024 10:04:19 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 ( '94422' , '5458' , 'IO SONO CON VOI 2 PARTE' , '2' , '-2' , '4' , '2.80' , '2.8' , '0' , '0' , '5.60' ) 22/11/2024 10:15:56 am >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'encSmPWVlAznao2T' , NOW() , NOW() ) 22/11/2024 10:15:56 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4146' , '1' ) 22/11/2024 10:15:56 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4146' , '2' ) 22/11/2024 10:15:56 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4146' , '3' ) 22/11/2024 10:17:58 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4146' 22/11/2024 10:17:58 am >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '4146' , '10' , '130' , 'PARR. SS. VITO E STEFANO' , 'LEPRE' , 'DON GERARDO' , 'CORSO PIETRO ASCOLESE - FRAZ. PIAZZA DI PANDOLA' , '' , '83025' , 'MONTORO INFERIORE' , '' , '' , '3405592733' , '' , '' , NOW() , NOW() ) 22/11/2024 10:17:58 am >> UPDATE ps_customer SET email = 'dongerardolepre@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4146' 22/11/2024 10:22:06 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4146' 22/11/2024 10:22:06 am >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '4146' , '10' , '130' , 'PARR. SS. VITO E STEFANO' , 'LEPRE' , 'DON GERARDO' , 'CORSO PIETRO ASCOLESE - FRAZ. PIAZZA DI PANDOLA' , '' , '83025' , 'MONTORO INFERIORE' , '' , '' , '3405592733' , '' , '92009940641' , NOW() , NOW() ) 22/11/2024 10:22:06 am >> UPDATE ps_customer SET email = 'dongerardolepre@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4146' 22/11/2024 10:22:22 am >> SELECT document_num FROM ps_document WHERE document_num = '249' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-11-22') 22/11/2024 10:22:22 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '249' , '2024-11-22' , '' , '4146' , '0' , '4679438' , 'CORSO PIETRO ASCOLESE - FRAZ. PIAZZA DI PANDOLA 83025 MONTORO INFERIORE' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '262.74' , '262.74' , NOW() , NOW() ) 22/11/2024 10:22:22 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 = '94423' 22/11/2024 10:22:22 am >> DELETE FROM ps_document_detail WHERE id_document = '94423' 22/11/2024 10:22:22 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 ( '94423' , '2679' , 'CONOSCERE GESU\'' , '11' , '-11' , '4' , '3.50' , '3.5' , '0' , '15' , '32.73' ) 22/11/2024 10:22:22 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 ( '94423' , '2680' , 'CONOSCERE GESU\' - GUIDA' , '1' , '-1' , '4' , '6.00' , '6' , '0' , '15' , '5.10' ) 22/11/2024 10:22:22 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 ( '94423' , '8511' , 'PRIMI PASSI CON GESÙ - ANNO C' , '15' , '-15' , '4' , '3.40' , '3.4' , '0' , '15' , '43.35' ) 22/11/2024 10:22:22 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 ( '94423' , '8515' , 'PRIMI PASSI CON GESÙ ANNO C - GUIDA' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '15' , '4.25' ) 22/11/2024 10:22:22 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 ( '94423' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '17' , '-17' , '4' , '3.80' , '3.8' , '0' , '15' , '54.91' ) 22/11/2024 10:22:22 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 ( '94423' , '4393' , 'GESÙ CI CHIAMA 1 - GUIDA' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '15' , '8.50' ) 22/11/2024 10:22:22 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 ( '94423' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '13' , '-13' , '4' , '3.80' , '3.8' , '0' , '15' , '41.99' ) 22/11/2024 10:22:22 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 ( '94423' , '4396' , 'GESÙ CI RIVELA IL PADRE 2 - GUIDA' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '15' , '8.50' ) 22/11/2024 10:22:22 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 ( '94423' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '17' , '-17' , '4' , '3.80' , '3.8' , '0' , '15' , '54.91' ) 22/11/2024 10:22:22 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 ( '94423' , '4494' , 'GESÙ RESTA CON NOI 3 - GUIDA' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '15' , '8.50' ) 22/11/2024 10:22:48 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '2878' 22/11/2024 10:22:48 am >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '2878' , '10' , '210' , 'PARROCCHIA SS. ANNUNZIATA IN COSTA' , 'MASCIA' , 'DON GIOVANNI' , 'VIA FERROVIA VALLE, 20' , '' , '84085' , 'COSTA - MERCATO S. SEVERINO' , '' , '' , '' , '' , '97000030656' , NOW() , NOW() ) 22/11/2024 10:22:48 am >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '2878' 22/11/2024 10:28:39 am >> SELECT document_num FROM ps_document WHERE document_num = '3598' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-22') 22/11/2024 10:28:39 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' , '3598' , '2024-11-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '360.00' , '295.08' , NOW() , NOW() ) 22/11/2024 10:28:39 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 = '94424' 22/11/2024 10:28:39 am >> DELETE FROM ps_document_detail WHERE id_document = '94424' 22/11/2024 10:28:39 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 ( '94424' , '797' , 'ASTUCCIO CON 3 VASETTI - 1759/3' , '1' , '-1' , '1' , '360' , '295.08196721311' , '22' , '0' , '360.00' ) 22/11/2024 10:28:53 am >> SELECT document_num FROM ps_document WHERE document_num = '3599' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-22') 22/11/2024 10:28:53 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' , '3599' , '2024-11-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.50' , '7.79' , NOW() , NOW() ) 22/11/2024 10:28:53 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 = '94425' 22/11/2024 10:28:53 am >> DELETE FROM ps_document_detail WHERE id_document = '94425' 22/11/2024 10:28:53 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 ( '94425' , '22910' , 'AGENDA DEVOZIONALE 2025 - 40822' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '5' , '9.50' ) 22/11/2024 10:37:07 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 22/11/2024 10:37:07 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23242' , '1' , '' , 'nuovo-prodotto' ) 22/11/2024 10:37:07 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '23242' , '1' , '1' , '2' , NOW() , NOW() ) 22/11/2024 10:37:07 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '23242' , '0' , '1' , '0' , '0' ) 22/11/2024 10:37:55 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002329' AND id_product != '23242' AND ean13 != '' 22/11/2024 10:37:55 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002329', date_upd = NOW() WHERE id_product = '23242' 22/11/2024 10:37:55 am >> UPDATE ps_product_lang SET name = 'VELO OMERALE - V2P124', description = '' WHERE id_product = '23242' 22/11/2024 10:37:55 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '137.70491803278688' WHERE id_product = '23242' 22/11/2024 10:37:55 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '137.70491803278688', id_tax_rules_group = '1', id_category_default = '539', 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 = '23242' 22/11/2024 10:37:55 am >> DELETE FROM ps_specific_price WHERE id_product = '23242' 22/11/2024 10:38:02 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '23242' 22/11/2024 10:38:02 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23243' , '1' , '' , 'nuovo-prodotto' ) 22/11/2024 10:38:02 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '23243' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23242' 22/11/2024 10:38:02 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23243' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23242' 22/11/2024 10:39:06 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 ( '31' , 'FAR/453' , '2024-11-20' , '453' , '0' , '187' , '4679290' , 'VIA G. B. STUCCHI 62/27 20900 MONZA' , '' , '' , '13' , '1' , '0' , '0' , '0' , '' , '3' , '0' , '308.66' , '253.00' , NOW() , NOW() ) 22/11/2024 10:39:06 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 = '94426' 22/11/2024 10:39:06 am >> DELETE FROM ps_document_detail WHERE id_document = '94426' 22/11/2024 10:39:06 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 ( '94426' , '22777' , 'CASULA - C2P712' , '1' , '1' , '1' , '171' , '140.16393442623' , '22' , '0' , '208.6200' ) 22/11/2024 10:39:06 am >> DELETE FROM ps_product_supplier WHERE id_product = '22777' AND id_supplier = '187' 22/11/2024 10:39:06 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22777' , '187' , '1' ) 22/11/2024 10:39:06 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 ( '94426' , '23242' , 'VELO OMERALE - V2P124' , '1' , '1' , '1' , '69' , '56.55737704918' , '22' , '0' , '84.1800' ) 22/11/2024 10:39:06 am >> DELETE FROM ps_product_supplier WHERE id_product = '23242' AND id_supplier = '187' 22/11/2024 10:39:06 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23242' , '187' , '1' ) 22/11/2024 10:56:25 am >> SELECT document_num FROM ps_document WHERE document_num = '3600' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-22') 22/11/2024 10:56:25 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' , '3600' , '2024-11-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '0.80' , '0.80' , NOW() , NOW() ) 22/11/2024 10:56:25 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 = '94427' 22/11/2024 10:56:25 am >> DELETE FROM ps_document_detail WHERE id_document = '94427' 22/11/2024 10:56:25 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 ( '94427' , '22698' , 'CALENDARIO LITURGICO 2025' , '1' , '-1' , '4' , '0.80' , '0.8' , '0' , '0' , '0.80' ) 22/11/2024 10:57:52 am >> SELECT document_num FROM ps_document WHERE document_num = '3601' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-22') 22/11/2024 10:57:52 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3601' , '2024-11-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '18.40' , '15.71' , NOW() , NOW() ) 22/11/2024 10:57:52 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94428' 22/11/2024 10:57:52 am >> DELETE FROM ps_document_detail WHERE id_document = '94428' 22/11/2024 10:57:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94428' , '9675' , 'SARETE MIEI TESTIMONI' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '0' , '3.50' ) 22/11/2024 10:57:53 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 ( '94428' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '14.9' , '12.213114754098' , '22' , '0' , '14.90' ) 22/11/2024 10:58:26 am >> SELECT document_num FROM ps_document WHERE document_num = '3602' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-22') 22/11/2024 10:58:26 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' , '3602' , '2024-11-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '56.40' , '46.23' , NOW() , NOW() ) 22/11/2024 10:58:26 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 = '94429' 22/11/2024 10:58:26 am >> DELETE FROM ps_document_detail WHERE id_document = '94429' 22/11/2024 10:58:26 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 ( '94429' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 22/11/2024 10:59:09 am >> SELECT document_num FROM ps_document WHERE document_num = '250' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-11-22') 22/11/2024 10:59:09 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '250' , '2024-11-22' , '' , '3351' , '0' , '4671704' , 'VIA SERRACAPILLI 84025 EBOLI ' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '40.80' , '40.80' , NOW() , NOW() ) 22/11/2024 10:59:09 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 = '94430' 22/11/2024 10:59:09 am >> DELETE FROM ps_document_detail WHERE id_document = '94430' 22/11/2024 10:59:09 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 ( '94430' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '20' , '-20' , '4' , '2.40' , '2.4' , '0' , '15' , '40.80' ) 22/11/2024 11:00:39 am >> SELECT document_num FROM ps_document WHERE document_num = '250' AND id_document != '94430' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-11-22') 22/11/2024 11:00:39 am >> UPDATE ps_document SET id_document_type = '21', document_num = '250', document_date = '2024-11-22', document_letter = '', id_customer = '3351', id_supplier = '', id_address = '4671704', address1 = 'VIA SERRACAPILLI 84025 EBOLI ', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '40.80', price_tax_excluded = '40.80', date_upd = NOW() WHERE id_document = '94430' 22/11/2024 11:00:39 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 = '94430' 22/11/2024 11:00:39 am >> DELETE FROM ps_document_detail WHERE id_document = '94430' 22/11/2024 11:00:39 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 ( '94430' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '20' , '-20' , '4' , '2.4000' , '2.4' , '0' , '15' , '40.80' ) 22/11/2024 11:02:55 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788851429393' AND id_product != '23243' AND ean13 != '' 22/11/2024 11:02:55 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788851429393', date_upd = NOW() WHERE id_product = '23243' 22/11/2024 11:02:55 am >> UPDATE ps_product_lang SET name = 'NATALE PER SPERARE', description = '' WHERE id_product = '23243' 22/11/2024 11:02:55 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '4.5' WHERE id_product = '23243' 22/11/2024 11:02:55 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '4.5', id_tax_rules_group = '4', id_category_default = '98', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23243' 22/11/2024 11:02:55 am >> DELETE FROM ps_specific_price WHERE id_product = '23243' 22/11/2024 11:02:56 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '23243' 22/11/2024 11:02:56 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23244' , '1' , '' , 'nuovo-prodotto' ) 22/11/2024 11:02:56 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '23244' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23243' 22/11/2024 11:02:56 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23244' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23243' 22/11/2024 11:03:28 am >> SELECT ean13 FROM ps_product WHERE ean13 = '8051739458015' AND id_product != '23244' AND ean13 != '' 22/11/2024 11:03:28 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8051739458015', date_upd = NOW() WHERE id_product = '23244' 22/11/2024 11:03:28 am >> UPDATE ps_product_lang SET name = 'INSIEME NELLA MESSA - FEB 2025', description = '' WHERE id_product = '23244' 22/11/2024 11:03:28 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '1.8' WHERE id_product = '23244' 22/11/2024 11:03:28 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '1.8', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '64', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23244' 22/11/2024 11:03:28 am >> DELETE FROM ps_specific_price WHERE id_product = '23244' 22/11/2024 11:03:29 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '23244' 22/11/2024 11:03:29 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23245' , '1' , '' , 'nuovo-prodotto' ) 22/11/2024 11:03:29 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '23245' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23244' 22/11/2024 11:03:29 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23245' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23244' 22/11/2024 11:03:52 am >> SELECT ean13 FROM ps_product WHERE ean13 = '8051739457896' AND id_product != '23245' AND ean13 != '' 22/11/2024 11:03:52 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8051739457896', date_upd = NOW() WHERE id_product = '23245' 22/11/2024 11:03:52 am >> UPDATE ps_product_lang SET name = 'PAROLA E PREGHIERA - FEB 2025', description = '' WHERE id_product = '23245' 22/11/2024 11:03:52 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '2.9' WHERE id_product = '23245' 22/11/2024 11:03:52 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '2.9', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '64', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23245' 22/11/2024 11:03:52 am >> DELETE FROM ps_specific_price WHERE id_product = '23245' 22/11/2024 11:03:53 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '23245' 22/11/2024 11:03:53 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23246' , '1' , '' , 'nuovo-prodotto' ) 22/11/2024 11:03:53 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '23246' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23245' 22/11/2024 11:03:53 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23246' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23245' 22/11/2024 11:04:42 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892246102' AND id_product != '23246' AND ean13 != '' 22/11/2024 11:04:42 am >> UPDATE ps_product SET id_supplier = '', reference = '11/3', ean13 = '9788892246102', date_upd = NOW() WHERE id_product = '23246' 22/11/2024 11:04:42 am >> UPDATE ps_product_lang SET name = 'CANTI NUOVI - TUROLDO/RAVASI', description = '' WHERE id_product = '23246' 22/11/2024 11:04:42 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '25' WHERE id_product = '23246' 22/11/2024 11:04:42 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '25', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '20', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23246' 22/11/2024 11:04:42 am >> DELETE FROM ps_specific_price WHERE id_product = '23246' 22/11/2024 11:04:43 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '23246' 22/11/2024 11:04:43 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23247' , '1' , '' , 'nuovo-prodotto' ) 22/11/2024 11:04:43 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '23247' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23246' 22/11/2024 11:04:43 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23247' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23246' 22/11/2024 11:05:33 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892246072' AND id_product != '23247' AND ean13 != '' 22/11/2024 11:05:33 am >> UPDATE ps_product SET id_supplier = '', reference = '7/2', ean13 = '9788892246072', date_upd = NOW() WHERE id_product = '23247' 22/11/2024 11:05:33 am >> UPDATE ps_product_lang SET name = 'ASCOLTARLO ERA RIMANERE ACCESI - ANNO C - E. RONCHI', description = '' WHERE id_product = '23247' 22/11/2024 11:05:33 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '20' WHERE id_product = '23247' 22/11/2024 11:05:33 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '20', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '64', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23247' 22/11/2024 11:05:33 am >> DELETE FROM ps_specific_price WHERE id_product = '23247' 22/11/2024 11:05:34 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '23247' 22/11/2024 11:05:34 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23248' , '1' , '' , 'nuovo-prodotto' ) 22/11/2024 11:05:34 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '23248' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23247' 22/11/2024 11:05:34 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23248' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23247' 22/11/2024 11:06:24 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791256450138' AND id_product != '23248' AND ean13 != '' 22/11/2024 11:06:24 am >> UPDATE ps_product SET id_supplier = '', reference = '7/2', ean13 = '9791256450138', date_upd = NOW() WHERE id_product = '23248' 22/11/2024 11:06:24 am >> UPDATE ps_product_lang SET name = 'COMMENTO AL VANGELO DEL GIORNO - ANNO C - A. SPINA', description = '' WHERE id_product = '23248' 22/11/2024 11:06:24 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '18' WHERE id_product = '23248' 22/11/2024 11:06:24 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '18', id_tax_rules_group = '4', id_category_default = '98', id_argoment_default = '64', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23248' 22/11/2024 11:06:24 am >> DELETE FROM ps_specific_price WHERE id_product = '23248' 22/11/2024 11:06:25 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '23248' 22/11/2024 11:06:25 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23249' , '1' , '' , 'nuovo-prodotto' ) 22/11/2024 11:06:25 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '23249' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23248' 22/11/2024 11:06:25 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23249' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23248' 22/11/2024 11:07:07 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788851429232' AND id_product != '23249' AND ean13 != '' 22/11/2024 11:07:07 am >> UPDATE ps_product SET id_supplier = '', reference = '6/7', ean13 = '9788851429232', date_upd = NOW() WHERE id_product = '23249' 22/11/2024 11:07:07 am >> UPDATE ps_product_lang SET name = 'SPERANZA - G. CUCCI', description = '' WHERE id_product = '23249' 22/11/2024 11:07:07 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '13' WHERE id_product = '23249' 22/11/2024 11:07:07 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '13', id_tax_rules_group = '4', id_category_default = '98', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23249' 22/11/2024 11:07:07 am >> DELETE FROM ps_specific_price WHERE id_product = '23249' 22/11/2024 11:07:08 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '23249' 22/11/2024 11:07:08 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23250' , '1' , '' , 'nuovo-prodotto' ) 22/11/2024 11:07:08 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '23250' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23249' 22/11/2024 11:07:08 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23250' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23249' 22/11/2024 11:07:54 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788851429355' AND id_product != '23250' AND ean13 != '' 22/11/2024 11:07:54 am >> UPDATE ps_product SET id_supplier = '', reference = '7/2', ean13 = '9788851429355', date_upd = NOW() WHERE id_product = '23250' 22/11/2024 11:07:54 am >> UPDATE ps_product_lang SET name = 'PREGANDO LA PAROLA - ANNO C - M. TELLAN', description = '' WHERE id_product = '23250' 22/11/2024 11:07:54 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '16' WHERE id_product = '23250' 22/11/2024 11:07:54 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '16', id_tax_rules_group = '4', id_category_default = '98', id_argoment_default = '64', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23250' 22/11/2024 11:07:54 am >> DELETE FROM ps_specific_price WHERE id_product = '23250' 22/11/2024 11:07:55 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '23250' 22/11/2024 11:07:55 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23251' , '1' , '' , 'nuovo-prodotto' ) 22/11/2024 11:07:55 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '23251' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23250' 22/11/2024 11:07:55 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23251' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23250' 22/11/2024 11:08:47 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892245556' AND id_product != '23251' AND ean13 != '' 22/11/2024 11:08:47 am >> UPDATE ps_product SET id_supplier = '', reference = '6/6', ean13 = '9788892245556', date_upd = NOW() WHERE id_product = '23251' 22/11/2024 11:08:47 am >> UPDATE ps_product_lang SET name = 'ANGELI CON UN\'ALA SOLTANTO - TONINO BELLO', description = '' WHERE id_product = '23251' 22/11/2024 11:08:47 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '18' WHERE id_product = '23251' 22/11/2024 11:08:47 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '18', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '23', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23251' 22/11/2024 11:08:47 am >> DELETE FROM ps_specific_price WHERE id_product = '23251' 22/11/2024 11:08:48 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '23251' 22/11/2024 11:08:48 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23252' , '1' , '' , 'nuovo-prodotto' ) 22/11/2024 11:08:48 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '23252' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23251' 22/11/2024 11:08:48 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23252' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23251' 22/11/2024 11:09:36 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788839932396' AND id_product != '23252' AND ean13 != '' 22/11/2024 11:09:36 am >> UPDATE ps_product SET id_supplier = '', reference = '7/1', ean13 = '9788839932396', date_upd = NOW() WHERE id_product = '23252' 22/11/2024 11:09:36 am >> UPDATE ps_product_lang SET name = 'BREVE INTRODUZIONE AL CRISTIANESIMO - J. RATZINGER', description = '' WHERE id_product = '23252' 22/11/2024 11:09:36 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '0.0000' WHERE id_product = '23252' 22/11/2024 11:09:36 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '0.0000', id_tax_rules_group = '4', id_category_default = '111', id_argoment_default = '65', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23252' 22/11/2024 11:09:36 am >> DELETE FROM ps_specific_price WHERE id_product = '23252' 22/11/2024 11:09:37 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '23252' 22/11/2024 11:09:37 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23253' , '1' , '' , 'nuovo-prodotto' ) 22/11/2024 11:09:37 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '23253' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23252' 22/11/2024 11:09:37 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23253' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23252' 22/11/2024 11:10:16 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788839931382' AND id_product != '23253' AND ean13 != '' 22/11/2024 11:10:16 am >> UPDATE ps_product SET id_supplier = '', reference = 'GONDOLA 2', ean13 = '9788839931382', date_upd = NOW() WHERE id_product = '23253' 22/11/2024 11:10:16 am >> UPDATE ps_product_lang SET name = 'PAROLE CHIAVE PER L\'AVVENTO - R. LAURITA', description = '' WHERE id_product = '23253' 22/11/2024 11:10:16 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '5' WHERE id_product = '23253' 22/11/2024 11:10:16 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '5', id_tax_rules_group = '4', id_category_default = '111', id_argoment_default = '39', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23253' 22/11/2024 11:10:16 am >> DELETE FROM ps_specific_price WHERE id_product = '23253' 22/11/2024 11:10:17 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '23253' 22/11/2024 11:10:17 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23254' , '1' , '' , 'nuovo-prodotto' ) 22/11/2024 11:10:17 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '23254' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23253' 22/11/2024 11:10:18 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23254' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23253' 22/11/2024 11:10:53 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788839932860' AND id_product != '23254' AND ean13 != '' 22/11/2024 11:10:53 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788839932860', date_upd = NOW() WHERE id_product = '23254' 22/11/2024 11:10:53 am >> UPDATE ps_product_lang SET name = 'UN NATALE INCONTENIBILE - A. SCHWARZ', description = '' WHERE id_product = '23254' 22/11/2024 11:10:53 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '12' WHERE id_product = '23254' 22/11/2024 11:10:53 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '12', id_tax_rules_group = '4', id_category_default = '111', id_argoment_default = '39', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23254' 22/11/2024 11:10:53 am >> DELETE FROM ps_specific_price WHERE id_product = '23254' 22/11/2024 11:10:54 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '23254' 22/11/2024 11:10:54 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23255' , '1' , '' , 'nuovo-prodotto' ) 22/11/2024 11:10:54 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '23255' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23254' 22/11/2024 11:10:54 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23255' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23254' 22/11/2024 11:11:43 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788825058307' AND id_product != '23255' AND ean13 != '' 22/11/2024 11:11:43 am >> UPDATE ps_product SET id_supplier = '', reference = '7/5', ean13 = '9788825058307', date_upd = NOW() WHERE id_product = '23255' 22/11/2024 11:11:43 am >> UPDATE ps_product_lang SET name = 'MARIA DONNA DI SPERANZA - GALIAZZO/RAMINA', description = '' WHERE id_product = '23255' 22/11/2024 11:11:43 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '20' WHERE id_product = '23255' 22/11/2024 11:11:43 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '20', id_tax_rules_group = '4', id_category_default = '17', id_argoment_default = '23', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23255' 22/11/2024 11:11:43 am >> DELETE FROM ps_specific_price WHERE id_product = '23255' 22/11/2024 11:11:44 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '23255' 22/11/2024 11:11:44 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23256' , '1' , '' , 'nuovo-prodotto' ) 22/11/2024 11:11:44 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '23256' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23255' 22/11/2024 11:11:44 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23256' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23255' 22/11/2024 11:13:24 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '682673' , '2024-11-22' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '3.7' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '124.88' , '124.88' , NOW() , NOW() ) 22/11/2024 11:13:24 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94431' 22/11/2024 11:13:24 am >> DELETE FROM ps_document_detail WHERE id_document = '94431' 22/11/2024 11:13:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94431' , '23165' , 'DILEXIT NOS' , '24' , '24' , '4' , '2.20' , '2.2' , '0' , '33' , '35.3760' ) 22/11/2024 11:13:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '23165' AND id_supplier = '7' 22/11/2024 11:13:25 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23165' , '7' , '1' ) 22/11/2024 11:13:25 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 ( '94431' , '23165' , 'DILEXIT NOS' , '2' , '2' , '4' , '2.20' , '2.2' , '0' , '100' , '0.0000' ) 22/11/2024 11:13:25 am >> DELETE FROM ps_product_supplier WHERE id_product = '23165' AND id_supplier = '7' 22/11/2024 11:13:25 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23165' , '7' , '1' ) 22/11/2024 11:13:25 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 ( '94431' , '23169' , 'DILEXIT NOS ' , '60' , '60' , '4' , '2.20' , '2.2' , '0' , '35' , '85.8000' ) 22/11/2024 11:13:25 am >> DELETE FROM ps_product_supplier WHERE id_product = '23169' AND id_supplier = '7' 22/11/2024 11:13:25 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23169' , '7' , '1' ) 22/11/2024 11:13:25 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 ( '94431' , '23169' , 'DILEXIT NOS ' , '5' , '5' , '4' , '2.20' , '2.2' , '0' , '100' , '0.0000' ) 22/11/2024 11:13:25 am >> DELETE FROM ps_product_supplier WHERE id_product = '23169' AND id_supplier = '7' 22/11/2024 11:13:25 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23169' , '7' , '1' ) 22/11/2024 11:15:38 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '682673' , '2024-11-20' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '3.70' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '124.88' , '124.88' , NOW() , NOW() ) 22/11/2024 11:15:38 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 = '94432' 22/11/2024 11:15:38 am >> DELETE FROM ps_document_detail WHERE id_document = '94432' 22/11/2024 11:15:38 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 ( '94432' , '23165' , 'DILEXIT NOS' , '24' , '24' , '4' , '2.2000' , '2.2' , '0' , '33' , '35.38' ) 22/11/2024 11:15:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '23165' AND id_supplier = '7' 22/11/2024 11:15:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23165' , '7' , '1' ) 22/11/2024 11:15:38 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 ( '94432' , '23165' , 'DILEXIT NOS' , '2' , '2' , '4' , '2.2000' , '2.2' , '0' , '100' , '0.00' ) 22/11/2024 11:15:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '23165' AND id_supplier = '7' 22/11/2024 11:15:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23165' , '7' , '1' ) 22/11/2024 11:15:38 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 ( '94432' , '23169' , 'DILEXIT NOS ' , '60' , '60' , '4' , '2.2000' , '2.2' , '0' , '35' , '85.80' ) 22/11/2024 11:15:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '23169' AND id_supplier = '7' 22/11/2024 11:15:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23169' , '7' , '1' ) 22/11/2024 11:15:38 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 ( '94432' , '23169' , 'DILEXIT NOS ' , '5' , '5' , '4' , '2.2000' , '2.2' , '0' , '100' , '0.00' ) 22/11/2024 11:15:39 am >> DELETE FROM ps_product_supplier WHERE id_product = '23169' AND id_supplier = '7' 22/11/2024 11:15:39 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23169' , '7' , '1' ) 22/11/2024 11:15:46 am >> DELETE FROM ps_document WHERE id_document = '94431' 22/11/2024 11:15:47 am >> DELETE FROM ps_document_detail WHERE id_document = '94431' 22/11/2024 11:18:24 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788839932396' AND id_product != '23252' AND ean13 != '' 22/11/2024 11:18:24 am >> UPDATE ps_product SET id_supplier = '', reference = '7/1', ean13 = '9788839932396', date_upd = NOW() WHERE id_product = '23252' 22/11/2024 11:18:24 am >> UPDATE ps_product_lang SET name = 'BREVE INTRODUZIONE AL CRISTIANESIMO - J. RATZINGER', description = '' WHERE id_product = '23252' 22/11/2024 11:18:24 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '18' WHERE id_product = '23252' 22/11/2024 11:18:25 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '18', id_tax_rules_group = '4', id_category_default = '111', id_argoment_default = '65', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23252' 22/11/2024 11:18:25 am >> DELETE FROM ps_specific_price WHERE id_product = '23252' 22/11/2024 11:18:48 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '682399' , '2024-11-22' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '3.75' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '131.50' , '131.50' , NOW() , NOW() ) 22/11/2024 11:18:48 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 = '94433' 22/11/2024 11:18:49 am >> DELETE FROM ps_document_detail WHERE id_document = '94433' 22/11/2024 11:18:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94433' , '23244' , 'INSIEME NELLA MESSA - FEB 2025' , '1' , '1' , '4' , '1.80' , '1.8' , '0' , '33' , '1.2060' ) 22/11/2024 11:18:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '23244' AND id_supplier = '7' 22/11/2024 11:18:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23244' , '7' , '1' ) 22/11/2024 11:18:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94433' , '23245' , 'PAROLA E PREGHIERA - FEB 2025' , '4' , '4' , '4' , '2.90' , '2.9' , '0' , '33' , '7.7720' ) 22/11/2024 11:18:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '23245' AND id_supplier = '7' 22/11/2024 11:18:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23245' , '7' , '1' ) 22/11/2024 11:18:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94433' , '23243' , 'NATALE PER SPERARE' , '2' , '2' , '4' , '4.50' , '4.5' , '0' , '33' , '6.0300' ) 22/11/2024 11:18:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '23243' AND id_supplier = '7' 22/11/2024 11:18:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23243' , '7' , '1' ) 22/11/2024 11:18:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94433' , '23249' , 'SPERANZA - G. CUCCI' , '1' , '1' , '4' , '13.00' , '13' , '0' , '33' , '8.7100' ) 22/11/2024 11:18:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '23249' AND id_supplier = '7' 22/11/2024 11:18:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23249' , '7' , '1' ) 22/11/2024 11:18:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94433' , '23250' , 'PREGANDO LA PAROLA - ANNO C - M. TELLAN' , '1' , '1' , '4' , '16.00' , '16' , '0' , '33' , '10.7200' ) 22/11/2024 11:18:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '23250' AND id_supplier = '7' 22/11/2024 11:18:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23250' , '7' , '1' ) 22/11/2024 11:18:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94433' , '23247' , 'ASCOLTARLO ERA RIMANERE ACCESI - ANNO C - E. RONCHI' , '1' , '1' , '4' , '20.00' , '20' , '0' , '33' , '13.4000' ) 22/11/2024 11:18:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '23247' AND id_supplier = '7' 22/11/2024 11:18:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23247' , '7' , '1' ) 22/11/2024 11:18:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94433' , '23246' , 'CANTI NUOVI - TUROLDO/RAVASI' , '1' , '1' , '4' , '25.00' , '25' , '0' , '33' , '16.7500' ) 22/11/2024 11:18:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '23246' AND id_supplier = '7' 22/11/2024 11:18:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23246' , '7' , '1' ) 22/11/2024 11:18:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94433' , '23254' , 'UN NATALE INCONTENIBILE - A. SCHWARZ' , '1' , '1' , '4' , '12.00' , '12' , '0' , '30' , '8.4000' ) 22/11/2024 11:18:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '23254' AND id_supplier = '7' 22/11/2024 11:18:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23254' , '7' , '1' ) 22/11/2024 11:18:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94433' , '23253' , 'PAROLE CHIAVE PER LAVVENTO - R. LAURITA' , '1' , '1' , '4' , '5.00' , '5' , '0' , '30' , '3.5000' ) 22/11/2024 11:18:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '23253' AND id_supplier = '7' 22/11/2024 11:18:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23253' , '7' , '1' ) 22/11/2024 11:18:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94433' , '23248' , 'COMMENTO AL VANGELO DEL GIORNO - ANNO C - A. SPINA' , '1' , '1' , '4' , '18.00' , '18' , '0' , '30' , '12.6000' ) 22/11/2024 11:18:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '23248' AND id_supplier = '7' 22/11/2024 11:18:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23248' , '7' , '1' ) 22/11/2024 11:18:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94433' , '23251' , 'ANGELI CON UNALA SOLTANTO - TONINO BELLO' , '1' , '1' , '4' , '18.00' , '18' , '0' , '33' , '12.0600' ) 22/11/2024 11:18:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '23251' AND id_supplier = '7' 22/11/2024 11:18:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23251' , '7' , '1' ) 22/11/2024 11:18:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94433' , '23255' , 'MARIA DONNA DI SPERANZA - GALIAZZO/RAMINA' , '1' , '1' , '4' , '20.00' , '20' , '0' , '30' , '14.0000' ) 22/11/2024 11:18:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '23255' AND id_supplier = '7' 22/11/2024 11:18:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23255' , '7' , '1' ) 22/11/2024 11:18:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94433' , '23252' , 'BREVE INTRODUZIONE AL CRISTIANESIMO - J. RATZINGER' , '1' , '1' , '4' , '18.00' , '18' , '0' , '30' , '12.6000' ) 22/11/2024 11:18:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '23252' AND id_supplier = '7' 22/11/2024 11:18:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23252' , '7' , '1' ) 22/11/2024 11:30:00 am >> SELECT document_num FROM ps_document WHERE document_num = '3603' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-22') 22/11/2024 11:30:00 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' , '3603' , '2024-11-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.27' , '10.27' , NOW() , NOW() ) 22/11/2024 11:30:00 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 = '94434' 22/11/2024 11:30:00 am >> DELETE FROM ps_document_detail WHERE id_document = '94434' 22/11/2024 11:30:00 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 ( '94434' , '22825' , 'PAROLA E PREGHIERA - NOV 24' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '5' , '2.76' ) 22/11/2024 11:30:00 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 ( '94434' , '22937' , 'PAROLA E PREGHIERA - DIC 2024' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '5' , '2.76' ) 22/11/2024 11:30:00 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 ( '94434' , '23104' , 'SULLA TUA PAROLA - GEN/FEB 25' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 22/11/2024 11:31:36 am >> INSERT INTO ps_employee ( lastname, firstname, email, passwd, active, id_profile, id_lang, last_passwd_gen ) VALUES ( 'dragon' , 'De Simone Adrew' , 'aaronalger36@gmail.com' , MD5('Dragon21@@') , '1' , '1' , '1' , NOW() ) 22/11/2024 11:36:30 am >> INSERT INTO ps_image ( id_product , position ) VALUES ( '21945' , '1' ) 22/11/2024 11:36:30 am >> INSERT INTO ps_image_lang ( id_image , id_lang , legend ) VALUES ( '184' , '1' , '' ) 22/11/2024 11:36:30 am >> INSERT INTO ps_image_shop ( id_image , id_shop , id_product ) VALUES ( '184' , '1' , '21945' ) 22/11/2024 11:36:30 am >> SELECT name, width, height FROM ps_image_type 22/11/2024 11:37:06 am >> INSERT INTO ps_image ( id_product , position ) VALUES ( '21945' , '1' ) 22/11/2024 11:37:06 am >> INSERT INTO ps_image_lang ( id_image , id_lang , legend ) VALUES ( '185' , '1' , '' ) 22/11/2024 11:37:06 am >> INSERT INTO ps_image_shop ( id_image , id_shop , id_product ) VALUES ( '185' , '1' , '21945' ) 22/11/2024 11:37:06 am >> SELECT name, width, height FROM ps_image_type 22/11/2024 11:37:13 am >> INSERT INTO ps_image ( id_product , position ) VALUES ( '21945' , '1' ) 22/11/2024 11:37:13 am >> INSERT INTO ps_image_lang ( id_image , id_lang , legend ) VALUES ( '186' , '1' , '12123123' ) 22/11/2024 11:37:14 am >> INSERT INTO ps_image_shop ( id_image , id_shop , id_product ) VALUES ( '186' , '1' , '21945' ) 22/11/2024 11:37:14 am >> SELECT name, width, height FROM ps_image_type 22/11/2024 11:37:46 am >> INSERT INTO ps_image ( id_product , position ) VALUES ( '21945' , '1' ) 22/11/2024 11:37:46 am >> INSERT INTO ps_image_lang ( id_image , id_lang , legend ) VALUES ( '187' , '1' , '12123123' ) 22/11/2024 11:37:46 am >> INSERT INTO ps_image_shop ( id_image , id_shop , id_product ) VALUES ( '187' , '1' , '21945' ) 22/11/2024 11:37:46 am >> SELECT name, width, height FROM ps_image_type 22/11/2024 11:37:53 am >> SELECT document_num FROM ps_document WHERE document_num = '3604' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-22') 22/11/2024 11:37:53 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' , '3604' , '2024-11-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '92.20' , '75.97' , NOW() , NOW() ) 22/11/2024 11:37:53 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 = '94435' 22/11/2024 11:37:53 am >> DELETE FROM ps_document_detail WHERE id_document = '94435' 22/11/2024 11:37:53 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 ( '94435' , '13049' , 'LITURGICO ART. 60LT BIANCO SUPER' , '30' , '-30' , '1' , '3' , '2.4590163934426' , '22' , '0' , '90.00' ) 22/11/2024 11:37:54 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 ( '94435' , '23169' , 'DILEXIT NOS ' , '1' , '-1' , '4' , '2.20' , '2.2' , '0' , '0' , '2.20' ) 22/11/2024 11:38:14 am >> DELETE FROM ps_image WHERE id_image = '187' 22/11/2024 11:38:14 am >> DELETE FROM ps_image_lang WHERE id_image = '187' 22/11/2024 11:38:14 am >> DELETE FROM ps_image_shop WHERE id_image = '187' 22/11/2024 11:38:14 am >> UPDATE ps_image SET cover = null WHERE id_product = '187' 22/11/2024 11:38:14 am >> UPDATE ps_image_shop SET cover = null WHERE id_product = '187' 22/11/2024 11:38:14 am >> UPDATE ps_image_shop SET cover = '1' WHERE id_image = ( SELECT id_image FROM ps_image WHERE id_product = '187' ORDER BY position ASC LIMIT 1 ) 22/11/2024 11:38:14 am >> UPDATE ps_image SET cover = '1' WHERE id_product = '187' AND position = ( SELECT id_image FROM ps_image_shop WHERE id_product = '187' AND cover = '1' ) 22/11/2024 11:38:15 am >> DELETE FROM ps_image WHERE id_image = '186' 22/11/2024 11:38:15 am >> DELETE FROM ps_image_lang WHERE id_image = '186' 22/11/2024 11:38:15 am >> DELETE FROM ps_image_shop WHERE id_image = '186' 22/11/2024 11:38:15 am >> UPDATE ps_image SET cover = null WHERE id_product = '186' 22/11/2024 11:38:15 am >> UPDATE ps_image_shop SET cover = null WHERE id_product = '186' 22/11/2024 11:38:15 am >> UPDATE ps_image_shop SET cover = '1' WHERE id_image = ( SELECT id_image FROM ps_image WHERE id_product = '186' ORDER BY position ASC LIMIT 1 ) 22/11/2024 11:38:15 am >> UPDATE ps_image SET cover = '1' WHERE id_product = '186' AND position = ( SELECT id_image FROM ps_image_shop WHERE id_product = '186' AND cover = '1' ) 22/11/2024 11:38:18 am >> DELETE FROM ps_image WHERE id_image = '184' 22/11/2024 11:38:18 am >> DELETE FROM ps_image_lang WHERE id_image = '184' 22/11/2024 11:38:18 am >> DELETE FROM ps_image_shop WHERE id_image = '184' 22/11/2024 11:38:18 am >> UPDATE ps_image SET cover = null WHERE id_product = '184' 22/11/2024 11:38:18 am >> UPDATE ps_image_shop SET cover = null WHERE id_product = '184' 22/11/2024 11:38:18 am >> UPDATE ps_image_shop SET cover = '1' WHERE id_image = ( SELECT id_image FROM ps_image WHERE id_product = '184' ORDER BY position ASC LIMIT 1 ) 22/11/2024 11:38:18 am >> UPDATE ps_image SET cover = '1' WHERE id_product = '184' AND position = ( SELECT id_image FROM ps_image_shop WHERE id_product = '184' AND cover = '1' ) 22/11/2024 11:38:20 am >> DELETE FROM ps_image WHERE id_image = '185' 22/11/2024 11:38:20 am >> DELETE FROM ps_image_lang WHERE id_image = '185' 22/11/2024 11:38:20 am >> DELETE FROM ps_image_shop WHERE id_image = '185' 22/11/2024 11:38:20 am >> UPDATE ps_image SET cover = null WHERE id_product = '185' 22/11/2024 11:38:20 am >> UPDATE ps_image_shop SET cover = null WHERE id_product = '185' 22/11/2024 11:38:20 am >> UPDATE ps_image_shop SET cover = '1' WHERE id_image = ( SELECT id_image FROM ps_image WHERE id_product = '185' ORDER BY position ASC LIMIT 1 ) 22/11/2024 11:38:20 am >> UPDATE ps_image SET cover = '1' WHERE id_product = '185' AND position = ( SELECT id_image FROM ps_image_shop WHERE id_product = '185' AND cover = '1' ) 22/11/2024 11:46:33 am >> SELECT document_num FROM ps_document WHERE document_num = '251' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-11-22') 22/11/2024 11:46: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 ( '21' , '251' , '2024-11-22' , '' , '3533' , '0' , '4672868' , 'VIALE FRENTANO 2 66030 MOZZAGROGNA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '7' , '0' , '92.40' , '92.40' , NOW() , NOW() ) 22/11/2024 11:46: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 = '94436' 22/11/2024 11:46:33 am >> DELETE FROM ps_document_detail WHERE id_document = '94436' 22/11/2024 11:46: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 ( '94436' , '8601' , 'SARETE MIEI TESTIMONI 2 - MAGNIFICAT' , '15' , '-15' , '4' , '3.00' , '3' , '0' , '5' , '42.75' ) 22/11/2024 11:46: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 ( '94436' , '9681' , 'SARETE MIEI TESTIMONI - GUIDA 2 - MAGNIFICAT' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 22/11/2024 11:46: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 ( '94436' , '6629' , 'MIA PREGHIERA' , '50' , '-50' , '4' , '0.90' , '0.9' , '0' , '15' , '38.25' ) 22/11/2024 11:54:25 am >> SELECT document_num FROM ps_document WHERE document_num = '3351' AND id_document != '94087' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-06') 22/11/2024 11:54:25 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3351', document_date = '2024-11-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 = '24.65', price_tax_excluded = '24.50', date_upd = NOW() WHERE id_document = '94087' 22/11/2024 11:54:26 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 = '94087' 22/11/2024 11:54:26 am >> DELETE FROM ps_document_detail WHERE id_document = '94087' 22/11/2024 11:54:26 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 ( '94087' , '23196' , 'DILEXIT NOS' , '1' , '-1' , '4' , '2.12' , '2.12' , '0' , '0' , '2.12' ) 22/11/2024 11:54:26 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 ( '94087' , '7311' , 'OSTIA SOTTILE 74MM' , '2' , '-2' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '4.00' ) 22/11/2024 11:54:26 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 ( '94087' , '22995' , 'MINISTRO STRAORDINARIO DELLA COMUNIONE' , '1' , '-1' , '4' , '7.0000' , '7' , '0' , '5' , '6.65' ) 22/11/2024 11:54:26 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 ( '94087' , '23172' , 'CHI E\' DI SCENA - 15/18 ANNI' , '1' , '-1' , '4' , '12.5000' , '12.5' , '0' , '5' , '11.88' ) 22/11/2024 11:54:48 am >> SELECT document_num FROM ps_document WHERE document_num = '2994' AND id_document != '93556' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-10') 22/11/2024 11:54:48 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2994', document_date = '2024-10-10', 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 = '62.19', price_tax_excluded = '61.81', date_upd = NOW() WHERE id_document = '93556' 22/11/2024 11:54:48 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 = '93556' 22/11/2024 11:54:48 am >> DELETE FROM ps_document_detail WHERE id_document = '93556' 22/11/2024 11:54:48 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 ( '93556' , '7311' , 'OSTIA SOTTILE 74MM' , '5' , '-5' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '10.00' ) 22/11/2024 11:54:48 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 ( '93556' , '22693' , 'SULLA TUA PAROLA - SET/OTT 2024' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '0' , '5.00' ) 22/11/2024 11:54:48 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 ( '93556' , '20696' , 'NOSTRE NOZZE ' , '1' , '-1' , '4' , '4.9000' , '4.9' , '0' , '5' , '4.66' ) 22/11/2024 11:54:48 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 ( '93556' , '22187' , 'SETTE SACRAMENTI CREATIVI - A. QUEIROLO' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '5' , '11.40' ) 22/11/2024 11:54:48 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 ( '93556' , '22265' , 'DIO ATTRAVERSA LA CITTA - TONINO BELLO' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '5' , '5.70' ) 22/11/2024 11:54:48 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 ( '93556' , '14000' , 'GALATEO IN CHIESA' , '1' , '-1' , '4' , '1.0000' , '1' , '0' , '0' , '1.00' ) 22/11/2024 11:54:48 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 ( '93556' , '20954' , 'TEMPO DELL’APOCALISSE ' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '5' , '14.25' ) 22/11/2024 11:54:48 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 ( '93556' , '22845' , 'SULLA TUA PAROLA - NOV/DIC 24' , '1' , '-1' , '4' , '3.33' , '3.33' , '0' , '0' , '3.33' ) 22/11/2024 11:54:48 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 ( '93556' , '19540' , 'CRESIMA N.E.' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '5' , '2.85' ) 22/11/2024 11:54:48 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 ( '93556' , '18290' , 'BATTESIMO - N.E. ' , '1' , '-1' , '4' , '1.5000' , '1.5' , '0' , '0' , '1.50' ) 22/11/2024 11:54:48 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 ( '93556' , '7275' , 'ORDO VIRGINUM' , '1' , '-1' , '4' , '2.5000' , '2.5' , '0' , '0' , '2.50' ) 22/11/2024 11:56:33 am >> SELECT document_num FROM ps_document WHERE document_num = '3536' AND id_document != '94341' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-19') 22/11/2024 11:56:33 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3536', document_date = '2024-11-19', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '21.00', price_tax_excluded = '21.00', date_upd = NOW() WHERE id_document = '94341' 22/11/2024 11:56: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 = '94341' 22/11/2024 11:56:33 am >> DELETE FROM ps_document_detail WHERE id_document = '94341' 22/11/2024 11:56: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 ( '94341' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '4.2' , '4.2' , '0' , '0' , '4.20' ) 22/11/2024 11:56: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 ( '94341' , '11858' , 'FOGLIETTI LA DOMENICA - LER' , '560' , '-560' , '4' , '0.03' , '0.03' , '0' , '0' , '16.80' ) 22/11/2024 12:03:49 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788810978658' AND id_product != '23256' AND ean13 != '' 22/11/2024 12:03:50 pm >> UPDATE ps_product SET id_supplier = '', reference = '7/4', ean13 = '9788810978658', date_upd = NOW() WHERE id_product = '23256' 22/11/2024 12:03:50 pm >> UPDATE ps_product_lang SET name = 'MESSALE MARIANO', description = '' WHERE id_product = '23256' 22/11/2024 12:03:50 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '42' WHERE id_product = '23256' 22/11/2024 12:03:50 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '42', id_tax_rules_group = '4', id_category_default = '9', id_argoment_default = '89', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23256' 22/11/2024 12:03:50 pm >> DELETE FROM ps_specific_price WHERE id_product = '23256' 22/11/2024 12:03:51 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 = '23256' 22/11/2024 12:03:51 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23257' , '1' , '' , 'nuovo-prodotto' ) 22/11/2024 12:03:51 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 '23257' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23256' 22/11/2024 12:03:51 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23257' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23256' 22/11/2024 12:04:33 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788833775302' AND id_product != '23257' AND ean13 != '' 22/11/2024 12:04:33 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788833775302', date_upd = NOW() WHERE id_product = '23257' 22/11/2024 12:04:33 pm >> UPDATE ps_product_lang SET name = 'CON UN PIEDE IN PARADISO', description = '' WHERE id_product = '23257' 22/11/2024 12:04:33 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '12' WHERE id_product = '23257' 22/11/2024 12:04:33 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '12', id_tax_rules_group = '4', id_category_default = '9', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23257' 22/11/2024 12:04:33 pm >> DELETE FROM ps_specific_price WHERE id_product = '23257' 22/11/2024 12:04:43 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 = '23257' 22/11/2024 12:04:43 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23258' , '1' , '' , 'nuovo-prodotto' ) 22/11/2024 12:04:43 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 '23258' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23257' 22/11/2024 12:04:43 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23258' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23257' 22/11/2024 12:06:50 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788810023426' AND id_product != '23258' AND ean13 != '' 22/11/2024 12:06:50 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788810023426', date_upd = NOW() WHERE id_product = '23258' 22/11/2024 12:06:50 pm >> UPDATE ps_product_lang SET name = 'MARIA PORTA DEL CIELO', description = '' WHERE id_product = '23258' 22/11/2024 12:06:50 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '4.5' WHERE id_product = '23258' 22/11/2024 12:06:50 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '4.5', id_tax_rules_group = '4', id_category_default = '9', id_argoment_default = '39', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23258' 22/11/2024 12:06:50 pm >> DELETE FROM ps_specific_price WHERE id_product = '23258' 22/11/2024 12:06:51 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 = '23258' 22/11/2024 12:06:51 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23259' , '1' , '' , 'nuovo-prodotto' ) 22/11/2024 12:06:51 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 '23259' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23258' 22/11/2024 12:06:51 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23259' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23258' 22/11/2024 12:07:02 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' , '00331330' , '2024-11-20' , '' , '0' , '109' , '4669106' , 'VIA G. VERDI, 8 20090 ASSAGO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '862.50' , '862.50' , NOW() , NOW() ) 22/11/2024 12:07:02 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 = '94437' 22/11/2024 12:07:02 pm >> DELETE FROM ps_document_detail WHERE id_document = '94437' 22/11/2024 12:07:02 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 ( '94437' , '23256' , 'MESSALE MARIANO' , '10' , '10' , '4' , '42.00' , '42' , '0' , '0' , '420.0000' ) 22/11/2024 12:07:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23256' AND id_supplier = '109' 22/11/2024 12:07:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23256' , '109' , '1' ) 22/11/2024 12:07:02 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 ( '94437' , '23257' , 'CON UN PIEDE IN PARADISO' , '35' , '35' , '4' , '12.00' , '12' , '0' , '0' , '420.0000' ) 22/11/2024 12:07:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23257' AND id_supplier = '109' 22/11/2024 12:07:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23257' , '109' , '1' ) 22/11/2024 12:07:02 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 ( '94437' , '23258' , 'MARIA PORTA DEL CIELO' , '5' , '5' , '4' , '4.50' , '4.5' , '0' , '0' , '22.5000' ) 22/11/2024 12:07:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23258' AND id_supplier = '109' 22/11/2024 12:07:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23258' , '109' , '1' ) 22/11/2024 12:08:05 pm >> SELECT document_num FROM ps_document WHERE document_num = '3605' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-22') 22/11/2024 12:08: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' , '3605' , '2024-11-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '67.60' , '61.16' , NOW() , NOW() ) 22/11/2024 12:08: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 = '94438' 22/11/2024 12:08:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '94438' 22/11/2024 12:08: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 ( '94438' , '6811' , 'MOCCOLO 80X200' , '4' , '-4' , '1' , '8.5' , '6.9672131147541' , '22' , '0' , '34.00' ) 22/11/2024 12:08: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 ( '94438' , '11858' , 'FOGLIETTI LA DOMENICA - LER' , '640' , '-640' , '4' , '0.04' , '0.04' , '0' , '0' , '25.60' ) 22/11/2024 12:08: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 ( '94438' , '7311' , 'OSTIA SOTTILE 74MM' , '4' , '-4' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '8.00' ) 22/11/2024 12:26:08 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3812' 22/11/2024 12:26:08 pm >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '3812' , '10' , '210' , 'SEMINARIO ARCIVESCOVILE SALERNO' , '' , '' , 'LARGO PLEBISCITO 12' , 'VIA POMPEI 6 - 84098 PONTECAGNANO SA' , '84121' , 'SALERNO ' , 'emmanuel iuzzino : 3315855008' , '089202040' , '' , '' , '80031940655' , NOW() , NOW() ) 22/11/2024 12:26:08 pm >> UPDATE ps_customer SET email = 'seminariogp2sa@gmail.com', sdi = '0000000', pec = 'seminariosalerno@pec.it', date_upd = NOW() WHERE id_customer = '3812' 22/11/2024 12:27:07 pm >> SELECT document_num FROM ps_document WHERE document_num = '126/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-11-22') 22/11/2024 12:27:07 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' , '126/A' , '2024-11-22' , 'A' , '1213' , '0' , '4679403' , 'VIA MARCONI 115 83025 MONTORO INFERIORE' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '220.00' , '200.16' , NOW() , NOW() ) 22/11/2024 12:27:07 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 = '94439' 22/11/2024 12:27:07 pm >> DELETE FROM ps_document_detail WHERE id_document = '94439' 22/11/2024 12:27:07 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 ( '94439' , '17329' , 'MESSALE ROMANO DALTARE N.E' , '1' , '-1' , '4' , '110.00' , '110' , '0' , '0' , '110.00' ) 22/11/2024 12:27:07 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 ( '94439' , '23223' , 'COPRILEGGIO - CL10' , '2' , '-2' , '1' , '55.00' , '45.081967213115' , '22' , '0' , '110.00' ) 22/11/2024 12:28:58 pm >> SELECT document_num FROM ps_document WHERE document_num = '3606' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-22') 22/11/2024 12:28:58 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3606' , '2024-11-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.00' , '5.00' , NOW() , NOW() ) 22/11/2024 12:28:58 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94440' 22/11/2024 12:28:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '94440' 22/11/2024 12:28:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94440' , '22998' , 'CALENDARIO FRATE INDOVINO 2025' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '0' , '5.00' ) 22/11/2024 12:34:01 pm >> SELECT document_num FROM ps_document WHERE document_num = '119/A' AND id_document != '94115' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-11-07') 22/11/2024 12:34:01 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '119/A', document_date = '2024-11-07', document_letter = 'A', id_customer = '1213', id_supplier = '', id_address = '4679403', address1 = 'VIA CONVENTO 83025 MONTORO', 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 = '440.00', price_tax_excluded = '380.49', date_upd = NOW() WHERE id_document = '94115' 22/11/2024 12:34:01 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 = '94115' 22/11/2024 12:34:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '94115' 22/11/2024 12:34:01 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 ( '94115' , '20227' , 'BAMBINELLO GESSO CM 40 STILE ANTICO - J202/40' , '1' , '-1' , '1' , '220.0000' , '180.32786885246' , '22' , '0' , '220.00' ) 22/11/2024 12:34:01 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 ( '94115' , '17329' , 'MESSALE ROMANO DALTARE N.E' , '1' , '-1' , '4' , '110.0000' , '110' , '0' , '0' , '110.00' ) 22/11/2024 12:34:01 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 ( '94115' , '23223' , 'COPRILEGGIO - CL10' , '2' , '-2' , '1' , '55.0000' , '45.082' , '22' , '0' , '110.00' ) 22/11/2024 12:34:09 pm >> DELETE FROM ps_document WHERE id_document = '94439' 22/11/2024 12:34:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '94439' 22/11/2024 02:14: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 ( '33' , '2024-DL003609' , '2024-11-21' , '' , '0' , '79' , '2686' , 'CITTA\\\' DEL VATICANO 00120 CITTA\\\' DEL VATICANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '182.25' , '182.25' , NOW() , NOW() ) 22/11/2024 02:14: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 = '94441' 22/11/2024 02:14:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '94441' 22/11/2024 02:14: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 ( '94441' , '20798' , 'LEZIONARIO DOMENICALE E FESTIVO - N.E. - ANNO C' , '1' , '1' , '4' , '60.00' , '60' , '0' , '35' , '39.0000' ) 22/11/2024 02:14:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20798' AND id_supplier = '79' 22/11/2024 02:14:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20798' , '79' , '1' ) 22/11/2024 02:14: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 ( '94441' , '21612' , 'RITO DELLE ESEQUIE - ED. MIN.- N.E.' , '2' , '2' , '4' , '30.00' , '30' , '0' , '35' , '39.0000' ) 22/11/2024 02:14:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21612' AND id_supplier = '79' 22/11/2024 02:14:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21612' , '79' , '1' ) 22/11/2024 02:14: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 ( '94441' , '5762' , 'LEZIONARIO E RITO DEL MATRIMONIO - KIT 2 VOL.' , '1' , '1' , '4' , '25.00' , '25' , '0' , '35' , '16.2500' ) 22/11/2024 02:14:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5762' AND id_supplier = '79' 22/11/2024 02:14:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5762' , '79' , '1' ) 22/11/2024 02:14: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 ( '94441' , '22507' , 'SPES NON CONFUNDIT' , '10' , '10' , '4' , '2.00' , '2' , '0' , '45' , '11.0000' ) 22/11/2024 02:14:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22507' AND id_supplier = '79' 22/11/2024 02:14:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22507' , '79' , '1' ) 22/11/2024 02:14: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 ( '94441' , '17329' , 'MESSALE ROMANO DALTARE N.E' , '1' , '1' , '4' , '110.00' , '110' , '0' , '30' , '77.0000' ) 22/11/2024 02:14:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17329' AND id_supplier = '79' 22/11/2024 02:14:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17329' , '79' , '1' ) 22/11/2024 03:03:27 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '300' , '2024-11-20' , '' , '0' , '137' , '4670816' , 'VIA G. BATTISTA VICO 73 80010 VILLARICCA' , '' , '' , '8.001' , '1' , '0' , '0' , '0' , '' , '3' , '0' , '141.85' , '116.27' , NOW() , NOW() ) 22/11/2024 03:03:27 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 = '94442' 22/11/2024 03:03:27 pm >> DELETE FROM ps_document_detail WHERE id_document = '94442' 22/11/2024 03:03:27 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 ( '94442' , '19395' , 'CLERGY MISTO COTONE ML - C01' , '4' , '4' , '1' , '17.5' , '14.344262295082' , '22' , '8' , '78.5680' ) 22/11/2024 03:03:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19395' AND id_supplier = '137' 22/11/2024 03:03:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19395' , '137' , '1' ) 22/11/2024 03:03:27 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 ( '94442' , '21132' , 'CLERGY F/F MC - C03' , '1' , '1' , '1' , '18.9' , '15.491803278689' , '22' , '6' , '21.6745' ) 22/11/2024 03:03:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21132' AND id_supplier = '137' 22/11/2024 03:03:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21132' , '137' , '1' ) 22/11/2024 03:03:27 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 ( '94442' , '16657' , 'CLERGY DENIM - ML ' , '1' , '1' , '1' , '29' , '23.770491803279' , '22' , '10' , '31.8420' ) 22/11/2024 03:03:27 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16657' AND id_supplier = '137' 22/11/2024 03:03:27 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16657' , '137' , '1' ) 22/11/2024 03:22:08 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788810978658' AND id_product != '23256' AND ean13 != '' 22/11/2024 03:22:08 pm >> UPDATE ps_product SET id_supplier = '109', reference = '7/4', ean13 = '9788810978658', date_upd = NOW() WHERE id_product = '23256' 22/11/2024 03:22:08 pm >> UPDATE ps_product_lang SET name = 'CELEBRIAMO MARIA -MESSALE MARIANO', description = '' WHERE id_product = '23256' 22/11/2024 03:22:08 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '42.0000' WHERE id_product = '23256' 22/11/2024 03:22:08 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '42.0000', id_tax_rules_group = '4', id_category_default = '9', id_argoment_default = '89', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23256' 22/11/2024 03:22:08 pm >> DELETE FROM ps_specific_price WHERE id_product = '23256' 22/11/2024 03:22:18 pm >> SELECT document_num FROM ps_document WHERE document_num = '83/A' AND id_document != '92691' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-07-22') 22/11/2024 03:22:18 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '83/A', document_date = '2024-07-22', document_letter = 'A', id_customer = '3812', id_supplier = '', id_address = '4678843', address1 = 'LARGO PLEBISCITO 12 84121 SALERNO ', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '662.95', price_tax_excluded = '650.30', date_upd = NOW() WHERE id_document = '92691' 22/11/2024 03:22:18 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 = '92691' 22/11/2024 03:22:18 pm >> DELETE FROM ps_document_detail WHERE id_document = '92691' 22/11/2024 03:22:18 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 ( '92691' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '5' , '-5' , '4' , '0.7000' , '0.7' , '0' , '0' , '3.50' ) 22/11/2024 03:22:18 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 ( '92691' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '7' , '-7' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '24.50' ) 22/11/2024 03:22:18 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 ( '92691' , '7311' , 'OSTIA SOTTILE 74MM' , '7' , '-7' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '14.00' ) 22/11/2024 03:22:18 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 ( '92691' , '17005' , 'BIGLIETTO AUGURALE medio' , '6' , '-6' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '6.00' ) 22/11/2024 03:22:18 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 ( '92691' , '19089' , 'OSTIA MAGNA 150 - OM 150' , '1' , '-1' , '3' , '4.5000' , '4.3269230769231' , '4' , '0' , '4.50' ) 22/11/2024 03:22:18 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 ( '92691' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '5' , '-5' , '4' , '0.7000' , '0.7' , '0' , '0' , '3.50' ) 22/11/2024 03:22:18 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 ( '92691' , '17533' , 'CINGOLO ORO/COL - CING06' , '1' , '-1' , '1' , '19.0000' , '15.573770491803' , '22' , '0' , '19.00' ) 22/11/2024 03:22:18 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 ( '92691' , '17030' , 'MARIA - UN CAMMINO - A. DEHO' , '1' , '-1' , '4' , '9.0000' , '9' , '0' , '5' , '8.55' ) 22/11/2024 03:22:18 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 ( '92691' , '17329' , 'MESSALE ROMANO DALTARE N.E' , '1' , '-1' , '4' , '110.0000' , '110' , '0' , '5' , '104.50' ) 22/11/2024 03:22:18 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 ( '92691' , '6809' , 'MOCCOLO 60X165' , '8' , '-8' , '1' , '4.5000' , '3.6885245901639' , '22' , '0' , '36.00' ) 22/11/2024 03:22: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 ( '92691' , '23257' , 'CON UN PIEDE IN PARADISO' , '35' , '-35' , '4' , '12.00' , '12' , '0' , '5' , '399.00' ) 22/11/2024 03:22: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 ( '92691' , '23256' , 'CELEBRIAMO MARIA -MESSALE MARIANO' , '1' , '-1' , '4' , '42.00' , '42' , '0' , '5' , '39.90' ) 22/11/2024 03:49:22 pm >> SELECT document_num FROM ps_document WHERE document_num = '3607' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-22') 22/11/2024 03:49: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' , '3607' , '2024-11-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '45.50' , '38.54' , NOW() , NOW() ) 22/11/2024 03:49: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 = '94443' 22/11/2024 03:49:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '94443' 22/11/2024 03:49: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 ( '94443' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '100' , '-100' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '25.00' ) 22/11/2024 03:49: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 ( '94443' , '17940' , 'MIRACOLOSA - ISONZO 152bis' , '1' , '-1' , '1' , '3.6' , '2.9508196721311' , '22' , '0' , '3.60' ) 22/11/2024 03:49: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 ( '94443' , '17617' , 'IMMAGINI ISONZO X 100' , '2' , '-2' , '1' , '3.5' , '2.8688524590164' , '22' , '0' , '7.00' ) 22/11/2024 03:49: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 ( '94443' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3' , '2.4590163934426' , '22' , '0' , '3.00' ) 22/11/2024 03:49: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 ( '94443' , '21662' , 'ANDIAMO VERSO GESU' , '1' , '-1' , '4' , '6.90' , '6.9' , '0' , '0' , '6.90' ) 22/11/2024 04:01:41 pm >> SELECT document_num FROM ps_document WHERE document_num = '3203' AND id_document != '93865' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-10-26') 22/11/2024 04:01:41 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3203', document_date = '2024-10-26', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '79.00', price_tax_excluded = '65.48', date_upd = NOW() WHERE id_document = '93865' 22/11/2024 04:01:41 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93865' 22/11/2024 04:01:41 pm >> DELETE FROM ps_document_detail WHERE id_document = '93865' 22/11/2024 04:01:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93865' , '6962' , 'NELLA CASA DEL DEFUNTO' , '1' , '-1' , '4' , '1.5000' , '1.5' , '0' , '0' , '1.50' ) 22/11/2024 04:01:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93865' , '10965' , 'UNZIONE DEGLI INFERMI E IL VIATICO' , '1' , '-1' , '4' , '2.5000' , '2.5' , '0' , '0' , '2.50' ) 22/11/2024 04:01:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93865' , '20003' , 'GESU BAMBINO CM 4 - BJ140-4E' , '24' , '-24' , '1' , '2.5000' , '2.0491803278689' , '22' , '0' , '60.00' ) 22/11/2024 04:01:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93865' , '23093' , 'CONFEZIONE CAPANNA - P622-ITA' , '10' , '-10' , '1' , '1.2000' , '0.98360655737705' , '22' , '0' , '12.00' ) 22/11/2024 04:01:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93865' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3' , '2.4590163934426' , '22' , '0' , '3.00' ) 22/11/2024 05:17:20 pm >> SELECT document_num FROM ps_document WHERE document_num = '3608' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-22') 22/11/2024 05:17: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' , '3608' , '2024-11-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '27.50' , '22.54' , NOW() , NOW() ) 22/11/2024 05:17: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 = '94444' 22/11/2024 05:17:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '94444' 22/11/2024 05:17: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 ( '94444' , '23100' , 'MEDAGLIA MIRACOLOSA ARG. MEDIA - M057' , '1' , '-1' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '7.50' ) 22/11/2024 05:17: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 ( '94444' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '20' , '16.393442622951' , '22' , '0' , '20.00' ) 22/11/2024 05:34:00 pm >> SELECT document_num FROM ps_document WHERE document_num = '3609' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-22') 22/11/2024 05:34:00 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' , '3609' , '2024-11-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '26.00' , '21.31' , NOW() , NOW() ) 22/11/2024 05:34:00 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 = '94445' 22/11/2024 05:34:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '94445' 22/11/2024 05:34:01 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 ( '94445' , '1912' , 'CERA DELL\'EREMO - 415/B ' , '2' , '-2' , '1' , '6.00' , '4.9180327868852' , '22' , '0' , '12.00' ) 22/11/2024 05:34:01 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 ( '94445' , '13049' , 'LITURGICO ART. 60LT BIANCO SUPER' , '4' , '-4' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '14.00' ) 22/11/2024 05:39:41 pm >> SELECT document_num FROM ps_document WHERE document_num = '3610' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-22') 22/11/2024 05:39:41 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3610' , '2024-11-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '75.00' , '61.48' , NOW() , NOW() ) 22/11/2024 05:39:41 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94446' 22/11/2024 05:39:41 pm >> DELETE FROM ps_document_detail WHERE id_document = '94446' 22/11/2024 05:39:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94446' , '3134' , 'CROCE TAU MURANO DOPPIA CM 34' , '1' , '-1' , '1' , '75' , '61.475409836066' , '22' , '0' , '75.00' ) 22/11/2024 05:45:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '252' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-11-22') 22/11/2024 05:45:15 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '252' , '2024-11-22' , '' , '3770' , '0' , '4671727' , 'VIALE MARCONI 2 65020 ROSCIANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '144.68' , '144.68' , NOW() , NOW() ) 22/11/2024 05:45:15 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94447' 22/11/2024 05:45:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '94447' 22/11/2024 05:45:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94447' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '15' , '-15' , '4' , '2.40' , '2.4' , '0' , '15' , '30.60' ) 22/11/2024 05:45:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94447' , '11193' , 'VENITE CON ME CAT.' , '15' , '-15' , '4' , '5.50' , '5.5' , '0' , '5' , '78.38' ) 22/11/2024 05:45:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94447' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '15' , '-15' , '4' , '2.80' , '2.8' , '0' , '15' , '35.70' ) 22/11/2024 06:10:30 pm >> SELECT document_num FROM ps_document WHERE document_num = '126/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-11-22') 22/11/2024 06:10:30 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '126/A' , '2024-11-22' , 'A' , '321' , '0' , '4672782' , 'VIA VICENZA 45 84099 FILETTA S. CIPRIANO PIC.' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '547.91' , '547.91' , NOW() , NOW() ) 22/11/2024 06:10:30 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94448' 22/11/2024 06:10:30 pm >> DELETE FROM ps_document_detail WHERE id_document = '94448' 22/11/2024 06:10:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94448' , '2679' , 'CONOSCERE GESU\'' , '21' , '-21' , '4' , '3.50' , '3.5' , '0' , '15' , '62.48' ) 22/11/2024 06:10:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94448' , '5457' , 'IO SONO CON VOI 1 PARTE' , '17' , '-17' , '4' , '2.80' , '2.8' , '0' , '15' , '40.46' ) 22/11/2024 06:10:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94448' , '5444' , 'IO SONO CON VOI - CAT.' , '17' , '-17' , '4' , '5.50' , '5.5' , '0' , '5' , '88.82' ) 22/11/2024 06:10:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94448' , '8511' , 'PRIMI PASSI CON GESÙ - ANNO C' , '23' , '-23' , '4' , '3.40' , '3.4' , '0' , '15' , '66.47' ) 22/11/2024 06:10:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94448' , '4154' , 'FESTA DEL PERDONO' , '23' , '-23' , '4' , '3.00' , '3' , '0' , '15' , '58.65' ) 22/11/2024 06:10:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94448' , '4154' , 'FESTA DEL PERDONO' , '25' , '-25' , '4' , '3.00' , '3' , '0' , '15' , '63.75' ) 22/11/2024 06:10:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94448' , '8408' , 'PRENDETE E MANGIATE' , '25' , '-25' , '4' , '3.00' , '3' , '0' , '15' , '63.75' ) 22/11/2024 06:10:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94448' , '8408' , 'PRENDETE E MANGIATE' , '21' , '-21' , '4' , '3.00' , '3' , '0' , '15' , '53.55' ) 22/11/2024 06:10:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94448' , '11192' , 'VENITE CON ME 2 PARTE' , '21' , '-21' , '4' , '2.80' , '2.8' , '0' , '15' , '49.98' ) 22/11/2024 06:49:17 pm >> SELECT document_num FROM ps_document WHERE document_num = '253' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-11-22') 22/11/2024 06:49:17 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '253' , '2024-11-22' , '' , '1632' , '0' , '4679142' , 'P.ZZA PLEBISCITO, 11 84030 SANZA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '75.05' , '68.20' , NOW() , NOW() ) 22/11/2024 06:49:17 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 = '94449' 22/11/2024 06:49:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '94449' 22/11/2024 06:49:17 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 ( '94449' , '4154' , 'FESTA DEL PERDONO' , '2' , '-2' , '4' , '3.00' , '3' , '0' , '5' , '5.70' ) 22/11/2024 06:49:17 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 ( '94449' , '8408' , 'PRENDETE E MANGIATE' , '11' , '-11' , '4' , '3.00' , '3' , '0' , '5' , '31.35' ) 22/11/2024 06:49:17 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 ( '94449' , '12817' , 'LIBRO DEI MATRIMONI' , '1' , '-1' , '1' , '40.00' , '32.786885245902' , '22' , '5' , '38.00' ) 22/11/2024 06:59:09 pm >> SELECT document_num FROM ps_document WHERE document_num = '3611' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-22') 22/11/2024 06:59: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' , '3611' , '2024-11-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 22/11/2024 06:59: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 = '94450' 22/11/2024 06:59:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '94450' 22/11/2024 06:59: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 ( '94450' , '23104' , 'SULLA TUA PAROLA - GEN/FEB 25' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 22/11/2024 07:34:16 pm >> SELECT document_num FROM ps_document WHERE document_num = '3612' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-22') 22/11/2024 07:34:16 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' , '3612' , '2024-11-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '230.00' , '190.11' , NOW() , NOW() ) 22/11/2024 07:34:16 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94451' 22/11/2024 07:34:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '94451' 22/11/2024 07:34:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94451' , '22313' , 'CASULA MARIANA - C1P817' , '1' , '-1' , '1' , '221.2' , '181.31147540984' , '22' , '0' , '221.20' ) 22/11/2024 07:34:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94451' , '23165' , 'DILEXIT NOS' , '4' , '-4' , '4' , '2.20' , '2.2' , '0' , '0' , '8.80' ) 22/11/2024 08:03:54 pm >> SELECT document_num FROM ps_document WHERE document_num = '3613' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-22') 22/11/2024 08:03:54 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' , '3613' , '2024-11-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '82.50' , '79.61' , NOW() , NOW() ) 22/11/2024 08:03: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 = '94452' 22/11/2024 08:03:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '94452' 22/11/2024 08:03:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94452' , '21507' , 'LITURGIA DELLE ORE VOL. I N.E.' , '1' , '-1' , '4' , '35.00' , '35' , '0' , '5' , '33.25' ) 22/11/2024 08:03:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94452' , '21509' , 'LITURGIA DELLE ORE VOL. IV N.E.' , '1' , '-1' , '4' , '35.00' , '35' , '0' , '5' , '33.25' ) 22/11/2024 08:03:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94452' , '22223' , 'CUSTODIA LITURGIA DELLE ORE CON BOTTONE - 1731' , '1' , '-1' , '1' , '16' , '13.114754098361' , '22' , '0' , '16.00' )