Summer Schedule. On 08/02/2014 11:00AM Basic Pole and 08/07/2014 7:00PM Level1/2 are canceled. Sorry for the inconvenience.
Array
(
[10] => Array
(
[0] => Array
(
[name] => Stretch into Sleek
[bgcolor] => C6D9F1
[font] => Y
[teacher] => Carinne
[teacher_id] => 11142
[starthour] => 10
[type_id] => 29
[length] => 1
[level] => F
)
[1] => Array
(
[name] => Pole Fitness Bootcamp
[bgcolor] => FF99FF
[font] => Y
[teacher] => Hivo
[teacher_id] => 18660
[starthour] => 10
[type_id] => 30
[length] => 1
[level] => F
)
[2] => Array
(
[name] => Flexibility and Foam Rolling
[bgcolor] => 13912F
[font] => N
[teacher] => Yana
[teacher_id] => 7
[starthour] => 10
[type_id] => 78
[length] => 1
[level] => B
)
[3] => Array
(
[name] => Strip Dance
[bgcolor] => FFF00B
[font] => Y
[teacher] => Yana
[teacher_id] => 7
[starthour] => 10
[type_id] => 71
[length] => 1
[level] => A
)
[4] => Array
(
[name] => Conditioning for Pole
[bgcolor] => 98FF00
[font] => Y
[teacher] => Carinne
[teacher_id] => 11142
[starthour] => 10
[type_id] => 74
[length] => 1
[level] => F
)
)
[11] => Array
(
[0] => Array
(
[name] => Pole Dance Routine
[bgcolor] => FAA2B2
[font] => Y
[teacher] => Carinne
[teacher_id] => 11142
[starthour] => 11
[type_id] => 68
[length] => 1
[level] => AL
)
[1] => Array
(
[name] => Level 1&2 Beginner
[bgcolor] => 9933FF
[font] => N
[teacher] => Svetlana
[teacher_id] => 11145
[starthour] => 11
[type_id] => 64
[length] => 1
[level] => B
)
[2] => Array
(
[name] => Intro to Pole
[bgcolor] => FFFFFF
[font] => Y
[teacher] => Yana
[teacher_id] => 7
[starthour] => 11
[type_id] => 39
[length] => 1
[level] => B
)
[3] => Array
(
[name] => Sexy Chair
[bgcolor] => TT30A0
[font] => N
[teacher] => Yana
[teacher_id] => 7
[starthour] => 11
[type_id] => 13
[length] => 1
[level] => A
)
[4] => Array
(
[name] => Basic Pole
[bgcolor] => F8674A
[font] => N
[teacher] => Carinne
[teacher_id] => 11142
[starthour] => 11
[type_id] => 50
[length] => 1
[level] => B
)
[5] => Array
(
[name] => Canceled
[bgcolor] => 709FFA
[font] => N
[teacher] => Jesika
[teacher_id] => 18768
[starthour] => 11
[type_id] => 72
[length] => 1
[level] => B
)
)
[12] => Array
(
[0] => Array
(
[name] => Pole Grooves
[bgcolor] => BBB555
[font] => N
[teacher] => Carinne
[teacher_id] => 11142
[starthour] => 12
[type_id] => 44
[length] => 1
[level] => AL
)
[1] => Array
(
[name] => Beginner Tricks & Skills
[bgcolor] => 002060
[font] => N
[teacher] => Svetlana
[teacher_id] => 11145
[starthour] => 12
[type_id] => 48
[length] => 1
[level] => B
)
[2] => Array
(
[name] => Pole Prep
[bgcolor] => 1E11C5
[font] => N
[teacher] => Yana
[teacher_id] => 7
[starthour] => 12
[type_id] => 38
[length] => 1
[level] => B
)
[3] => Array
(
[name] => Intro to Pole
[bgcolor] => FFFFFF
[font] => Y
[teacher] => Yana
[teacher_id] => 7
[starthour] => 12
[type_id] => 39
[length] => 1
[level] => B
)
[4] => Array
(
[name] => Simple Spins and Beginner Pole
[bgcolor] => 262626
[font] => N
[teacher] => Carinne
[teacher_id] => 11142
[starthour] => 12
[type_id] => 51
[length] => 1
[level] => B
)
)
[17] => Array
(
[5] => Array
(
[name] => Booty Pop
[bgcolor] => 660033
[font] => N
[teacher] => Jesika
[teacher_id] => 18768
[starthour] => 12
[type_id] => 32
[length] => 1
[level] => A
)
[4] => Array
(
[name] => Open Pole Freestyle
[bgcolor] => BBA901
[font] => N
[teacher] => No Instructor
[teacher_id] => 18086
[starthour] => 13
[type_id] => 77
[length] => 1
[level] => B
)
[0] => Array
(
[name] => Basic Pole
[bgcolor] => F8674A
[font] => N
[teacher] => Svetlana
[teacher_id] => 11145
[starthour] => 17
[type_id] => 50
[length] => 1
[level] => B
)
[1] => Array
(
[name] => Zumba
[bgcolor] => 800080
[font] => N
[teacher] => Alex
[teacher_id] => 1074
[starthour] => 17
[type_id] => 47
[length] => 1
[level] => A
)
[2] => Array
(
[name] => SoBe Hip Hop
[bgcolor] => 00B050
[font] => Y
[teacher] => Iyana
[teacher_id] => 81
[starthour] => 17
[type_id] => 61
[length] => 1
[level] => AL
)
)
[18] => Array
(
[5] => Array
(
[name] => Exotic Lap Dance
[bgcolor] => FF00FF
[font] => N
[teacher] => Jesika
[teacher_id] => 18768
[starthour] => 13
[type_id] => 1
[length] => 1
[level] => A
)
[4] => Array
(
[name] => Open Pole Freestyle
[bgcolor] => BBA901
[font] => N
[teacher] => No Instructor
[teacher_id] => 18086
[starthour] => 14
[type_id] => 77
[length] => 1
[level] => B
)
[0] => Array
(
[name] => Beginner Tricks & Skills
[bgcolor] => 002060
[font] => N
[teacher] => Svetlana
[teacher_id] => 11145
[starthour] => 18
[type_id] => 48
[length] => 1
[level] => B
)
[1] => Array
(
[name] => Level 1 Beginner
[bgcolor] => C4BC96
[font] => Y
[teacher] => Svetlana
[teacher_id] => 11145
[starthour] => 18
[type_id] => 6
[length] => 1
[level] => B
)
[2] => Array
(
[name] => Pole Divas
[bgcolor] => 10FFF9
[font] => Y
[teacher] => Iyana
[teacher_id] => 81
[starthour] => 18
[type_id] => 62
[length] => 1
[level] => B
)
[3] => Array
(
[name] => Zumba
[bgcolor] => 800080
[font] => N
[teacher] => Alex
[teacher_id] => 1074
[starthour] => 18
[type_id] => 47
[length] => 1
[level] => A
)
)
[19] => Array
(
[5] => Array
(
[name] => Simple Spins and Beginner Pole
[bgcolor] => 262626
[font] => N
[teacher] => Jesika
[teacher_id] => 18768
[starthour] => 14
[type_id] => 51
[length] => 1
[level] => B
)
[4] => Array
(
[name] => Open Pole Freestyle
[bgcolor] => BBA901
[font] => N
[teacher] => No Instructor
[teacher_id] => 18086
[starthour] => 15
[type_id] => 77
[length] => 1
[level] => B
)
[0] => Array
(
[name] => Transitional Level 2/3
[bgcolor] => FF00A0
[font] => N
[teacher] => Svetlana
[teacher_id] => 11145
[starthour] => 19
[type_id] => 66
[length] => 1
[level] => I
)
[1] => Array
(
[name] => Level 2 Beginner
[bgcolor] => 948A54
[font] => N
[teacher] => Svetlana
[teacher_id] => 11145
[starthour] => 19
[type_id] => 7
[length] => 1
[level] => B
)
[2] => Array
(
[name] => Level 3&4 Intermediate
[bgcolor] => 548DD4
[font] => N
[teacher] => Iyana
[teacher_id] => 81
[starthour] => 19
[type_id] => 52
[length] => 1
[level] => I
)
[3] => Array
(
[name] => Level 1&2 Beginner
[bgcolor] => 9933FF
[font] => N
[teacher] => Guensie
[teacher_id] => 26
[starthour] => 19
[type_id] => 64
[length] => 1
[level] => B
)
)
[20] => Array
(
[3] => Array
(
[name] => Basic Pole
[bgcolor] => F8674A
[font] => N
[teacher] => Guensie
[teacher_id] => 26
[starthour] => 20
[type_id] => 50
[length] => 1
[level] => B
)
)
)
select *, WEEKDAY(lesson_date) as wd from xcart_cm_lessons les
join xcart_cm_lesson_types lt on les.lesson_type_id = lt.type_id
join xcart_customers cust on les.lesson_teacher_id = cust.id
WHERE les.lesson_date>='2014-07-28' AND les.lesson_date<='2014-08-03' AND les.lesson_group_type='G'
order by les.lesson_starthour
B = Beginner F = Fitness A = Alternative (not a pole dance class) I = Intermediate AL = All Levels
CLASS REGISTRATION:
Please be aware that there is limited space in each class (maximum number of students per class is 12), and that REGISTRATION for a class is OPTIONAL. WALK-INS ARE WELCOME but a space cannot be guaranteed. Registering for a class will reserve your position in that class and for that hour and day only. Upon registering for a class you will be held financially accountable for that specific class. Be advised that the Studio provides NO REFUNDS. Call Studio to register at (305) 532-7171. You may also register online. To register online simply add class/classes to your cart, proceed with the purchase and indicate class name and date you would like to register for under “Customer Notes”. You should always call for availability. We recommend coming to a class at least 15 minutes prior to class time to ensure your spot. Your cooperation is greatly appreciated. Studio reserves the right to cancel or reschedule classes. For your safety we do not allow to a class after 10 min.
For Private Lessons: Please call or contact us to schedule an appointment with one of our instructors. Availability: Mon-Fri 1:00:00-5:00pm (Last Private Begins at 4:00pm), Sat 4:00-6:00pm (Last Private Begins at 5:00pm), Sun: closed
For Private Parties: Please call (305) 532-7171 or contact us to check for availability.
|
