UCSF banner
Search Results
Initial search took 0 second(s).
Beginning : #1 Hits: 100 Display:   per page=

Download: Show Detail?
Done
ZINC ID
Supplier information; Representations
Properties:xLogP, ap & p desolvation, HBD,HBA,Charge,Mwt,NRB
Annotations; Similarity
Structure

Click for quick 3D display
98175599
 
#1

Synchem UG and Co KG: cdp234de1
SureChEMBL: SCHEMBL8847160
ref: mol2, SDF, SMILES, flexibase
-4.62,-5.24,-96.42,0,7,-2, 237.214, 2
59292444
 
#2

Synchem UG and Co KG: un212vp2de1
PubChem: 15731611
lo: mol2, SDF, SMILES, flexibase
-0.28,0.12,-13.85,2,5,0, 118.092, 2
98175598
 
#3

Synchem UG and Co KG: wh228
ref: mol2, SDF, SMILES, flexibase
3.24,9.9,-13.78,1,6,0, 369.417, 4
mid: mol2, SDF, SMILES, flexibase
2.87,8.67,-48.57,0,6,-1, 368.409, 2
98175597
 
#4

Synchem UG and Co KG: wh228
ref: mol2, SDF, SMILES, flexibase
3.24,9.9,-13.1,1,6,0, 369.417, 4
mid: mol2, SDF, SMILES, flexibase
2.87,8.72,-47.36,0,6,-1, 368.409, 2
98175596
 
#5

Synchem UG and Co KG: wh227
ref: mol2, SDF, SMILES, flexibase
-0.86,4.43,-38.04,1,10,-1, 330.28, 2
98175595
 
#6

Synchem UG and Co KG: wh225
ref: mol2, SDF, SMILES, flexibase
3.01,10.16,-18.67,1,7,0, 363.373, 6
98175594
 
#7

Synchem UG and Co KG: wh224
ref: mol2, SDF, SMILES, flexibase
0.96,1.68,-12.81,3,8,0, 252.23, 5
24545267
 
#8

Synchem UG and Co KG: wh214
PubChem: 12235701
ref: mol2, SDF, SMILES, flexibase
2.87,5.37,-11.36,0,3,0, 234.324, 3
98175593
 
#9

Synchem UG and Co KG: wh213
ref: mol2, SDF, SMILES, flexibase
2.47,8.23,-8.94,1,4,0, 291.372, 5
28538982
 
#10

Synchem UG and Co KG: wh212
ref: mol2, SDF, SMILES, flexibase
1.88,6.58,-7.8,1,4,0, 257.355, 5
98175592
 
#11

Synchem UG and Co KG: wh210
ref: mol2, SDF, SMILES, flexibase
2.05,2.39,-4.46,1,4,0, 254.355, 2
98175591
 
#12

Synchem UG and Co KG: wh210
ref: mol2, SDF, SMILES, flexibase
2.05,2.06,-4.66,1,4,0, 254.355, 2
98175590
 
#13

Synchem UG and Co KG: wh210
ref: mol2, SDF, SMILES, flexibase
2.05,2.08,-4.3,1,4,0, 254.355, 2
98175589
 
#14

Synchem UG and Co KG: wh210
ref: mol2, SDF, SMILES, flexibase
2.05,2,-4.64,1,4,0, 254.355, 2
98175588
 
#15

Synchem UG and Co KG: rp289de1
ref: mol2, SDF, SMILES, flexibase
0.59,1,-43.73,1,4,-1, 163.156, 0
98175587
 
#16

Synchem UG and Co KG: dna307de9
ref: mol2, SDF, SMILES, flexibase
3.61,7.38,-9.33,0,1,0, 232.08, 0
39331389
 
#17

Synchem UG and Co KG: dna307de6
SureChEMBL: SCHEMBL1383189
ref: mol2, SDF, SMILES, flexibase
2.47,4.24,-11.38,2,3,0, 201.225, 2

Similar to: 2647455,
98175586
 
#18

Synchem UG and Co KG: dna307de5
SureChEMBL: SCHEMBL607844
ref: mol2, SDF, SMILES, flexibase
2.68,4.07,-10.66,2,2,0, 250.095, 1
98175585
 
#19

Synchem UG and Co KG: dna307de2
SureChEMBL: SCHEMBL14060956
ref: mol2, SDF, SMILES, flexibase
1.11,3.61,-9.08,2,2,0, 189.189, 1
79132111
 
#20

Synchem UG and Co KG: un372
IBM Patent Data: 135741988
PubChem: 56982137
SureChEMBL: SCHEMBL1064674, SCHEMBL4383794
ref: mol2, SDF, SMILES, flexibase
5.06,10.42,-51.67,0,0,-1, 233.315, 0
mid: mol2, SDF, SMILES, flexibase
5.06,9.89,-6.94,0,0,0, 234.323, 0
98175584
 
#21

Synchem UG and Co KG: bc025vp1de7
SureChEMBL: SCHEMBL5954099, SCHEMBL5215991
ref: mol2, SDF, SMILES, flexibase
2.03,3.98,-4.22,2,2,0, 188.152, 2
98175583
 
#22

Synchem UG and Co KG: bc025vp1de6
ref: mol2, SDF, SMILES, flexibase
1.12,3.48,-7.27,2,3,0, 171.203, 1
98175582
 
#23

Synchem UG and Co KG: bc025vp1de5
ref: mol2, SDF, SMILES, flexibase
1.41,3.1,-5.3,2,2,0, 156.135, 1
38404008
 
#24

Synchem UG and Co KG: bc025vp1de4
ref: mol2, SDF, SMILES, flexibase
2.06,3.64,-2.93,2,2,0, 217.041, 1

Similar to: 7277661,
98175581
 
#25

Synchem UG and Co KG: bc025vp1de3
SureChEMBL: SCHEMBL3631739, SCHEMBL9673071
ref: mol2, SDF, SMILES, flexibase
0.19,-1.93,-7.39,4,4,0, 152.153, 1
34771208
 
#26

Synchem UG and Co KG: bc025vp1de2
SureChEMBL: SCHEMBL4162111
ref: mol2, SDF, SMILES, flexibase
0.50,0.12,-7.72,3,4,0, 166.18, 2
98175580
 
#27

Synchem UG and Co KG: bc025vp1de1
ref: mol2, SDF, SMILES, flexibase
0.50,0.12,-7.06,3,4,0, 166.18, 2
98175579
 
#28

Synchem UG and Co KG: wh081de9
SureChEMBL: SCHEMBL6683798
ref: mol2, SDF, SMILES, flexibase
-0.19,1.72,-9.9,0,4,0, 136.11, 2
98175578
 
#29

Synchem UG and Co KG: wh081de7
ref: mol2, SDF, SMILES, flexibase
0.45,2.54,-11.89,0,3,0, 141.151, 2
5359988
 
#30

Synchem UG and Co KG: wh081de6
IBM Patent Data: 136294094
PubChem: 167604
SureChEMBL: SCHEMBL10896623, SCHEMBL2408997
Enamine BB Make on Demand: BBV-41852710...7 total

ref: mol2, SDF, SMILES, flexibase
0.96,4.36,-11.15,0,2,0, 114.144, 3

Similar to: 1716800, 2041126, 1482107, 1587723, ... 4 in total.
39465
 
#31

Anward: ANW-68175
Ark Pharm Building Blocks: AK-80651
BePharm Building Blocks: B237027
Chembo Pharma: KB-246644
Chemstep: 20025...16 total

ref: mol2, SDF, SMILES, flexibase
0.06,-3.87,-101.71,1,5,-2, 140.098, 0
mid: mol2, SDF, SMILES, flexibase
-0.40,-2.11,-30.98,2,5,-1, 141.106, 0

Similar to: 34329719,
98175577
 
#32

Synchem UG and Co KG: ct051vp1fp2de16
ref: mol2, SDF, SMILES, flexibase
2.74,6.28,-4.17,0,2,0, 192.306, 3
mid: mol2, SDF, SMILES, flexibase
2.74,6.75,-26.83,1,2,1, 193.314, 3
98175576
 
#33

Synchem UG and Co KG: ct051vp1fp2de14
SureChEMBL: SCHEMBL14041781
ref: mol2, SDF, SMILES, flexibase
2.15,5.64,-4.42,0,2,0, 164.252, 3
mid: mol2, SDF, SMILES, flexibase
2.15,6.11,-26.82,1,2,1, 165.26, 3
98175575
 
#34

Synchem UG and Co KG: ct051vp1fp2de13
ref: mol2, SDF, SMILES, flexibase
1.53,2.97,-4.37,1,2,0, 136.198, 2
mid: mol2, SDF, SMILES, flexibase
1.53,3.44,-26.93,2,2,1, 137.206, 2
98175574
 
#35

Synchem UG and Co KG: ct051vp1fp2de11
ref: mol2, SDF, SMILES, flexibase
2.37,6.25,-4.21,0,2,0, 192.306, 3
mid: mol2, SDF, SMILES, flexibase
2.37,6.68,-25.23,1,2,1, 193.314, 3
98175573
 
#36

Synchem UG and Co KG: ct051vp1fp2de9
SureChEMBL: SCHEMBL13942706
ref: mol2, SDF, SMILES, flexibase
1.77,5.61,-4.6,0,2,0, 164.252, 3
mid: mol2, SDF, SMILES, flexibase
1.77,6.04,-25.31,1,2,1, 165.26, 3
98175572
 
#37

Synchem UG and Co KG: ct051vp1fp2de8
SureChEMBL: SCHEMBL3632606
ref: mol2, SDF, SMILES, flexibase
1.15,2.94,-4.59,1,2,0, 136.198, 2
mid: mol2, SDF, SMILES, flexibase
1.15,3.38,-25.85,2,2,1, 137.206, 2
39207881
 
#38

Synchem UG and Co KG: ct051vp1fp2de7
SureChEMBL: SCHEMBL2304520
ref: mol2, SDF, SMILES, flexibase
1.02,3.7,-4.97,0,2,0, 136.198, 1
mid: mol2, SDF, SMILES, flexibase
1.02,4.13,-25.83,1,2,1, 137.206, 1
98175571
 
#39

Synchem UG and Co KG: ct051vp1fp2de5
ref: mol2, SDF, SMILES, flexibase
2.69,6.79,-2.97,0,2,0, 192.306, 3
mid: mol2, SDF, SMILES, flexibase
2.69,7.25,-28.4,1,2,1, 193.314, 3
98175570
 
#40

Synchem UG and Co KG: ct051vp1fp2de3
SureChEMBL: SCHEMBL8320974
ref: mol2, SDF, SMILES, flexibase
2.10,6.25,-3.24,0,2,0, 164.252, 3
mid: mol2, SDF, SMILES, flexibase
2.10,6.71,-28.74,1,2,1, 165.26, 3
98175569
 
#41

Synchem UG and Co KG: ct051vp1fp2de1
SureChEMBL: SCHEMBL8128310
ref: mol2, SDF, SMILES, flexibase
1.34,4.58,-3.71,0,2,0, 136.198, 1
mid: mol2, SDF, SMILES, flexibase
1.34,5.03,-29.24,1,2,1, 137.206, 1
98175568
 
#42

Synchem UG and Co KG: dap038
ref: mol2, SDF, SMILES, flexibase
0.94,0.35,-27.56,5,3,1, 203.063, 0
mid: mol2, SDF, SMILES, flexibase
0.94,-0.06,-4.84,4,3,0, 202.055, 0
98175567
 
#43

Synchem UG and Co KG: nap003
ref: mol2, SDF, SMILES, flexibase
1.41,2.7,-3.9,2,5,0, 232.037, 1
98175566
 
#44

Synchem UG and Co KG: nap001
SureChEMBL: SCHEMBL15371478
ref: mol2, SDF, SMILES, flexibase
-0.21,2.24,-35.47,2,7,-1, 182.115, 2
lo: mol2, SDF, SMILES, flexibase
-0.21,2.7,-39.63,3,7,0, 183.123, 2
98175565
 
#45

Synchem UG and Co KG: bc431
ref: mol2, SDF, SMILES, flexibase
5.52,14.48,-45.17,2,4,1, 476.591, 7
hi: mol2, SDF, SMILES, flexibase
5.52,12.22,-9.72,1,4,0, 475.583, 7
98175564
 
#46

Synchem UG and Co KG: bc431
ref: mol2, SDF, SMILES, flexibase
5.52,14.47,-45.26,2,4,1, 476.591, 7
hi: mol2, SDF, SMILES, flexibase
5.52,12.22,-9.43,1,4,0, 475.583, 7
98175563
 
#47

Synchem UG and Co KG: dna332de13
ref: mol2, SDF, SMILES, flexibase
1.61,4.02,-42.75,0,3,-1, 365.022, 1
98175562
 
#48

Synchem UG and Co KG: dna332de12
ref: mol2, SDF, SMILES, flexibase
1.02,2.9,-38.81,2,4,-1, 380.037, 1
98175561
 
#49

Synchem UG and Co KG: dna332de11
ref: mol2, SDF, SMILES, flexibase
1.61,4.26,-46.67,0,3,-1, 365.022, 1
98175560
 
#50

Synchem UG and Co KG: dna332de10
ref: mol2, SDF, SMILES, flexibase
1.02,2.31,-49.1,2,4,-1, 380.037, 1
98175559
 
#51

Synchem UG and Co KG: dna332de9
ref: mol2, SDF, SMILES, flexibase
1.64,3.98,-39.76,0,3,-1, 365.022, 1
98175558
 
#52

Synchem UG and Co KG: dna332de8
SureChEMBL: SCHEMBL11805749
ref: mol2, SDF, SMILES, flexibase
1.05,2.03,-40.06,2,4,-1, 380.037, 1
98175557
 
#53

Synchem UG and Co KG: dna332de7
ref: mol2, SDF, SMILES, flexibase
1.64,3.98,-43.09,0,3,-1, 365.022, 1
98175556
 
#54

Synchem UG and Co KG: dna332de6
ref: mol2, SDF, SMILES, flexibase
1.05,2.03,-44.36,2,4,-1, 380.037, 1
98175555
 
#55

Synchem UG and Co KG: dna332de4
ref: mol2, SDF, SMILES, flexibase
0.85,3.5,-47.49,0,3,-1, 286.126, 1
98175554
 
#56

Synchem UG and Co KG: bc421
ref: mol2, SDF, SMILES, flexibase
2.27,5.45,-11.42,3,5,0, 357.211, 4
lo: mol2, SDF, SMILES, flexibase
2.27,5.7,-52.18,4,5,1, 358.219, 4
98175553
 
#57

Synchem UG and Co KG: ct044fp2de26
SureChEMBL: SCHEMBL14317797
ref: mol2, SDF, SMILES, flexibase
-0.22,-1.71,-10.54,2,4,0, 172.209, 1
98175552
 
#58

Synchem UG and Co KG: ct044fp2de24
ref: mol2, SDF, SMILES, flexibase
0.38,-1.15,-10.88,2,4,0, 186.236, 1
98175551
 
#59

Synchem UG and Co KG: ct044fp2de23
ref: mol2, SDF, SMILES, flexibase
0.37,-1.08,-11,2,4,0, 186.236, 1
98175550
 
#60

Synchem UG and Co KG: ct044fp2de22
ref: mol2, SDF, SMILES, flexibase
0.21,-0.95,-10.29,2,4,0, 186.236, 1
98175549
 
#61

Synchem UG and Co KG: ct044fp2de21
SureChEMBL: SCHEMBL14247786, SCHEMBL2227362
ref: mol2, SDF, SMILES, flexibase
-0.22,-1.64,-10.48,2,4,0, 172.209, 1
98175548
 
#62

Synchem UG and Co KG: ct044fp2de19
ref: mol2, SDF, SMILES, flexibase
0.38,-0.99,-11.34,2,4,0, 186.236, 1
98175547
 
#63

Synchem UG and Co KG: ct044fp2de18
ref: mol2, SDF, SMILES, flexibase
-0.16,-0.98,-10.65,2,4,0, 186.236, 1
98175546
 
#64

Synchem UG and Co KG: ct044fp2de15
SureChEMBL: SCHEMBL6501463
ref: mol2, SDF, SMILES, flexibase
0.92,-2.01,-10.71,2,4,0, 192.627, 1
98175545
 
#65

Synchem UG and Co KG: bc409
ref: mol2, SDF, SMILES, flexibase
5.94,16.36,-8.13,0,4,0, 350.51, 6
mid: mol2, SDF, SMILES, flexibase
5.94,16.83,-24.15,1,4,1, 351.518, 6
98175544
 
#66

Synchem UG and Co KG: un359
SureChEMBL: SCHEMBL12110662
ref: mol2, SDF, SMILES, flexibase
3.62,10.44,-7.97,0,2,0, 249.313, 4
98175543
 
#67

Synchem UG and Co KG: un357
SureChEMBL: SCHEMBL15011167
ref: mol2, SDF, SMILES, flexibase
3.21,8.32,-6.25,0,1,0, 220.337, 2
98175542
 
#68

Synchem UG and Co KG: un357
SureChEMBL: SCHEMBL15011167
ref: mol2, SDF, SMILES, flexibase
3.21,8.32,-6.24,0,1,0, 220.337, 2
98175541
 
#69

Synchem UG and Co KG: un356
SureChEMBL: SCHEMBL14389907
ref: mol2, SDF, SMILES, flexibase
1.87,4.42,-9.92,1,7,0, 278.264, 1
34486011
 
#70

Synchem UG and Co KG: un355
SureChEMBL: SCHEMBL1914096, SCHEMBL1914092
ref: mol2, SDF, SMILES, flexibase
2.64,6.06,-7.22,0,3,0, 256.099, 4
98175540
 
#71

Synchem UG and Co KG: un354
SureChEMBL: SCHEMBL14785152
ref: mol2, SDF, SMILES, flexibase
1.71,2.15,-7.82,1,4,0, 246.69, 7
98175539
 
#72

Synchem UG and Co KG: un353
SureChEMBL: SCHEMBL98804
ref: mol2, SDF, SMILES, flexibase
6.04,13.74,-43.6,3,1,1, 376.589, 10
98175538
 
#73

Synchem UG and Co KG: un352
SureChEMBL: SCHEMBL4205964
ref: mol2, SDF, SMILES, flexibase
3.81,4.72,-26.47,4,4,1, 266.752, 2
mid: mol2, SDF, SMILES, flexibase
3.81,4.73,-8.99,3,4,0, 265.744, 2
hi: mol2, SDF, SMILES, flexibase
3.81,5.5,-41.41,2,4,-1, 264.736, 2
98175537
 
#74

Synchem UG and Co KG: un351
SureChEMBL: SCHEMBL14637963
ref: mol2, SDF, SMILES, flexibase
3.96,6.81,-6.78,1,2,0, 243.709, 2
98175536
 
#75

Synchem UG and Co KG: un350
SureChEMBL: SCHEMBL1422341
ref: mol2, SDF, SMILES, flexibase
1.42,3.51,-42.76,0,5,-1, 256.303, 6
lo: mol2, SDF, SMILES, flexibase
1.42,3.34,-13.94,1,5,0, 257.311, 6
98175535
 
#76

Synchem UG and Co KG: un349
ref: mol2, SDF, SMILES, flexibase
1.83,8.08,-13.4,0,6,0, 250.254, 5
98175534
 
#77

Synchem UG and Co KG: un349
ref: mol2, SDF, SMILES, flexibase
1.83,8.08,-9.52,0,6,0, 250.254, 5
98175533
 
#78

Synchem UG and Co KG: un348
SureChEMBL: SCHEMBL7930745
ref: mol2, SDF, SMILES, flexibase
2.74,6.11,-8.05,1,5,0, 279.336, 6
98175532
 
#79

Synchem UG and Co KG: un346
ref: mol2, SDF, SMILES, flexibase
4.75,8.76,-6.77,0,2,0, 299.128, 4
39627081
 
#80

Angene Building Blocks: AGN-PC-0W2OLT
Ark Pharm Building Blocks: AK119632
Chembo Pharma: KB-241778
Ryan Scientific BB (Depleted): 087-08963
Synchem UG and Co KG: hw016a...8 total

ref: mol2, SDF, SMILES, flexibase
4.52,11.04,-16.18,0,7,0, 421.906, 6
98175531
 
#81

Synchem UG and Co KG: cdp236vp3de8
SureChEMBL: SCHEMBL3214901
ref: mol2, SDF, SMILES, flexibase
2.29,1.29,-37.52,0,5,-1, 252.431, 1
lo: mol2, SDF, SMILES, flexibase
1.83,4.03,-17.04,1,5,0, 253.439, 1
32191127
 
#82

Molport BB: MolPort-038-289-787
Synchem UG and Co KG: cdp183de5
SureChEMBL: SCHEMBL2585062, SCHEMBL2963596
ref: mol2, SDF, SMILES, flexibase
0.55,4.86,-45.54,0,5,-1, 194.166, 4

Similar to: 34249404, 34441475, 34601504, 42685597, ... 11 in total.
98175530
 
#83

Synchem UG and Co KG: cdp183de3
ref: mol2, SDF, SMILES, flexibase
0.74,5.09,-41.89,0,9,-1, 212.097, 3
98175529
 
#84

Synchem UG and Co KG: cdp183de2
ref: mol2, SDF, SMILES, flexibase
0.92,4.54,-51.18,0,3,-1, 170.575, 2
98175528
 
#85

Synchem UG and Co KG: cdp183de1
ref: mol2, SDF, SMILES, flexibase
2.23,5.81,-46.99,0,3,-1, 239.465, 2
32173983
 
#86

Synchem UG and Co KG: cdp263fp1de32
ref: mol2, SDF, SMILES, flexibase
0.78,5.36,-17.47,0,6,0, 182.135, 3
98175527
 
#87

Synchem UG and Co KG: cdp263fp1de24
ref: mol2, SDF, SMILES, flexibase
1.25,3.54,-9.95,0,4,0, 181.191, 4
98175526
 
#88

Synchem UG and Co KG: cdp263fp1de17
ref: mol2, SDF, SMILES, flexibase
2.06,4.45,-6.06,0,3,0, 185.61, 2
98175525
 
#89

Synchem UG and Co KG: cdp263fp1de13
SureChEMBL: SCHEMBL11041168
ref: mol2, SDF, SMILES, flexibase
2.56,6.74,-7.55,0,3,0, 213.236, 3
98175524
 
#90

Synchem UG and Co KG: a007de1de11
SureChEMBL: SCHEMBL131465, SCHEMBL131464
ref: mol2, SDF, SMILES, flexibase
1.87,2.88,-5.01,0,2,0, 137.182, 2
98175523
 
#91

Synchem UG and Co KG: a007de1de10
ref: mol2, SDF, SMILES, flexibase
1.29,1.63,-29.72,3,4,1, 183.231, 4
hi: mol2, SDF, SMILES, flexibase
1.29,1.18,-5.03,2,4,0, 182.223, 4
98175522
 
#92

Synchem UG and Co KG: a007de1de8
SureChEMBL: SCHEMBL130178, SCHEMBL130177, SCHEMBL3116672
ref: mol2, SDF, SMILES, flexibase
1.92,2.79,-4.72,0,2,0, 137.182, 2
39203135
 
#93

Synchem UG and Co KG: a007de1de5
SureChEMBL: SCHEMBL1697616, SCHEMBL2069142
ref: mol2, SDF, SMILES, flexibase
1.86,2.98,-7.22,0,3,0, 167.208, 4
98175521
 
#94

Synchem UG and Co KG: cdp082de2de1
SureChEMBL: SCHEMBL1171022
ref: mol2, SDF, SMILES, flexibase
-0.20,4.84,-192.12,0,7,-3, 208.105, 3
lo: mol2, SDF, SMILES, flexibase
-0.20,5.24,-113.34,1,7,-2, 209.113, 3
98175520
 
#95

Synchem UG and Co KG: abp022
ref: mol2, SDF, SMILES, flexibase
1.92,2.95,-4.32,2,3,0, 276.919, 0
98175519
 
#96

Synchem UG and Co KG: acp032
SureChEMBL: SCHEMBL6115978
ref: mol2, SDF, SMILES, flexibase
1.66,2.79,-4.64,2,3,0, 188.017, 0
98175518
 
#97

Synchem UG and Co KG: acp031
ref: mol2, SDF, SMILES, flexibase
1.05,2.28,-5.69,2,3,0, 153.572, 0
98175517
 
#98

Synchem UG and Co KG: acp029
ref: mol2, SDF, SMILES, flexibase
3.11,3.47,-3.42,2,2,0, 231.004, 1
98175516
 
#99

Synchem UG and Co KG: acp026
ref: mol2, SDF, SMILES, flexibase
2.48,3.16,-2.62,2,2,0, 221.485, 0
98175515
 
#100

Synchem UG and Co KG: acp024
ref: mol2, SDF, SMILES, flexibase
2.77,3.82,-2.45,2,2,0, 191.061, 1

Old detail retrieval took 2 seconds.

start 0 size 100

select distinct(s.sub_id),s.smiles from substance s, catalog_item ci, catalog c where s.sub_id = ci.sub_id_fk and ci.cat_id_fk = c.cat_id and c.free=1 and ( c.cat_id = 246 ) limit 0,100

Smiles were