-
Notifications
You must be signed in to change notification settings - Fork 1
/
Copy pathbudha-query.sql
14 lines (11 loc) · 13.2 KB
/
budha-query.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
#select * from prodotti as p where p.`id`=2321
#SELECT * FROM `prodotti_dimensioni` AS pd WHERE pd.`id_prodotto`=2321
SELECT pse.`sku`, p.`prezzo` AS 'old_price', pd.b_S AS 'base_small', pd.h_S AS 'height_small', pd.`p_S` AS 'price_small',
pd.b_M AS 'base_medium',
pd.h_M AS 'height_medium' , pd.`p_M` AS 'price_medium', pd.b_L AS 'base_large', pd.h_L AS 'height_large', pd.p_L AS 'price_large'
FROM prodotti_sku_ean AS pse
INNER JOIN prodotti AS p ON pse.`id_prodotto` = p.`id`
INNER JOIN `prodotti_dimensioni` AS pd ON pd.`id_prodotto` = p.`id`
WHERE (NOT (pd.`b_L` <=> NULL) OR NOT (pd.`b_M` <=> NULL) OR NOT (pd.`b_S` <=> NULL)) AND
pse.`sku` REGEXP 'Wall0001090|Wall0001091|Wall0002143|Wall0002151|Wall0002152|Wall0002154|Wall0002155|Wall0002156|Wall0002169|Wall0002171|Wall0002173|Wall0002174|Wall0002175|Wall0002204|Wall0002262|Wall0002427|Wall0002429|Wall0002430|Wall0002432|Wall0002433|Wall0002435|Wall0002437|Wall0002438|Wall0002440|Wall0001036|Wall0001038|Wall0001039|Wall0001040|Wall0001050|Wall0001054|Wall0002032|Wall0002034|Wall0002614|Wall0002740|Wall0002742|Wall0001037|Charlie|Wall0000651|Coco|Wall0000699|Buddha|AALav0000797|AALav0000798|AALav0000799|AALav0000800|AALav0000801|AAFlu0000818|AAFlu0000819|AALav0000877|Wall0000880|Wall0000881|Wall0000882|Wall0000886|Wall0000887|Wall0000888|Wall0000889|Wall0000890|Wall0000891|Wall0000892|Wall0000893|Wall0000894|Wall0000895|Wall0000900|Wall0000901|Wall0000904|Wall0000907|Wall0000919|Wall0000929|Wall0000936|Wall0000939|Wall0001046|Wall0001047|Wall0001048|Wall0001049|Wall0001051|Wall0001052|Wall0001053|Wall0001064|Wall0001072|Wall0001080|Wall0001081|Wall0001082|Wall0001083|Wall0001084|Wall0001085|Wall0001086|Wall0001087|Wall0001088|Wall0001089|Wall0001122|Wall0001125|Wall0001126|Wall0001127|Wall0001128|Wall0001129|Wall0001130|Wall0001132|Wall0001134|Wall0001135|Wall0001137|Wall0001138|Wall0001139|Wall0001140|Wall0001141|Wall0001142|Wall0001143|Wall0001144|Wall0001145|Wall0001146|Wall0001147|Wall0001148|Wall0001149|Wall0001150|Wall0001151|Wall0001152|Wall0001153|Wall0001154|Wall0001155|Wall0001156|Wall0001158|Wall0001160|Wall0001162|Wall0001164|Wall0001165|Wall0001167|Wall0001168|Wall0001169|Wall0001170|Wall0001171|Wall0001176|Wall0001177|Wall0001178|Wall0001179|Wall0001183|Wall0001186|Wall0001187|AALav0001208|AALav0001209|AALav0001210|AALav0001211|AALav0001212|AALav0001213|Wall0001214|Wall0001224|Wall0001225|Wall0001227|Wall0001230|Wall0001271|Wall0001273|Wall0001289|Wall0001291|Wall0001297|Wall0001302|Wall0001303|Wall0001304|Wall0001305|Wall0001306|Wall0001307|Wall0001308|Wall0001309|Wall0001310|Wall0001312|AALav0001313|AALav0001314|AALav0001315|AALav0001316|AALav0001317|AALav0001318|AALav0001319|AALav0001320|AALav0001321|AALav0001322|AALav0001323|AALav0001324|AALav0001325|AALav0001326|AALav0001327|AALav0001328|Wall0001331|Wall0001332|Wall0001334|Wall0001354|Wall0001355|Wall0001356|Wall0001357|Wall0001358|Wall0001359|Wall0001360|Wall0001390|Wall0001394|Wall0001410|AALav0001411|Wall0001415|Wall0001418|Wall0001420|Wall0001421|Wall0001423|Wall0001424|Wall0001425|Wall0001426|Wall0001449|Wall0001450|Wall0001451|Wall0001454|Wall0001465|Wall0001467|Wall0001468|Wall0001469|Wall0001470|Wall0001471|Wall0001475|Wall0001476|Wall0001477|Wall0001497|Wall0001585|Wall0001587|Wall0001588|Wall0001589|Wall0001590|Wall0001591|Wall0001592|Wall0001593|Wall0001594|Wall0001595|Wall0001596|Wall0001597|Wall0001598|Wall0001599|Wall0001600|Wall0001601|Wall0001602|Wall0001603|Wall0001604|Wall0001605|Wall0001606|Wall0001607|Wall0001608|Wall0001609|Wall0001610|Wall0001611|Wall0001612|Wall0001613|Wall0001614|Wall0001615|Wall0001616|Wall0001617|Wall0001618|Wall0001619|Wall0001620|Wall0001621|Wall0001622|Wall0001623|Wall0001624|Wall0001625|Wall0001626|Wall0001627|Wall0001628|Wall0001629|Wall0001630|Wall0001631|Wall0001632|Wall0001633|Wall0001634|Wall0001635|Wall0001636|Wall0001637|Wall0001638|Wall0001639|Wall0001640|Wall0001641|Wall0001642|Wall0001643|Wall0001644|Wall0001645|Wall0001646|Wall0001647|Wall0001648|Wall0001650|Wall0001651|Wall0001652|Wall0001653|Wall0001654|Wall0001655|Wall0001656|Wall0001657|Wall0001658|Wall0001659|Wall0001660|Wall0001661|Wall0001662|Wall0001663|Wall0001664|Wall0001665|Wall0001666|Wall0001667|Wall0001668|Wall0001669|Wall0001670|Wall0001671|Wall0001672|Wall0001673|Wall0001674|Wall0001675|Wall0001676|Wall0001677|Wall0001678|Wall0001679|Wall0001680|Wall0001681|Wall0001682|Wall0001683|Wall0001684|Wall0001685|Wall0001686|Wall0001687|Wall0001688|Wall0001689|Wall0001690|Wall0001691|Wall0001692|Wall0001693|Wall0001694|Wall0001695|Wall0001696|Wall0001697|Wall0001698|Wall0001699|Wall0001700|Wall0001701|Wall0001702|Wall0001703|Wall0001704|Wall0001705|Wall0001706|Wall0001707|Wall0001708|Wall0001709|Wall0001710|Wall0001711|Wall0001712|Wall0001713|Wall0001714|Wall0001715|Wall0001716|Wall0001717|Wall0001718|Wall0001719|Wall0001720|Wall0001722|Wall0001723|Wall0001724|Wall0001725|Wall0001726|Wall0001727|Wall0001728|Wall0001729|Wall0001730|Wall0001731|Wall0001732|Wall0001733|Wall0001734|Wall0001735|Wall0001736|Wall0001737|Wall0001738|Wall0001739|Wall0001740|Wall0001741|Wall0001742|Wall0001743|Wall0001744|Wall0001745|Wall0001746|Wall0001747|Wall0001748|Wall0001749|Wall0001750|Wall0001751|Wall0001752|Wall0001753|Wall0001754|Wall0001755|Wall0001756|Wall0001757|Wall0001758|Wall0001759|Wall0001760|Wall0001761|Wall0001762|Wall0001763|Wall0001764|Wall0001765|Wall0001775|Wall0001793|Wall0001794|Wall0001795|Wall0001796|Wall0001797|Wall0001798|Wall0001799|Wall0001800|Wall0001801|Wall0001802|Wall0001803|Wall0001804|Wall0001805|Wall0001806|Wall0001807|Wall0001808|Wall0001809|Wall0001811|Wall0001812|Wall0001813|Wall0001814|Wall0001815|Wall0001816|Wall0001817|Wall0001818|Wall0001819|Wall0001820|Wall0001822|Wall0001823|Wall0001824|Wall0001825|Wall0001826|Wall0001827|Wall0001828|Wall0001829|Wall0001830|Wall0001831|Wall0001832|Wall0001835|Wall0001836|Wall0001837|Wall0001838|Wall0001839|Wall0001840|Wall0001841|Wall0001842|Wall0001843|Wall0001844|Wall0001845|Wall0001846|Wall0001848|Wall0001849|Wall0001855|Wall0001856|Wall0001857|Wall0001858|Wall0001859|Wall0001860|Wall0001862|Wall0001863|Wall0001864|Wall0001866|Wall0001867|Wall0001869|Wall0001870|Wall0001871|Wall0001872|Wall0001873|Wall0001874|Wall0001875|Wall0001876|Wall0001877|Wall0001878|Wall0001879|Wall0001880|Wall0001881|Wall0001886|Wall0001887|Wall0001888|Wall0001889|Wall0001891|Wall0001892|Wall0001893|Wall0001894|Wall0001895|Wall0001896|Wall0001897|Wall0001899|Wall0001903|Wall0001904|Wall0001905|Wall0001906|Wall0001907|Wall0001908|Wall0001909|Wall0001910|Wall0001911|Wall0001912|Wall0001913|Wall0001914|Wall0001915|Wall0001916|Wall0001917|Wall0001918|Wall0001919|Wall0001921|Wall0001922|Wall0001923|Wall0001924|Wall0001925|Wall0001926|Wall0001927|Wall0001928|Wall0001929|Wall0001934|Wall0001936|Wall0001955|Wall0001956|Wall0001960|Wall0001965|Wall0001966|Wall0001967|Wall0001968|Wall0001969|Wall0001973|Wall0001974|Wall0001975|Wall0001976|Wall0001977|Wall0001982|Wall0001983|Wall0001984|Wall0001985|Wall0001986|Wall0001987|Wall0001988|Wall0001989|Wall0001992|Wall0001993|Wall0001994|Wall0001995|Wall0001996|Wall0001997|Wall0001998|Wall0001999|Wall0002000|Wall0002001|Wall0002002|Wall0002004|Wall0002005|Wall0002006|Wall0002007|Wall0002008|Wall0002009|Wall0002010|Wall0002012|Wall0002013|Wall0002014|Wall0002015|Wall0002023|Wall0002024|Wall0002025|Wall0002026|Wall0002027|Wall0002029|Wall0002030|Wall0002031|Wall0002033|Wall0002035|Wall0002036|Wall0002037|Wall0002038|Wall0002039|Wall0002040|Wall0002041|Wall0002042|Wall0002043|Wall0002044|Wall0002045|Wall0002046|Wall0002048|Wall0002049|Wall0002050|Wall0002051|Por0002052|Wall0002053|Wall0002055|Wall0002057|Wall0002058|Por0002059|Prt0002059|Por0002060|Wall0002061|Wall0002063|Wall0002064|Wall0002065|Wall0002066|Wall0002067|Wall0002068|Wall0002070|Wall0002071|Wall0002072|Wall0002073|Wall0002074|Wall0002075|Wall0002077|Wall0002078|Wall0002079|Wall0002080|Wall0002081|Wall0002082|Wall0002083|Wall0002084|Wall0002085|Wall0002086|Wall0002087|Wall0002088|Wall0002089|Wall0002090|Wall0002091|Wall0002092|Wall0002093|Wall0002094|Wall0002095|Wall0002096|Wall0002098|Wall0002099|Wall0002100|Wall0002101|Wall0002104|Wall0002105|Wall0002106|Wall0002107|Por0002108|Wall0002109|Wall0002110|Wall0002111|Wall0002112|Wall0002113|Wall0002114|Wall0002115|Wall0002117|Wall0002118|Wall0002119|Wall0002122|Wall0002123|Wall0002124|Wall0002125|Eti0002126|Etic0002127|Etic0002128|Etic0002129|Etic0002130|Etic0002131|Etic0002132|Etic0002133|Etic0002134|Etic0002135|Etic0002136|Etic0002137|Etic0002138|Etic0002139|Wall0002140|Wall0002142|Wall0002153|Wall0002157|Wall0002158|Wall0002160|Wall0002161|Wall0002162|Wall0002163|Wall0002164|Wall0002165|Wall0002166|Wall0002167|Wall0002168|Wall0002170|Wall0002172|Wall0002176|Wall0002177|Wall0002178|Wall0002179|Wall0002182|Wall0002183|Wall0002184|Wall0002185|Wall0002186|Wall0002187|Wall0002189|Wall0002190|Wall0002191|Wall0002192|Wall0002194|Wall0002195|Wall0002196|AALav0002197|Wall0002198|Wall0002199|Etic0002200|Wall0002201|Wall0002202|Wall0002203|Prt0002205|Wall0002206|Wall0002207|Wall0002208|Wall0002209|AALav0002210|Wall0002212|Wall0002213|Wall0002214|Wall0002215|Wall0002217|Wall0002221|Wall0002223|Wall0002224|Wall0002225|Wall0002226|Wall0002227|Wall0002228|Wall0002229|Wall0002230|Wall0002231|Wall0002232|Wall0002233|Wall0002234|Wall0002235|Wall0002236|Wall0002237|Wall0002238|Wall0002239|Wall0002240|Wall0002241|Wall0002242|Wall0002243|Wall0002244|Wall0002245|Wall0002246|Wall0002247|Wall0002248|Wall0002249|Wall0002250|Wall0002251|Wall0002253|Wall0002255|Wall0002258|Wall0002259|AALav0002260|Wall0002263|AAVar0002318|AAVar0002319|AAVar0002320|AAVar0002321|AAVar0002322|AAVar0002323|AAVar0002324|AAVar0002325|AAVar0002326|AAVar0002327|AAVar0002328|AAVar0002329|AAVar0002330|AAVar0002331|AAVar0002332|AAVar0002333|Wall0002345|Wall0002346|AAVar0002356|AAVar0002357|AAVar0002358|AAVar0002359|AAVar0002360|AAVar0002361|AAVar0002362|AAVar0002363|AAVar0002364|AAVar0002365|AAVar0002366|AAVar0002367|AAVar0002368|Wall0002369|Wall0002370|Wall0002374|Wall0002375|Wall0002376|Wall0002382|Wall0002383|Wall0002384|Wall0002385|Wall0002386|Wall0002387|Wall0002388|Wall0002390|Wall0002391|Wall0002392|Wall0002393|Wall0002407|Wall0002408|Wall0002409|Wall0002410|Wall0002413|Wall0002415|Wall0002416|AALav0002421|Wall0002422|Wall0002423|Wall0002424|Wall0002425|Wall0002426|Wall0002441|Wall0002442|Wall0002443|Wall0002444|Wall0002445|Wall0002446|Wall0002447|Wall0002448|Wall0002449|Wall0002450|Wall0002451|Wall0002452|Wall0002453|Wall0002454|Wall0002455|Wall0002456|Wall0002457|Wall0002458|Wall0002463|Wall0002464|AALav0002467|AALav0002469|AALav0002470|AALav0002471|Wall0002473|Wall0002474|Wall0002475|Wall0002476|Wall0002477|Wall0002478|Wall0002479|Wall0002480|Wall0002482|Wall0002487|Wall0002489|Wall0002490|Wall0002491|Wall0002495|Wall0002523|Wall0002524|Wall0002525|Wall0002526|Wall0002527|Wall0002528|Wall0002529|Wall0002530|Wall0002531|Wall0002532|Wall0002534|Wall0002535|Wall0002536|Wall0002537|Wall0002538|Wall0002539|Wall0002540|Wall0002541|Wall0002551|Wall0002552|Wall0002553|Wall0002556|Wall0002564|Wall0002565|Wall0002566|Wall0002567|Wall0002571|Wall0002573|Wall0002576|Wall0002577|Wall0002578|Wall0002579|Wall0002580|Wall0002581|Wall0002582|Wall0002583|Wall0002584|Wall0002585|Wall0002586|Wall0002587|Wall0002588|Wall0002589|Wall0002590|Wall0002591|Wall0002592|Wall0002593|Wall0002594|Wall0002595|Wall0002596|Wall0002597|Wall0002598|Wall0002599|Wall0002604|Wall0002606|Wall0002608|Wall0002611|Wall0002613|Wall0002615|Wall0002616|Wall0002617|Wall0002618|Wall0002621|Wall0002622|Wall0002625|Wall0002634|Wall0002635|Wall0002636|Wall0002637|Wall0002638|Wall0002639|Wall0002640|Wall0002641|Wall0002642|Wall0002643|Wall0002644|Wall0002645|Wall0002646|Wall0002647|Wall0002648|Wall0002649|Wall0002650|Wall0002651|Wall0002652|Wall0002653|Wall0002654|Wall0002655|Wall0002656|Wall0002657|Wall0002658|Wall0002659|Wall0002660|Wall0002662|Wall0002666|Wall0002670|Wall0002673|Wall0002674|Wall0002680|Wall0002681|Wall0002682|Wall0002683|Wall0002684|Wall0002685|Wall0002686|Wall0002687|Wall0002688|Wall0002689|Wall0002690|Wall0002691|Wall0002693|Wall0002694|Wall0002695|Wall0002696|Wall0002697|Wall0002698|Wall0002699|Wall0002700|Wall0002701|Wall0002702|Wall0002703|Wall0002704|Wall0002705|Wall0002706|Wall0002707|Wall0002708|Wall0002709|Wall0002710|Wall0002712|Wall0002713|Wall0002714|Wall0002715|Wall0002716|Wall0002717|Wall0002718|Wall0002719|Wall0002720|Wall0002721|Wall0002722|Wall0002723|Wall0002725|Wall0002726|Wall0002727|Wall0002728|Wall0002729|Wall0002730|Wall0002731|Wall0002732|Wall0002733|Wall0002734|Wall0002735|Wall0002736|Wall0002739|Wall0002744|Wall0002745|Wall0002746|Wall0002747|Wall0002748|Wall0002749|Wall0002750|Wall0002751|Wall0002753|Wall0002754|Wall0002755|Wall0002756|Wall0002757|Wall0002758|Wall0002759|Wall0002760|Wall0002761|Wall0002762|Wall0002763|Wall0002764|Wall0002765|Wall0002766|Wall0002767|Wall0002768|Wall0002771|Wall0002772|Wall0002773|Wall0002774|Wall0002775|Wall0002776|Wall0002777|Wall0002778|Wall0002779|Wall0002783|AALav0002806|Wall0002812|Wall0002835|Wall0002839|Wall0002847|Wall0002851|Wall0002853|Wall0002862|Wall0002863|Wall0002864|Wall0002865|Wall0002866|Wall0002867|Wall0002868|Wall0002869|Wall0002870|Wall0002871|Wall0002872|Wall0002873|Wall0002874|Wall0002875|Wall0002876|Wall0002877|Wall0002878|Wall0002879|Wall0002880|Wall0002881|Wall0002882|Wall0002883|Wall0002884|Wall0002885|Wall0002886|Wall0002887|Wall0002888|Wall0002889|Wall0002890|Wall0003107'
#WHERE pd.`b_L` <> null or pd.`b_M` <> null or pd.`b_S` <> null