SELECT *, 'd' AS gal_source FROM gallery LEFT OUTER JOIN sizes ON size_id = gal_size LEFT OUTER JOIN leadtimes ON lead_id = gal_leadtime LEFT OUTER JOIN groups ON grp_id = gal_group LEFT OUTER JOIN group_types ON grp_gt = gt_id WHERE gal_active = 'true' AND ( OR (((gal_raw_price*1*1) >= '2000' AND (gal_raw_price*1*1) <= '4999') AND gal_group = '27') OR (((gal_raw_price*1*1) >= '2000' AND (gal_raw_price*1*1) <= '4999') AND gal_group = '5') OR (((gal_raw_price*1*1) >= '2000' AND (gal_raw_price*1*1) <= '4999') AND gal_group = '43') OR (((gal_raw_price*1*1) >= '2000' AND (gal_raw_price*1*1) <= '4999') AND gal_group = '32') OR (((gal_raw_price*1*1) >= '2000' AND (gal_raw_price*1*1) <= '4999') AND gal_group = '3') (((gal_raw_price*1*1) >= '2000' AND (gal_raw_price*1*1) <= '4999') AND gal_group = '36') OR (((gal_raw_price*1*1) >= '2000' AND (gal_raw_price*1*1) <= '4999') AND gal_group = '25') OR (((gal_raw_price*1*1) >= '2000' AND (gal_raw_price*1*1) <= '4999') AND gal_group = '4') OR (((gal_raw_price*1*1) >= '2000' AND (gal_raw_price*1*1) <= '4999') AND gal_group = '1') OR (((gal_raw_price*1*1) >= '2000' AND (gal_raw_price*1*1) <= '4999') AND gal_group = '13') OR (((gal_raw_price*1*1) >= '2000' AND (gal_raw_price*1*1) <= '4999') AND gal_group = '2') OR (((gal_raw_price*1*1) >= '2000' AND (gal_raw_price*1*1) <= '4999') AND gal_group = '41') ) AND (gal_group = '36' OR gal_group = '41' OR gal_group = '25' OR gal_group = '3' OR gal_group = '32' OR gal_group = '5' OR gal_group = '27' OR gal_group = '43' OR gal_group = '1' OR gal_group = '2' OR gal_group = '13' OR gal_group = '4') AND (grp_id <> '11') AND (grp_id <> '12') ORDER BY size_name IS NULL, size_name, grp_order, gal_order, gal_id DESC,gal_title DESC SELECT DISTINCT gal_size, size_name, size_name_metric, size_id FROM gallery INNER JOIN groups ON grp_id = gal_group INNER JOIN sizes ON size_id = gal_size WHERE gal_active = 'true' AND (size_dist = 'classic') AND (size_id <> 'EXCLUDED_SIZES') AND ( OR (((gal_raw_price*1*1) >= '2000' AND (gal_raw_price*1*1) <= '4999') AND gal_group = '27') OR (((gal_raw_price*1*1) >= '2000' AND (gal_raw_price*1*1) <= '4999') AND gal_group = '5') OR (((gal_raw_price*1*1) >= '2000' AND (gal_raw_price*1*1) <= '4999') AND gal_group = '43') OR (((gal_raw_price*1*1) >= '2000' AND (gal_raw_price*1*1) <= '4999') AND gal_group = '32') OR (((gal_raw_price*1*1) >= '2000' AND (gal_raw_price*1*1) <= '4999') AND gal_group = '3') (((gal_raw_price*1*1) >= '2000' AND (gal_raw_price*1*1) <= '4999') AND gal_group = '36') OR (((gal_raw_price*1*1) >= '2000' AND (gal_raw_price*1*1) <= '4999') AND gal_group = '25') OR (((gal_raw_price*1*1) >= '2000' AND (gal_raw_price*1*1) <= '4999') AND gal_group = '4') OR (((gal_raw_price*1*1) >= '2000' AND (gal_raw_price*1*1) <= '4999') AND gal_group = '1') OR (((gal_raw_price*1*1) >= '2000' AND (gal_raw_price*1*1) <= '4999') AND gal_group = '13') OR (((gal_raw_price*1*1) >= '2000' AND (gal_raw_price*1*1) <= '4999') AND gal_group = '2') OR (((gal_raw_price*1*1) >= '2000' AND (gal_raw_price*1*1) <= '4999') AND gal_group = '41') ) AND (gal_group = '36' OR gal_group = '41' OR gal_group = '25' OR gal_group = '3' OR gal_group = '32' OR gal_group = '5' OR gal_group = '27' OR gal_group = '43' OR gal_group = '1' OR gal_group = '2' OR gal_group = '13' OR gal_group = '4') AND (grp_id <> '11') AND (grp_id <> '12') ORDER BY size_name;}ks6LUV;=1įyrQ$$1Hl+Vݯ|Z%gNMEn4FbF$zd6zMji90ëCt -?rc7-4ko_zN>׈g7j9؍=?;ɀZ=!t(L;rF3ZDurjEG:g}L= !v:95vM ^mdzwM#@6bDo5`j2<׿!!jQJAfbzvXUo:6 6EA{4tfУ5b~LxvrF̾Y3p}ۛ/i0jl7 {QmPaK^e*DvbSX[#Qhsec6&) t"[y g?Yv<iXׅ~8U@WCl`4 kd|\LZWKyIYt0bF@:4p&e'%/A9io! ܷo%?`jyC4l7DU0#vNX .!&@4;R uǓxo|y:do*p+V Wojoާ1XꓑET;˷˲mEAhfz$#2 BRT 4UX rWlﲒ6Dŋ$f $ŋVYDO~Zo޳/iD?x oZT|:j4/.'E/RAJ5(ʱi%U:rdz*l./iӋT%DrlZ*dU-n92HJPݶvEUފ2["U*A t;"U*A.@׊T*P*S(TA2ՋT% ]Ъj^a%0QѧWJ UN+R D'4BBT"&1 P"@ItR)T1T/S(B՘Tb&uzw +c&B8kBCUXj6w[j<0۳H2ܺu cu)|{oLa{+)]ꓗ˓ZE l?Qǧc-H-,!V3F;f4 |R2Ø6e[Rmp/?;5M10ضRo{5r+xBs4;NOtdOZ݄ZOлֿx4t)}n&wj,n{]ǸBռ[gϬĒHї/qMfyiMaHbGhGs_lG9ds΢Mv"BG]cHg MK;}Lߦ r5x# ѬLUd$|Bva/]xAp;qpq7!5S ;vTR2%8t0" ޒm27{O6/mkut@%+#aUNy Odpy .>}#!?ǽZ ,2Ґ1}ރӰ; ©Huz,dў>m\s:~ؔƓ٫:8 vB5cF \6ףa\: sxqVۘew0ttϣ`3'0O58W͇S7F> Z>^$X|^ZHćZѹNs~pt/C:eˮ])0L5K^{&xFуQ_g| gV χrA$ޫN>~zGڍx2 K_>#-ru&ӱȽJ x%Y` .^> w6.Q;0 NlP)ؘ.l(qP;}\aC\0 %OF< f|,w|[z>}|=3stg?3'a:\?C?bI(3sg?33z<ڥpN,XDnזOՇu-43Q?(b Ebqi^  JgQ xf-ߧŖ,R^WJB} ͽV?$6ǻ =_3e. {2! m+tPQ#oZT868}'H$?z[T7n/R^߈'ap/2 ML=fWF(u_@9gNh54RoFš!R΀눆`"Iv Sjvԋ0ͺ*]׳$Tja:X$L.!W{'whufW I6m~MB)R+,.JJoyjkN#l!.}5:-5^ z]+=)Jí=99 VmAW6$Fۊ3mWK Lo-̄lM+iF3êN3.%+Q:`d 8pWl7(NXL>.gV Fl\ l!SEU|yN (Ql6nmzKTV[k |fRU%QΖBڪږX۲ kk[bm m]#v֎کڑX;kGaTcJ]vv{, kkOb =$I=)K kb[1DTyâT݈r5KǚZdZiˌ9{Hi5윀);rWgimJR[PT|,lZzN\n~sx1C&f2/ DR^Ggr(Nz0^K7)ًLI1,a]sA( Ox2s?rkIƆ;0߼z8G_yqe|F.=FZ{Pmr̉ͥl*h[Hn]q]gVȰ\ 2JRtkpj%35[q<. 흷=S?{cq4k5xR m5#FkP&,2>00.GHenb/ n5z@4pVkkېVm2[zvq>o[=e=fVgezT>ʚ9I m0k>Ѷٖc-Lj5vNlLP@@CC=; ӝR6L:;[iuڷY*˷|뤠XuF-y&r;m#lklQ Yd"?'s۝mڷRjU)[,sq7N4]Z03EO7xOrQB[)D>TYhbGZKMo~$6Ul4 nf,_ _4J")Ȏ\P!;$)tN33DW[tENN?ġEWQK0jfKnoY@[%bT/S/aSoc\4c2jDr lV4%%5@`"#v¦N;at肈:6- J(lN:I +7CWiR uMD122UJu# c0xرر6vlH0W 먆u [Hʝ270:qx姆t[ l]xWWFlp AэzKzKzkm R:yxWjWw~^q,fϷTkIjf f9pW] 7疇2v[mm} ̺!TO?ƴOL&5lnO0-[$}$kw}#*lAu:H`^MSCF/?8?n kFcn u=zy]v-'`ኋ˿~o+7ܠ;?"ͣЊWp*Q,좋LlQ4ELÉk)EojiD⮑o.YQl[6TWf<nLID녮Tx%xzHb^jvJS˚6g̮i8򁻕`O6SWg!"OYi%ZV M5[H}i h%%(e1դoӋ E(P(DF`c%F |c|FBQX 1b>DV텯J"I#`ve.c ζWV#g3q,!t uǬVQ̣03 e@K͸#C+1УS?b榺aEyR%yکt-ybT{0jCIitw?2W<2wq<wVo^谆pӱ=xQ?ur|Z'uN?g:\'_]-Z(}ߟ&:qxpA <| sCmh1GCɵtp RYs^pbˣ7s<0,x-[ǧ3<ƚ 1 p(L@ZT,c !rA}"g`YrryZgރy}D EC728 @띹[>g \ԊcO4!&$oHΔ Ai7+2Nbς$uQjD Ev1A0$ +Ae-?[܍5X"b)*W(oh54D,uH 5?DžsUO ckl1GnLu`m<'UAg^Xg"0 -ض{?lrwwoBڊHuR@b3K^qK[ڐ`#C/A(El Kil)qwFF ?~D2- o"й!=k6xLM~4N#\R آ3y]2Nwf̳*G.')Z֭S :0 M;I ͧ;Q}?!e'E?FжU?Λ7 U럃F9J RX0JYkpcGֵGd, %[x>CN`\`XPK2>/fQ$̥qo,NuI lEŘmFN9'M ֍{5iAv6 J %av)'+=*_]k׌9R1 .r:+ּePj=FBS^\ѥD$F~ơ5M*$*$M!DIOzQf[!N:Z_&,G,d~i-^9 hJ8.wB""C:_@w##'2)+xW77s)"Hv| ڑN+Q\ `HAu"jh/<S%}| {k` '{E뭿!lATRtaP5X>QĪ" J!l3QM9;\u-&뱺Ll(hP33L:u0q٤s6 g(IhONp!tx8n6#}83#J;ĺEjAs:3nDA,oܱžw쨲d쟟_|9?8:;:zGD[ZkIvic>s,<ҏXN(A ɵ`Ls!Nw9uB~%Ov'z VwʖXO7?*Rzt3kR4Xhf7]O, fS4H*€k=9C +DX'_|HZb1i#Ʉx pd;Q\kf'2\7򲋇Y y*P^*?ri9fM{5Y`:D[pKUZi2]:H\H<8|?dl9Ž'$$, sT.Z&qBRΝlvvE` ۃi-b@.a\/=냗51x\(S_IJ&VZ)\.-N-pyޢJ9SZC|!8(1j:PFT.Qfj|SKQzO۫?5$s8{5ƈޫ5A;Ta2iJ &].&HLgN;H3RL31J_9ՐmJcO }9_N8H4>i4g].9X/'rD>| _^| +$gxk'͍X;9 :AL40eO 3LY S%/WW3+,0䉠35d !.7nlO@A4H̓sHZ$ 1G fpJ%&GsdOh(Jœ2R%8(錙 0lj;  !f k"R`oI  zY0F\GcFc.LoYma߽Om%cnК4Ôd:?0H"74ct)hfXWׁדQb.v7*_,4sش6 DFNrPtO//Mq]2OMQ"4no]A0̓ҐuQ{U F|1XZtNrsBu.GX=k e&.K袙K=ZImEst.TDH dJ!1KÑAZO;jq˾B Lm(ڼMds,yn 8F$W$K؍nLrFCPOŸ́(3]3:|[hjAU*m0OFkfv/uѬA'bWD8?l+/~jA,m':sI?C[TLU!כR5p,[éZmc7b+,h\8W@jgT6dJEM;b1^*N`G:,"v[Xf.:'ѣ,]aa dSЀ<|g L1&̬0FH(Ux #;E#mYѻ#pp MMnbm )Xw@Q5x;pP a2PK!0K>֪˄KIY9,*& fO&VxK/xA׶=ZOXIŠA򷂌/+:,v1^Ȃ2Na4%fI Qo[0ŵ^?Lٹַ<²gJS'lԜGe3t31==S  `Cbaz[.rZnBYz?aԀPkÏȂem-cIf[~iAj;?"c(G'^pl+S]>+*N%Da%˕&5oiҙ%Aǔޭ\hӋ_1bggk\x(9QǐnӒ>qkE>]IjMKj^(}0h掋2L-'F)ӧ&>|ŋv1WcQ{ɗv uAy|Eɠe$ezx 镠v Z)[sVH49'4}akE-26LkGcD vܵ6 7n`UhguP)$dqCUݖKbXG+tsbȰG `,-+A\ox \|A}@h`c7ٳZ,ajj0oDaM^%d*z8f%ioiI)~ y>F na"sE2j/M"j\^Jvr+"0#BY˶ M4GW}{ӛNkno;բUQ^W<Q,(Ljl72xڵ5}V™tCG3f,~MxJK