SELECT DISTINCT ingredient.product_ID FROM ingredient, recipe, xcart_products WHERE ingredient.recipe_ID = recipe.recipe_ID AND recipe.active = 'yes' AND ingredient.product_ID > 0 AND ingredient.product_ID = xcart_products.productid ORDER BY xcart_products.product ASC
LIST:Array
(
[0] => 3754
[1] => 3450
[2] => 3567
[3] => 3732
[4] => 3755
[5] => 3661
[6] => 3572
[7] => 3655
[8] => 3487
[9] => 3507
[10] => 3474
[11] => 3539
[12] => 3451
[13] => 3531
[14] => 3502
[15] => 3508
[16] => 3586
[17] => 3588
[18] => 3607
[19] => 3505
[20] => 3453
[21] => 3472
[22] => 3642
[23] => 3515
[24] => 3457
[25] => 3506
[26] => 3581
[27] => 3569
[28] => 4008
[29] => 3687
[30] => 3530
[31] => 3733
[32] => 3613
[33] => 3592
[34] => 3751
[35] => 3735
[36] => 3599
[37] => 3608
[38] => 3867
[39] => 4957
[40] => 3520
[41] => 3671
[42] => 3469
[43] => 3636
[44] => 3542
[45] => 3576
[46] => 3752
[47] => 3497
[48] => 3611
[49] => 3573
[50] => 3625
[51] => 3624
[52] => 3499
[53] => 3551
[54] => 3753
[55] => 3658
[56] => 3673
[57] => 3645
[58] => 3870
[59] => 3465
[60] => 3550
[61] => 3940
[62] => 3554
[63] => 3536
[64] => 3640
[65] => 3571
[66] => 3570
[67] => 3822
[68] => 3742
[69] => 3743
[70] => 4919
[71] => 3746
[72] => 3745
[73] => 3747
[74] => 4729
[75] => 3758
[76] => 3748
[77] => 3669
[78] => 3749
[79] => 3834
[80] => 4925
[81] => 4926
[82] => 4916
[83] => 4918
[84] => 4914
[85] => 4920
[86] => 4087
[87] => 3633
[88] => 4109
[89] => 4118
[90] => 3589
[91] => 3537
[92] => 3528
[93] => 3485
[94] => 3563
[95] => 3646
[96] => 3540
[97] => 3663
[98] => 3579
[99] => 3475
[100] => 4100
[101] => 4099
[102] => 3594
[103] => 3545
[104] => 3750
[105] => 3524
[106] => 3675
[107] => 3525
[108] => 4789
[109] => 3686
[110] => 3503
[111] => 3760
[112] => 3761
[113] => 3470
[114] => 3529
[115] => 3559
[116] => 3612
[117] => 3595
[118] => 3566
[119] => 3672
[120] => 3643
[121] => 3654
[122] => 3628
[123] => 3727
[124] => 3738
[125] => 3473
[126] => 3583
[127] => 3605
[128] => 3556
[129] => 3477
[130] => 3560
[131] => 3486
[132] => 3731
[133] => 3452
[134] => 3604
[135] => 3632
[136] => 3681
[137] => 3736
[138] => 3670
[139] => 3960
[140] => 3660
[141] => 3490
[142] => 3513
[143] => 3737
[144] => 3561
[145] => 3466
[146] => 3602
[147] => 3464
[148] => 3591
[149] => 3616
[150] => 3580
[151] => 3462
[152] => 3471
[153] => 3479
[154] => 3674
[155] => 3546
[156] => 3511
[157] => 3562
[158] => 3662
[159] => 3593
[160] => 3549
[161] => 3491
[162] => 3728
[163] => 3679
[164] => 3667
[165] => 3644
[166] => 3500
[167] => 3678
[168] => 3512
[169] => 3685
[170] => 3622
[171] => 3575
[172] => 3496
[173] => 3555
[174] => 3757
[175] => 3957
[176] => 3730
[177] => 3677
[178] => 3481
[179] => 3650
[180] => 3635
[181] => 3538
[182] => 3568
[183] => 3651
[184] => 3526
[185] => 3547
[186] => 3510
[187] => 3578
[188] => 721
[189] => 3501
[190] => 3534
[191] => 3454
[192] => 3484
[193] => 3461
[194] => 3638
[195] => 3986
[196] => 3517
[197] => 3729
[198] => 3701
[199] => 3682
[200] => 3668
[201] => 3615
[202] => 3666
[203] => 3627
[204] => 3656
[205] => 3649
[206] => 3614
[207] => 3590
[208] => 3459
[209] => 3527
[210] => 3598
[211] => 3516
[212] => 3947
[213] => 3460
[214] => 3548
[215] => 3552
[216] => 3480
[217] => 3652
[218] => 3585
[219] => 3522
[220] => 4062
[221] => 3557
[222] => 3478
[223] => 3975
[224] => 3558
[225] => 3498
[226] => 3587
[227] => 3618
[228] => 3637
[229] => 3617
[230] => 3606
[231] => 3844
[232] => 3519
[233] => 3634
[234] => 3603
[235] => 3482
[236] => 3683
[237] => 3564
[238] => 3476
)