Drop files here

SQL upload ( 0 ) x -

Page-related settings Click on the bar to scroll to top of page
Press Ctrl+Enter to execute query Press Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse Expand Show trace Hide trace Count : Time taken :
Options
Set default





Collapse Expand Requery Edit Explain Profiling Query failed Database : Queried time :
Browse mode
Customize browse mode.
Browse mode
Documentation Use only icons, only text or both. Restore default value
Documentation Use only icons, only text or both. Restore default value
Documentation Whether a user should be displayed a "show all (rows)" button. Restore default value
Documentation Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown. Restore default value
Documentation SMART - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise. Restore default value
Documentation Highlight row pointed by the mouse cursor. Restore default value
Documentation Highlight selected rows. Restore default value
Documentation Restore default value
Documentation Restore default value
Documentation Repeat the headers every X cells, 0 deactivates this feature. Restore default value
Documentation Maximum number of characters shown in any non-numeric column on browse view. Restore default value
Documentation These are Edit, Copy and Delete links. Restore default value
Documentation Whether to show row links even in the absence of a unique key. Restore default value
Documentation Default sort order for tables with a primary key. Restore default value
Documentation When browsing tables, the sorting of each table is remembered. Restore default value
Documentation For display Options Restore default value
SELECT * FROM `vlstventasconlymyorder`
[ Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
Full texts codigo
Nro factura
Fecha Partida Cliente
Nro cliente
Articulo Articulod Cant Precio Linea Marca Linead Marcad CamNeg Loc
Edit Edit Copy Copy Delete Delete
DELETE FROM vlstventasconlymyorder WHERE `vlstventasconlymyorder`.`codigo` = 131614 AND `vlstventasconlymyorder`.`Fecha` = '2016-06-01' AND `vlstventasconlymyorder`.`Partida` = 'M' AND `vlstventasconlymyorder`.`Cliente` = 1 AND `vlstventasconlymyorder`.`Articulo` = 5387 AND `vlstventasconlymyorder`.`Articulod` = '2800 MULTIGAS BLANCA ' AND `vlstventasconlymyorder`.`Cant` = 1 AND CONCAT(`vlstventasconlymyorder`.`Precio`) = 1 AND `vlstventasconlymyorder`.`Linea` = 3 AND `vlstventasconlymyorder`.`Marca` = 18 AND `vlstventasconlymyorder`.`Linead` = 'COCINAS' AND `vlstventasconlymyorder`.`Marcad` = 'COSQUIN' AND `vlstventasconlymyorder`.`CamNeg` = 'C' AND `vlstventasconlymyorder`.`Loc` = '9 DE ABRIL ' LIMIT 1
131614 2016-06-01 M 1 5387 2800 MULTIGAS BLANCA 1 1 3 18 COCINAS COSQUIN C 9 DE ABRIL
Edit Edit Copy Copy Delete Delete
DELETE FROM vlstventasconlymyorder WHERE `vlstventasconlymyorder`.`codigo` = 131646 AND `vlstventasconlymyorder`.`Fecha` = '2016-06-01' AND `vlstventasconlymyorder`.`Partida` = 'M' AND `vlstventasconlymyorder`.`Cliente` = 1 AND `vlstventasconlymyorder`.`Articulo` = 11610 AND `vlstventasconlymyorder`.`Articulod` = 'HN16T TURBO HALOGENA 1600W' AND `vlstventasconlymyorder`.`Cant` = 2 AND CONCAT(`vlstventasconlymyorder`.`Precio`) = 1 AND `vlstventasconlymyorder`.`Linea` = 45 AND `vlstventasconlymyorder`.`Marca` = 628 AND `vlstventasconlymyorder`.`Linead` = 'ESTUFAS' AND `vlstventasconlymyorder`.`Marcad` = 'PROTALIA' AND `vlstventasconlymyorder`.`CamNeg` = 'N' AND `vlstventasconlymyorder`.`Loc` = 'SN ' LIMIT 1
131646 2016-06-01 M 1 11610 HN16T TURBO HALOGENA 1600W 2 1 45 628 ESTUFAS PROTALIA N SN
Edit Edit Copy Copy Delete Delete
DELETE FROM vlstventasconlymyorder WHERE `vlstventasconlymyorder`.`codigo` = 131648 AND `vlstventasconlymyorder`.`Fecha` = '2016-06-01' AND `vlstventasconlymyorder`.`Partida` = 'M' AND `vlstventasconlymyorder`.`Cliente` = 1 AND `vlstventasconlymyorder`.`Articulo` = 10245 AND `vlstventasconlymyorder`.`Articulod` = 'PR1230' AND `vlstventasconlymyorder`.`Cant` = 1 AND CONCAT(`vlstventasconlymyorder`.`Precio`) = 1 AND `vlstventasconlymyorder`.`Linea` = 97 AND `vlstventasconlymyorder`.`Marca` = 101 AND `vlstventasconlymyorder`.`Linead` = 'AFEITADORAS' AND `vlstventasconlymyorder`.`Marcad` = 'REMIGTON' AND `vlstventasconlymyorder`.`CamNeg` = 'N' AND `vlstventasconlymyorder`.`Loc` = 'SN ' LIMIT 1
131648 2016-06-01 M 1 10245 PR1230 1 1 97 101 AFEITADORAS REMIGTON N SN
Edit Edit Copy Copy Delete Delete
DELETE FROM vlstventasconlymyorder WHERE `vlstventasconlymyorder`.`codigo` = 131650 AND `vlstventasconlymyorder`.`Fecha` = '2016-06-01' AND `vlstventasconlymyorder`.`Partida` = 'M' AND `vlstventasconlymyorder`.`Cliente` = 1 AND `vlstventasconlymyorder`.`Articulo` = 8501 AND `vlstventasconlymyorder`.`Articulod` = 'PE-3902K' AND `vlstventasconlymyorder`.`Cant` = 1 AND CONCAT(`vlstventasconlymyorder`.`Precio`) = 1 AND `vlstventasconlymyorder`.`Linea` = 144 AND `vlstventasconlymyorder`.`Marca` = 25 AND `vlstventasconlymyorder`.`Linead` = 'PAVA ELECTRICA' AND `vlstventasconlymyorder`.`Marcad` = 'YELMO' AND `vlstventasconlymyorder`.`CamNeg` = 'N' AND `vlstventasconlymyorder`.`Loc` = 'SN ' LIMIT 1
131650 2016-06-01 M 1 8501 PE-3902K 1 1 144 25 PAVA ELECTRICA YELMO N SN
Edit Edit Copy Copy Delete Delete
DELETE FROM vlstventasconlymyorder WHERE `vlstventasconlymyorder`.`codigo` = 131649 AND `vlstventasconlymyorder`.`Fecha` = '2016-06-01' AND `vlstventasconlymyorder`.`Partida` = 'M' AND `vlstventasconlymyorder`.`Cliente` = 1 AND `vlstventasconlymyorder`.`Articulo` = 9538 AND `vlstventasconlymyorder`.`Articulod` = '0 60 CM' AND `vlstventasconlymyorder`.`Cant` = 1 AND CONCAT(`vlstventasconlymyorder`.`Precio`) = 1 AND `vlstventasconlymyorder`.`Linea` = 203 AND `vlstventasconlymyorder`.`Marca` = 700 AND `vlstventasconlymyorder`.`Linead` = 'ANTENAS' AND `vlstventasconlymyorder`.`Marcad` = 'DIREC TV' AND `vlstventasconlymyorder`.`CamNeg` = 'N' AND `vlstventasconlymyorder`.`Loc` = 'SN ' LIMIT 1
131649 2016-06-01 M 1 9538 0 60 CM 1 1 203 700 ANTENAS DIREC TV N SN
Edit Edit Copy Copy Delete Delete
DELETE FROM vlstventasconlymyorder WHERE `vlstventasconlymyorder`.`codigo` = 131670 AND `vlstventasconlymyorder`.`Fecha` = '2016-06-02' AND `vlstventasconlymyorder`.`Partida` = 'M' AND `vlstventasconlymyorder`.`Cliente` = 1 AND `vlstventasconlymyorder`.`Articulo` = 10891 AND `vlstventasconlymyorder`.`Articulod` = 'HN16 HALOGENA 800 1600W' AND `vlstventasconlymyorder`.`Cant` = 1 AND CONCAT(`vlstventasconlymyorder`.`Precio`) = 1 AND `vlstventasconlymyorder`.`Linea` = 45 AND `vlstventasconlymyorder`.`Marca` = 628 AND `vlstventasconlymyorder`.`Linead` = 'ESTUFAS' AND `vlstventasconlymyorder`.`Marcad` = 'PROTALIA' AND `vlstventasconlymyorder`.`CamNeg` = 'N' AND `vlstventasconlymyorder`.`Loc` = 'SN ' LIMIT 1
131670 2016-06-02 M 1 10891 HN16 HALOGENA 800 1600W 1 1 45 628 ESTUFAS PROTALIA N SN
Edit Edit Copy Copy Delete Delete
DELETE FROM vlstventasconlymyorder WHERE `vlstventasconlymyorder`.`codigo` = 131668 AND `vlstventasconlymyorder`.`Fecha` = '2016-06-02' AND `vlstventasconlymyorder`.`Partida` = 'M' AND `vlstventasconlymyorder`.`Cliente` = 1 AND `vlstventasconlymyorder`.`Articulo` = 11610 AND `vlstventasconlymyorder`.`Articulod` = 'HN16T TURBO HALOGENA 1600W' AND `vlstventasconlymyorder`.`Cant` = 1 AND CONCAT(`vlstventasconlymyorder`.`Precio`) = 1 AND `vlstventasconlymyorder`.`Linea` = 45 AND `vlstventasconlymyorder`.`Marca` = 628 AND `vlstventasconlymyorder`.`Linead` = 'ESTUFAS' AND `vlstventasconlymyorder`.`Marcad` = 'PROTALIA' AND `vlstventasconlymyorder`.`CamNeg` = 'N' AND `vlstventasconlymyorder`.`Loc` = 'SN ' LIMIT 1
131668 2016-06-02 M 1 11610 HN16T TURBO HALOGENA 1600W 1 1 45 628 ESTUFAS PROTALIA N SN
Edit Edit Copy Copy Delete Delete
DELETE FROM vlstventasconlymyorder WHERE `vlstventasconlymyorder`.`codigo` = 131671 AND `vlstventasconlymyorder`.`Fecha` = '2016-06-02' AND `vlstventasconlymyorder`.`Partida` = 'M' AND `vlstventasconlymyorder`.`Cliente` = 1 AND `vlstventasconlymyorder`.`Articulo` = 9609 AND `vlstventasconlymyorder`.`Articulod` = 'QV 6 5' AND `vlstventasconlymyorder`.`Cant` = 1 AND CONCAT(`vlstventasconlymyorder`.`Precio`) = 1 AND `vlstventasconlymyorder`.`Linea` = 48 AND `vlstventasconlymyorder`.`Marca` = 515 AND `vlstventasconlymyorder`.`Linead` = 'SECARROPAS' AND `vlstventasconlymyorder`.`Marcad` = 'DREAN' AND `vlstventasconlymyorder`.`CamNeg` = 'N' AND `vlstventasconlymyorder`.`Loc` = 'SN ' LIMIT 1
131671 2016-06-02 M 1 9609 QV 6 5 1 1 48 515 SECARROPAS DREAN N SN
Edit Edit Copy Copy Delete Delete
DELETE FROM vlstventasconlymyorder WHERE `vlstventasconlymyorder`.`codigo` = 131669 AND `vlstventasconlymyorder`.`Fecha` = '2016-06-02' AND `vlstventasconlymyorder`.`Partida` = 'M' AND `vlstventasconlymyorder`.`Cliente` = 1 AND `vlstventasconlymyorder`.`Articulo` = 10750 AND `vlstventasconlymyorder`.`Articulod` = 'UC-30S' AND `vlstventasconlymyorder`.`Cant` = 1 AND CONCAT(`vlstventasconlymyorder`.`Precio`) = 1 AND `vlstventasconlymyorder`.`Linea` = 79 AND `vlstventasconlymyorder`.`Marca` = 22 AND `vlstventasconlymyorder`.`Linead` = 'HORNOS' AND `vlstventasconlymyorder`.`Marcad` = 'ULTRACOMB' AND `vlstventasconlymyorder`.`CamNeg` = 'N' AND `vlstventasconlymyorder`.`Loc` = 'SN ' LIMIT 1
131669 2016-06-02 M 1 10750 UC-30S 1 1 79 22 HORNOS ULTRACOMB N SN
Edit Edit Copy Copy Delete Delete
DELETE FROM vlstventasconlymyorder WHERE `vlstventasconlymyorder`.`codigo` = 131741 AND `vlstventasconlymyorder`.`Fecha` = '2016-06-03' AND `vlstventasconlymyorder`.`Partida` = 'M' AND `vlstventasconlymyorder`.`Cliente` = 1 AND `vlstventasconlymyorder`.`Articulo` = 8449 AND `vlstventasconlymyorder`.`Articulod` = 'MODELO R' AND `vlstventasconlymyorder`.`Cant` = 6 AND CONCAT(`vlstventasconlymyorder`.`Precio`) = 1 AND `vlstventasconlymyorder`.`Linea` = 13 AND `vlstventasconlymyorder`.`Marca` = 343 AND `vlstventasconlymyorder`.`Linead` = 'SILLAS' AND `vlstventasconlymyorder`.`Marcad` = 'BORDIÑUK' AND `vlstventasconlymyorder`.`CamNeg` = 'N' AND `vlstventasconlymyorder`.`Loc` = 'SN ' LIMIT 1
131741 2016-06-03 M 1 8449 MODELO R 6 1 13 343 SILLAS BORDIÑUK N SN
Edit Edit Copy Copy Delete Delete
DELETE FROM vlstventasconlymyorder WHERE `vlstventasconlymyorder`.`codigo` = 131739 AND `vlstventasconlymyorder`.`Fecha` = '2016-06-03' AND `vlstventasconlymyorder`.`Partida` = 'M' AND `vlstventasconlymyorder`.`Cliente` = 1 AND `vlstventasconlymyorder`.`Articulo` = 3301 AND `vlstventasconlymyorder`.`Articulod` = '080X17 C C' AND `vlstventasconlymyorder`.`Cant` = 1 AND CONCAT(`vlstventasconlymyorder`.`Precio`) = 1 AND `vlstventasconlymyorder`.`Linea` = 14 AND `vlstventasconlymyorder`.`Marca` = 372 AND `vlstventasconlymyorder`.`Linead` = 'COLCHONES' AND `vlstventasconlymyorder`.`Marcad` = 'MI SUEÑITO' AND `vlstventasconlymyorder`.`CamNeg` = 'N' AND `vlstventasconlymyorder`.`Loc` = 'SN' LIMIT 1
131739 2016-06-03 M 1 3301 080X17 C C 1 1 14 372 COLCHONES MI SUEÑITO N SN
Edit Edit Copy Copy Delete Delete
DELETE FROM vlstventasconlymyorder WHERE `vlstventasconlymyorder`.`codigo` = 131741 AND `vlstventasconlymyorder`.`Fecha` = '2016-06-03' AND `vlstventasconlymyorder`.`Partida` = 'M' AND `vlstventasconlymyorder`.`Cliente` = 1 AND `vlstventasconlymyorder`.`Articulo` = 322 AND `vlstventasconlymyorder`.`Articulod` = '1 80 MTS TRAMPA' AND `vlstventasconlymyorder`.`Cant` = 1 AND CONCAT(`vlstventasconlymyorder`.`Precio`) = 1 AND `vlstventasconlymyorder`.`Linea` = 36 AND `vlstventasconlymyorder`.`Marca` = 253 AND `vlstventasconlymyorder`.`Linead` = 'MESAS' AND `vlstventasconlymyorder`.`Marcad` = 'JUAN' AND `vlstventasconlymyorder`.`CamNeg` = 'N' AND `vlstventasconlymyorder`.`Loc` = 'SN ' LIMIT 1
131741 2016-06-03 M 1 322 1 80 MTS TRAMPA 1 1 36 253 MESAS JUAN N SN
Edit Edit Copy Copy Delete Delete
DELETE FROM vlstventasconlymyorder WHERE `vlstventasconlymyorder`.`codigo` = 131737 AND `vlstventasconlymyorder`.`Fecha` = '2016-06-03' AND `vlstventasconlymyorder`.`Partida` = 'M' AND `vlstventasconlymyorder`.`Cliente` = 1 AND `vlstventasconlymyorder`.`Articulo` = 11582 AND `vlstventasconlymyorder`.`Articulod` = 'PANEL CONVECT CH2000B' AND `vlstventasconlymyorder`.`Cant` = 1 AND CONCAT(`vlstventasconlymyorder`.`Precio`) = 1 AND `vlstventasconlymyorder`.`Linea` = 45 AND `vlstventasconlymyorder`.`Marca` = 628 AND `vlstventasconlymyorder`.`Linead` = 'ESTUFAS' AND `vlstventasconlymyorder`.`Marcad` = 'PROTALIA' AND `vlstventasconlymyorder`.`CamNeg` = 'N' AND `vlstventasconlymyorder`.`Loc` = 'SN ' LIMIT 1
131737 2016-06-03 M 1 11582 PANEL CONVECT CH2000B 1 1 45 628 ESTUFAS PROTALIA N SN
Edit Edit Copy Copy Delete Delete
DELETE FROM vlstventasconlymyorder WHERE `vlstventasconlymyorder`.`codigo` = 131740 AND `vlstventasconlymyorder`.`Fecha` = '2016-06-03' AND `vlstventasconlymyorder`.`Partida` = 'M' AND `vlstventasconlymyorder`.`Cliente` = 1 AND `vlstventasconlymyorder`.`Articulo` = 11582 AND `vlstventasconlymyorder`.`Articulod` = 'PANEL CONVECT CH2000B' AND `vlstventasconlymyorder`.`Cant` = 1 AND CONCAT(`vlstventasconlymyorder`.`Precio`) = 1 AND `vlstventasconlymyorder`.`Linea` = 45 AND `vlstventasconlymyorder`.`Marca` = 628 AND `vlstventasconlymyorder`.`Linead` = 'ESTUFAS' AND `vlstventasconlymyorder`.`Marcad` = 'PROTALIA' AND `vlstventasconlymyorder`.`CamNeg` = 'N' AND `vlstventasconlymyorder`.`Loc` = 'SN ' LIMIT 1
131740 2016-06-03 M 1 11582 PANEL CONVECT CH2000B 1 1 45 628 ESTUFAS PROTALIA N SN
Edit Edit Copy Copy Delete Delete
DELETE FROM vlstventasconlymyorder WHERE `vlstventasconlymyorder`.`codigo` = 131738 AND `vlstventasconlymyorder`.`Fecha` = '2016-06-03' AND `vlstventasconlymyorder`.`Partida` = 'M' AND `vlstventasconlymyorder`.`Cliente` = 1 AND `vlstventasconlymyorder`.`Articulo` = 11458 AND `vlstventasconlymyorder`.`Articulod` = 'DEH-X1850UB' AND `vlstventasconlymyorder`.`Cant` = 1 AND CONCAT(`vlstventasconlymyorder`.`Precio`) = 1 AND `vlstventasconlymyorder`.`Linea` = 85 AND `vlstventasconlymyorder`.`Marca` = 109 AND `vlstventasconlymyorder`.`Linead` = 'ESTEREOS' AND `vlstventasconlymyorder`.`Marcad` = 'PIONNER' AND `vlstventasconlymyorder`.`CamNeg` = 'N' AND `vlstventasconlymyorder`.`Loc` = 'SN ' LIMIT 1
131738 2016-06-03 M 1 11458 DEH-X1850UB 1 1 85 109 ESTEREOS PIONNER N SN
Edit Edit Copy Copy Delete Delete
DELETE FROM vlstventasconlymyorder WHERE `vlstventasconlymyorder`.`codigo` = 131732 AND `vlstventasconlymyorder`.`Fecha` = '2016-06-04' AND `vlstventasconlymyorder`.`Partida` = 'M' AND `vlstventasconlymyorder`.`Cliente` = 1 AND `vlstventasconlymyorder`.`Articulo` = 10538 AND `vlstventasconlymyorder`.`Articulod` = 'E-307 CALOVENTOR 1000-2000W' AND `vlstventasconlymyorder`.`Cant` = 1 AND CONCAT(`vlstventasconlymyorder`.`Precio`) = 1 AND `vlstventasconlymyorder`.`Linea` = 45 AND `vlstventasconlymyorder`.`Marca` = 511 AND `vlstventasconlymyorder`.`Linead` = 'ESTUFAS' AND `vlstventasconlymyorder`.`Marcad` = 'EIFFEL' AND `vlstventasconlymyorder`.`CamNeg` = 'N' AND `vlstventasconlymyorder`.`Loc` = 'SN ' LIMIT 1
131732 2016-06-04 M 1 10538 E-307 CALOVENTOR 1000-2000W 1 1 45 511 ESTUFAS EIFFEL N SN
Edit Edit Copy Copy Delete Delete
DELETE FROM vlstventasconlymyorder WHERE `vlstventasconlymyorder`.`codigo` = 131734 AND `vlstventasconlymyorder`.`Fecha` = '2016-06-04' AND `vlstventasconlymyorder`.`Partida` = 'M' AND `vlstventasconlymyorder`.`Cliente` = 1 AND `vlstventasconlymyorder`.`Articulo` = 5098 AND `vlstventasconlymyorder`.`Articulod` = 'S1001 ' AND `vlstventasconlymyorder`.`Cant` = 1 AND CONCAT(`vlstventasconlymyorder`.`Precio`) = 1 AND `vlstventasconlymyorder`.`Linea` = 145 AND `vlstventasconlymyorder`.`Marca` = 101 AND `vlstventasconlymyorder`.`Linead` = 'PLANCHITA PARA EL PELO' AND `vlstventasconlymyorder`.`Marcad` = 'REMIGTON' AND `vlstventasconlymyorder`.`CamNeg` = 'N' AND `vlstventasconlymyorder`.`Loc` = 'SN ' LIMIT 1
131734 2016-06-04 M 1 5098 S1001 1 1 145 101 PLANCHITA PARA EL PELO REMIGTON N SN
Edit Edit Copy Copy Delete Delete
DELETE FROM vlstventasconlymyorder WHERE `vlstventasconlymyorder`.`codigo` = 131733 AND `vlstventasconlymyorder`.`Fecha` = '2016-06-04' AND `vlstventasconlymyorder`.`Partida` = 'M' AND `vlstventasconlymyorder`.`Cliente` = 1 AND `vlstventasconlymyorder`.`Articulo` = 9538 AND `vlstventasconlymyorder`.`Articulod` = '0 60 CM' AND `vlstventasconlymyorder`.`Cant` = 1 AND CONCAT(`vlstventasconlymyorder`.`Precio`) = 1 AND `vlstventasconlymyorder`.`Linea` = 203 AND `vlstventasconlymyorder`.`Marca` = 700 AND `vlstventasconlymyorder`.`Linead` = 'ANTENAS' AND `vlstventasconlymyorder`.`Marcad` = 'DIREC TV' AND `vlstventasconlymyorder`.`CamNeg` = 'N' AND `vlstventasconlymyorder`.`Loc` = 'SN ' LIMIT 1
131733 2016-06-04 M 1 9538 0 60 CM 1 1 203 700 ANTENAS DIREC TV N SN
Edit Edit Copy Copy Delete Delete
DELETE FROM vlstventasconlymyorder WHERE `vlstventasconlymyorder`.`codigo` = 131947 AND `vlstventasconlymyorder`.`Fecha` = '2016-06-06' AND `vlstventasconlymyorder`.`Partida` = 'M' AND `vlstventasconlymyorder`.`Cliente` = 1 AND `vlstventasconlymyorder`.`Articulo` = 3301 AND `vlstventasconlymyorder`.`Articulod` = '080X17 C C' AND `vlstventasconlymyorder`.`Cant` = 1 AND CONCAT(`vlstventasconlymyorder`.`Precio`) = 1 AND `vlstventasconlymyorder`.`Linea` = 14 AND `vlstventasconlymyorder`.`Marca` = 372 AND `vlstventasconlymyorder`.`Linead` = 'COLCHONES' AND `vlstventasconlymyorder`.`Marcad` = 'MI SUEÑITO' AND `vlstventasconlymyorder`.`CamNeg` = 'N' AND `vlstventasconlymyorder`.`Loc` = 'SN ' LIMIT 1
131947 2016-06-06 M 1 3301 080X17 C C 1 1 14 372 COLCHONES MI SUEÑITO N SN
Edit Edit Copy Copy Delete Delete
DELETE FROM vlstventasconlymyorder WHERE `vlstventasconlymyorder`.`codigo` = 131947 AND `vlstventasconlymyorder`.`Fecha` = '2016-06-06' AND `vlstventasconlymyorder`.`Partida` = 'M' AND `vlstventasconlymyorder`.`Cliente` = 1 AND `vlstventasconlymyorder`.`Articulo` = 591 AND `vlstventasconlymyorder`.`Articulod` = 'FIJA ECONOMICA' AND `vlstventasconlymyorder`.`Cant` = 1 AND CONCAT(`vlstventasconlymyorder`.`Precio`) = 1 AND `vlstventasconlymyorder`.`Linea` = 32 AND `vlstventasconlymyorder`.`Marca` = 198 AND `vlstventasconlymyorder`.`Linead` = 'SUPERPUESTAS' AND `vlstventasconlymyorder`.`Marcad` = 'PINO' AND `vlstventasconlymyorder`.`CamNeg` = 'N' AND `vlstventasconlymyorder`.`Loc` = 'SN ' LIMIT 1
131947 2016-06-06 M 1 591 FIJA ECONOMICA 1 1 32 198 SUPERPUESTAS PINO N SN
Edit Edit Copy Copy Delete Delete
DELETE FROM vlstventasconlymyorder WHERE `vlstventasconlymyorder`.`codigo` = 131950 AND `vlstventasconlymyorder`.`Fecha` = '2016-06-06' AND `vlstventasconlymyorder`.`Partida` = 'M' AND `vlstventasconlymyorder`.`Cliente` = 1 AND `vlstventasconlymyorder`.`Articulo` = 10866 AND `vlstventasconlymyorder`.`Articulod` = 'R95-B07 KEROSEN' AND `vlstventasconlymyorder`.`Cant` = 1 AND CONCAT(`vlstventasconlymyorder`.`Precio`) = 1 AND `vlstventasconlymyorder`.`Linea` = 45 AND `vlstventasconlymyorder`.`Marca` = 140 AND `vlstventasconlymyorder`.`Linead` = 'ESTUFAS' AND `vlstventasconlymyorder`.`Marcad` = 'LELUX' AND `vlstventasconlymyorder`.`CamNeg` = 'N' AND `vlstventasconlymyorder`.`Loc` = 'SN ' LIMIT 1
131950 2016-06-06 M 1 10866 R95-B07 KEROSEN 1 1 45 140 ESTUFAS LELUX N SN
Edit Edit Copy Copy Delete Delete
DELETE FROM vlstventasconlymyorder WHERE `vlstventasconlymyorder`.`codigo` = 131948 AND `vlstventasconlymyorder`.`Fecha` = '2016-06-06' AND `vlstventasconlymyorder`.`Partida` = 'M' AND `vlstventasconlymyorder`.`Cliente` = 1 AND `vlstventasconlymyorder`.`Articulo` = 10538 AND `vlstventasconlymyorder`.`Articulod` = 'E-307 CALOVENTOR 1000-2000W' AND `vlstventasconlymyorder`.`Cant` = 1 AND CONCAT(`vlstventasconlymyorder`.`Precio`) = 1 AND `vlstventasconlymyorder`.`Linea` = 45 AND `vlstventasconlymyorder`.`Marca` = 511 AND `vlstventasconlymyorder`.`Linead` = 'ESTUFAS' AND `vlstventasconlymyorder`.`Marcad` = 'EIFFEL' AND `vlstventasconlymyorder`.`CamNeg` = 'N' AND `vlstventasconlymyorder`.`Loc` = 'SN ' LIMIT 1
131948 2016-06-06 M 1 10538 E-307 CALOVENTOR 1000-2000W 1 1 45 511 ESTUFAS EIFFEL N SN
Edit Edit Copy Copy Delete Delete
DELETE FROM vlstventasconlymyorder WHERE `vlstventasconlymyorder`.`codigo` = 131946 AND `vlstventasconlymyorder`.`Fecha` = '2016-06-06' AND `vlstventasconlymyorder`.`Partida` = 'M' AND `vlstventasconlymyorder`.`Cliente` = 1 AND `vlstventasconlymyorder`.`Articulo` = 11610 AND `vlstventasconlymyorder`.`Articulod` = 'HN16T TURBO HALOGENA 1600W' AND `vlstventasconlymyorder`.`Cant` = 1 AND CONCAT(`vlstventasconlymyorder`.`Precio`) = 1 AND `vlstventasconlymyorder`.`Linea` = 45 AND `vlstventasconlymyorder`.`Marca` = 628 AND `vlstventasconlymyorder`.`Linead` = 'ESTUFAS' AND `vlstventasconlymyorder`.`Marcad` = 'PROTALIA' AND `vlstventasconlymyorder`.`CamNeg` = 'N' AND `vlstventasconlymyorder`.`Loc` = 'SN' LIMIT 1
131946 2016-06-06 M 1 11610 HN16T TURBO HALOGENA 1600W 1 1 45 628 ESTUFAS PROTALIA N SN
Edit Edit Copy Copy Delete Delete
DELETE FROM vlstventasconlymyorder WHERE `vlstventasconlymyorder`.`codigo` = 131951 AND `vlstventasconlymyorder`.`Fecha` = '2016-06-06' AND `vlstventasconlymyorder`.`Partida` = 'M' AND `vlstventasconlymyorder`.`Cliente` = 1 AND `vlstventasconlymyorder`.`Articulo` = 6698 AND `vlstventasconlymyorder`.`Articulod` = '100 LTS ' AND `vlstventasconlymyorder`.`Cant` = 1 AND CONCAT(`vlstventasconlymyorder`.`Precio`) = 1 AND `vlstventasconlymyorder`.`Linea` = 69 AND `vlstventasconlymyorder`.`Marca` = 132 AND `vlstventasconlymyorder`.`Linead` = 'CARRETILLAS' AND `vlstventasconlymyorder`.`Marcad` = 'ROPAL' AND `vlstventasconlymyorder`.`CamNeg` = 'N' AND `vlstventasconlymyorder`.`Loc` = 'SN ' LIMIT 1
131951 2016-06-06 M 1 6698 100 LTS 1 1 69 132 CARRETILLAS ROPAL N SN
Edit Edit Copy Copy Delete Delete
DELETE FROM vlstventasconlymyorder WHERE `vlstventasconlymyorder`.`codigo` = 131949 AND `vlstventasconlymyorder`.`Fecha` = '2016-06-06' AND `vlstventasconlymyorder`.`Partida` = 'M' AND `vlstventasconlymyorder`.`Cliente` = 1 AND `vlstventasconlymyorder`.`Articulo` = 7545 AND `vlstventasconlymyorder`.`Articulod` = 'E-206 VAPOR CON ROCIADOR' AND `vlstventasconlymyorder`.`Cant` = 1 AND CONCAT(`vlstventasconlymyorder`.`Precio`) = 1 AND `vlstventasconlymyorder`.`Linea` = 95 AND `vlstventasconlymyorder`.`Marca` = 511 AND `vlstventasconlymyorder`.`Linead` = 'PLANCHAS' AND `vlstventasconlymyorder`.`Marcad` = 'EIFFEL' AND `vlstventasconlymyorder`.`CamNeg` = 'N' AND `vlstventasconlymyorder`.`Loc` = 'SN ' LIMIT 1
131949 2016-06-06 M 1 7545 E-206 VAPOR CON ROCIADOR 1 1 95 511 PLANCHAS EIFFEL N SN
With selected: With selected:
Query results operations Copy to clipboard Copy to clipboard Export Export Display chart Display chart Create view Create view