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 )
