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 )
