The Making of a Doctor

By Julius Adebiyi Sodipo

Part Four of PHP codings formulated by Segun, as described, at the back of volume 18. Query results showing PHP codings to: (1) Last 20 patients seen in October 2010. (2) Appointments before 1050 hours and after 1730 hours in October 2014. (3) Patients seen in October 2010 who had similar entered complaints entries as those seen in October 2009, each of them in both months having consultation time of more than 10 minutes.
JanuaryConsultationDatabase and OnCallDatabase codings which are required for the appropriate C#.Net codings.
Comments about Forms design and insight into the appreciation of the message of the project specified in all the 19 volumes.

• Language: English
• Publisher: Balboa Press UK
• Release date: Jan 27, 2022
• ISBN: 9781982285159

Book preview

Copyright © 2022 Julius Adebiyi Sodipo.

All rights reserved. No part of this book may be used or reproduced by any means,

graphic, electronic, or mechanical, including photocopying, recording, taping or by

any information storage retrieval system without the written permission of the author

except in the case of brief quotations embodied in critical articles and reviews.

Balboa Press

A Division of Hay House

1663 Liberty Drive

Bloomington, IN 47403

www.balboapress.co.uk

UK TFN: 0800 0148647 (Toll Free inside the UK)

UK Local: (02) 0369 56325 ([phone] from outside the UK)

Because of the dynamic nature of the Internet, any web addresses or links contained in

this book may have changed since publication and may no longer be valid. The views

expressed in this work are solely those of the author and do not necessarily reflect the

views of the publisher, and the publisher hereby disclaims any responsibility for them.

The author of this book does not dispense medical advice or prescribe the use of any

technique as a form of treatment for physical, emotional, or medical problems without the

advice of a physician, either directly or indirectly. The intent of the author is only to offer

information of a general nature to help you in your quest for emotional and spiritual well-

being. In the event you use any of the information in this book for yourself, which is your

constitutional right, the author and the publisher assume no responsibility for your actions.

Any people depicted in stock imagery provided by Getty Images are models,

and such images are being used for illustrative purposes only.

Certain stock imagery © Getty Images.

ISBN: 978-1-9822-8514-2 (sc)

ISBN: 978-1-9822-8516-6 (hc)

ISBN: 978-1-9822-8515-9 (e)

Balboa Press rev. date:  01/27/2022

CONTENTS

Dedication

Appreciation

AIM

Introduction

Experience of a solo GP (virtually) Practice in suburban England (PHP coding) Part 4

Last 20 patients seen in October 2010

Appointments before 1050 hours and after 1730 hours in October 2014

Patients seen in October 2010 who had similar entered complaints entries as those seen in October 2009, each of them in both months having consultation time of more than 10 minutes

JanuaryConsultationDatabase

OnCallDatabaseNew

Forms Design

The Project throughout all the volumes

DEDICATION

I dedicate this book to my four sons:

Julius Adedeji, John Adesola, Isaac Adetokunbo and Johnson Adeyinka;

their mother Gloria Adanma;

to the memory of my:

father’s father Papa (Chief) Isaac Omolaja Sodipo;

father’s mother Madam Bilewunmi-omo Sodipo (alias Iya Ita-oloti);

mother’s mother Nee Alice Aina Ero-Phillips (alias Iya Alakara);

mother Madam (Chief) Harriet Olufunke Ibidunni Sodipo

father, Dr (Chief) John Adewunmi Akanbi Sodipo.

APPRECIATION

I will like to thank my wife, Gloria Adanma (Nee Okoroafor), for showing fleeting interests during the production of the whole project and to thank my son, Isaac Adetokunbo, for editing and proof-reading the book.

AIM

Any proceeds from the sale(s) or distribution of this book should be used in setting up a Fund, which should be invested in a safe investment. This fund should be called Dr Julius Adebiyi Sodipo’s Fund.

All the proceeds being generated from the sale of the book (or project) as well as all the proceeds from his estate should be deposited as Capital into the fund. The managers of the Estate Fund should not get more than 10% of the income generated by the Fund each year. The proceeds in the Fund should be invested in a relatively safe investment and what is generated should be called the Fund Income.

So, should any of the remaining of my estate, after deduction of any debts and taxes should be added to the Dr Julius Adebiyi Sodipo’s Fund. The monies in the fund should be distributed from time to time occasionally but regularly to my biological grandchildren, biological great grandchildren, biological great great grandchildren, and biological generations yet to be born with no conditions attached. For example, for those who are eligible i.e., my biological descendants, 30 percent of the yearly income should be distributed equally yearly rather than 5 percent monthly. Those who are managing the Fund and its distribution should receive 5 to 10 percent of the yearly income, as appropriate to use in maintaining the fund and as their fees.

The remaining 90% (or 95%) of the yearly income generated by the Estate Fund, reiterated here, should be equally divided between the biological posterity of Dr Julius Adebiyi Sodipo for generations to come including those yet unborn for as long as possible as far as the Estate exists.

The division of the Estate Fund’s income should be as follows:

Each member of his (my) biological posterity should get their own share from the age of 30 years old until the age of 55 years old, or they are no longer alive if this should happen earlier. As reiterated earlier their own share should be given to them yearly or more frequently if the managers feel it is in the best interest of the recipient to do so.

An independent legal firm (team) mutually agreeable to most of the stakeholders must be employed. The legal firm is to ensure the smooth running by the Fund Managers, to ensure that the managers keep to the protocol set out above or not to significantly deviate from it. The legal team should receive 5% of the yearly income of the fund as their renumeration.

INTRODUCTION

This idea and realism of writing this book came to me to write a brief overview of Segun as a teenager in his country of birth of Nigeria and to travel through his journey from then until about his retirement as a doctor. There will be inevitable gaps, for which Segun whole-heartedly apologises. A sizeable amount is allocated to life before his university days. There is a noticeable abrupt end and allocation of the book towards his experience as a medical student. This is done on purpose in view of the way Segun felt and still feels being unfairly treated towards the end of his period as a student in the University. Efforts to introduce his experiences as a doctor are deliberate and apologies for any perceived idea of turning the contents of the book to more of science. Segun feels this is necessary to be able to show his experiences and knowledge as a medical doctor.

57790.png

EXPERIENCE OF A SOLO GP

(VIRTUALLY) PRACTICE IN SUBURBAN

ENGLAND (PHP CODING) PART 4

//November query statements:

//SETTING OUT THE DATA IN THE $sqlquery ARRAY & PICKING THE APPROPRIATE ONE

//LINE 2308

$query[0] = SELECT * FROM november2006 WHERE Notes LIKE ‘%c%’;

$query[1] = SELECT * FROM november2007 WHERE Notes LIKE ‘%c%’;

$query[2] = SELECT * FROM november2008 WHERE Notes LIKE ‘%c%’;

$query[3] = SELECT * FROM november2009 WHERE Notes LIKE ‘%c%’;

$query[4] = SELECT * FROM november2010 WHERE Notes LIKE ‘%c%’;

$query[5] = SELECT * FROM november2011 WHERE Notes LIKE ‘%c%’;

$query[6] = SELECT * FROM november2012 WHERE Notes LIKE ‘%c%’;

$query[7] = SELECT * FROM november2013 WHERE Notes LIKE ‘%c%’;

$query[8] = SELECT * FROM november2014 WHERE Notes LIKE ‘%c%’;

$query[9] = SELECT * FROM november2015 WHERE Notes LIKE ‘%c%’;

$query[10] = SELECT * FROM november2006 A WHERE EXISTS (SELECT * FROM november2007 B WHERE (A.Notes = B.Notes OR A.Treatments = B.Treatments OR A.DateOfBirth = B.DateOfBIrth) AND A.Notes <> ‘’ AND B.Notes <> ‘’ AND A.Treatments <> ‘’ AND B.Treatments <> ‘’);

$query[11] = SELECT * FROM november2007 A WHERE EXISTS (SELECT * FROM november2008 B WHERE (A.Notes = B.Notes OR A.Treatments = B.Treatments OR A.DateOfBirth = B.DateOfBIrth) AND A.Notes <> ‘’ AND B.Notes <> ‘’ AND A.Treatments <> ‘’ AND B.Treatments <> ‘’);

$query[12] = SELECT * FROM november2008 A WHERE EXISTS (SELECT * FROM november2009 B WHERE (A.Notes = B.Notes OR A.Treatments = B.Treatments OR A.DateOfBirth = B.DateOfBIrth) AND A.Notes <> ‘’ AND B.Notes <> ‘’ AND A.Treatments <> ‘’ AND B.Treatments <> ‘’);

$query[13] = SELECT * FROM november2009 A WHERE EXISTS (SELECT * FROM november2010 B WHERE (A.Notes = B.Notes OR A.Treatments = B.Treatments OR A.DateOfBirth = B.DateOfBIrth) AND A.Notes <> ‘’ AND B.Notes <> ‘’ AND A.Treatments <> ‘’ AND B.Treatments <> ‘’);

$query[14] = SELECT * FROM november2010 A WHERE EXISTS (SELECT * FROM november2011 B WHERE (A.Notes = B.Notes OR A.Treatments = B.Treatments OR A.DateOfBirth = B.DateOfBIrth) AND A.Notes <> ‘’ AND B.Notes <> ‘’ AND A.Treatments <> ‘’ AND B.Treatments <> ‘’);

$query[15] = SELECT * FROM november2011 A WHERE EXISTS (SELECT * FROM november2012 B WHERE (A.Notes = B.Notes OR A.Treatments = B.Treatments OR A.DateOfBirth = B.DateOfBIrth) AND A.Notes <> ‘’ AND B.Notes <> ‘’ AND A.Treatments <> ‘’ AND B.Treatments <> ‘’);

$query[16] = SELECT * FROM november2012 A WHERE EXISTS (SELECT * FROM november2013 B WHERE (A.Notes = B.Notes OR A.Treatments = B.Treatments OR A.DateOfBirth = B.DateOfBIrth) AND A.Notes <> ‘’ AND B.Notes <> ‘’ AND A.Treatments <> ‘’ AND B.Treatments <> ‘’);

$query[17] = SELECT * FROM november2013 A WHERE EXISTS (SELECT * FROM november2014 B WHERE (A.Notes = B.Notes OR A.Treatments = B.Treatments OR A.DateOfBirth = B.DateOfBIrth) AND A.Notes <> ‘’ AND B.Notes <> ‘’ AND A.Treatments <> ‘’ AND B.Treatments <> ‘’);

$query[18] = SELECT * FROM november2014 A WHERE EXISTS (SELECT * FROM november2015 B WHERE (A.Notes = B.Notes OR A.Treatments = B.Treatments OR A.DateOfBirth = B.DateOfBIrth) AND A.Notes <> ‘’ AND B.Notes <> ‘’ AND A.Treatments <> ‘’ AND B.Treatments <> ‘’);

$query[19] = SELECT * FROM november2015 A WHERE EXISTS (SELECT * FROM november2006 B WHERE (A.Notes = B.Notes OR A.Treatments = B.Treatments OR A.DateOfBirth = B.DateOfBIrth) AND A.Notes <> ‘’ AND B.Notes <> ‘’ AND A.Treatments <> ‘’ AND B.Treatments <> ‘’);

$query[20] = SELECT * FROM november2015 WHERE Diagnosis IN (SELECT Diagnosis FROM november2014) AND Diagnosis NOT LIKE ‘’;

$query[21] = SELECT * FROM november2014 WHERE Diagnosis IN (SELECT Diagnosis FROM november2013) AND Diagnosis NOT LIKE ‘’;

$query[22] = SELECT * FROM november2013 WHERE Diagnosis IN (SELECT Diagnosis FROM november2012) AND Diagnosis NOT LIKE ‘’;

$query[23] = SELECT * FROM november2012 WHERE Diagnosis IN (SELECT Diagnosis FROM november2011) AND Diagnosis NOT LIKE ‘’;

$query[24] = SELECT * FROM november2011 WHERE Diagnosis IN (SELECT Diagnosis FROM november2010) AND Diagnosis NOT LIKE ‘’;

$query[25] = SELECT * FROM november2010 WHERE Diagnosis IN (SELECT Diagnosis FROM november2009) AND Diagnosis NOT LIKE ‘’;

$query[26] = SELECT * FROM november2009 WHERE Diagnosis IN (SELECT Diagnosis FROM november2008) AND Diagnosis NOT LIKE ‘’;

$query[27] = SELECT * FROM november2008 WHERE Diagnosis IN (SELECT Diagnosis FROM november2007) AND Diagnosis NOT LIKE ‘’;

$query[28] = SELECT * FROM november2007 WHERE Diagnosis IN (SELECT Diagnosis FROM november2006) AND Diagnosis NOT LIKE ‘’;

$query[29] = SELECT * FROM november2006 WHERE Diagnosis IN (SELECT Diagnosis FROM november2015) AND Diagnosis NOT LIKE ‘’;

$query[30] = SELECT * FROM november2015 A WHERE EXISTS (SELECT B.Treatments, B.Complaints FROM november2014 B WHERE (A.Complaints = B.Complaints OR A.Treatments = B.Treatments) AND A.Notes <> B.Notes AND A.Complaints <> ‘’ AND B.Complaints <> ‘’ AND A.Treatments <> ‘’ AND B.Treatments <> ‘’ AND A.Notes <> ‘’ AND B.Notes <> ‘’ AND A.Diagnosis <> ‘’ AND B.Diagnosis <> ‘’);

$query[31] = SELECT * FROM november2014 A WHERE EXISTS (SELECT B.Treatments, B.Complaints FROM november2013 B WHERE (A.Complaints = B.Complaints OR A.Treatments = B.Treatments) AND A.Notes <> B.Notes AND A.Complaints <> ‘’ AND B.Complaints <> ‘’ AND A.Treatments <> ‘’ AND B.Treatments <> ‘’ AND A.Notes <> ‘’ AND B.Notes <> ‘’ AND A.Diagnosis <> ‘’ AND B.Diagnosis <> ‘’);

$query[32] = SELECT * FROM november2013 A WHERE EXISTS (SELECT B.Treatments, B.Complaints FROM november2012 B WHERE (A.Complaints = B.Complaints OR A.Treatments = B.Treatments) AND A.Notes <> B.Notes AND A.Complaints <> ‘’ AND B.Complaints <> ‘’ AND A.Treatments <> ‘’ AND B.Treatments <> ‘’ AND A.Notes <> ‘’ AND B.Notes <> ‘’ AND A.Diagnosis <> ‘’ AND B.Diagnosis <> ‘’);

$query[33] = SELECT * FROM november2012 A WHERE EXISTS (SELECT B.Treatments, B.Complaints FROM november2011 B WHERE (A.Complaints = B.Complaints OR A.Treatments = B.Treatments) AND A.Notes <> B.Notes AND A.Complaints <> ‘’ AND B.Complaints <> ‘’ AND A.Treatments <> ‘’ AND B.Treatments <> ‘’ AND A.Notes <> ‘’ AND B.Notes <> ‘’ AND A.Diagnosis <> ‘’ AND B.Diagnosis <> ‘’);

$query[34] = SELECT * FROM november2011 A WHERE EXISTS (SELECT B.Treatments, B.Complaints FROM november2010 B WHERE (A.Complaints = B.Complaints OR A.Treatments = B.Treatments) AND A.Notes <> B.Notes AND A.Complaints <> ‘’ AND B.Complaints <> ‘’ AND A.Treatments <> ‘’ AND B.Treatments <> ‘’ AND A.Notes <> ‘’ AND B.Notes <> ‘’ AND A.Diagnosis <> ‘’ AND B.Diagnosis <> ‘’);

$query[35] = SELECT * FROM november2010 A WHERE EXISTS (SELECT B.Treatments, B.Complaints FROM november2009 B WHERE (A.Complaints = B.Complaints OR A.Treatments = B.Treatments) AND A.Notes <> B.Notes AND A.Complaints <> ‘’ AND B.Complaints <> ‘’ AND A.Treatments <> ‘’ AND B.Treatments <> ‘’ AND A.Notes <> ‘’ AND B.Notes <> ‘’ AND A.Diagnosis <> ‘’ AND B.Diagnosis <> ‘’);

$query[36] = SELECT * FROM november2009 A WHERE EXISTS (SELECT B.Treatments, B.Complaints FROM november2008 B WHERE (A.Complaints = B.Complaints OR A.Treatments = B.Treatments) AND A.Notes <> B.Notes AND A.Complaints <> ‘’ AND B.Complaints <> ‘’ AND A.Treatments <> ‘’ AND B.Treatments <> ‘’ AND A.Notes <> ‘’ AND B.Notes <> ‘’ AND A.Diagnosis <> ‘’ AND B.Diagnosis <> ‘’);

$query[37] = SELECT * FROM november2008 A WHERE EXISTS (SELECT B.Treatments, B.Complaints FROM november2007 B WHERE (A.Complaints = B.Complaints OR A.Treatments = B.Treatments) AND A.Notes <> B.Notes AND A.Complaints <> ‘’ AND B.Complaints <> ‘’ AND A.Treatments <> ‘’ AND B.Treatments <> ‘’ AND A.Notes <> ‘’ AND B.Notes <> ‘’ AND A.Diagnosis <> ‘’ AND B.Diagnosis <> ‘’);

$query[38] = SELECT * FROM november2007 A WHERE EXISTS (SELECT B.Treatments, B.Complaints FROM november2006 B WHERE (A.Complaints = B.Complaints OR A.Treatments = B.Treatments) AND A.Notes <> B.Notes AND A.Complaints <> ‘’ AND B.Complaints <> ‘’ AND A.Treatments <> ‘’ AND B.Treatments <> ‘’ AND A.Notes <> ‘’ AND B.Notes <> ‘’ AND A.Diagnosis <> ‘’ AND B.Diagnosis <> ‘’);

$query[39] = SELECT * FROM november2006 A WHERE EXISTS (SELECT B.Treatments, B.Complaints FROM november2015 B WHERE (A.Complaints = B.Complaints OR A.Treatments = B.Treatments) AND A.Notes <> B.Notes AND A.Complaints <> ‘’ AND B.Complaints <> ‘’ AND A.Treatments <> ‘’ AND B.Treatments <> ‘’ AND A.Notes <> ‘’ AND B.Notes <> ‘’ AND A.Diagnosis <> ‘’ AND B.Diagnosis <> ‘’);

$query[40] = SELECT * FROM november2015 WHERE Complaints IN (SELECT Complaints FROM november2014 WHERE (TimeOut - TimeIn > ‘10’) AND (TimeOut - TimeIn < ‘40’)) AND (TimeOut - TimeIn > ‘10’) AND (TimeOut - TimeIn < ‘40’);

$query[41] = SELECT * FROM november2014 WHERE Complaints IN (SELECT Complaints FROM november2013 WHERE (TimeOut - TimeIn > ‘10’) AND (TimeOut - TimeIn < ‘40’)) AND (TimeOut - TimeIn > ‘10’) AND (TimeOut - TimeIn < ‘40’);

$query[42] = SELECT * FROM november2013 WHERE Complaints IN (SELECT Complaints FROM november2012 WHERE (TimeOut - TimeIn > ‘10’) AND (TimeOut - TimeIn < ‘40’)) AND (TimeOut - TimeIn > ‘10’) AND (TimeOut - TimeIn < ‘40’);

$query[43] = SELECT * FROM november2012 WHERE Complaints IN (SELECT Complaints FROM november2011 WHERE (TimeOut - TimeIn > ‘10’) AND (TimeOut - TimeIn < ‘40’)) AND (TimeOut - TimeIn > ‘10’) AND (TimeOut - TimeIn < ‘40’);

$query[44] = SELECT * FROM november2011 WHERE Complaints IN (SELECT Complaints FROM november2010 WHERE (TimeOut - TimeIn > ‘10’) AND (TimeOut - TimeIn < ‘40’)) AND (TimeOut - TimeIn > ‘10’) AND (TimeOut - TimeIn < ‘40’);

$query[45] = SELECT * FROM november2010 WHERE Complaints IN (SELECT Complaints FROM november2009 WHERE (TimeOut - TimeIn > ‘10’) AND (TimeOut - TimeIn < ‘40’)) AND (TimeOut - TimeIn > ‘10’) AND (TimeOut - TimeIn < ‘40’);

$query[46] = SELECT * FROM november2009 WHERE Complaints IN (SELECT Complaints FROM november2008 WHERE (TimeOut - TimeIn > ‘10’) AND (TimeOut - TimeIn < ‘40’)) AND (TimeOut - TimeIn > ‘10’) AND (TimeOut - TimeIn < ‘40’);

$query[47] = SELECT * FROM november2008 WHERE Complaints IN (SELECT Complaints FROM november2007 WHERE (TimeOut - TimeIn > ‘10’) AND (TimeOut - TimeIn < ‘40’)) AND (TimeOut - TimeIn > ‘10’) AND (TimeOut - TimeIn < ‘40’);

$query[48] = SELECT * FROM november2007 WHERE Complaints IN (SELECT Complaints FROM november2006 WHERE (TimeOut - TimeIn > ‘10’) AND (TimeOut - TimeIn < ‘40’)) AND (TimeOut - TimeIn > ‘10’) AND (TimeOut - TimeIn < ‘40’);

$query[49] = SELECT * FROM november2006 WHERE Complaints IN (SELECT Complaints FROM november2015 WHERE (TimeOut - TimeIn > ‘10’) AND (TimeOut - TimeIn < ‘40’)) AND (TimeOut - TimeIn > ‘10’) AND (TimeOut - TimeIn < ‘40’);

$query[50] = SELECT * FROM november2015 UNION SELECT * FROM november2014;

$query[51] = SELECT * FROM november2014 UNION SELECT * FROM november2013;

$query[52] = SELECT * FROM november2013 UNION SELECT * FROM november2012;

$query[53] = SELECT * FROM november2012 UNION SELECT * FROM november2011;

$query[54] = SELECT * FROM november2011 UNION SELECT * FROM november2010;

$query[55] = SELECT * FROM november2010 UNION SELECT * FROM november2009;

$query[56] = SELECT * FROM november2009 UNION SELECT * FROM november2008;

$query[57] = SELECT * FROM november2008 UNION SELECT * FROM november2007;

$query[58] = SELECT * FROM november2007 UNION SELECT * FROM november2006;

$query[59] = SELECT * FROM november2006 UNION SELECT * FROM november2015;

$query[60] = SELECT * FROM november2015 WHERE Diagnosis = ‘URTI’ UNION SELECT * FROM november2014 WHERE Diagnosis = ‘URTI’;

$query[61] = SELECT * FROM november2014 WHERE Diagnosis = ‘URTI’ UNION SELECT * FROM november2013 WHERE Diagnosis = ‘URTI’;

$query[62] = SELECT * FROM november2013 WHERE Diagnosis = ‘URTI’ UNION SELECT * FROM november2012 WHERE Diagnosis = ‘URTI’;

$query[63] = SELECT * FROM november2012 WHERE Diagnosis = ‘URTI’ UNION SELECT * FROM november2011 WHERE Diagnosis = ‘URTI’;

$query[64] = SELECT * FROM november2011 WHERE Diagnosis = ‘URTI’ UNION SELECT * FROM november2010 WHERE Diagnosis = ‘URTI’;

$query[65] = SELECT * FROM november2010 WHERE Diagnosis = ‘URTI’ UNION SELECT * FROM november2009 WHERE Diagnosis = ‘URTI’;

$query[66] = SELECT * FROM november2009 WHERE Diagnosis = ‘URTI’ UNION SELECT * FROM november2008 WHERE Diagnosis = ‘URTI’;

$query[67] = SELECT * FROM november2008 WHERE Diagnosis = ‘URTI’ UNION SELECT * FROM november2007 WHERE Diagnosis = ‘URTI’;

$query[68] = SELECT * FROM november2007 WHERE Diagnosis = ‘URTI’ UNION SELECT * FROM november2006 WHERE Diagnosis = ‘URTI’;

$query[69] = SELECT * FROM november2006 WHERE Diagnosis = ‘URTI’ UNION SELECT * FROM november2015 WHERE Diagnosis = ‘URTI’;

$query[70] = SELECT * FROM november2006 WHERE Diagnosis IN (SELECT Diagnosis FROM november2006) AND Diagnosis NOT LIKE ‘’ ORDER BY Diagnosis LIMIT 10;

$query[71] = SELECT * FROM november2007 WHERE Diagnosis IN (SELECT Diagnosis FROM november2007) AND Diagnosis NOT LIKE ‘’ ORDER BY Diagnosis LIMIT 10;

$query[72] = SELECT * FROM november2008 WHERE Diagnosis IN (SELECT Diagnosis FROM november2008) AND Diagnosis NOT LIKE ‘’ ORDER BY Diagnosis LIMIT 10;

$query[73] = SELECT * FROM november2009 WHERE Diagnosis IN (SELECT Diagnosis FROM november2009) AND Diagnosis NOT LIKE ‘’ ORDER BY Diagnosis LIMIT 10;

$query[74] = SELECT * FROM november2010 WHERE Diagnosis IN (SELECT Diagnosis FROM november2010) AND Diagnosis NOT LIKE ‘’ ORDER BY Diagnosis LIMIT 10;

$query[75] = SELECT * FROM november2011 WHERE Diagnosis IN (SELECT Diagnosis FROM november2011) AND Diagnosis NOT LIKE ‘’ ORDER BY Diagnosis LIMIT 10;

$query[76] = SELECT * FROM november2012 WHERE Diagnosis IN (SELECT Diagnosis FROM november2012) AND Diagnosis NOT LIKE ‘’ ORDER BY Diagnosis LIMIT 10;

$query[77] = SELECT * FROM november2013 WHERE Diagnosis IN (SELECT Diagnosis FROM november2013) AND Diagnosis NOT LIKE ‘’ ORDER BY Diagnosis LIMIT 10;

$query[78] = SELECT * FROM november2014 WHERE Diagnosis IN (SELECT Diagnosis FROM november2014) AND Diagnosis NOT LIKE ‘’ ORDER BY Diagnosis LIMIT 10;

$query[79] = SELECT * FROM november2015 WHERE Diagnosis IN (SELECT Diagnosis FROM november2015) AND Diagnosis NOT LIKE ‘’ ORDER BY Diagnosis LIMIT 10;

$query[80] = SELECT * FROM november2006 ORDER BY TimeIn DESC LIMIT 20;

$query[81] = SELECT * FROM november2007 ORDER BY TimeIn DESC LIMIT 20;

$query[82] = SELECT * FROM november2008 ORDER BY TimeIn DESC LIMIT 20;

$query[83] = SELECT * FROM november2009 ORDER BY TimeIn DESC LIMIT 20;

$query[84] = SELECT * FROM november2010 ORDER BY TimeIn DESC LIMIT 20;

$query[85] = SELECT * FROM november2011 ORDER BY TimeIn DESC LIMIT 20;

$query[86] = SELECT * FROM november2012 ORDER BY TimeIn DESC LIMIT 20;

$query[87] = SELECT * FROM november2013 ORDER BY TimeIn DESC LIMIT 20;

$query[88] = SELECT * FROM november2014 ORDER BY TimeIn DESC LIMIT 20;

$query[89] = SELECT * FROM november2015 ORDER BY TimeIn DESC LIMIT 20;

$query[90] = SELECT * FROM november2006 UNION SELECT * FROM november2007;

$query[91] = SELECT * FROM november2007 UNION SELECT * FROM november2008;

$query[92] = SELECT * FROM november2008 UNION SELECT * FROM november2009;

$query[93] = SELECT * FROM november2009 UNION SELECT * FROM november2010;

$query[94] = SELECT * FROM november2010 UNION SELECT * FROM november2011;

$query[95] = SELECT * FROM november2011 UNION SELECT * FROM november2012;

$query[96] = SELECT * FROM november2012 UNION SELECT * FROM november2013;

$query[97] = SELECT * FROM november2013 UNION SELECT * FROM november2014;

$query[98] = SELECT * FROM november2014 UNION SELECT * FROM november2015;

$query[99] = SELECT * FROM november2015 UNION SELECT * FROM november2006;

$query[100] = SELECT * FROM november2006 WHERE Diagnosis LIKE ‘%ref%’ OR Complaints LIKE ‘%ref%’ OR Treatments LIKE ‘%ref%’ OR Notes LIKE ‘%ref%’ ;

$query[101] = SELECT * FROM november2007 WHERE Diagnosis LIKE ‘%ref%’ OR Complaints LIKE ‘%ref%’ OR Treatments LIKE ‘%ref%’ OR Notes LIKE ‘%ref%’ ;

$query[102] = SELECT * FROM november2008 WHERE Diagnosis LIKE ‘%ref%’ OR Complaints LIKE ‘%ref%’ OR Treatments LIKE ‘%ref%’ OR Notes LIKE ‘%ref%’ ;

$query[103] = SELECT * FROM november2009 WHERE Diagnosis LIKE ‘%ref%’ OR Complaints LIKE ‘%ref%’ OR Treatments LIKE ‘%ref%’ OR Notes LIKE ‘%ref%’ ;

$query[104] = SELECT * FROM november2010 WHERE Diagnosis LIKE ‘%ref%’ OR Complaints LIKE ‘%ref%’ OR Treatments LIKE ‘%ref%’ OR Notes LIKE ‘%ref%’ ;

$query[105] = SELECT * FROM november2011 WHERE Diagnosis LIKE ‘%ref%’ OR Complaints LIKE ‘%ref%’ OR Treatments LIKE ‘%ref%’ OR Notes LIKE ‘%ref%’ ;

$query[106] = SELECT * FROM november2012 WHERE Diagnosis LIKE ‘%ref%’ OR Complaints LIKE ‘%ref%’ OR Treatments LIKE ‘%ref%’ OR Notes LIKE ‘%ref%’ ;

$query[107] = SELECT * FROM november2013 WHERE Diagnosis LIKE ‘%ref%’ OR Complaints LIKE ‘%ref%’ OR Treatments LIKE ‘%ref%’ OR Notes LIKE ‘%ref%’ ;

$query[108] = SELECT * FROM november2014 WHERE Diagnosis LIKE ‘%ref%’ OR Complaints LIKE ‘%ref%’ OR Treatments LIKE ‘%ref%’ OR Notes LIKE ‘%ref%’ ;

$query[109] = SELECT * FROM november2015 WHERE Diagnosis LIKE ‘%ref%’ OR Complaints LIKE ‘%ref%’ OR Treatments LIKE ‘%ref%’ OR Notes LIKE ‘%ref%’ ;

$query[110] = SELECT * FROM november2006 WHERE TimeIn NOT BETWEEN 1050 AND 1730;

$query[111] = SELECT * FROM november2007 WHERE TimeIn NOT BETWEEN 1050 AND 1730;

$query[112] = SELECT * FROM november2008 WHERE TimeIn NOT BETWEEN 1050 AND 1730;

$query[113] = SELECT * FROM november2009 WHERE TimeIn NOT BETWEEN 1050 AND 1730;

$query[114] = SELECT * FROM november2010 WHERE TimeIn NOT BETWEEN 1050 AND 1730;

$query[115] = SELECT * FROM november2011 WHERE TimeIn NOT BETWEEN 1050 AND 1730;

$query[116] = SELECT * FROM november2012 WHERE TimeIn NOT BETWEEN 1050 AND 1730;

$query[117] = SELECT * FROM november2013 WHERE TimeIn NOT BETWEEN 1050 AND 1730;

$query[118] = SELECT * FROM november2014 WHERE TimeIn NOT BETWEEN 1050 AND 1730;

$query[119] = SELECT * FROM november2015 WHERE TimeIn NOT BETWEEN 1050 AND 1730;

$query[120] = SELECT * FROM november2006 WHERE Complaints IN (SELECT Complaints FROM november2007);

$query[121] = SELECT * FROM november2007 WHERE Complaints IN (SELECT Complaints FROM november2008);

$query[122] = SELECT * FROM november2008 WHERE Complaints IN (SELECT Complaints FROM november2009);

$query[123] = SELECT * FROM november2009 WHERE Complaints IN (SELECT Complaints FROM november2010);

$query[124] = SELECT * FROM november2010 WHERE Complaints IN (SELECT Complaints FROM november2011);

$query[125] = SELECT * FROM november2011 WHERE Complaints IN (SELECT Complaints FROM november2012);

$query[126] = SELECT * FROM november2012 WHERE Complaints IN (SELECT Complaints FROM november2013);

$query[127] = SELECT * FROM november2013 WHERE Complaints IN (SELECT Complaints FROM november2014);

$query[128] = SELECT * FROM november2014 WHERE Complaints IN (SELECT Complaints FROM november2015);

$query[129] = SELECT * FROM november2015 WHERE Complaints IN (SELECT Complaints FROM november2006);

$query[130] = SELECT * FROM november2006 WHERE SurgeryDate BETWEEN ‘01.11.2006’ AND ‘07.11.2006’;

$query[131] = SELECT * FROM november2007 WHERE SurgeryDate BETWEEN ‘01.11.2007’ AND ‘07.11.2007’;

$query[132] = SELECT * FROM november2008 WHERE SurgeryDate BETWEEN ‘01.11.2008’ AND ‘07.11.2008’;

$query[133] = SELECT * FROM november2009 WHERE SurgeryDate BETWEEN ‘01.11.2009’ AND ‘07.11.2009’;

$query[134] = SELECT * FROM november2010 WHERE SurgeryDate BETWEEN ‘01.11.2010’ AND ‘07.11.2010’;

$query[135] = SELECT * FROM november2011 WHERE SurgeryDate BETWEEN ‘01.11.2011’ AND ‘07.11.2011’;

$query[136] = SELECT * FROM november2012 WHERE SurgeryDate BETWEEN ‘01.11.2012’ AND ‘07.11.2012’;

$query[137] = SELECT * FROM november2013 WHERE SurgeryDate BETWEEN ‘01.11.2013’ AND ‘07.11.2013’;

$query[138] = SELECT * FROM november2014 WHERE SurgeryDate BETWEEN ‘01.11.2014’ AND ‘07.11.2014’;

$query[139] = SELECT * FROM november2015 WHERE SurgeryDate BETWEEN ‘01.11.2015’ AND ‘07.11.2015’;

$query[140] = SELECT * FROM november2006 WHERE SurgeryDate BETWEEN ‘08.11.2006’ AND ‘14.11.2006’;

$query[141] = SELECT * FROM november2007 WHERE SurgeryDate BETWEEN ‘08.11.2007’ AND ‘14.11.2007’;

$query[142] = SELECT * FROM november2008 WHERE SurgeryDate BETWEEN ‘08.11.2008’ AND ‘14.11.2008’;

$query[143] = SELECT * FROM november2009 WHERE SurgeryDate BETWEEN ‘08.11.2009’ AND ‘14.11.2009’;

$query[144] = SELECT * FROM november2010 WHERE SurgeryDate BETWEEN ‘08.11.2010’ AND ‘14.11.2010’;

$query[145] = SELECT * FROM november2011 WHERE SurgeryDate BETWEEN ‘08.11.2011’ AND ‘14.11.2011’;

$query[146] = SELECT * FROM november2012 WHERE SurgeryDate BETWEEN ‘08.11.2012’ AND ‘14.11.2012’;

$query[147] = SELECT * FROM november2013 WHERE SurgeryDate BETWEEN ‘08.11.2013’ AND ‘14.11.2013’;

$query[148] = SELECT * FROM november2014 WHERE SurgeryDate BETWEEN ‘08.11.2014’ AND ‘14.11.2014’;

$query[149] = SELECT * FROM november2015 WHERE SurgeryDate BETWEEN ‘08.11.2015’ AND ‘14.11.2015’;

$query[150] = SELECT * FROM november2006 WHERE SurgeryDate BETWEEN ‘15.11.2006’ AND ‘21.11.2006’;

$query[151] = SELECT * FROM november2007 WHERE SurgeryDate BETWEEN ‘15.11.2007’ AND ‘21.11.2007’;

$query[152] = SELECT * FROM november2008 WHERE SurgeryDate BETWEEN ‘15.11.2008’ AND ‘21.11.2008’;

$query[153] = SELECT * FROM november2009 WHERE SurgeryDate BETWEEN ‘15.11.2009’ AND ‘21.11.2009’;

$query[154] = SELECT * FROM november2010 WHERE SurgeryDate BETWEEN ‘15.11.2010’ AND ‘21.11.2010’;

$query[155] = SELECT * FROM november2011 WHERE SurgeryDate BETWEEN ‘15.11.2011’ AND ‘21.11.2011’;

$query[156] = SELECT * FROM november2012 WHERE SurgeryDate BETWEEN ‘15.11.2012’ AND ‘21.11.2012’;

$query[157] = SELECT * FROM november2013 WHERE SurgeryDate BETWEEN ‘15.11.2013’ AND ‘21.11.2013’;

$query[158] = SELECT * FROM november2014 WHERE SurgeryDate BETWEEN ‘15.11.2014’ AND ‘21.11.2014’;

$query[159] = SELECT * FROM november2015 WHERE SurgeryDate BETWEEN ‘15.11.2015’ AND ‘21.11.2015’;

$query[160] = SELECT * FROM november2006 WHERE SurgeryDate BETWEEN ‘22.11.2006’ AND ‘32.11.2006’;

$query[161] = SELECT * FROM november2007 WHERE SurgeryDate BETWEEN ‘22.11.2007’ AND ‘32.11.2007’;

$query[162] = SELECT * FROM november2008 WHERE SurgeryDate BETWEEN ‘22.11.2008’ AND ‘32.11.2008’;

$query[163] = SELECT * FROM november2009 WHERE SurgeryDate BETWEEN ‘22.11.2009’ AND ‘32.11.2009’;

$query[164] = SELECT * FROM november2010 WHERE SurgeryDate BETWEEN ‘22.11.2010’ AND ‘32.11.2010’;

$query[165] = SELECT * FROM november2011 WHERE SurgeryDate BETWEEN ‘22.11.2011’ AND ‘32.11.2011’;

$query[166] = SELECT * FROM november2012 WHERE SurgeryDate BETWEEN ‘22.11.2012’ AND ‘32.11.2012’;

$query[167] = SELECT * FROM november2013 WHERE SurgeryDate BETWEEN ‘22.11.2013’ AND ‘32.11.2013’;

$query[168] = SELECT * FROM november2014 WHERE SurgeryDate BETWEEN ‘22.11.2014’ AND ‘32.11.2014’;

$query[169] = SELECT * FROM november2015 WHERE SurgeryDate BETWEEN ‘22.11.2015’ AND ‘32.11.2015’;

$query[170] = SELECT * FROM november2006 WHERE Treatments IN (SELECT Treatments FROM november2007 WHERE Notes <> ‘’ AND Treatments <> ‘’) AND Notes <> ‘’ AND Treatments <> ‘’;

$query[171] = SELECT * FROM november2007 WHERE Treatments IN (SELECT Treatments FROM november2008 WHERE Notes <> ‘’ AND Treatments <> ‘’) AND Notes <> ‘’ AND Treatments <> ‘’;

$query[172] = SELECT * FROM november2008 WHERE Treatments IN (SELECT Treatments FROM november2009 WHERE Notes <> ‘’ AND Treatments <> ‘’) AND Notes <> ‘’ AND Treatments <> ‘’;

$query[173] = SELECT * FROM november2009 WHERE Treatments IN (SELECT Treatments FROM november2010 WHERE Notes <> ‘’ AND Treatments <> ‘’) AND Notes <> ‘’ AND Treatments <> ‘’;

$query[174] = SELECT * FROM november2010 WHERE Treatments IN (SELECT Treatments FROM november2011 WHERE Notes <> ‘’ AND Treatments <> ‘’) AND Notes <> ‘’ AND Treatments <> ‘’;

$query[175] = SELECT * FROM november2011 WHERE Treatments IN (SELECT Treatments FROM november2012 WHERE Notes <> ‘’ AND Treatments <> ‘’) AND Notes <> ‘’ AND Treatments <> ‘’;

$query[176] = SELECT * FROM november2012 WHERE Treatments IN (SELECT Treatments FROM november2013 WHERE Notes <> ‘’ AND Treatments <> ‘’) AND Notes <> ‘’ AND Treatments <> ‘’;

$query[177] = SELECT * FROM november2013 WHERE Treatments IN (SELECT Treatments FROM november2014 WHERE Notes <> ‘’ AND Treatments <> ‘’) AND Notes <> ‘’ AND Treatments <> ‘’;

$query[178] = SELECT * FROM november2014 WHERE Treatments IN (SELECT Treatments FROM november2015 WHERE Notes <> ‘’ AND Treatments <> ‘’) AND Notes <> ‘’ AND Treatments <> ‘’;

$query[179] = SELECT * FROM november2015 WHERE Treatments IN (SELECT Treatments FROM november2006 WHERE Notes <> ‘’ AND Treatments <> ‘’) AND Notes <> ‘’ AND Treatments <> ‘’;

$query[180] = SELECT * FROM november2006 A WHERE EXISTS (SELECT * FROM november2007 B WHERE (A.Notes = B.Notes OR A.Treatments = B.Treatments OR A.DateOfBirth = B.DateOfBIrth) AND A.Notes <> ‘’ AND B.Notes <> ‘’ AND A.Treatments <> ‘’ AND B.Treatments <> ‘’);

$query[181] = SELECT * FROM november2007 A WHERE EXISTS (SELECT * FROM november2008 B WHERE (A.Notes = B.Notes OR A.Treatments = B.Treatments OR A.DateOfBirth = B.DateOfBIrth) AND A.Notes <> ‘’ AND B.Notes <> ‘’ AND A.Treatments <> ‘’ AND B.Treatments <> ‘’);

$query[182] = SELECT * FROM november2008 A WHERE EXISTS (SELECT * FROM november2009 B WHERE (A.Notes = B.Notes OR A.Treatments = B.Treatments OR A.DateOfBirth = B.DateOfBIrth) AND A.Notes <> ‘’ AND B.Notes <> ‘’ AND A.Treatments <> ‘’ AND B.Treatments <> ‘’);

$query[183] = SELECT * FROM november2009 A WHERE EXISTS (SELECT * FROM november2010 B WHERE (A.Notes = B.Notes OR A.Treatments = B.Treatments OR A.DateOfBirth = B.DateOfBIrth) AND A.Notes <> ‘’ AND B.Notes <> ‘’ AND A.Treatments <> ‘’ AND B.Treatments <> ‘’);

$query[184] = SELECT * FROM november2010 A WHERE EXISTS (SELECT * FROM november2011 B WHERE (A.Notes = B.Notes OR A.Treatments = B.Treatments OR A.DateOfBirth = B.DateOfBIrth) AND A.Notes <> ‘’ AND B.Notes <> ‘’ AND A.Treatments <> ‘’ AND B.Treatments <> ‘’);

$query[185] = SELECT * FROM november2011 A WHERE EXISTS (SELECT * FROM november2012 B WHERE (A.Notes = B.Notes OR A.Treatments = B.Treatments OR A.DateOfBirth = B.DateOfBIrth) AND A.Notes <> ‘’ AND B.Notes <> ‘’ AND A.Treatments <> ‘’ AND B.Treatments <> ‘’);

$query[186] = SELECT * FROM november2012 A WHERE EXISTS (SELECT * FROM november2013 B WHERE (A.Notes = B.Notes OR A.Treatments = B.Treatments OR A.DateOfBirth = B.DateOfBIrth) AND A.Notes <> ‘’ AND B.Notes <> ‘’ AND A.Treatments <> ‘’ AND B.Treatments <> ‘’);

$query[187] = SELECT * FROM november2013 A WHERE EXISTS (SELECT * FROM november2014 B WHERE (A.Notes = B.Notes OR A.Treatments = B.Treatments OR A.DateOfBirth = B.DateOfBIrth) AND A.Notes <> ‘’ AND B.Notes <> ‘’ AND A.Treatments <> ‘’ AND B.Treatments <> ‘’);

$query[188] = SELECT * FROM november2014 A WHERE EXISTS (SELECT * FROM november2015 B WHERE (A.Notes = B.Notes OR A.Treatments = B.Treatments OR A.DateOfBirth = B.DateOfBIrth) AND A.Notes <> ‘’ AND B.Notes <> ‘’ AND A.Treatments <> ‘’ AND B.Treatments <> ‘’);

$query[189] = SELECT * FROM november2015 A WHERE EXISTS (SELECT * FROM november2006 B WHERE (A.Notes = B.Notes OR A.Treatments = B.Treatments OR A.DateOfBirth = B.DateOfBIrth) AND A.Notes <> ‘’ AND B.Notes <> ‘’ AND A.Treatments <> ‘’ AND B.Treatments <> ‘’);

$query[190] = SELECT * FROM november2006 A WHERE EXISTS (SELECT B.Treatments, B.Complaints FROM november2007 B WHERE (A.Complaints = B.Complaints OR A.Treatments = B.Treatments) AND A.Notes <> B.Notes AND A.Complaints <> ‘’ AND B.Complaints <> ‘’ AND A.Treatments <> ‘’ AND B.Treatments <> ‘’ AND A.Notes <>’’ AND B.Notes <> ‘’ AND A.Diagnosis <>’’ AND B.Diagnosis <>’’);

$query[191] = SELECT * FROM november2007 A WHERE EXISTS (SELECT B.Treatments, B.Complaints FROM november2008 B WHERE (A.Complaints = B.Complaints OR A.Treatments = B.Treatments) AND A.Notes <> B.Notes AND A.Complaints <> ‘’ AND B.Complaints <> ‘’ AND A.Treatments <> ‘’ AND B.Treatments <> ‘’ AND A.Notes <>’’ AND B.Notes <> ‘’ AND A.Diagnosis <>’’ AND B.Diagnosis <>’’);

$query[192] = SELECT * FROM november2008 A WHERE EXISTS (SELECT B.Treatments, B.Complaints FROM november2009 B WHERE (A.Complaints = B.Complaints OR A.Treatments = B.Treatments) AND A.Notes <> B.Notes AND A.Complaints <> ‘’ AND B.Complaints <> ‘’ AND A.Treatments <> ‘’ AND B.Treatments <> ‘’ AND A.Notes <>’’ AND B.Notes <> ‘’ AND A.Diagnosis <>’’ AND B.Diagnosis <>’’);

$query[193] = SELECT * FROM november2009 A WHERE EXISTS (SELECT B.Treatments, B.Complaints FROM november2010 B WHERE (A.Complaints = B.Complaints OR A.Treatments = B.Treatments) AND A.Notes <> B.Notes AND A.Complaints <> ‘’ AND B.Complaints <> ‘’ AND A.Treatments <> ‘’ AND B.Treatments <> ‘’ AND A.Notes <>’’ AND B.Notes <> ‘’ AND A.Diagnosis <>’’ AND B.Diagnosis <>’’);

$query[194] = SELECT * FROM november2010 A WHERE EXISTS (SELECT B.Treatments, B.Complaints FROM november2011 B WHERE (A.Complaints = B.Complaints OR A.Treatments = B.Treatments) AND A.Notes <> B.Notes AND A.Complaints <> ‘’ AND B.Complaints <> ‘’ AND A.Treatments <> ‘’ AND B.Treatments <> ‘’ AND A.Notes <>’’ AND B.Notes <> ‘’ AND A.Diagnosis <>’’ AND B.Diagnosis <>’’);

$query[195] = SELECT * FROM november2011 A WHERE EXISTS (SELECT B.Treatments, B.Complaints FROM november2012 B WHERE (A.Complaints = B.Complaints OR A.Treatments = B.Treatments) AND A.Notes <> B.Notes AND A.Complaints <> ‘’ AND B.Complaints <> ‘’ AND A.Treatments <> ‘’ AND B.Treatments <> ‘’ AND A.Notes <>’’ AND B.Notes <> ‘’ AND A.Diagnosis <>’’ AND B.Diagnosis <>’’);

$query[196] = SELECT * FROM november2012 A WHERE EXISTS (SELECT B.Treatments, B.Complaints FROM november2013 B WHERE (A.Complaints = B.Complaints OR A.Treatments = B.Treatments) AND A.Notes <> B.Notes AND A.Complaints <> ‘’ AND B.Complaints <> ‘’ AND A.Treatments <> ‘’ AND B.Treatments <> ‘’ AND A.Notes <>’’ AND B.Notes <> ‘’ AND A.Diagnosis <>’’ AND B.Diagnosis <>’’);

$query[197] = SELECT * FROM november2013 A WHERE EXISTS (SELECT B.Treatments, B.Complaints FROM november2014 B WHERE (A.Complaints = B.Complaints OR A.Treatments = B.Treatments) AND A.Notes <> B.Notes AND A.Complaints <> ‘’ AND B.Complaints <> ‘’ AND A.Treatments <> ‘’ AND B.Treatments <> ‘’ AND A.Notes <>’’ AND B.Notes <> ‘’ AND A.Diagnosis <>’’ AND B.Diagnosis <>’’);

$query[198] = SELECT * FROM november2014 A WHERE EXISTS (SELECT B.Treatments, B.Complaints FROM november2015 B WHERE (A.Complaints = B.Complaints OR A.Treatments = B.Treatments) AND A.Notes <> B.Notes AND A.Complaints <> ‘’ AND B.Complaints <> ‘’ AND A.Treatments <> ‘’ AND B.Treatments <> ‘’ AND A.Notes <>’’ AND B.Notes <> ‘’ AND A.Diagnosis <>’’ AND B.Diagnosis <>’’);

$query[199] = SELECT * FROM november2015 A WHERE EXISTS (SELECT B.Treatments, B.Complaints FROM november2006 B WHERE (A.Complaints = B.Complaints OR A.Treatments = B.Treatments) AND A.Notes <> B.Notes AND A.Complaints <> ‘’ AND B.Complaints <> ‘’ AND A.Treatments <> ‘’ AND B.Treatments <> ‘’ AND A.Notes <>’’ AND B.Notes <> ‘’ AND A.Diagnosis <>’’ AND B.Diagnosis <>’’);

$query[200] = SELECT * FROM november2015 A WHERE EXISTS (SELECT B.Treatments, B.Complaints FROM november2014 B WHERE (A.Complaints = B.Complaints OR A.Treatments = B.Treatments) AND A.Notes <> B.Notes AND A.Complaints <> ‘’ AND B.Complaints <> ‘’ AND A.Treatments <> ‘’ AND B.Treatments <> ‘’ AND A.Notes <> ‘’ AND B.Notes <> ‘’ AND A.Diagnosis <> ‘’ AND B.Diagnosis <> ‘’);

$query[201] = SELECT * FROM november2014 A WHERE EXISTS (SELECT B.Treatments, B.Complaints FROM november2013 B WHERE (A.Complaints = B.Complaints OR A.Treatments = B.Treatments) AND A.Notes <> B.Notes AND A.Complaints <> ‘’ AND B.Complaints <> ‘’ AND A.Treatments <> ‘’ AND B.Treatments <> ‘’ AND A.Notes <> ‘’ AND B.Notes <> ‘’ AND A.Diagnosis <> ‘’ AND B.Diagnosis <> ‘’);

$query[202] = SELECT * FROM november2013 A WHERE EXISTS (SELECT B.Treatments, B.Complaints FROM november2012 B WHERE (A.Complaints = B.Complaints OR A.Treatments = B.Treatments) AND A.Notes <> B.Notes AND A.Complaints <> ‘’ AND B.Complaints <> ‘’ AND A.Treatments <> ‘’ AND B.Treatments <> ‘’ AND A.Notes <> ‘’ AND B.Notes <> ‘’ AND A.Diagnosis <> ‘’ AND B.Diagnosis <> ‘’);

$query[203] = SELECT * FROM november2012 A WHERE EXISTS (SELECT B.Treatments, B.Complaints FROM november2011 B WHERE (A.Complaints = B.Complaints OR A.Treatments = B.Treatments) AND A.Notes <> B.Notes AND A.Complaints <> ‘’ AND B.Complaints <> ‘’ AND A.Treatments <> ‘’ AND B.Treatments <> ‘’ AND A.Notes <> ‘’ AND B.Notes <> ‘’ AND A.Diagnosis <> ‘’ AND B.Diagnosis <> ‘’);

$query[204] = SELECT * FROM november2011 A WHERE EXISTS (SELECT B.Treatments, B.Complaints FROM november2010 B WHERE (A.Complaints = B.Complaints OR A.Treatments = B.Treatments) AND A.Notes <> B.Notes AND A.Complaints <> ‘’ AND B.Complaints <> ‘’ AND A.Treatments <> ‘’ AND B.Treatments <> ‘’ AND A.Notes <> ‘’ AND B.Notes <> ‘’ AND A.Diagnosis <> ‘’ AND B.Diagnosis <> ‘’);

$query[205] = SELECT * FROM november2010 A WHERE EXISTS (SELECT B.Treatments, B.Complaints FROM november2009 B WHERE (A.Complaints = B.Complaints OR A.Treatments = B.Treatments) AND A.Notes <> B.Notes AND A.Complaints <> ‘’ AND B.Complaints <> ‘’ AND A.Treatments <> ‘’ AND B.Treatments <> ‘’ AND A.Notes <> ‘’ AND B.Notes <> ‘’ AND A.Diagnosis <> ‘’ AND B.Diagnosis <> ‘’);

$query[206] = SELECT * FROM november2009 A WHERE EXISTS (SELECT B.Treatments, B.Complaints FROM november2008 B WHERE (A.Complaints = B.Complaints OR A.Treatments = B.Treatments) AND A.Notes <> B.Notes AND A.Complaints <> ‘’ AND B.Complaints <> ‘’ AND A.Treatments <> ‘’ AND B.Treatments <> ‘’ AND A.Notes <> ‘’ AND B.Notes <> ‘’ AND A.Diagnosis <> ‘’ AND B.Diagnosis <> ‘’);

$query[207] = SELECT * FROM november2008 A WHERE EXISTS (SELECT B.Treatments, B.Complaints FROM november2007 B WHERE (A.Complaints = B.Complaints OR A.Treatments = B.Treatments) AND A.Notes <> B.Notes AND A.Complaints <> ‘’ AND B.Complaints <> ‘’ AND A.Treatments <> ‘’ AND B.Treatments <> ‘’ AND A.Notes <> ‘’ AND B.Notes <> ‘’ AND A.Diagnosis <> ‘’ AND B.Diagnosis <> ‘’);

$query[208] = SELECT * FROM november2007 A WHERE EXISTS (SELECT B.Treatments, B.Complaints FROM november2006 B WHERE (A.Complaints = B.Complaints OR A.Treatments = B.Treatments) AND A.Notes <> B.Notes AND A.Complaints <> ‘’ AND B.Complaints <> ‘’ AND A.Treatments <> ‘’ AND B.Treatments <> ‘’ AND A.Notes <> ‘’ AND B.Notes <> ‘’ AND A.Diagnosis <> ‘’ AND B.Diagnosis <> ‘’);

$query[209] = SELECT * FROM november2006 A WHERE EXISTS (SELECT B.Treatments, B.Complaints FROM november2015 B WHERE (A.Complaints = B.Complaints OR A.Treatments = B.Treatments) AND A.Notes <> B.Notes AND A.Complaints <> ‘’ AND B.Complaints <> ‘’ AND A.Treatments <> ‘’ AND B.Treatments <> ‘’ AND A.Notes <> ‘’ AND B.Notes <> ‘’ AND A.Diagnosis <> ‘’ AND B.Diagnosis <> ‘’);

$query[210] = SELECT * FROM november2015 WHERE Complaints IN (SELECT Complaints FROM november2014 WHERE (TimeOut - TimeIn > ‘10’) AND (TimeOut - TimeIn < ‘40’)) AND (TimeOut - TimeIn > ‘10’) AND (TimeOut - TimeIn < ‘40’);

$query[211] = SELECT * FROM november2014 WHERE Complaints IN (SELECT Complaints FROM november2013 WHERE (TimeOut - TimeIn > ‘10’) AND (TimeOut - TimeIn < ‘40’)) AND (TimeOut - TimeIn > ‘10’) AND (TimeOut - TimeIn < ‘40’);

$query[212] = SELECT * FROM november2013 WHERE Complaints IN (SELECT Complaints FROM november2012 WHERE (TimeOut - TimeIn > ‘10’) AND (TimeOut - TimeIn < ‘40’)) AND (TimeOut - TimeIn > ‘10’) AND (TimeOut - TimeIn < ‘40’);

$query[213] = SELECT * FROM november2012 WHERE Complaints IN (SELECT Complaints FROM november2011 WHERE (TimeOut - TimeIn > ‘10’) AND (TimeOut - TimeIn < ‘40’)) AND (TimeOut - TimeIn > ‘10’) AND (TimeOut - TimeIn < ‘40’);

$query[214] = SELECT * FROM november2011 WHERE Complaints IN (SELECT Complaints FROM november2010 WHERE (TimeOut - TimeIn > ‘10’) AND (TimeOut - TimeIn < ‘40’)) AND (TimeOut - TimeIn > ‘10’) AND (TimeOut - TimeIn < ‘40’);

$query[215] = SELECT * FROM november2010 WHERE Complaints IN (SELECT Complaints FROM november2009 WHERE (TimeOut - TimeIn > ‘10’) AND (TimeOut - TimeIn < ‘40’)) AND (TimeOut - TimeIn > ‘10’) AND (TimeOut - TimeIn < ‘40’);

$query[216] = SELECT * FROM november2009 WHERE Complaints IN (SELECT Complaints FROM november2008 WHERE (TimeOut - TimeIn > ‘10’) AND (TimeOut - TimeIn < ‘40’)) AND (TimeOut - TimeIn > ‘10’) AND (TimeOut - TimeIn < ‘40’);

$query[217] = SELECT * FROM november2008 WHERE Complaints IN (SELECT Complaints FROM november2007 WHERE (TimeOut - TimeIn > ‘10’) AND (TimeOut - TimeIn < ‘40’)) AND (TimeOut - TimeIn > ‘10’) AND (TimeOut - TimeIn < ‘40’);

$query[218] = SELECT * FROM november2007 WHERE Complaints IN (SELECT Complaints FROM november2006 WHERE (TimeOut - TimeIn > ‘10’) AND (TimeOut - TimeIn < ‘40’)) AND (TimeOut - TimeIn > ‘10’) AND (TimeOut - TimeIn < ‘40’);

$query[219] = SELECT * FROM november2006 WHERE Complaints IN (SELECT Complaints FROM november2015 WHERE (TimeOut - TimeIn > ‘10’) AND (TimeOut - TimeIn < ‘40’)) AND (TimeOut - TimeIn > ‘10’) AND (TimeOut - TimeIn < ‘40’);

$query[220] = SELECT * FROM november2015 WHERE Diagnosis IN (SELECT Diagnosis FROM november2014);

$query[221] = SELECT * FROM november2014 WHERE Diagnosis IN (SELECT Diagnosis FROM november2013);

$query[222] = SELECT * FROM november2013 WHERE Diagnosis IN (SELECT Diagnosis FROM november2012);

$query[223] = SELECT * FROM november2012 WHERE Diagnosis IN (SELECT Diagnosis FROM november2011);

$query[224] = SELECT * FROM november2011 WHERE Diagnosis IN (SELECT Diagnosis FROM november2010);

$query[225] = SELECT * FROM november2010 WHERE Diagnosis IN (SELECT Diagnosis FROM november2009);

$query[226] = SELECT * FROM november2009 WHERE Diagnosis IN (SELECT Diagnosis FROM november2008);

$query[227] = SELECT * FROM november2008 WHERE Diagnosis IN (SELECT Diagnosis FROM november2007);

$query[228] = SELECT * FROM november2007 WHERE Diagnosis IN (SELECT Diagnosis FROM november2006);

$query[229] = SELECT * FROM november2006 WHERE Diagnosis IN (SELECT Diagnosis FROM november2015);

$query[230] = SELECT * FROM november2006 WHERE Diagnosis IN (SELECT Diagnosis FROM november2007 ORDER BY Diagnosis) AND Diagnosis NOT LIKE ‘’ ORDER BY Diagnosis LIMIT 10;

$query[231] = SELECT * FROM november2007 WHERE Diagnosis IN (SELECT Diagnosis FROM november2008 ORDER BY Diagnosis) AND Diagnosis NOT LIKE ‘’ ORDER BY Diagnosis LIMIT 10;

$query[232] = SELECT * FROM november2008 WHERE Diagnosis IN (SELECT Diagnosis FROM november2009 ORDER BY Diagnosis) AND Diagnosis NOT LIKE ‘’ ORDER BY Diagnosis LIMIT 10;

$query[233] = SELECT * FROM november2009 WHERE Diagnosis IN (SELECT Diagnosis FROM november2010 ORDER BY Diagnosis) AND Diagnosis NOT LIKE ‘’ ORDER BY Diagnosis LIMIT 10;

$query[234] = SELECT * FROM november2010 WHERE Diagnosis IN (SELECT Diagnosis FROM november2011 ORDER BY Diagnosis) AND Diagnosis NOT LIKE ‘’ ORDER BY Diagnosis LIMIT 10;

$query[235] = SELECT * FROM november2011 WHERE Diagnosis IN (SELECT Diagnosis FROM november2012 ORDER BY Diagnosis) AND Diagnosis NOT LIKE ‘’ ORDER BY Diagnosis LIMIT 10;

$query[236] = SELECT * FROM november2012 WHERE Diagnosis IN (SELECT Diagnosis FROM november2013 ORDER BY Diagnosis) AND Diagnosis NOT LIKE ‘’ ORDER BY Diagnosis LIMIT 10;

$query[237] = SELECT * FROM november2013 WHERE Diagnosis IN (SELECT Diagnosis FROM november2014 ORDER BY Diagnosis) AND Diagnosis NOT LIKE ‘’ ORDER BY Diagnosis LIMIT 10;

$query[238] = SELECT * FROM november2014 WHERE Diagnosis IN (SELECT Diagnosis FROM november2015 ORDER BY Diagnosis) AND Diagnosis NOT LIKE ‘’ ORDER BY Diagnosis LIMIT 10;

$query[239] = SELECT * FROM november2015 WHERE Diagnosis IN (SELECT Diagnosis FROM november2006 ORDER BY Diagnosis) AND Diagnosis NOT LIKE ‘’ ORDER BY Diagnosis LIMIT 10;

$query[240] = SELECT DISTINCT * FROM november2006 b JOIN (SELECT Diagnosis FROM november2006 ORDER BY Diagnosis) sub ON b.Diagnosis = sub.Diagnosis AND b.Diagnosis <> ‘’ ORDER BY b.Diagnosis;

$query[241] = SELECT DISTINCT * FROM november2007 b JOIN (SELECT Diagnosis FROM november2007 ORDER BY Diagnosis) sub ON b.Diagnosis = sub.Diagnosis AND b.Diagnosis <> ‘’ ORDER BY b.Diagnosis;

$query[242] = SELECT DISTINCT * FROM november2008 b JOIN (SELECT Diagnosis FROM november2008 ORDER BY Diagnosis) sub ON b.Diagnosis = sub.Diagnosis AND b.Diagnosis <> ‘’ ORDER BY b.Diagnosis;

$query[243] = SELECT DISTINCT * FROM november2009 b JOIN (SELECT Diagnosis FROM november2009 ORDER BY Diagnosis) sub ON b.Diagnosis = sub.Diagnosis AND b.Diagnosis <> ‘’ ORDER BY b.Diagnosis;

$query[244] = SELECT DISTINCT * FROM november2010 b JOIN (SELECT Diagnosis FROM november2010 ORDER BY Diagnosis) sub ON b.Diagnosis = sub.Diagnosis AND b.Diagnosis <> ‘’ ORDER BY b.Diagnosis;

$query[245] = SELECT DISTINCT * FROM november2011 b JOIN (SELECT Diagnosis FROM november2011 ORDER BY Diagnosis) sub ON b.Diagnosis = sub.Diagnosis AND b.Diagnosis <> ‘’ ORDER BY b.Diagnosis;

$query[246] = SELECT DISTINCT * FROM november2012 b JOIN (SELECT Diagnosis FROM november2012 ORDER BY Diagnosis) sub ON b.Diagnosis = sub.Diagnosis AND b.Diagnosis <> ‘’ ORDER BY b.Diagnosis;

$query[247] = SELECT DISTINCT * FROM november2013 b JOIN (SELECT Diagnosis FROM november2013 ORDER BY Diagnosis) sub ON b.Diagnosis = sub.Diagnosis AND b.Diagnosis <> ‘’ ORDER BY b.Diagnosis;

$query[248] = SELECT DISTINCT * FROM november2014 b JOIN (SELECT Diagnosis FROM november2014 ORDER BY Diagnosis) sub ON b.Diagnosis = sub.Diagnosis AND b.Diagnosis <> ‘’ ORDER BY b.Diagnosis;

$query[249] = SELECT DISTINCT * FROM november2015 b JOIN (SELECT Diagnosis FROM november2015 ORDER BY Diagnosis) sub ON b.Diagnosis = sub.Diagnosis AND b.Diagnosis <> ‘’ ORDER BY b.Diagnosis;

$query[250] = SELECT *, (CASE WHEN Notes = ‘’ THEN ‘No notes entry’ ELSE Notes END) AS Notes FROM november2006;

$query[251] = SELECT *, (CASE WHEN Notes = ‘’ THEN ‘No notes entry’ ELSE Notes END) AS Notes FROM november2007;

$query[252] = SELECT *, (CASE WHEN Notes = ‘’ THEN ‘No notes entry’ ELSE Notes END) AS Notes FROM november2008;

$query[253] = SELECT *, (CASE WHEN Notes = ‘’ THEN ‘No notes entry’ ELSE Notes END) AS Notes FROM november2009;

$query[254] = SELECT *, (CASE WHEN Notes = ‘’ THEN ‘No notes entry’ ELSE Notes END) AS Notes FROM november2010;

$query[255] = SELECT *, (CASE WHEN Notes = ‘’ THEN ‘No notes entry’ ELSE Notes END) AS Notes FROM november2011;

$query[256] = SELECT *, (CASE WHEN Notes = ‘’ THEN ‘No notes entry’ ELSE Notes END) AS Notes FROM november2012;

$query[257] = SELECT *, (CASE WHEN Notes = ‘’ THEN ‘No notes entry’ ELSE Notes END) AS Notes FROM november2013;

$query[258] = SELECT *, (CASE WHEN Notes = ‘’ THEN ‘No notes entry’ ELSE Notes END) AS Notes FROM november2014;

$query[259] = SELECT *, (CASE WHEN Notes = ‘’ THEN ‘No notes entry’ ELSE Notes END) AS Notes FROM november2015;

$query[260] = SELECT * FROM november2006 ORDER BY TimeOut DESC LIMIT 50;

$query[261] = SELECT * FROM november2007 ORDER BY TimeOut DESC LIMIT 50;

$query[262] = SELECT * FROM november2008 ORDER BY TimeOut DESC LIMIT 50;

$query[263] = SELECT * FROM november2009 ORDER BY TimeOut DESC LIMIT 50;

$query[264] = SELECT * FROM november2010 ORDER BY TimeOut DESC LIMIT 50;

$query[265] = SELECT * FROM november2011 ORDER BY TimeOut DESC LIMIT 50;

$query[266] = SELECT * FROM november2012 ORDER BY TimeOut DESC LIMIT 50;

$query[267] = SELECT * FROM november2013 ORDER BY TimeOut DESC LIMIT 50;

$query[268] = SELECT * FROM november2014 ORDER BY TimeOut DESC LIMIT 50;

$query[269] = SELECT * FROM november2015 ORDER BY TimeOut DESC LIMIT 50;

    //LINE 96

    $key_data_sqlResult = $sqlResult[$m];

    $key_data_query = $query[$m];

}

            print $key_data_sqlResult.
;

//print Patients seen in November 1997 showing the notes column with.
;

//print no record entry provided they originally had nothing entered..
;

//print are being ordered by diagnosis in ascending order..
;

//print -----.
;

print =====================================================.
;

print
;

print
;

print
; //LINE 219

//Because it is a bit complex, let’s go through the steps we’ve used to access the records from our table:

// 1. Set up a SQL Statement that can be used to get the records from the database table

// 2. Use mysqli_query() to bring back the records we’ve specified in Step 1

// 3. Use mysqli_fetch_assoc() to set up an array. The array will contain all the records that were returned in Step 2

// 4. Loop round all the data in the array using a While loop

    $db_handle = mysqli_connect(DB_SERVER, DB_USER, DB_PASS);

    $db_found = mysqli_select_db($db_handle, $database);

    $start = 1;

    $maxRow = 1;

if ($db_found) {     //LINE 238

// Step 1

$SQL = $key_data_query;

//This shows the number of the Query

//print Number is .($m-1).
;

print
;

// Step 2

    $result = mysqli_query($db_handle, $SQL);    //LINE 2872

$db_field = -1;

if($db_field = -1){     //LINE 13527 ??

                $maxRow = $start + 1;

    }                //LINE 13503 new

    while($start < $maxRow + 1){

        if (0 === mysqli_num_rows($result)) {

                //results are empty, do something here

                print Total number of records: .($start - 1).
;

                exit;

    } else if (1 == mysqli_num_rows($result)) {

                $db_field = mysqli_fetch_assoc($result);

                print Total number of records: .$start.
;

                print
;

                print Record Number .$start.
;

                print ========================.
;

    print Surgery Date: .$db_field[‘SurgeryDate’].
;

    print Date Of Birth: .$db_field[‘DateOfBirth’].
;

    print Sex: .$db_field[‘Sex’].
;

                print Diagnosis: .$db_field[‘Diagnosis’].
;

                print Time In: .$db_field[‘TimeIn’].
;

                print Time Out: .$db_field[‘TimeOut’].
;

                print Complaints: .$db_field[‘Complaints’].
;

                print Treatments: .$db_field[‘Treatments’].
;

                print Initials: .$db_field[‘Initials’].
;

                //print Numbers ID: .$db_field[‘NumbersID’].
;

                print Notes: .$db_field[‘Notes’].
;

                print
;

                print Total number of records: .$start.
;

                print «
»;

                print «
»;

                exit;

    } else {

                while ($db_field = mysqli_fetch_assoc($result)){

                            $start++;

            }

        }

    }

    print Total number of records: .($start - 1).
;

    print
;

    print
;

    }

$start = 1;

$maxRow = 1;

    $result = mysqli_query($db_handle, $SQL); //LINE 14071 new

    $db_field = -1;

    if($db_field = -1){

                $maxRow = $start + 1;

    while($start < $maxRow + 1){

    // Step 3 was the bit in the () of while Step 3 was the bit in the () of while

    // Step 4 were the bits assigned to the print and bit in step 3

while ($db_field = mysqli_fetch_assoc($result)){

                print Record Number .$start.
;

                print ========================.
;

                print Surgery Date: .$db_field[‘SurgeryDate’].
;

                print Date Of Birth: .$db_field[‘DateOfBirth’].
;

                print Sex: .$db_field[‘Sex’].
;

                print Diagnosis: .$db_field[‘Diagnosis’].
;

                print Time In: .$db_field[‘TimeIn’].
;

                print Time Out: .$db_field[‘TimeOut’].
;

                print Complaints: .$db_field[‘Complaints’].
;

                print Treatments: .$db_field[‘Treatments’].
;

                print Initials: .$db_field[‘Initials’].
;

                //print Numbers ID: .$db_field[‘NumbersID’].
;

                print Notes: .$db_field[‘Notes’].
;

                print
;

                $start++;

            }

        }

            print Total number of records: .($start - 1).
;

        }

        else {

            print Database NOT found;

        }

        mysqli_close($db_handle);

?>

Combo Box October 1997 to October 2005 Queries

if(isset($_POST[‘search’])){

    $maker = $_POST[‘Make’]; // make value

    $maker = explode(_, $maker);

    print (Query selected is ) . $_POST[‘Make’].
;

}

else {

    echo ‘

post action= /October_1997_October_2005_SurgeryDatabaseA.php>’;

    // here should be your SQL query and the combobox options generation

    echo ‘’;

    print Query is not yet selected. Click inside the box containing Select a Query or on the downward arrow, select a query and then click on Search;

}

?>

form1 method=POST ACTION = /October_1997_October_2005_SurgeryDatabaseA.php >

Query >

cmbMake name=Make>

    0>Select a Query

October Queries:

Queries starting with October 1997 and ending with October 2005>

Write a query that lists all patients seen in October 1997 whose notes entries began with the letter ‘C’>Write a query that lists all patients seen in October 1997 whose notes entries began with the letter ‘C’

Write a query that lists all patients seen in October 1998 whose notes entries began with the letter ‘C’>Write a query that lists all patients seen in October 1998 whose notes entries began with the letter ‘C’

Write a query that lists all patients seen in October 1999 whose notes entries began with the letter ‘C’>Write a query that lists all patients seen in October 1999 whose notes entries began with the letter ‘C’

Write a query that lists all patients seen in October 2000 whose notes entries began with the letter ‘C’>Write a query that lists all patients seen in October 2000 whose notes entries began with the letter ‘C’

Write a query that lists all patients seen in October 2001 whose notes entries began with the letter ‘C’>Write a query that lists all patients seen in October 2001 whose notes entries began with the letter ‘C’

Write a query that lists all patients seen in October 2002 whose notes entries began with the letter ‘C’>Write a query that lists all patients seen in October 2002 whose notes entries began with the letter ‘C’

Write a query that lists all patients seen in October 2003 whose notes entries began with the letter ‘C’>Write a query that lists all patients seen in October 2003 whose notes entries began with the letter ‘C’

Write a query that lists all patients seen in October 2004 whose notes entries began with the letter ‘C’>Write a query that lists all patients seen in October 2004 whose notes entries began with the letter ‘C’

Write a query that lists all patients seen in October 2005 whose notes entries began with the letter ‘C’>Write a query that lists all patients seen in October 2005 whose notes entries began with the letter ‘C’

Write a query that lists all patients seen in October 1997 who have similarly entered notes, similarly entered treatments or similarly entered date of births in October 1998>Write a query that lists all patients seen in October 1997 who have similarly entered notes, similarly entered treatments or similarly entered date of births in October 1998

Write a query that lists all patients seen in October 1998 who have similarly entered notes, similarly entered treatments or similarly entered date of births in October 1999>Write a query that lists all patients seen in October 1998 who have similarly entered notes, similarly entered treatments or similarly entered date of births in October 1999

Write a query that lists all patients seen in October 1999 who have similarly entered notes, similarly entered treatments or similarly entered date of births in October 2000>Write a query that lists all patients seen in October 1999 who have similarly entered notes, similarly entered treatments or similarly entered date of births in October 2000

Write a query that lists all patients seen in October 2000 who have similarly entered notes, similarly entered treatments or similarly entered date of births in October 2001>Write a query that lists all patients seen in October 2000 who have similarly entered notes, similarly entered treatments or similarly entered date of births in October 2001

Write a query that lists all patients seen in October 2001 who have similarly entered notes, similarly entered treatments or similarly entered date of births in October 2002>Write a query that lists all patients seen in October 2001 who have similarly entered notes, similarly entered treatments or similarly entered date of births in October 2002

Write a query that lists all patients seen in October 2002 who have similarly entered notes, similarly entered treatments or similarly entered date of births in October 2003>Write a query that lists all patients seen in October 2002 who have similarly entered notes, similarly entered treatments or similarly entered date of births in October 2003

Write a query that lists all patients seen in October 2003 who have similarly entered notes, similarly entered treatments or similarly entered date of births in October 2004>Write a query that lists all patients seen in October 2003 who have similarly entered notes, similarly entered treatments or similarly entered date of births in October 2004

Write a query that lists all patients seen in October 2004 who have similarly entered notes, similarly entered treatments or similarly entered date of births in October 2005>Write a query that lists all patients seen in October 2004 who have similarly entered notes, similarly entered treatments or similarly entered date of births in October 2005

Write a query that lists all patients seen in October 2005 who have similarly entered notes, similarly entered treatments or similarly entered date of births in October 1997>Write a query that lists all patients seen in October 2005 who have similarly entered notes, similarly entered treatments or similarly entered date of births in October 1997

Queries starting with October 2005 and ending with October 1997>

Write a query that lists all patients seen in October 2005 who have similarly diagnosis as those seen in October 2004>Write a query that lists all patients seen in October 2005 who have similarly diagnosis as those seen in October 2004

Write a query that lists all patients seen in October 2004 who have similarly diagnosis as those seen in October 2003>Write a query that lists all patients seen in October 2004 who have similarly diagnosis as those seen in October 2003

Write a query that lists all patients seen in October 2003 who have similarly diagnosis as those seen in October 2002>Write a query that lists all patients seen in October 2003 who have similarly diagnosis as those seen in October 2002

Write a query that lists all patients seen in October 2002 who have similarly diagnosis as those seen in October 2001>Write a query that lists all patients seen in October 2002 who have similarly diagnosis as those seen in October 2001

Write a query that lists all patients seen in October 2001 who have similarly diagnosis as those seen in October 2000>Write a query that lists all patients seen in October 2001 who have similarly diagnosis as those seen in October 2000

Write a query that lists all patients seen in October 2000 who have similarly diagnosis as those seen in October 1999>Write a query that lists all patients seen in October 2000 who have similarly diagnosis as those seen in October 1999

Write a query that lists all patients seen in October 1999 who have similarly diagnosis as those seen in October 1998>Write a query that lists all patients seen in October 1999 who have similarly diagnosis as those seen in October 1998

Write a query that lists all patients seen in October 1998 who have similarly diagnosis as those seen in October 1997>Write a query that lists all patients seen in October 1998 who have similarly diagnosis as those seen in October 1997

Write a query that lists all patients seen in October 1997 who have similarly diagnosis as those seen in October 2005>Write a query that lists all patients seen in October 1997 who have similarly diagnosis as those seen in October 2005