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] => 3520
[40] => 3671
[41] => 3469
[42] => 3636
[43] => 3542
[44] => 3576
[45] => 3752
[46] => 3497
[47] => 3611
[48] => 3573
[49] => 3625
[50] => 3624
[51] => 3499
[52] => 3551
[53] => 3753
[54] => 3658
[55] => 3673
[56] => 3645
[57] => 3870
[58] => 3465
[59] => 3550
[60] => 3940
[61] => 3554
[62] => 3536
[63] => 3640
[64] => 3571
[65] => 3570
[66] => 3822
[67] => 3742
[68] => 3743
[69] => 4919
[70] => 3746
[71] => 3745
[72] => 3747
[73] => 4729
[74] => 3758
[75] => 3748
[76] => 3669
[77] => 3749
[78] => 3834
[79] => 4925
[80] => 4926
[81] => 4916
[82] => 4918
[83] => 4914
[84] => 4920
[85] => 4087
[86] => 3633
[87] => 4109
[88] => 3589
[89] => 3537
[90] => 3528
[91] => 3485
[92] => 3563
[93] => 3646
[94] => 3540
[95] => 3663
[96] => 3579
[97] => 3475
[98] => 4100
[99] => 4099
[100] => 3594
[101] => 3545
[102] => 3750
[103] => 3524
[104] => 3675
[105] => 3525
[106] => 4789
[107] => 3686
[108] => 3503
[109] => 3760
[110] => 3761
[111] => 3470
[112] => 3529
[113] => 3559
[114] => 3612
[115] => 3595
[116] => 3566
[117] => 3672
[118] => 3643
[119] => 3654
[120] => 3628
[121] => 3727
[122] => 3738
[123] => 3473
[124] => 3583
[125] => 3605
[126] => 3556
[127] => 3477
[128] => 3560
[129] => 3486
[130] => 3731
[131] => 3452
[132] => 3604
[133] => 3632
[134] => 3681
[135] => 3736
[136] => 3960
[137] => 3660
[138] => 3490
[139] => 3513
[140] => 3737
[141] => 3561
[142] => 3466
[143] => 3602
[144] => 3464
[145] => 3591
[146] => 3616
[147] => 3580
[148] => 3462
[149] => 3471
[150] => 3479
[151] => 3674
[152] => 3546
[153] => 3511
[154] => 3562
[155] => 3662
[156] => 3593
[157] => 3549
[158] => 3491
[159] => 3728
[160] => 3679
[161] => 3667
[162] => 3644
[163] => 3500
[164] => 3678
[165] => 3512
[166] => 3685
[167] => 3622
[168] => 3575
[169] => 3496
[170] => 3555
[171] => 3757
[172] => 3957
[173] => 3730
[174] => 3677
[175] => 3481
[176] => 3650
[177] => 3635
[178] => 3538
[179] => 3568
[180] => 3651
[181] => 3526
[182] => 3547
[183] => 3510
[184] => 3578
[185] => 721
[186] => 3501
[187] => 3534
[188] => 3454
[189] => 3484
[190] => 3461
[191] => 3638
[192] => 3986
[193] => 3517
[194] => 3729
[195] => 3701
[196] => 3682
[197] => 3668
[198] => 3615
[199] => 3666
[200] => 3627
[201] => 3656
[202] => 3649
[203] => 3614
[204] => 3590
[205] => 3459
[206] => 3527
[207] => 3598
[208] => 3516
[209] => 3947
[210] => 3460
[211] => 3548
[212] => 3552
[213] => 3480
[214] => 3652
[215] => 3585
[216] => 3522
[217] => 4062
[218] => 3557
[219] => 3478
[220] => 3975
[221] => 3558
[222] => 3498
[223] => 3587
[224] => 3618
[225] => 3637
[226] => 3617
[227] => 3606
[228] => 3844
[229] => 3519
[230] => 3634
[231] => 3603
[232] => 3482
[233] => 3683
[234] => 3564
[235] => 3476
)