SitePoint Sponsor

User Tag List

Results 1 to 19 of 19
  1. #1
    SitePoint Evangelist Miguel61's Avatar
    Join Date
    Mar 2008
    Posts
    408
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)

    Problem with subquery

    Hi all, I need your appreciated help.

    I need this output:
    Code:
    +----------+--------+-----+------------------------+------------+
    | COUNT(*) | Combo  | Q   | text                   | LastDate   |
    +----------+--------+-----+------------------------+------------+
    |     5954 | Combo1 |   3 | to be treated          | 20/02/2014 |
    |     5954 | Combo1 | 118 | regular                | 20/02/2014 |
    |     5954 | Combo1 |   6 | verification Required  | 20/02/2014 |
    |     5954 | Combo1 |   9 | required control       | 20/02/2014 |
    |     7171 | Combo2 |   7 | regular                | 20/02/2014 |
    |     7171 | Combo2 |   1 | verification Required  | 20/02/2014 |
    |     7171 | Combo2 |  42 | required control       | 20/02/2014 |
    |     7888 | Combo3 | 379 | regular                | 20/02/2014 |
    |     7888 | Combo3 |  54 | verification Required  | 20/02/2014 |
    |     7888 | Combo3 |  78 | required control       | 20/02/2014 |
    |     1942 | Combo4 | 224 | regular                | 20/02/2014 |
    |     1942 | Combo4 |  26 | verification Required  | 20/02/2014 |
    +----------+--------+-----+------------------------+------------+
    12 rows in set
    And this is my step to step, first sql query:
    Code:
    mysql> SELECT
    	CASE
    WHEN LEFT (area, 2) = '2I' THEN
    	'Combo1'
    WHEN LEFT (area, 2) = '2M' THEN
    	'Combo2'
    WHEN LEFT (area, 2) = '2O' THEN
    	'Combo3'
    WHEN LEFT (area, 2) = '2S' THEN
    	'Combo4'
    ELSE
    	'tot'
    END AS Combo,
     COUNT(*)
    FROM
    	doTable
    GROUP BY
    	LEFT (area, 2) WITH ROLLUP;
    +--------+----------+
    | Combo  | COUNT(*) |
    +--------+----------+
    | Combo1 |     5954 |
    | Combo2 |     7171 |
    | Combo3 |     7888 |
    | Combo4 |     1942 |
    | Combo4 |    22955 |
    +--------+----------+
    5 rows in set
    Next sql query:
    Code:
    mysql> SELECT
    	CASE
    WHEN LEFT (area, 2) = '2I' THEN
    	'Combo1'
    WHEN LEFT (area, 2) = '2M' THEN
    	'Combo2'
    WHEN LEFT (area, 2) = '2O' THEN
    	'Combo3'
    ELSE
    	'Combo4'
    END AS Combo,
     COUNT(text) AS q,
     text AS text,
     DATE_FORMAT(CURRENT_DATE(), '%d/%m/%Y') AS LastDate
    FROM
    	doTable
    WHERE
    	text IS NOT NULL
    AND text > ''
    GROUP BY
    	Combo,
    	text;
    
    +--------+-----+------------------------+------------+
    | Combo  | q   | text                   | LastDate   |
    +--------+-----+------------------------+------------+
    | Combo1 |   3 | to be treated          | 20/02/2014 |
    | Combo1 | 118 | regular                | 20/02/2014 |
    | Combo1 |   6 | verification Required  | 20/02/2014 |
    | Combo1 |   9 | required control       | 20/02/2014 |
    | Combo2 |   7 | regular                | 20/02/2014 |
    | Combo2 |   1 | verification Required  | 20/02/2014 |
    | Combo2 |  42 | required control       | 20/02/2014 |
    | Combo3 | 379 | regular                | 20/02/2014 |
    | Combo3 |  54 | verification Required  | 20/02/2014 |
    | Combo3 |  78 | required control       | 20/02/2014 |
    | Combo4 | 224 | regular                | 20/02/2014 |
    | Combo4 |  26 | verification Required  | 20/02/2014 |
    +--------+-----+------------------------+------------+
    12 rows in set
    Final sql query:
    Code:
    mysql> SELECT
    	COUNT(*),
    	Combo,
    	Q,
    	text,
    	LastDate
    FROM
    	(
    		SELECT
    			CASE
    		WHEN LEFT (area, 2) = '2I' THEN
    			'Combo1'
    		WHEN LEFT (area, 2) = '2M' THEN
    			'Combo2'
    		WHEN LEFT (area, 2) = '2O' THEN
    			'Combo3'
    		ELSE
    			'Combo4'
    		END AS Combo,
    		COUNT(text) AS q,
    		text AS text,
    		DATE_FORMAT(CURRENT_DATE(), '%d/%m/%Y') AS LastDate
    	FROM
    		doTable
    	WHERE
    		text IS NOT NULL
    	AND text > ''
    	GROUP BY
    		Combo,
    		text
    	) q
    WHERE
    	q.text IS NOT NULL
    AND q.text > ''
    GROUP BY
    	Combo,
    	text;
    +----------+--------+-----+------------------------+------------+
    | COUNT(*) | Combo  | Q   | text                   | LastDate   |
    +----------+--------+-----+------------------------+------------+
    |        1 | Combo1 |   3 | to be treated          | 20/02/2014 |
    |        1 | Combo1 | 118 | regular                | 20/02/2014 |
    |        1 | Combo1 |   6 | verification Required  | 20/02/2014 |
    |        1 | Combo1 |   9 | required control       | 20/02/2014 |
    |        1 | Combo2 |   7 | regular                | 20/02/2014 |
    |        1 | Combo2 |   1 | verification Required  | 20/02/2014 |
    |        1 | Combo2 |  42 | required control       | 20/02/2014 |
    |        1 | Combo3 | 379 | regular                | 20/02/2014 |
    |        1 | Combo3 |  54 | verification Required  | 20/02/2014 |
    |        1 | Combo3 |  78 | required control       | 20/02/2014 |
    |        1 | Combo4 | 224 | regular                | 20/02/2014 |
    |        1 | Combo4 |  26 | verification Required  | 20/02/2014 |
    +----------+--------+-----+------------------------+------------+
    12 rows in set
    The output is wrong.... can you help me?
    Thank you in advance for any help.

  2. #2
    From Italy with love silver trophybronze trophy
    guido2004's Avatar
    Join Date
    Sep 2004
    Posts
    9,509
    Mentioned
    163 Post(s)
    Tagged
    4 Thread(s)
    I don't see where the third query is coming from?
    Why don't you do a join of the first two queries, I think that'll give what you're looking for.

  3. #3
    SitePoint Evangelist Miguel61's Avatar
    Join Date
    Mar 2008
    Posts
    408
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)
    I'm sorry I don't understand your help ...

  4. #4
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,341
    Mentioned
    63 Post(s)
    Tagged
    3 Thread(s)
    Quote Originally Posted by Miguel61 View Post
    I'm sorry I don't understand your help ...
    he means you should join the second query to the first query

    like this --
    Code:
    SELECT query1.combo_count AS `COUNT(*)`
         , query1.combo
         , query2.q
         , query2.text
         , query2.lastdate
      FROM ( SELECT CASE LEFT(area, 2)
                         WHEN '2I' THEN 'Combo1'
                         WHEN '2M' THEN 'Combo2'
                         WHEN '2O' THEN 'Combo3'
                         WHEN '2S' THEN 'Combo4'
                                   ELSE 'tot' END AS Combo
                  , COUNT(*) AS combo_count
               FROM doTable
             GROUP 
                 BY LEFT(area, 2) WITH ROLLUP ) AS query1
    LEFT OUTER
      JOIN ( SELECT CASE LEFT(area, 2)
                         WHEN '2I' THEN 'Combo1'
                         WHEN '2M' THEN 'Combo2'
                         WHEN '2O' THEN 'Combo3'
                                   ELSE 'Combo4' END AS Combo
                  , COUNT(text) AS q
                  , text AS text
                  , DATE_FORMAT(CURRENT_DATE(),'%d/%m/%Y') AS LastDate
               FROM doTable
              WHERE text > ''
             GROUP 
                 BY Combo
                  , text ) AS query2
    
        ON query2.combo = query1.combo
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  5. #5
    SitePoint Evangelist Miguel61's Avatar
    Join Date
    Mar 2008
    Posts
    408
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)
    Many thanks for help and now I've this output:
    Code:
    +----------+--------+-----+------------------------+------------+
    | COUNT(*) | Combo  | Q   | text                   | LastDate   |
    +----------+--------+-----+------------------------+------------+
    |     5954 | Combo1 |   3 | to be treated          | 20/02/2014 |
    |     5954 | Combo1 | 118 | regular                | 20/02/2014 |
    |     5954 | Combo1 |   6 | verification Required  | 20/02/2014 |
    |     5954 | Combo1 |   9 | required control       | 20/02/2014 |
    |     7171 | Combo2 |   7 | regular                | 20/02/2014 |
    |     7171 | Combo2 |   1 | verification Required  | 20/02/2014 |
    |     7171 | Combo2 |  42 | required control       | 20/02/2014 |
    |     7888 | Combo3 | 379 | regular                | 20/02/2014 |
    |     7888 | Combo3 |  54 | verification Required  | 20/02/2014 |
    |     7888 | Combo3 |  78 | required control       | 20/02/2014 |
    |     1942 | Combo4 | 224 | regular                | 20/02/2014 |
    |     1942 | Combo4 |  26 | verification Required  | 20/02/2014 |
    |    22955 | Combo4 | 224 | regular                | 20/02/2014 |
    |    22955 | Combo4 |  26 | verification Required  | 20/02/2014 |
    +----------+--------+-----+------------------------+------------+
    In the final output I've in the column `Combo`, `Q` and `test` the last two lines are duplicated, why?:
    Code:
    |     1942 | Combo4 | 224 | regular                | 20/02/2014 |
    |     1942 | Combo4 |  26 | verification Required  | 20/02/2014 |
    |    22955 | Combo4 | 224 | regular                | 20/02/2014 |
    |    22955 | Combo4 |  26 | verification Required  | 20/02/2014 |
    +----------+--------+-----+------------------------+------------+

  6. #6
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,341
    Mentioned
    63 Post(s)
    Tagged
    3 Thread(s)
    Quote Originally Posted by Miguel61 View Post
    In the final output I've in the column `Combo`, `Q` and `test` the last two lines are duplicated, why?
    most likely this is due to WITH ROLLUP

    see Combo4 22955 in your first post
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  7. #7
    SitePoint Evangelist Miguel61's Avatar
    Join Date
    Mar 2008
    Posts
    408
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)
    Yes right, Sir .. but I think in this output WITH ROLLUP :
    Code:
    +----------+--------+-----+------------------------+------------+
    | COUNT(*) | Combo  | Q   | text                   | LastDate   |
    +----------+--------+-----+------------------------+------------+
    |     5954 | Combo1 |   3 | to be treated          | 20/02/2014 |
    |     5954 | Combo1 | 118 | regular                | 20/02/2014 |
    |     5954 | Combo1 |   6 | verification Required  | 20/02/2014 |
    |     5954 | Combo1 |   9 | required control       | 20/02/2014 |
    |     7171 | Combo2 |   7 | regular                | 20/02/2014 |
    |     7171 | Combo2 |   1 | verification Required  | 20/02/2014 |
    |     7171 | Combo2 |  42 | required control       | 20/02/2014 |
    |     7888 | Combo3 | 379 | regular                | 20/02/2014 |
    |     7888 | Combo3 |  54 | verification Required  | 20/02/2014 |
    |     7888 | Combo3 |  78 | required control       | 20/02/2014 |
    |     1942 | Combo4 | 224 | regular                | 20/02/2014 |
    |     1942 | Combo4 |  26 | verification Required  | 20/02/2014 |
    |    22955 | tot    | 947 |                        |            |
    +----------+--------+-----+------------------------+------------+
    where:
    Code:
    SELECT CASE LEFT(area, 2)
                         WHEN '2I' THEN 'Combo1'
                         WHEN '2M' THEN 'Combo2'
                         WHEN '2O' THEN 'Combo3'
                         WHEN '2S' THEN 'Combo4'
                                   ELSE 'tot' END AS Combo

  8. #8
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,341
    Mentioned
    63 Post(s)
    Tagged
    3 Thread(s)
    Quote Originally Posted by Miguel61 View Post
    Yes right, Sir .. but I think in this output WITH ROLLUP :
    yes, exactly the reason

    you understand now how to join subqueries, so fixing that problem should be easy
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  9. #9
    Just Blow It bronze trophy
    DaveMaxwell's Avatar
    Join Date
    Nov 1999
    Location
    Mechanicsburg, PA
    Posts
    7,290
    Mentioned
    122 Post(s)
    Tagged
    1 Thread(s)
    The case for the 2nd query is inconsistent with the first -

    This
    WHEN '2O' THEN 'Combo3'
    ELSE 'Combo4' END AS Combo

    Should be
    WHEN '2O' THEN 'Combo3'
    WHEN '2S' THEN 'Combo4
    ELSE 'tot' END AS Combo
    Dave Maxwell - Manage Your Site Team Leader
    My favorite YouTube Video! | Star Wars, Dr Suess Style
    Learn how to be ready for The Forums' Move to Discourse

  10. #10
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,341
    Mentioned
    63 Post(s)
    Tagged
    3 Thread(s)
    Quote Originally Posted by DaveMaxwell View Post
    The case for the 2nd query is inconsistent with the first
    indeed

    i wasn't going to mention those discepancies unless miguel came back with a plea for more help understanding ROLLUP
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  11. #11
    Just Blow It bronze trophy
    DaveMaxwell's Avatar
    Join Date
    Nov 1999
    Location
    Mechanicsburg, PA
    Posts
    7,290
    Mentioned
    122 Post(s)
    Tagged
    1 Thread(s)
    Quote Originally Posted by r937 View Post
    indeed

    i wasn't going to mention those discepancies unless miguel came back with a plea for more help understanding ROLLUP
    Ah. I have never used ROLLUP before (should have based on quick search), but since the case was wrong, the join would be wrong which would guarantee ROLLUP would be wrong.
    Dave Maxwell - Manage Your Site Team Leader
    My favorite YouTube Video! | Star Wars, Dr Suess Style
    Learn how to be ready for The Forums' Move to Discourse

  12. #12
    SitePoint Evangelist Miguel61's Avatar
    Join Date
    Mar 2008
    Posts
    408
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by r937 View Post
    yes, exactly the reason

    you understand now how to join subqueries, so fixing that problem should be easy
    I've changed the query:
    Code:
    SELECT query1.combo_count AS `COUNT(*)`
         , query1.combo
         , query2.q
         , query2.text
         , query2.lastdate
      FROM ( SELECT CASE LEFT(area, 2)
                         WHEN '2I' THEN 'Combo1'
                         WHEN '2M' THEN 'Combo2'
                         WHEN '2O' THEN 'Combo3'
                         WHEN '2S' THEN 'Combo4'
                                   ELSE 'tot' END AS Combo
                  , COUNT(*) AS combo_count
               FROM doTable
             GROUP 
                 BY LEFT(area, 2) WITH ROLLUP ) AS query1
    LEFT OUTER
      JOIN ( SELECT CASE LEFT(area, 2)
                         WHEN '2I' THEN 'Combo1'
                         WHEN '2M' THEN 'Combo2'
                         WHEN '2O' THEN 'Combo3'
                         WHEN '2S' THEN 'Combo4'
                                   ELSE 'tot' END AS Combo
                  , COUNT(text) AS q
                  , text AS text
                  , DATE_FORMAT(CURRENT_DATE(),'%d/%m/%Y') AS LastDate
               FROM doTable
              WHERE text > ''
             GROUP 
                 BY Combo
                  , text ) AS query2
    
        ON query2.combo = query1.combo
    But the output not change...
    Code:
    +----------+--------+-----+------------------------+------------+
    | COUNT(*) | Combo  | Q   | text                   | LastDate   |
    +----------+--------+-----+------------------------+------------+
    |     5954 | Combo1 |   3 | to be treated          | 20/02/2014 |
    |     5954 | Combo1 | 118 | regular                | 20/02/2014 |
    |     5954 | Combo1 |   6 | verification Required  | 20/02/2014 |
    |     5954 | Combo1 |   9 | required control       | 20/02/2014 |
    |     7171 | Combo2 |   7 | regular                | 20/02/2014 |
    |     7171 | Combo2 |   1 | verification Required  | 20/02/2014 |
    |     7171 | Combo2 |  42 | required control       | 20/02/2014 |
    |     7888 | Combo3 | 379 | regular                | 20/02/2014 |
    |     7888 | Combo3 |  54 | verification Required  | 20/02/2014 |
    |     7888 | Combo3 |  78 | required control       | 20/02/2014 |
    |     1942 | Combo4 | 224 | regular                | 20/02/2014 |
    |     1942 | Combo4 |  26 | verification Required  | 20/02/2014 |
    |    22955 | Combo4 | 224 | regular                | 20/02/2014 |
    |    22955 | Combo4 |  26 | verification Required  | 20/02/2014 |
    +----------+--------+-----+------------------------+------------+

  13. #13
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,341
    Mentioned
    63 Post(s)
    Tagged
    3 Thread(s)
    Quote Originally Posted by Miguel61 View Post
    But the output not change...
    see post #6
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  14. #14
    SitePoint Evangelist Miguel61's Avatar
    Join Date
    Mar 2008
    Posts
    408
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by r937 View Post
    see post #6
    Okey, I see.. This means that I can't have the output in #1 ?

  15. #15
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,341
    Mentioned
    63 Post(s)
    Tagged
    3 Thread(s)
    Quote Originally Posted by Miguel61 View Post
    Okey, I see.. This means that I can't have the output in #1 ?
    no

    it means that you can have it, if you fix the problem

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  16. #16
    SitePoint Evangelist Miguel61's Avatar
    Join Date
    Mar 2008
    Posts
    408
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)
    Okey thank you... this is the new version of query and new output ... in the column `COUNT(*) ` I've the total right ... but why I don't see the total in the column `Q` ? And e.g. how to replace `2I` with `Combo1` ?
    Code:
    SELECT query1.combo_count AS `COUNT(*)`
         , IFNULL(query1.combo, 'Tot') AS `Combo`,
         , query2.q
         , query2.text
         , query2.lastdate
      FROM ( SELECT LEFT(area, 2) AS Combo
                  , COUNT(*) AS combo_count
               FROM doTable
             GROUP 
                 BY LEFT(area, 2) WITH ROLLUP ) AS query1
    LEFT OUTER
      JOIN ( SELECT LEFT(area, 2) AS Combo
                  , COUNT(text) AS q
                  , text AS text
                  , DATE_FORMAT(CURRENT_DATE(),'%d/%m/%Y') AS LastDate
               FROM doTable
              WHERE text > ''
             GROUP 
                 BY Combo
                  , text ) AS query2
        ON query2.combo = query1.combo;
    
    
    +----------+--------+--------+------------------------+------------+
    | COUNT(*) | Combo  | Q      | text                   | LastDate   |
    +----------+--------+--------+------------------------+------------+
    |     5954 | 2I     |   3    | to be treated          | 20/02/2014 |
    |     5954 | 2I     | 118    | regular                | 20/02/2014 |
    |     5954 | 2I     |   6    | verification Required  | 20/02/2014 |
    |     5954 | 2I     |   9    | required control       | 20/02/2014 |
    |     7171 | 2M     |   7    | regular                | 20/02/2014 |
    |     7171 | 2M     |   1    | verification Required  | 20/02/2014 |
    |     7171 | 2M     |  42    | required control       | 20/02/2014 |
    |     7888 | 2O     | 379    | regular                | 20/02/2014 |
    |     7888 | 2O     |  54    | verification Required  | 20/02/2014 |
    |     7888 | 2O     |  78    | required control       | 20/02/2014 |
    |     1942 | 2S     | 224    | regular                | 20/02/2014 |
    |     1942 | 2S     |  26    | verification Required  | 20/02/2014 |
    |    22955 | Tot    | (NULL) | (NULL)                 | (NULL)     |
    +----------+--------+--------+------------------------+------------+

  17. #17
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,341
    Mentioned
    63 Post(s)
    Tagged
    3 Thread(s)
    Quote Originally Posted by Miguel61 View Post
    but why I don't see the total in the column `Q` ?
    because there's no ROLLUP in query2
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  18. #18
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,341
    Mentioned
    63 Post(s)
    Tagged
    3 Thread(s)
    Quote Originally Posted by Miguel61 View Post
    And e.g. how to replace `2I` with `Combo1` ?
    use a CASE expression
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  19. #19
    SitePoint Evangelist Miguel61's Avatar
    Join Date
    Mar 2008
    Posts
    408
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by r937 View Post
    because there's no ROLLUP in query2
    I'm sorry but in this mode the output is:
    Code:
    SELECT query1.combo_count AS `COUNT(*)`
         , IFNULL(query1.combo, 'Tot') AS `Combo`
         , query2.q
         , IFNULL(
    		query2.text,
    		CONCAT('Tot', ' ' , query1.combo)
    	) AS `text`
         , query2.lastdate
      FROM ( SELECT LEFT(area, 2) AS Combo
                  , COUNT(*) AS combo_count
               FROM doTable
             GROUP 
                 BY LEFT(area, 2) WITH ROLLUP ) AS query1
    LEFT OUTER
      JOIN ( SELECT LEFT(area, 2) AS Combo
                  , COUNT(text) AS q
                  , text AS text
                  , DATE_FORMAT(CURRENT_DATE(),'%d/%m/%Y') AS LastDate
               FROM doTable
              WHERE text > ''
             GROUP 
                 BY Combo 
                  , text WITH ROLLUP ) AS query2
        ON query2.combo = query1.combo;
    
    
    +----------+--------+--------+------------------------+------------+
    | COUNT(*) | Combo  | Q      | text                   | LastDate   |
    +----------+--------+--------+------------------------+------------+
    |     5954 | 2I     |   3    | to be treated          | 20/02/2014 |
    |     5954 | 2I     | 118    | regular                | 20/02/2014 |
    |     5954 | 2I     |   6    | verification Required  | 20/02/2014 |
    |     5954 | 2I     |   9    | required control       | 20/02/2014 |
    |     5954 | 2I     | 136    | Tot 2I                 | 20/02/2014 |
    
    |     7171 | 2M     |   7    | regular                | 20/02/2014 |
    |     7171 | 2M     |   1    | verification Required  | 20/02/2014 |
    |     7171 | 2M     |  42    | required control       | 20/02/2014 |
    |     7171 | 2M     |  50    | Tot 2M                 | 20/02/2014 |
    
    |     7888 | 2O     | 379    | regular                | 20/02/2014 |
    |     7888 | 2O     |  54    | verification Required  | 20/02/2014 |
    |     7888 | 2O     |  78    | required control       | 20/02/2014 |
    |     7888 | 2O     | 511    | Tot 2O                 | 20/02/2014 |
    
    |     1942 | 2S     | 224    | regular                | 20/02/2014 |
    |     1942 | 2S     |  26    | verification Required  | 20/02/2014 |
    |     1942 | 2S     | 250    | Tot 2S                 | 20/02/2014 |
    
    |    22955 | Tot    | (NULL) | (NULL)                 | (NULL)     |
    +----------+--------+--------+------------------------+------------+


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •